Microsoft Excel – Part 3

Details

Microsoft Excel – Part 3

Duration: 1 day

Microsoft Excel – Part 3 covers the advanced features that turn Excel into a true analysis and automation tool. You’ll work with advanced functions, PivotTables and PivotCharts, what-if analysis, and automation basics so you can handle large data sets with confidence.

Learning Objectives

  • Use advanced functions including lookup and reference functions
  • Create and analyze data with PivotTables and PivotCharts
  • Perform what-if analysis
  • Automate workbooks with macros
  • Audit and troubleshoot formulas

Who Should Attend

  • Experienced Excel users
  • Analysts and professionals working with large data sets
  • Anyone who completed Excel – Part 2 or has equivalent experience

Prerequisites

  • Microsoft Excel – Part 2 or equivalent experience
  • Comfort with functions, tables, and charts

What's Included

What’s Included

  • Authorized courseware and student materials
  • Hands-on labs and real-world practice exercises
  • Live instruction from an experienced, certified trainer
  • Small class sizes for personalized attention
  • Attend on campus in Miami or Fort Lauderdale, or live online
  • Certificate of completion

Training Solutions

With several convenient training delivery methods offered, The 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 Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Schedule

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
12/8/202512/8/2025
12/29/202512/29/2025
1/19/20261/19/2026
2/9/20262/9/2026
3/2/20263/2/2026
3/23/20263/23/2026
4/13/20264/13/2026
5/4/20265/4/2026
5/25/20265/25/2026
6/15/20266/15/2026
7/6/20267/6/2026
7/27/20267/27/2026
8/17/20268/17/2026
9/7/20269/7/2026
9/28/20269/28/2026
10/19/202610/19/2026
11/9/202611/9/2026
11/30/202611/30/2026
12/21/202612/21/2026
1/11/20271/11/2027

Curriculum

Course Outline

Module 1: Advanced Functions

Use lookup, reference, and nested functions to solve real business problems.

Module 2: PivotTables and PivotCharts

Summarize large data sets, group and filter, and visualize with PivotCharts.

Module 3: What-If Analysis

Use Goal Seek, Scenario Manager, and data tables to model outcomes.

Module 4: Auditing and Troubleshooting

Trace precedents and dependents and resolve formula errors.

Module 5: Automating with Macros

Record and run macros to automate repetitive tasks.