Description
Duration: 1 day
Excel – Part 3 is an advanced course that builds on the skills developed in Excel Parts 1 and 2. Participants work with conditional logic, complex formulas, and automation tools to handle sophisticated data tasks. The course also covers dashboard creation, data modeling, and trend forecasting using Excel’s more powerful features.
Target Audience
- Professionals who have completed Microsoft Excel Part 1 and Part 2, or who have equivalent hands-on experience
- Data analysts and financial analysts looking to expand their Excel skill set
- Project managers and business professionals who regularly work with large amounts of data
- Anyone looking to automate workflows, build dashboards, and draw insights from large datasets in Excel
Prerequisites
- Completion of Microsoft Excel – Part 1 (Introduction) and Microsoft Excel – Part 2 (Intermediate), or equivalent knowledge and experience
- Comfortable entering and formatting data in Excel
- Ability to write basic formulas and use functions such as SUM and IF
- Some experience creating simple PivotTables and charts
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.
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
| 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 |
Learning Objectives
- Apply advanced formulas and functions using conditional logic
- Design dynamic dashboards for data visualization
- Automate repetitive and complex tasks using macros
- Analyze data and project future trends
- Build interactive PivotTables and PivotCharts
- Use Power Query and Power Pivot to work with large datasets
- Collaborate more effectively with others using Excel’s advanced features
Course Outline
Module 1: Advanced Formulas and Functions
Participants learn to apply conditional logic and more advanced formula techniques to address complex business problems. Coverage includes nested functions, array formulas, and using Excel’s broader function library to automate calculations and reduce manual effort.
Module 2: Creating Dynamic Dashboards
This module addresses how to design and build interactive dashboards that display data visually and refresh automatically. Participants work with charts, slicers, and named ranges to produce clear, easy-to-navigate data presentations.
Module 3: Task Automation with Macros
Participants are introduced to recording and editing macros to automate repetitive or complex processes. Topics include the macro environment, running and adjusting recorded macros, and identifying situations where automation provides practical value.
Module 4: Data Analysis and Forecasting
This module covers Excel’s built-in analytical tools, including What-If Analysis, Goal Seek, Scenario Manager, and Forecast Sheets. Participants learn to model business scenarios and estimate future outcomes based on historical data.
Module 5: PivotTables and PivotCharts
Participants build on existing PivotTable knowledge by creating calculated fields, grouping data, applying filters, and connecting PivotCharts. The focus is on using PivotTables as a flexible tool for summarizing and exploring large datasets.
Module 6: Power Query and Power Pivot
This module covers Power Query for importing, transforming, and cleaning data from multiple sources, alongside Power Pivot for building data models and defining relationships between tables. Participants learn to manage and analyze datasets that go beyond standard Excel constraints.
