LANTEC Logo
BACK
Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot

Excel Advanced Data Analysis with Pivot Tables and PowerPivot

$245.00
1 days
Audience
Prerequisites
Course Files
Share
Print

Description:

This full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets

Outline:

Lesson 1: Preparing Data and Creating PivotTables

  • Topic A: Prepare Data for PivotTable Reporting
  • Topic B: Create PivotTables from Local Data Sources
  • Topic C: Create PivotTables from Multiple Local Data Sources
  • Topic D: Create PivotTables from External Data Sources

Lesson 2: Analyzing Data by Using PivotTables

  • Topic A: Summarize PivotTable Data
  • Topic B: Organize and Filter PivotTable Data
  • Topic C: Format PivotTables
  • Topic D: Refresh and Modify PivotTable Data

Lesson 3: Working with PivotCharts

  • Topic A: Create and Format PivotCharts
  • Topic B: Manipulate PivotChart Data
  • Topic C: Use PivotCharts for Data Visualization

Lesson 4: Getting Started with PowerPivot

  • Topic A: Enable and Navigate PowerPivot
  • Topic B: Manage Data Relationships within Power Pivot

Lesson 5: Visualizing Power Pivot Data

  • Topic A: Create Power Pivot Reports
  • Topic B: Use Calculations in PowerPivot for Enhanced Data Insights

Lesson 6: Working with Advanced Functionality in Power Pivot

  • Topic A: Create and Analyze KPIs (Key Performance Indicators)
  • Topic B: Work with Dates and Time in PowerPivot for Advanced Analysis

Appendix A: Overview of Commonly Used DAX (Data Analysis Expressions) Functions

Scheduled Courses

Feb 06, 2025
vILT (Virtual)
Enroll
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9342",
    "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": 9342,
    "Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "Url_List": [
      "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline"
    ],
    "UrlSlug": "excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2024-10-16T09:27:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nThis full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
  • Topic A: Prepare Data for PivotTable Reporting
  • Topic B: Create PivotTables from Local Data Sources
  • Topic C: Create PivotTables from Multiple Local Data Sources
  • Topic D: Create PivotTables from External Data Sources
Lesson 2: Analyzing Data by Using PivotTables
  • Topic A: Summarize PivotTable Data
  • Topic B: Organize and Filter PivotTable Data
  • Topic C: Format PivotTables
  • Topic D: Refresh and Modify PivotTable Data
Lesson 3: Working with PivotCharts
  • Topic A: Create and Format PivotCharts
  • Topic B: Manipulate PivotChart Data
  • Topic C: Use PivotCharts for Data Visualization
Lesson 4: Getting Started with PowerPivot
  • Topic A: Enable and Navigate PowerPivot
  • Topic B: Manage Data Relationships within Power Pivot
Lesson 5: Visualizing Power Pivot Data
  • Topic A: Create Power Pivot Reports
  • Topic B: Use Calculations in PowerPivot for Enhanced Data Insights
Lesson 6: Working with Advanced Functionality in Power Pivot
  • Topic A: Create and Analyze KPIs (Key Performance Indicators)
  • Topic B: Work with Dates and Time in PowerPivot for Advanced Analysis
Appendix A: Overview of Commonly Used DAX (Data Analysis Expressions) Functions
    \n
",
    "Weighting": 0,
    "DisableForSiteSearch": false,
    "CreatedByMemberId": "0",
    "ItemCategories": [
      "Courses",
      "Courses/Courses-Application",
      "Courses/Courses-Application/Business Intelligence",
      "Courses/Courses-Application/Microsoft"
    ],
    "ItemCategoryIdList": [
      8576,
      8587,
      8588,
      8606
    ],
    "ItemTags": [
      "Microsoft"
    ],
    "Author": 0,
    "Author_Name": "",
    "Author_Url": "",
    "Item_Rating": 0,
    "CourseTitle": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "This full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets.",
    "Days": "1",
    "Prerequisites": "Participants should be comfortable using Excel and have experience creating basic PivotTables.",
    "Audience": "This course is ideal for experienced Excel users looking to further their expertise in data analysis by utilizing advanced PivotTable features and PowerPivot.",
    "Cost": "$245.00",
    "GoogleAnalyticsCode": "",
    "Popular": false,
    "Photo": "",
    "Disclaimer": "",
    "ShowPageForSearchEngine": true,
    "MetaTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "SEOTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "MetaDescription": "Advances in technology have made it possible to store ever increasing amounts of data.  Along with this, the need to analyze that data and gain actionable insight is greater than ever.  Most users have experienced working with Excel and creating basic PivotTables to summarize data.  Excel is capable of doing much more.  Students will not only be able to summarize data, but also organize the data in a way that can be meaningfully presented to others.  With PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible.  This tools combined with maximize your effectiveness when analyzing data. ",
    "CanonicalLink": "",
    "SocialMetaTags": "",
    "SeoPriority": 0.0,
    "EnableAMP": false,
    "AMPContent": "",
    "OpenGraphProperties": {
      "title": "",
      "type": "",
      "url": "",
      "locale": "",
      "image": ""
    },
    "ExternalId": 9342,
    "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": 23836,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 020625",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-02-06T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "fa24dacb-82d1-41da-8155-9e96c98d8f85",
      "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-02-06T08:00:00",
      "EventDateEnd": "2025-02-06T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24107,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042825",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-04-28T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "6d173ae1-78b8-41a2-809a-27fe74d8cdbb",
      "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-04-28T08:00:00",
      "EventDateEnd": "2025-04-28T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24607,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 062525",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-06-25T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "7d35fe3a-ca5d-48a2-971b-fd76f48abe66",
      "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-06-25T08:00:00",
      "EventDateEnd": "2025-06-25T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": {}
    }
  ]
}
Apr 28, 2025
vILT (Virtual)
Enroll
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9342",
    "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": 9342,
    "Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "Url_List": [
      "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline"
    ],
    "UrlSlug": "excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2024-10-16T09:27:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nThis full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
  • Topic A: Prepare Data for PivotTable Reporting
  • Topic B: Create PivotTables from Local Data Sources
  • Topic C: Create PivotTables from Multiple Local Data Sources
  • Topic D: Create PivotTables from External Data Sources
Lesson 2: Analyzing Data by Using PivotTables
  • Topic A: Summarize PivotTable Data
  • Topic B: Organize and Filter PivotTable Data
  • Topic C: Format PivotTables
  • Topic D: Refresh and Modify PivotTable Data
Lesson 3: Working with PivotCharts
  • Topic A: Create and Format PivotCharts
  • Topic B: Manipulate PivotChart Data
  • Topic C: Use PivotCharts for Data Visualization
Lesson 4: Getting Started with PowerPivot
  • Topic A: Enable and Navigate PowerPivot
  • Topic B: Manage Data Relationships within Power Pivot
Lesson 5: Visualizing Power Pivot Data
  • Topic A: Create Power Pivot Reports
  • Topic B: Use Calculations in PowerPivot for Enhanced Data Insights
Lesson 6: Working with Advanced Functionality in Power Pivot
  • Topic A: Create and Analyze KPIs (Key Performance Indicators)
  • Topic B: Work with Dates and Time in PowerPivot for Advanced Analysis
Appendix A: Overview of Commonly Used DAX (Data Analysis Expressions) Functions
    \n
",
    "Weighting": 0,
    "DisableForSiteSearch": false,
    "CreatedByMemberId": "0",
    "ItemCategories": [
      "Courses",
      "Courses/Courses-Application",
      "Courses/Courses-Application/Business Intelligence",
      "Courses/Courses-Application/Microsoft"
    ],
    "ItemCategoryIdList": [
      8576,
      8587,
      8588,
      8606
    ],
    "ItemTags": [
      "Microsoft"
    ],
    "Author": 0,
    "Author_Name": "",
    "Author_Url": "",
    "Item_Rating": 0,
    "CourseTitle": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "This full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets.",
    "Days": "1",
    "Prerequisites": "Participants should be comfortable using Excel and have experience creating basic PivotTables.",
    "Audience": "This course is ideal for experienced Excel users looking to further their expertise in data analysis by utilizing advanced PivotTable features and PowerPivot.",
    "Cost": "$245.00",
    "GoogleAnalyticsCode": "",
    "Popular": false,
    "Photo": "",
    "Disclaimer": "",
    "ShowPageForSearchEngine": true,
    "MetaTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "SEOTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "MetaDescription": "Advances in technology have made it possible to store ever increasing amounts of data.  Along with this, the need to analyze that data and gain actionable insight is greater than ever.  Most users have experienced working with Excel and creating basic PivotTables to summarize data.  Excel is capable of doing much more.  Students will not only be able to summarize data, but also organize the data in a way that can be meaningfully presented to others.  With PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible.  This tools combined with maximize your effectiveness when analyzing data. ",
    "CanonicalLink": "",
    "SocialMetaTags": "",
    "SeoPriority": 0.0,
    "EnableAMP": false,
    "AMPContent": "",
    "OpenGraphProperties": {
      "title": "",
      "type": "",
      "url": "",
      "locale": "",
      "image": ""
    },
    "ExternalId": 9342,
    "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": 23836,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 020625",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-02-06T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "fa24dacb-82d1-41da-8155-9e96c98d8f85",
      "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-02-06T08:00:00",
      "EventDateEnd": "2025-02-06T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24107,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042825",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-04-28T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "6d173ae1-78b8-41a2-809a-27fe74d8cdbb",
      "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-04-28T08:00:00",
      "EventDateEnd": "2025-04-28T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24607,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 062525",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-06-25T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "7d35fe3a-ca5d-48a2-971b-fd76f48abe66",
      "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-06-25T08:00:00",
      "EventDateEnd": "2025-06-25T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": {}
    }
  ]
}
Jun 25, 2025
vILT (Virtual)
Enroll
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9342",
    "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": 9342,
    "Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "Url_List": [
      "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline"
    ],
    "UrlSlug": "excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2024-10-16T09:27:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nThis full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
  • Topic A: Prepare Data for PivotTable Reporting
  • Topic B: Create PivotTables from Local Data Sources
  • Topic C: Create PivotTables from Multiple Local Data Sources
  • Topic D: Create PivotTables from External Data Sources
Lesson 2: Analyzing Data by Using PivotTables
  • Topic A: Summarize PivotTable Data
  • Topic B: Organize and Filter PivotTable Data
  • Topic C: Format PivotTables
  • Topic D: Refresh and Modify PivotTable Data
Lesson 3: Working with PivotCharts
  • Topic A: Create and Format PivotCharts
  • Topic B: Manipulate PivotChart Data
  • Topic C: Use PivotCharts for Data Visualization
Lesson 4: Getting Started with PowerPivot
  • Topic A: Enable and Navigate PowerPivot
  • Topic B: Manage Data Relationships within Power Pivot
Lesson 5: Visualizing Power Pivot Data
  • Topic A: Create Power Pivot Reports
  • Topic B: Use Calculations in PowerPivot for Enhanced Data Insights
Lesson 6: Working with Advanced Functionality in Power Pivot
  • Topic A: Create and Analyze KPIs (Key Performance Indicators)
  • Topic B: Work with Dates and Time in PowerPivot for Advanced Analysis
Appendix A: Overview of Commonly Used DAX (Data Analysis Expressions) Functions
    \n
",
    "Weighting": 0,
    "DisableForSiteSearch": false,
    "CreatedByMemberId": "0",
    "ItemCategories": [
      "Courses",
      "Courses/Courses-Application",
      "Courses/Courses-Application/Business Intelligence",
      "Courses/Courses-Application/Microsoft"
    ],
    "ItemCategoryIdList": [
      8576,
      8587,
      8588,
      8606
    ],
    "ItemTags": [
      "Microsoft"
    ],
    "Author": 0,
    "Author_Name": "",
    "Author_Url": "",
    "Item_Rating": 0,
    "CourseTitle": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "This full-day course will enhance your data analysis skills using advanced Excel features, including PivotTables and Power Pivot. You will learn how to organize, manipulate, and present large datasets for data-driven decision-making. The course is split into two parts: AM Section: Advanced use of PivotTables and PivotCharts. PM Section: Power Pivot for managing and analyzing large datasets.",
    "Days": "1",
    "Prerequisites": "Participants should be comfortable using Excel and have experience creating basic PivotTables.",
    "Audience": "This course is ideal for experienced Excel users looking to further their expertise in data analysis by utilizing advanced PivotTable features and PowerPivot.",
    "Cost": "$245.00",
    "GoogleAnalyticsCode": "",
    "Popular": false,
    "Photo": "",
    "Disclaimer": "",
    "ShowPageForSearchEngine": true,
    "MetaTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "SEOTitle": "Lantec | Course: Excel 2016 Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "MetaDescription": "Advances in technology have made it possible to store ever increasing amounts of data.  Along with this, the need to analyze that data and gain actionable insight is greater than ever.  Most users have experienced working with Excel and creating basic PivotTables to summarize data.  Excel is capable of doing much more.  Students will not only be able to summarize data, but also organize the data in a way that can be meaningfully presented to others.  With PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible.  This tools combined with maximize your effectiveness when analyzing data. ",
    "CanonicalLink": "",
    "SocialMetaTags": "",
    "SeoPriority": 0.0,
    "EnableAMP": false,
    "AMPContent": "",
    "OpenGraphProperties": {
      "title": "",
      "type": "",
      "url": "",
      "locale": "",
      "image": ""
    },
    "ExternalId": 9342,
    "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": 23836,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 020625",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-02-06T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "fa24dacb-82d1-41da-8155-9e96c98d8f85",
      "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-02-06T08:00:00",
      "EventDateEnd": "2025-02-06T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24107,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042825",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042825",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-04-28T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "6d173ae1-78b8-41a2-809a-27fe74d8cdbb",
      "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-04-28T08:00:00",
      "EventDateEnd": "2025-04-28T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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": 24607,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 062525",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-062525",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2025-06-25T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "7d35fe3a-ca5d-48a2-971b-fd76f48abe66",
      "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-06-25T08:00:00",
      "EventDateEnd": "2025-06-25T17: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": 9342,
      "Course_Name": "Excel Advanced Data Analysis with Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-with-pivot-tables-and-powerpivot-course-outline",
      "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?


Brittany Pitre, Trade Construction

"Perfect class at a great pace. Bottom link and no extra nonsense."