Microsoft Office 2010 (Word, Excel & Power Point)

Printer-friendly version
Course Contents: 


1. Learn essential productivity techniques to speed up your work, including keyboard shortcuts, docking commands to the quick access toolbar, compatibility shortcuts for legacy features like autoformat, and more
2. Creating Pivot Tables with the new interface and using advanced Pivot Table options
a. Adding fields or tiers to Pivot Tables
b. Drilling to detail
c. Manipulating fields and Value fields
d. Building Grouped Fields
e. Building Formula Fields within the Pivot Table
3. Key functions and formulas including functions like SUMIF and COUNTIF, important functions like SUMPRODUCT, and more
4. Use the FORMAT as TABLE feature to set up a dynamic data range for analysis tables and Pivot Tables
5. Understanding best practices in spreadsheet development for use in an organizational setting, formatting, visual settings, and protection
6. Protecting and locking spreadsheet zones for ensuring integrity of data and linked reports


1. The new interface, key commands to dock on the quick access toolbar for productivity, compatibility shortcuts, and more
2. Understanding Object Linking and embedding and creating presentations with slides of linked data
3. Powerful graphics processing and embellishment tools available for stunning graphics and photographs in your presentation; including smart art
4. Rapid Presentation deck building using Word and PowerPoint together for fully formatted presentation in minutes
5. Leveraging Presentation Design templates and themes for Rapid Presentation development and maintaining visual consistency in team presentations
6. Introduction to the powerful custom animation, and how custom animation can be used to introduce data and information effectively
7. Understanding the Presenter’s view using dual-screen displays - see your notes on the screen while audience see only the presentation


1. Using Document styles, Headers and Footers and Auto-text – how they come together for professional documents
2. Working with fields and how to include fields in your document, generating a Table of contents, and protecting documents effectively
3. Paste Linking tabular data from Excel into word while maintaining links yet retaining the visual consistency of your Word document
4. Combined use of Word, Excel, and Outlook - using the mail merge wizard for letters and mailings and for generating speedy personalized items like mailing labels, name tags etc
5. Plenty of other shortcuts, tips and tricks to greatly enhance your productivity and the quality of your reports and documents


• The workshop will be carried out in a highly interactive manner, and depending on time, may have many more tips and tricks covered. We reserve the right to make modifications to the course coverage depending on participant level and time available.
• Microsoft Excel for PC, Version 2010 will be used in the demonstration of techniques of this workshop. Participants may use version 2007 as well though differences in capability may exist in some modules. While participants are welcome to work with versions prior to 2007 or non-PC versions, some procedures and shortcuts vary and in the interest of clarity, the workshop demonstration may not be able to include them all.


Focused training for users of Microsoft Office, is aimed at getting users up to speed with key advanced features of Office, the new features in version 2007/2010 and how to take advantage of them for maximum return to the organization. It is task oriented and aims to ensure that users acquire an in-depth knowledge of advanced techniques to do the tasks they normally would in significantly lower time frames and with enhanced quality and output. This workshop is focused on data management, data analysis, reporting, presenting, planning and communication.


Participants must have a good working knowledge of Microsoft Office with higher intermediate proficiency. This includes knowing how to build formulas with nested functions including functions such as IF, COUNTIF, SUMIF, Absolute and Mixed references, spreadsheet productivity shortcuts, basic Pivot Table creation, and other intermediate spreadsheet development, formatting and printing tasks in Excel. In PowerPoint participants should know basic to intermediate tasks such as building a slide presentation, formatting content on a slide, developing slide decks with transitions, using drawing tools, and copying and pasting data from Excel. In Microsoft Word, participants are expected to know basic to intermediate level tasks such as building a document, formatting text, creating indents, using bullets and numbering, and other intermediate document development and printing tasks.

If you have not got a working knowledge of these Microsoft Office tools, you might want to access a fundamentals or intermediate class before attending this one.

This is a HANDS-ON workshop. Participants are expected to bring their own laptop computers. A mouse is essential. Please note the software requirements mentioned under Notes above.


7 hours of hands-on instruction which will familiarize you with focused techniques on higher intermediate to advanced level computing and reporting using Microsoft Excel, PowerPoint and Word, individually and in combination to unlock their power; including many of the newer features introduced since version 2007.


Any regular business user or student who has higher intermediate proficiency in Microsoft Officeand wishes to take their skills to an Advanced level and learn new features as well as new ways to use known features.

16 hours
For more information on Microsoft Office 2010 (Word, Excel & Power Point) please feel free to contact us online or call us at 416-513-1535.