Modern Excel for Business: Advanced Formulas, Power Query & Dashboards

Transform raw data into dynamic, automated executive reports using XLOOKUP, dynamic array formulas, Power Query ETL, and interactive slicers.

5.00
(From 2 Reviews)
Intermediate 2:16:52
Created by Wade C. Nelson Last Updated 04/10/2026 15:42

Preview

$35.00 $69.00 49.28% off
30-Day Money-Back Guarantee
Modern Excel for Business: Advanced Formulas, Power Query & Dashboards
5.00 Intermediate
$35.00 $69.00 49.28% off

What you'll learn

Master next-generation formulas: XLOOKUP, FILTER, UNIQUE, SORT, and LAMBDA
Automate repetitive data cleaning and transformation workflows with Power Query
Connect multiple data sources without writing complex VLOOKUPs using Data Models
Build interactive executive KPI dashboards with dynamic slicers and charts
Perform advanced financial and statistical analysis using Pivot Tables and DAX measures
Protect, audit, and troubleshoot complex spreadsheet models efficiently

Course Curriculum

3 sections • 9 Lectures • 2:16:52 total duration

Expand all

Requirements

  • Microsoft Excel (Office 365, Excel 2019, or Excel 2021 recommended for modern array formulas)
  • Basic familiarity with entering numbers and simple formulas in Excel

Description

Stop wasting hours copying and pasting spreadsheet rows every week. Learn how modern Microsoft Excel features—like Power Query, Dynamic Arrays, and Power Pivot—automate your workflow and turn messy spreadsheets into self-updating executive dashboards.

Instructors

WC
4.85 Rating
7 Courses
0 Students
Wade C. Nelson

Student feedback

5.00
From 2 Reviews
100%
0%
0%
0%
0%
MB
JT
What's Included
  • 2:16:52 on-demand video
  • 9 Lectures
  • Full lifetime access on mobile & PC
  • Certificate of completion