Boot Camp:Microsoft Office Tools for Administrative Professionals

Boot Camp2 DaysVersion 365Official CPE Provider

A hands-on boot camp covering the Microsoft Office tools you use every day.

Course Objective

• Learn to use mail merge to automatically produce letters, labels, and even emails to your clients •

Prerequisites

To ensure your success, each student should have a general knowledge of Microsoft Office. What is included? Hands-On Training

Course Outline

4 lessons · 47 topics

1Day 1:

Outlook
Environment overview and shortcuts
Create groups and distribution lists
Add tasks, calendar, contacts
Sort, filter, conditional formats
Out of office assistant
Create signatures
Follow-up tracking
Search options
Organize contacts and use with mail merge
Word
Environment overview and shortcuts
Format paragraphs and spacing
Use columns and text boxes for improved layout
Format document as lists and outlines
Find and replace
Control appearance with styles and templates
Compare and merge/ track changes
Tables and charts
Mail merge

2Day 2:

Excel
Environment overview
Save options
Format a worksheet
Cut and paste options
Autofill handle and series list
Perform calculations
Print a workbook
Headers and footers
Custom window layout
Tables and charts
Data sorting, filtering, grouping and creating subtotals
Link charts and tables to other Microsoft Applications
Work with linked data to other applications (Word, PowerPoint)

3Day 3:

PowerPoint
Environment overview and shortcuts
Create a basic presentation quickly and easily
Slide design and layout
Transitions
Play and customize slideshows
Flowcharts and diagrams
Create an organization chart

4Day 4:

OneNote
Use OneNote to organize notes and lists
Environment overview of OneNote
Add content and formats to a OneNote notebook
Share and collaborate with shared notebooks

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals