LANTEC Logo

AI-Powered Excel: Data, Dashboards & Decisions

$599
1 days

Audience:

Business professionals, analysts, coordinators, operations staff, managers, and supervisors who use Excel to prepare, analyze, or report data and want to work more efficiently with Microsoft Copilot.

Prerequisites:

Participants should have advanced Excel skills equivalent to Excel Level 3. Completion of Excel Level 3 is recommended; however, participants who have completed Excel Dashboards, Power BI, Excel Advanced Data Analysis with Pivot Tables and PowerPivot, or who possess equivalent advanced Excel experience are also appropriate candidates for this course. No prior AI experience is required.
Prerequisites: Participants should have advanced Excel skills equivalent to Excel Level 3. Completion of Excel Level 3 is recommended; however, participants who have completed Excel Dashboards, Power BI, Excel Advanced Data Analysis with Pivot Tables and PowerPivot, or who possess equivalent advanced Excel experience are also appropriate candidates for this course. No prior AI experience is required.

Course Description:

AI-Powered Excel: Data, Dashboards & Decisions is a hands-on, instructor-led course that teaches participants how to direct Copilot through spreadsheet preparation, calculations, analysis, dashboards, and reporting while maintaining human judgment and verifying results.

Through a realistic business scenario, participants move from messy source data to a management-ready recommendation. Guided demonstrations, individual and partner exercises, and a final capstone develop practical skills in reviewing Copilot plans, tracing findings to source data, and auditing workbooks for errors that may otherwise go unnoticed.

Participants create a cleaned dataset, a formula-assisted workbook, analyst and management dashboards, a traced business finding, a workbook audit, and an executive summary with a recommendation.

Course Objectives:

By the end of this course, participants will learn to:

  • Distinguish between Copilot modes and choose whether to request an answer or a workbook change
  • Evaluate a multi-step Copilot plan before it changes a workbook
  • Prepare and structure data for reliable analysis
  • Generate, explain, and troubleshoot formulas using business language
  • Investigate spreadsheet data and trace findings back to source rows
  • Build analyst and management dashboards with slicers and timelines
  • Audit Copilot-generated work and hand-check critical results
  • Create an executive summary explaining findings, assumptions, and recommended next steps
     
     

Scheduled Courses

Nov 19, 2026
vILT (Virtual)
Dec 15, 2026
vILT (Virtual)
Jan 28, 2027
vILT (Virtual)
Feb 24, 2027
vILT (Virtual)

Want to Take this Course on a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please constact us. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.

Baton Rouge (225) 293-0656
Lafayette (337) 233-2016
New Orleans (504) 576-1010