Microsoft Excel Associate Certification Prep Online Bootcamp
  

$299

What is covered in this Prep Course?
This prep course covers the topics that will be reviewed in the Microsoft Excel Associate Certification Exam. Even if you are an every day Excel user, the certification exam covers topics that are not used on a daily basis.
Prerequisite: Students who register for this Bootcamp are required to have taken our Microsoft Excel Bootcamp (or taken Microsoft Excel as part of another Bootcamp) or have had previous experience with Microsoft Excel.
THIS COURSE WILL PREP YOU FOR THE MICROSOFT EXCEL ASSOCIATE CERTIFICATION. THE CERTIFICATION EXAM WILL BE ADMINISTERED THROUGH MICROSOFT. CERTIFICATION WILL BE PROVIDED BY MICROSOFT AFTER A PASSING SCORE.  EXAM TAKERS ARE RESPONSIBLE FOR SCHEDULING THE EXAM AND PAYING THE $100 EXAM FEE THROUGH MICROSOFT.

Prep for Microsoft Excel's Associate Certification with this live training prep course


Course Schedule
Course Dates: May 31st - July 1st
Days of the week: Weeknights (Monday - Thursday)
Time (EST): 630p - 730p EST

 

Module 1: Workbook + Worksheet Management

 

Course 1: Importing Data
Monday, May 31st | 6:30p - 7:30p
  • Import data from different file types

Course 2: Workbook Navigation
Tuesday, June 1st | 6:30p - 7:30p
  • Name Manager
  • Cell References
  • Hyperlinks

Course 3: Formatting
Wednesday, June 2nd | 6:30p - 7:30p

Course 4: Views + Printing
Thursday, June 3rd | 6:30p - 7:30p

Module 2: Visualizing Data

 

Course 1: Sparklines
Monday, June 7th | 6:30p - 7:30p

Course 2: Conditional Formatting (Part 1)
Tuesday, June 8th | 6:30p - 7:30p

Course 3: Conditional Formatting (Part 2)
Wednesday, June 9th | 6:30p - 7:30p

Course 4: Creating Charts (Part 1)
Thursday, June 10th | 6:30p - 7:30p

Course 5: Creating Charts (Part 2)
Monday, June 14th | 6:30p - 7:30p

Course 6: Formatting Charts (Part 1)
Tuesday, June 15th | 6:30p - 7:30p

Course 7: Formatting Charts (Part 2)
Wednesday, June 16th | 6:30p - 7:30p
  • Add various filters to data sets

Module 3: Tables

 

Course 1: Creating Tables
Monday, June 21st | 6:30p - 7:30p
  • Referenced vs. trend line

Course 2: Modifying Tables
Tuesday, June 22nd | 6:30p - 7:30p

Course 3: Formatting Tables
Wednesday, June 23rd | 6:30p - 7:30p

Course 4: Filtering + Sorting 
Thursday, June 24th | 6:30p - 7:30p

Module 4: Formulas

 

Course 1: Text Functions (Part 1)
Monday, June 28th | 6:30p - 7:30p

Course 2: Text Functions (Part 2)
Tuesday, June 29th | 6:30p - 7:30p

Course 3: If Statements
Wednesday, June 30th | 6:30p - 7:30p

Course 4: Aggregations
Thursday, July 1st | 6:30p - 7:30p

 

 

What's Included:
  • Dataset resources
  • Exam tips
  • Study guides
  • Prep exam resources
  • Self paced supplemental prep material
  • First hand exam expectations
  • Training from a certified instructor

 

 

Refund Policy: No Refunds
$199.00
Out of stock