I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel
Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.
The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.
Able to apply VLookup, Macros and Pivot Tables easily - M1
Improved my job productivity by 75% - ITE
Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas
View the Latest Advanced Excel Training Schedule to reserve a seat.
Advanced Word 2010
Course Duration : 2 day
About the Advanced Word 2010 Course:
Microsoft® Word 2010 Expert teaches the information worker how to use a variety of intermediate and advanced features to create and format business documents such as online forms, personalized mailings, or cites reference sources. Some topics will review core skill sets and are then discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.
You Will Learn How to
• Customize your working environment using Word Options
• Create a document from a template and create a new template
• Restrict access to parts of or the entire document
• Turn Protected View on or off
• Apply, create, modify, or delete styles
• Create Quick Parts
• Access the Building Blocks Organizer
• Set up formulas in tables
• Set up options to review documents
• Compare or combine multiple documents
• Accept or reject tracked changes
• Insert citation sources
• Insert captions
• Manage your reference sources
• Generate a table of figures
• Generate a table of authorities
• Mark entries for an index
• Generate an index
• Review how the merge process works
• Merge envelopes and labels
• Set rules for merging
• Create online forms using content controls and legacy tools
• Create, edit, and delete a macro
• Assign a keyboard shortcut to a macro
• Assign a macro to the Quick Access toolbar or a button on a Ribbon tab
Course Outline for Microsoft Word 2010
Lesson 1: Sharing and Maintaining Documents
Changing Word Options
Changing the Proofing Tools
Working with Templates
Managing Templates
Restricting Document Access
Using Protected View
Lesson 2: Formatting Content
Formatting with Styles
Using Quick Styles
Creating Styles
Using Quick Parts
Working with Tables
Inserting Formulas
Working with Charts
Adding Chart Elements
Saving a Chart as a Template
Working with Text Boxes
Linking Text Boxes
Lesson 3: Tracking and Reviewing Documents
Reviewing Documents
Setting Tracking Options
Tracking Changes
Reviewing a Document from Others
Comparing or Combining Documents
Referencing Information Sources
Inserting Citation Sources
Working with Captions
Listing Your Sources
Inserting a Bibliography
Managing Your Sources
Using Cross References
Creating an Index
Marking Index Entries
Generating an Index
Updating and Editing an Index
Lesson 4: Merging Documents
Merging with Forms
Merging with Outlook Contacts
Merging to Envelopes
Merging to Labels
Setting Rules for Merges
Lesson 5: Using Forms and Macros
Creating Online Forms
Locking the Form
Filling in Forms
Explaining Macros
Recording Macros
Running Macros
Editing Macros
Applying Security for Macros
Assigning Macros to the Quick
Access Toolbar
Assigning Macros to Ribbon Buttons
Duration
The course is a 2 day training course.
Certification:
Certificate of attendance would be given to participants.
Materials:
Notes in folders will be provided.
Class Size:
8-12 participants