Develop intermediate and advanced Microsoft Office skills in this immersive course. Master Excel, PowerPoint, Word, and Outlook to speed up your workflow and boost your productivity.
Overview
Syllabus
- Excel Level II: Intermediate
- Learn to split and join text, add data validation, and named ranges
- Use database functions and logical statements
- Create Pivot Tables to quickly summarize large databases
- Create advanced combo charts from multiple charts
- Excel Level III: Advanced
- Cell management including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions and advanced analytical toolsÂ
- Record macros and relative reference macros for ad hoc reporting
- Microsoft Word Level II
- Working with multiple documents
- Tracking changes
- Advanced formatting
- Reference tables
- Forms and mail merge
- Custom style sets and templates
- PowerPoint Level II
- Design Custom PowerPoint Themes
- Work with Theme Colors, Fonts, Backgrounds, & Slide Layouts
- Add Animations for Stand Out Presentations
- Incorporate Video
- Customize the Look of Charts & Animate Charts
- Bring in Tables from Excel
- Manage Large Presentations with Sections, Hidden Slides, and Custom Shows
- Collaborate with Others using Comments
- Microsoft Outlook Level II
Taught by
Garfield Stinvil and Dan Rodney
