Get certified in Microsoft Office suite with this comprehensive program: group classes, private training, and exams in Excel, PowerPoint, Word, and Outlook. The affordable price includes 7 group classes, 6 hours of private training, and 4 certification exams. Free retakes, MOS study guides, and instant digital certificates are included.
Overview
Syllabus
- Excel Level I: Fundamentals
- Learn how to use functions to speed up your workflow
- Add formatting and other visual effects
- Turn data into visual charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- 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
- PowerPoint Level I
- Create new PowerPoint Presentations
- Choose appropriate slide layouts & add content (text, images, etc.)
- Add photos, graphics, & how to adjust them (size, crop, etc.)
- Build Diagrams using SmartArt
- Draw Shapes & Lines
- Align & Evenly Space Objects
- Work with Tables & Charts
- Add Transitions
- Run a PowerPoint Presentation (Slide Show)
- 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 Word Level I
- Navigating through documents
- How to format documents
- Working with text and paragraphs
- Tables in Word
- Lists
- Endnotes, footnotes, and citations
- Adding Images to Word Documents
- Microsoft Word Level II
- Working with multiple documents
- Tracking changes
- Advanced formatting
- Reference tables
- Forms and mail merge
- Custom style sets and templates
- Microsoft Outlook Level I
Taught by
Garfield Stinvil and Dan Rodney
