LANTEC Logo
AI-Powered Excel: Data, Dashboards & Decisions

AI-Powered Excel: Data, Dashboards & Decisions

$599
1 days
Audience
Prerequisites

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
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "28852",
    "sortby": "EventDateStart",
    "sortorder": "ASC",
    "limit": "9999",
    "enablepagination": "false",
    "emptymessage": "

This course isn't currently on the schedule, but we can add it. Just let us know.

", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 28852, "Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Url": "/course/ai-powered-excel-data-dashboards-decisions", "Url_List": [ "/course/ai-powered-excel-data-dashboards-decisions" ], "UrlSlug": "ai-powered-excel-data-dashboards-decisions", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2099-12-31T00:00:00", "SiteSearchKeywords": [], "Description": "

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
     
     
", "Weighting": 0, "DisableForSiteSearch": false, "CreatedByMemberId": "0", "ItemCategories": [ "Courses", "Courses/Courses-Application", "Courses/Courses-Application/Artificial Intelligence" ], "ItemCategoryIdList": [ 8587, 8588, 179951 ], "ItemTags": [ "Artificial Intelligence", "Microsoft" ], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "CourseTitle": "AI-Powered Excel: Data, Dashboards & Decisions", "CourseFiles": "/AI-Powered Excel Data, Dashboards & Decisions Course Outline.pdf", "CourseFilesTitle": "Outline", "Intro": "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.", "Days": "1", "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.", "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.", "Cost": "$599", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": { "type": "snippet", "alias": "_template_header", "name": "_Template - Header", "content": "
\r\n
\r\n
\r\n
\r\n
\r\n
{% component type: \"menu\", alias: \"social_menu\", layoutGroup: \"Default\" %}
\r\n
\r\n
\r\n
\r\n {% component type: \"menu\", alias: \"utility_menu\", layoutGroup: \"Default\" %} \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \"LANTEC\r\n
\r\n
\r\n
\r\n
\r\n {% component type:\"menu\", alias: \"main_menu\", layoutGroup: \"Default\" %}\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\"LANTEC
\r\n \r\n
\r\n
\r\n \r\n {% assign brcr = \"BACK\" %}\r\n \r\n\t
\r\n\t BACK\r\n\t
\r\n
", "enabled": true } }, "Items": [ { "Id": 28856, "Name": "Microsoft Copilot for Excel: Working Smarter with AI - VILT - 111926", "Url": "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926", "Url_List": [ "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926" ], "UrlSlug": "microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2026-11-19T11:55:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "69f03273-8e40-494d-aa9d-37d40a910209", "Price": 610.9800, "PriceHtml": "610.98", "priceWithTax": 610.98, "priceWithTaxHtml": "610.98", "RecommendedPrice": 599.0000, "RecommendedPriceHtml": "599.00", "RecommendedPriceWithTax": 599.00, "RecommendedPriceWithTaxHtml": "599.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 0, "Allocation": 0, "EventDateStart": "2026-11-19T08:00:00", "EventDateEnd": "2026-11-19T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 610.9800, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "Course": 28852, "Course_Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Course_Url": "/course/ai-powered-excel-data-dashboards-decisions", "Location": "vILT", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": {} }, { "Id": 28857, "Name": "Microsoft Copilot for Excel: Working Smarter with AI - VILT - 121526", "Url": "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526", "Url_List": [ "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526" ], "UrlSlug": "microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2026-12-15T11:55:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "3a41df48-0798-47b6-a44e-49d924998d48", "Price": 610.9800, "PriceHtml": "610.98", "priceWithTax": 610.98, "priceWithTaxHtml": "610.98", "RecommendedPrice": 599.0000, "RecommendedPriceHtml": "599.00", "RecommendedPriceWithTax": 599.00, "RecommendedPriceWithTaxHtml": "599.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 0, "Allocation": 0, "EventDateStart": "2026-12-15T08:00:00", "EventDateEnd": "2026-12-15T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 610.9800, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "Course": 28852, "Course_Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Course_Url": "/course/ai-powered-excel-data-dashboards-decisions", "Location": "vILT", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": {} } ] }
Dec 15, 2026
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "28852",
    "sortby": "EventDateStart",
    "sortorder": "ASC",
    "limit": "9999",
    "enablepagination": "false",
    "emptymessage": "

This course isn't currently on the schedule, but we can add it. Just let us know.

", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 28852, "Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Url": "/course/ai-powered-excel-data-dashboards-decisions", "Url_List": [ "/course/ai-powered-excel-data-dashboards-decisions" ], "UrlSlug": "ai-powered-excel-data-dashboards-decisions", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2099-12-31T00:00:00", "SiteSearchKeywords": [], "Description": "

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
     
     
", "Weighting": 0, "DisableForSiteSearch": false, "CreatedByMemberId": "0", "ItemCategories": [ "Courses", "Courses/Courses-Application", "Courses/Courses-Application/Artificial Intelligence" ], "ItemCategoryIdList": [ 8587, 8588, 179951 ], "ItemTags": [ "Artificial Intelligence", "Microsoft" ], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "CourseTitle": "AI-Powered Excel: Data, Dashboards & Decisions", "CourseFiles": "/AI-Powered Excel Data, Dashboards & Decisions Course Outline.pdf", "CourseFilesTitle": "Outline", "Intro": "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.", "Days": "1", "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.", "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.", "Cost": "$599", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": { "type": "snippet", "alias": "_template_header", "name": "_Template - Header", "content": "
\r\n
\r\n
\r\n
\r\n
\r\n
{% component type: \"menu\", alias: \"social_menu\", layoutGroup: \"Default\" %}
\r\n
\r\n
\r\n
\r\n {% component type: \"menu\", alias: \"utility_menu\", layoutGroup: \"Default\" %} \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \"LANTEC\r\n
\r\n
\r\n
\r\n
\r\n {% component type:\"menu\", alias: \"main_menu\", layoutGroup: \"Default\" %}\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\"LANTEC
\r\n \r\n
\r\n
\r\n \r\n {% assign brcr = \"BACK\" %}\r\n \r\n\t
\r\n\t BACK\r\n\t
\r\n
", "enabled": true } }, "Items": [ { "Id": 28856, "Name": "Microsoft Copilot for Excel: Working Smarter with AI - VILT - 111926", "Url": "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926", "Url_List": [ "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926" ], "UrlSlug": "microsoft-copilot-for-excel-working-smarter-with-ai-vilt-111926", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2026-11-19T11:55:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "69f03273-8e40-494d-aa9d-37d40a910209", "Price": 610.9800, "PriceHtml": "610.98", "priceWithTax": 610.98, "priceWithTaxHtml": "610.98", "RecommendedPrice": 599.0000, "RecommendedPriceHtml": "599.00", "RecommendedPriceWithTax": 599.00, "RecommendedPriceWithTaxHtml": "599.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 0, "Allocation": 0, "EventDateStart": "2026-11-19T08:00:00", "EventDateEnd": "2026-11-19T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 610.9800, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "Course": 28852, "Course_Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Course_Url": "/course/ai-powered-excel-data-dashboards-decisions", "Location": "vILT", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": {} }, { "Id": 28857, "Name": "Microsoft Copilot for Excel: Working Smarter with AI - VILT - 121526", "Url": "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526", "Url_List": [ "/event/microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526" ], "UrlSlug": "microsoft-copilot-for-excel-working-smarter-with-ai-vilt-121526", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2026-09-14T00:00:00", "ExpiryDate": "2026-12-15T11:55:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "3a41df48-0798-47b6-a44e-49d924998d48", "Price": 610.9800, "PriceHtml": "610.98", "priceWithTax": 610.98, "priceWithTaxHtml": "610.98", "RecommendedPrice": 599.0000, "RecommendedPriceHtml": "599.00", "RecommendedPriceWithTax": 599.00, "RecommendedPriceWithTaxHtml": "599.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 0, "Allocation": 0, "EventDateStart": "2026-12-15T08:00:00", "EventDateEnd": "2026-12-15T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 610.9800, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "DnDOrder": 0, "Course": 28852, "Course_Name": "AI-Powered Excel: Data, Dashboards & Decisions", "Course_Url": "/course/ai-powered-excel-data-dashboards-decisions", "Location": "vILT", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": {} } ] }

Need to Request 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 submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?