416 513 1535 | HTI Portal Login
Microsoft Office 2010 (Word, Excel & Power Point)
Vendor:
Subject:
Course Contents:
EXCEL
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
POWERPOINT
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
WORD
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
Notes:
• 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.
Objective:
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.
Prerequisites:
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.
Benefits:
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.
Audience:
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.
Duration:
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.