LANTEC Logo
Lantec | Course: Excel 2016 Dashboard

Excel Dashboards

$245.00
1 days
Audience
Prerequisites

Description:

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

Outline:

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science

Topic B: Create and Modify Tables

Topic C: Sort and Filter Data

Lesson 2: Visualizing Data with Excel

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

Topic C: Apply Best Practices in Chart Design

Lesson 3: Analyzing Data with Formulas and Functions

Topic A: Analyze Data with Formulas and Named Ranges

Topic B: Analyze Data with Functions

Topic C: Implement Data Validation, Forms, and Controls

Topic D: Create Conditional Visualizations with Lookup Functions

Lesson 4: Analyzing Data with PivotTables

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel

Appendix A: Using Lookup Functions

Scheduled Courses

Jan 08, 2025
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9343",
    "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": 9343, "Name": "Excel Dashboards", "Url": "/course/excel-dashboards-1", "Url_List": [ "/course/excel-dashboards-1" ], "UrlSlug": "excel-dashboards-1", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2019-01-24T01:00:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "

Description:

\n

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

\n

Outline:

\n

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science

Topic B: Create and Modify Tables

Topic C: Sort and Filter Data

Lesson 2: Visualizing Data with Excel

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

Topic C: Apply Best Practices in Chart Design

Lesson 3: Analyzing Data with Formulas and Functions

Topic A: Analyze Data with Formulas and Named Ranges

Topic B: Analyze Data with Functions

Topic C: Implement Data Validation, Forms, and Controls

Topic D: Create Conditional Visualizations with Lookup Functions

Lesson 4: Analyzing Data with PivotTables

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel

Appendix A: Using Lookup Functions

    \n
", "Weighting": 0, "DisableForSiteSearch": false, "CreatedByMemberId": "0", "ItemCategories": [ "Courses", "Courses/Courses-Application", "Courses/Courses-Application/Microsoft" ], "ItemCategoryIdList": [ 8587, 8588, 8606 ], "ItemTags": [ "Microsoft" ], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "CourseTitle": "Excel Dashboards", "CourseFiles": "/Microsoft Excel for Office 365-2019-2021 - Dashboards.zip", "CourseFilesTitle": "", "Intro": "Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.", "Days": "1", "Prerequisites": "To ensure success, you should have baseline skill using Excel worksheets, particularly in creating workbooks with formulas and functions.", "Audience": "This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality with Excel using functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.", "Cost": "$245.00", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "Lantec | Course: Excel 2016 Dashboard", "SEOTitle": "Lantec | Course: Excel 2016 Dashboard", "MetaDescription": "You already know how to get Microsoft® Office Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that's exactly what this course aims to help you do.", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.0, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": "", "type": "", "url": "", "locale": "", "image": "" }, "ExternalId": 9343, "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": 24585, "Name": "Excel Dashboards - VILT - 010825", "Url": "/event/excel-dashboards-vilt-010825", "Url_List": [ "/event/excel-dashboards-vilt-010825" ], "UrlSlug": "excel-dashboards-vilt-010825", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2023-04-17T00:00:00", "ExpiryDate": "2025-01-08T05:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "7b9b1af3-3cd0-491f-8aee-405c1ff7031f", "Price": 249.9000, "PriceHtml": "249.90", "priceWithTax": 249.90, "priceWithTaxHtml": "249.90", "RecommendedPrice": 245.0000, "RecommendedPriceHtml": "245.00", "RecommendedPriceWithTax": 245.00, "RecommendedPriceWithTaxHtml": "245.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 20, "Allocation": 0, "EventDateStart": "2025-01-08T08:00:00", "EventDateEnd": "2025-01-08T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 249.9000, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "Course": 9343, "Course_Name": "Excel Dashboards", "Course_Url": "/course/excel-dashboards-1", "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": 23711, "Name": "Excel Dashboards - VILT - 032125", "Url": "/event/excel-dashboards-vilt-032125", "Url_List": [ "/event/excel-dashboards-vilt-032125" ], "UrlSlug": "excel-dashboards-vilt-032125", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2023-04-17T00:00:00", "ExpiryDate": "2025-03-21T05:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "8c3361e5-c19e-40e4-b078-01eeb99a4033", "Price": 249.9000, "PriceHtml": "249.90", "priceWithTax": 249.90, "priceWithTaxHtml": "249.90", "RecommendedPrice": 245.0000, "RecommendedPriceHtml": "245.00", "RecommendedPriceWithTax": 245.00, "RecommendedPriceWithTaxHtml": "245.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 20, "Allocation": 0, "EventDateStart": "2025-03-21T08:00:00", "EventDateEnd": "2025-03-21T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 249.9000, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "Course": 9343, "Course_Name": "Excel Dashboards", "Course_Url": "/course/excel-dashboards-1", "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": {} } ] }
Mar 21, 2025
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9343",
    "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": 9343, "Name": "Excel Dashboards", "Url": "/course/excel-dashboards-1", "Url_List": [ "/course/excel-dashboards-1" ], "UrlSlug": "excel-dashboards-1", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2019-01-24T01:00:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "

