Name: Microsoft Master Certification Program with Access (Live Online)
Price: 2799 USD

Microsoft Master Certification Program with Access (Live Online)

Overview

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.

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.