MS Word
Training Course Outline
WORD 365 – FIELD CODES & FILL-IN FORMS
Inserting a field code
Updating fields
Editing and deleting fields
Locking or unlocking fields
Displaying field codes
Converting fields to text
WORD 365 – FORMS
What are Word 2007 fill-in forms?
Creating and editing a form
Editing and formatting fill-in form fields
Deleting fields within a fill-in form
Protecting a fill-in form
WORD 365 – LINKING AND EMBEDDING
Linking and embedding objects
Embedding an Excel chart
Formatting an embedded worksheet within a document
Editing an embedded object
Linking an Excel chart to a Word document.
Using the ‘Insert Chart’ command
WORD 365 – REFERENCES OPTIONS
Creating a Table of Contents
Updating and modifying an existing Table of Contents
Adding a bookmark
Deleting a bookmark
Going to a bookmark
Cross-references
Creating or editing an index
Creating Footnotes
Formatting Footnotes
Deleting Footnotes
Creating Endnotes
Formatting Endnotes
Deleting Endnotes
Adding or updating a caption to an image, table or workshe
MS Word Contd...
WORD 365 – COLLABORATIVE EDITING AND SECURITY
To password protect documents
Inserting comments
Checking documents for sensitive ‘hidden’ information
Tracking changes within a document
WORD 365 – MASTER DOCUMENTS
Creating a Master Document
Inserting a table of contents into a master document
Editing sub-documents
Removing sub-documents
WORD 365 -CONDITIONAL MAIL MERGING
Using conditional mail merging
WORD 2007 – MACROS
What are macros?
Recording a macro
Assigning a macro to a button
WORD 365 – WEB PAGES AND HYPERLINKS
Microsoft Word 2007 and the Internet
Save a document as a Web page
Previewing a Web formatted page
Saving a Web page from the Internet
Saving documents from a Web page
Creating Internet Hyperlinks
Editing Internet Hyperlinks
Removing a hyperlink
WORD 2007 – THEMES Using Themes
MS Excel
HEMANT KAJARIA
SENIOR CORPORATE TRAINER
TRAINING FOR INDIVIDUALS | GROUP | CORPORATE
(+91) 9821041860 | 9820625162
Email: hkajaria@gmail.com
02 Days Training on Advance Excel
DAY – 1
Session I
IMPORTING AND Exporting to Access and other format
paste special
Auto-fill
creating your own auto-fill
*Assignment
Session II
Naming Ranges
Formulas
Chart
Session III
Functions
Hyperlink
*Assignment
Session IV
style
Conditional Formating
Locking and hiding of cells
*Assignment
DAY- 2
Session I
Goal Seek
Scenario
Auditing
Consolidate
*Assignment
Session II
Macro
Sort
*Assignment
Session III
Filter
Pivot table
Session IV
Doubt solving
*Assignment
MS Power Point
Session 1
Working with Themes and Slide Masters
• Applying Multiple Themes
• Applying Themes to Slide Masters
• Formatting Slide Master Backgrounds
• Customizing Slide Masters
• Using Multiple Slide Masters
• Customizing Handout Masters
Session 2
Customizing Text Elements
• Formatting Text Boxes
• Arranging Text
• Adding Bullet-ed and Numbered Lists
• Inserting and Formatting Word-Art
• Copying and Moving Text Session 3
Enhancing Audio and Visual Elements
• Adding Narration
• Creating Special Effects
• Working with Smart -Art
• Customizing Illustrations
• Formatting Charts
Session 4
Preparing Your Presentation
• Setting Slide Show Options
• Managing Presentation File Size
• Securing a Presentation
• Using the Document Inspector
• Running the Compatibility Checker
• Finalizing a Presentation
Session 5
Distributing Your Presentation
• Overview of Distribution Options
• Printing a Presentation
• Saving Presentations in Different Formats
• Exploring Web Options
• Saving Slides as Images
MS Access
TOPIC 1
Getting started
Getting Started
Quick Tour of Microsoft Offi ce Access 2007
The World of Relational Databases
Creating a Database
Creating and Modifying Tables
Relating Tables
Entering and Editing Data
TOPIC 2
Retrieving and Presenting Information
Sorting, Filtering, and Printing Records
Extracting Information with Queries
Creating Advanced Queries
Creating Form and Report Designs
Using the Form Tools
Customizing Forms
Using the Report Wizard
Customizing Reports
Creating Charts and Graphs
TOPIC 3
Improving the Workplace
Customizing the Workplace
Improving Database Performance
Understanding Events and the Event Model
Automating with Macros
Customizing the User Interface
Customizing the Navigation Pane and Creating Switchboards
TOPIC 4
Exchange Data with Others
Exchange Database Objects and Text
Exchanging Data with Outside Sources
Sharing with Multiple Users
Secure a Database
