|
|
|
You Will Learn How To
- Leverage the extensive features in Word, Excel and PowerPoint
- Build professional documents in Word with enhanced functionality
- Quickly present and summarize data with Excel using PivotTables and PivotCharts
- Easily incorporate external data sources
- Create visually dynamic and effective presentations in PowerPoint
- Safeguard documents from viruses and unauthorized access with the Trust Center
Course Benefits Organizations depend on highly skilled employees to work effectively and efficiently to produce quality documents. This course is designed to improve productivity by leveraging the power of Microsoft Office applications. Throughout this course, you gain the skills to stand out in a competitive market by maximizing the innovative features and integration techniques required to streamline day-to-day tasks and enable better decision making in the workplace.
Who Should Attend Anyone interested in enhancing their Microsoft Office skills for improved productivity. Experience with Microsoft Office applications at an introductory level is assumed.
Hands-On Training Exercises provide you with practical experience using Microsoft Office. Exercises include:
- Customizing Microsoft Office
- Designing documents with styles, themes and sections
- Implementing the TOC, headers and footers in Word
- Analyzing data with PivotTables and PivotCharts
- Applying conditional formatting and SmartArt
- Refining the data with formulas in Excel
- Creating PowerPoint presentations with Master layouts and design masters
- Securing documents using visible and invisible digital signatures and the Trust Center
Course 972 Content Introducing Microsoft Office
Discovering the User Interface
- Navigating the Ribbon and Dialog Launchers
- Setting defaults with Office options
- Customizing the Quick Access Toolbar
Exploring file formats
- Reviewing supported file extensions
- Discovering the Compatibility Pack
Creating Professional Documents in Word
Establishing the document setup
- Configuring the status bar
- Working with sections
- Handling multiple headers and footers
Formatting the document
- Implementing styles
- Condensing the document to an outline and viewing the document map
- Discovering themes
Automating documents and text
- Exploring templates
- Inserting and modifying Quick Parts and Building Blocks
Referencing and Navigating Documents
Streamlining document tasks
- Customizing document properties
- Inserting cover pages
- Creating the TOC
- Adding watermarks
Implementing revision control
- Creating comments
- Managing multiple versions of a document
- Reviewing and tracking changes
Producing Rapid Results with Excel
Leveraging Excel functionality
- Taking advantage of the Function Wizard
- Absolute versus relative addressing
Optimizing graphical objects
- Graphing data with charts
- Visually enhancing data with conditional formatting
Creating interactive PivotTables and PivotCharts
- Generating, editing and formatting PivotTable fields
- Filtering, sorting and pivoting charts and tables
Integrating Data Sources
Retrieving external data
- Connecting to MS Access using MS Query
- Extracting and correcting data types with formulas
Assembling mass mailings
- Connecting to Excel data
- Working with a template document
- Producing the result documents: letters, envelopes and labels
Developing PowerPoint Presentations
Building a dynamic slide show
- Best practices for creating presentations
- Designing effective slides
- Discovering methods to incorporate animation and sound
- Exploring slide show options
Enhancing the slides
- Applying themes
- Setting up and refining master layouts
Enhancing documents with graphics
- Leveraging SmartArt graphics
- Employing text to create SmartArt graphics
Finalizing and adding special effects
- Adding slide transitions
- Customizing animation
- Publishing the presentation
Document Security and Collaboration
Protecting documents
- Setting up document restriction using encryption
- Removing private and personal information
- Enabling digital signatures
Safeguarding documents with the Trust Center
- Manipulating the Document Inspector features
- Configuring Trust Center options
|
<< Back to Excel, Office and Access Course List
Related Courses
Microsoft is a registered trademark of Microsoft Corporation.
|
|
|
Training Dates
US Dates | | Mar 21 - 23 | Rockville, MD enrol | | Apr 11 - 13 | Reston, VA enrol | | May 23 - 25 | Rockville, MD enrol | | Jun 6 - 8 | New York enrol | | Jun 20 - 22 | Reston, VA enrol | | Aug 15 - 17 | New York enrol | | Aug 22 - 24 | Rockville, MD enrol | | Sep 12 - 14 | Reston, VA enrol | | Nov 7 - 9 | Rockville, MD enrol | | Dec 19 - 21 | New York enrol |
For AnyWare enrolments, please register at least 10 days prior to the start of the course.
More Dates and Locations.
|
|
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customized for your organization.
|
Course participants rapidly creating documents with Microsoft Office.
|
|
Average Attendee Evaluation
|
Evaluations in the last 12 months |
|
5 stars:
|
|
73% |
|
4 stars:
|
|
23% |
|
3 stars:
|
|
4% |
|
2 stars:
|
|
0% |
|
1 star:
|
|
0% |
|
|
"I definitely recommend taking a Learning Tree Course. The comprehensive materials, the excellent instructor, the hands-on exercises—I don't think you can beat it."
– B. Williams
TWD
|
 |
 |
|
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
