Microsoft Office Specialist: Excel Expert Boot Camp
Duration: 1 day
The Excel Expert boot camp covers advanced workbooks such as custom business templates, multi-axis financial charts, amortization tables, and inventory schedules — the skills measured by the Microsoft Office Specialist (MOS) Excel Expert certification.
This boot camp prepares you for the Microsoft Office Specialist Excel Expert exam in both current programs: MO-211 (Excel — Microsoft 365 Apps) and MO-201 (Excel — Office 2019). Both versions cover the same core skill areas.
Skills measured (Microsoft exam objectives)
- Manage workbook options and settings (10–15%)
- Manage and format data (30–35%)
- Create advanced formulas and macros (25–30%)
- Manage advanced charts and tables (25–30%)
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Code Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Code Academy for an engaging and effective learning experience.
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 5/25/2026 | 5/25/2026 | ||||
| 6/15/2026 | 6/15/2026 | ||||
| 7/6/2026 | 7/6/2026 | ||||
| 7/27/2026 | 7/27/2026 | ||||
| 8/17/2026 | 8/17/2026 | ||||
| 9/7/2026 | 9/7/2026 | ||||
| 9/28/2026 | 9/28/2026 | ||||
| 10/19/2026 | 10/19/2026 | ||||
| 11/9/2026 | 11/9/2026 | ||||
| 11/30/2026 | 11/30/2026 | ||||
| 12/21/2026 | 12/21/2026 | ||||
| 1/11/2027 | 1/11/2027 | ||||
| 2/1/2027 | 2/1/2027 | ||||
| 2/22/2027 | 2/22/2027 | ||||
| 3/15/2027 | 3/15/2027 | ||||
| 4/5/2027 | 4/5/2027 | ||||
| 4/26/2027 | 4/26/2027 |
Curriculum
1 – WORKING WITH FUNCTIONS
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
2 – WORKING WITH LISTS
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 – ANALYZING DATA
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
4 – VISUALIZING DATA WITH CHARTS
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
5 – USING PIVOTTABLES AND PIVOT CHARTS
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
6 – WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
7 – SHARING AND PROTECTING WORKBOOKS
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
8 – AUTOMATING WORKBOOK FUNCTIONALITY
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
9 – USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
10 – FORECASTING DATA
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
11 – CREATING SPARKLINES AND MAPPING DATA
- Topic A: Create Sparklines
- Topic B: Map Data
