Microsoft Office
Boot Camp:Microsoft Office Tools for Administrative Professionals
A hands-on boot camp covering the Microsoft Office tools you use every day.
CPE Eligible - visit /cpe for details.CPE page →
Scheduled dates
No public dates scheduled yet
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
Day 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
Day 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)
Day 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
Day 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