Earn Microsoft certification in Excel, PowerPoint, Word & Access through this comprehensive program with group classes, private training, exams, free retakes, study guides & flexible scheduling. Get certified and receive digital & physical certificates within weeks.
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 Access Level I
- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
- Organize and manage data stored within Access tables
- Use queries to join, sort, and filter data from different tables
- Use forms to make it easier to view, access, and input data
- Create and format custom reports
- Microsoft Access Level II
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Customize reports to organize the displayed information and produce specific print layouts.
Taught by
Garfield Stinvil and Dan Rodney