Description:

\n

Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more.

To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

\n

Outline:

\n

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science

Topic B: Create and Modify Tables

Topic C: Sort and Filter Data

Lesson 2: Visualizing Data with Excel

Topic A: Visualize Data with Charts

Topic B: Modify and Format Charts

Topic C: Apply Best Practices in Chart Design

Lesson 3: Analyzing Data with Formulas and Functions

Topic A: Analyze Data with Formulas and Named Ranges

Topic B: Analyze Data with Functions

Topic C: Implement Data Validation, Forms, and Controls

Topic D: Create Conditional Visualizations with Lookup Functions

Lesson 4: Analyzing Data with PivotTables

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Lesson 5: Presenting Visual Insights with Dashboards in Excel

Topic A: Visualize Data with PivotCharts

Topic B: Filter Data Using Slicers and Timelines

Topic C: Create a Dashboard in Excel

Appendix A: Using Lookup Functions

    \n
", "Weighting": 0, "DisableForSiteSearch": false, "CreatedByMemberId": "0", "ItemCategories": [ "Courses", "Courses/Courses-Application", "Courses/Courses-Application/Microsoft" ], "ItemCategoryIdList": [ 8587, 8588, 8606 ], "ItemTags": [ "Microsoft" ], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "CourseTitle": "Excel Dashboards", "CourseFiles": "/Microsoft Excel for Office 365-2019-2021 - Dashboards.zip", "CourseFilesTitle": "", "Intro": "Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.", "Days": "1", "Prerequisites": "To ensure success, you should have baseline skill using Excel worksheets, particularly in creating workbooks with formulas and functions.", "Audience": "This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of the data analysis functionality with Excel using functions, charts, and PivotTables, and using visualizations in charts and dashboards in Excel.", "Cost": "$245.00", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "Lantec | Course: Excel 2016 Dashboard", "SEOTitle": "Lantec | Course: Excel 2016 Dashboard", "MetaDescription": "You already know how to get Microsoft® Office Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that's exactly what this course aims to help you do.", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.0, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": "", "type": "", "url": "", "locale": "", "image": "" }, "ExternalId": 9343, "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": 24585, "Name": "Excel Dashboards - VILT - 010825", "Url": "/event/excel-dashboards-vilt-010825", "Url_List": [ "/event/excel-dashboards-vilt-010825" ], "UrlSlug": "excel-dashboards-vilt-010825", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2023-04-17T00:00:00", "ExpiryDate": "2025-01-08T05:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "7b9b1af3-3cd0-491f-8aee-405c1ff7031f", "Price": 249.9000, "PriceHtml": "249.90", "priceWithTax": 249.90, "priceWithTaxHtml": "249.90", "RecommendedPrice": 245.0000, "RecommendedPriceHtml": "245.00", "RecommendedPriceWithTax": 245.00, "RecommendedPriceWithTaxHtml": "245.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 20, "Allocation": 0, "EventDateStart": "2025-01-08T08:00:00", "EventDateEnd": "2025-01-08T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 249.9000, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "Course": 9343, "Course_Name": "Excel Dashboards", "Course_Url": "/course/excel-dashboards-1", "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": 23711, "Name": "Excel Dashboards - VILT - 032125", "Url": "/event/excel-dashboards-vilt-032125", "Url_List": [ "/event/excel-dashboards-vilt-032125" ], "UrlSlug": "excel-dashboards-vilt-032125", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2023-04-17T00:00:00", "ExpiryDate": "2025-03-21T05:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "8c3361e5-c19e-40e4-b078-01eeb99a4033", "Price": 249.9000, "PriceHtml": "249.90", "priceWithTax": 249.90, "priceWithTaxHtml": "249.90", "RecommendedPrice": 245.0000, "RecommendedPriceHtml": "245.00", "RecommendedPriceWithTax": 245.00, "RecommendedPriceWithTaxHtml": "245.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 20, "Allocation": 0, "EventDateStart": "2025-03-21T08:00:00", "EventDateEnd": "2025-03-21T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 249.9000, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "Course": 9343, "Course_Name": "Excel Dashboards", "Course_Url": "/course/excel-dashboards-1", "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?


Eric was awesome! The group had different level users and he was able to present content effectively for new and intermediate level users.