Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}

{
  "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.
Request To Schedule
",
    "object": "collection",
    "type": "module"
  },
  "Pagination": {
    "CurrentPage": 0,
    "ItemsPerPage": 0,
    "NumberOfPages": 0,
    "TotalItemsCount": 0
  },
  "Parent": {
    "Id": 9342,
    "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot",
    "Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "Url_List": [
      "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot"
    ],
    "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
    "ParentId": 5934,
    "ParentId_List": [
      -1
    ],
    "ParentName": "",
    "ParentUrl": "",
    "TemplateName": "",
    "Module_Alias": "Course",
    "Module_ID": 5934,
    "Enabled": true,
    "ReleaseDate": "2016-07-14T00:00:00",
    "ExpiryDate": "9999-01-01T01:00:00",
    "SiteSearchKeywords": [],
    "Description": "
Description:
\nAdvances 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\ninsight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of\ndoing 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.\nWith PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximizing your\neffectiveness when analyzing data.\n\n
Outline:
\n\n
Lesson 1: Preparing Data and Creating PivotTables
\n
\n    
Topic A: Prepare Data
\n    
Topic B: Create a PivotTable from a Local Data Source
\n    
Topic C: Create a PivotTable from Multiple Local Data Sources
\n    
Topic D: Create a PivotTable from an External Data Source
\n
\n\n\n
Lesson 2: Analyzing Data Using PivotTables
\n
\n    
Topic A: Summarize PivotTable Data
\n    
Topic B: Organize PivotTable Data
\n    
Topic C: Filter PivotTable Data
\n    
Topic D: Format a PivotTable
\n    
Topic E: Refresh and Change PivotTable Data
\n
\n\n\n
Lesson 3: Working with PivotCharts
\n
\n    
Topic A: Create a PivotChart
\n    
Topic B: Manipulate PivotChart Data
\n    
Topic C: Format a PivotChart
\n
\n\n\n
Lesson 4: Getting Started with PowerPivot
\n
\n    
Topic A: Enable and Navigate PowerPivot
\n    
Topic B: Manage Data Relationships
\n
\n\n\n
Lesson 5: Visualizing PowerPivot Data
\n
\n    
Topic A: Create a PowerPivot Report
\n    
Topic B: Create Calculations in PowerPivot
\n
\n\n\n
Lesson 6: Working with Advanced Functionality in PowerPivot
\n
\n    
Topic A: Create a Key Performance Indicator
\n    
Topic B: Work with Dates and Times to PowerPivot
\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 Tools: Pivot Tables and PowerPivot",
    "CourseFiles": "/_assets/img/Exercise Files/Excel 2016 Data Analysis with PitvotTables and PowerPivot.zip",
    "CourseFilesTitle": "",
    "Intro": "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. ",
    "Days": "1",
    "Prerequisites": "To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.  Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables and PowerPivot.",
    "Audience": "Students taking this class should be experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables 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                    \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    
\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": 22835,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T17:00:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "d454d899-f5b5-479b-8b54-e987c788d0c5",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-09-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23821,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 101024",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-101024-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-10-10T14:39:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "381ccc92-35ab-4690-9f5b-a9c0d370b668",
      "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": "2024-10-10T08:00:00",
      "EventDateEnd": "2024-10-10T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22954,
      "Name": "Excel  Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "ad87c036-f74c-4597-8a04-742e9eba72a9",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23822,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 121124",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-121124-1",
      "ParentId": 1827,
      "ParentId_List": [
        -1
      ],
      "ParentName": "",
      "ParentUrl": "",
      "TemplateName": "",
      "Module_Alias": "Event",
      "Module_ID": 1827,
      "Enabled": true,
      "ReleaseDate": "2023-02-02T00:00:00",
      "ExpiryDate": "2024-12-11T14:41:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "336cd916-5d57-4fe5-b347-9d3cf69aadbc",
      "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": "2024-12-11T08:00:00",
      "EventDateEnd": "2024-12-11T17: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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 23703,
      "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",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-020625",
      "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-06T13:37:00",
      "SiteSearchKeywords": [],
      "Description": "",
      "Weighting": 0,
      "DisableForSiteSearch": false,
      "SKUCode": "f233ba2d-2a58-4226-a3fa-acfdf9fc02a4",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": 22097,
      "Name": "Excel Advanced Data Analysis Tools: Pivot Tables and PowerPivot - VILT - 042824",
      "Url": "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "Url_List": [
        "/event/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824"
      ],
      "UrlSlug": "excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot-vilt-042824",
      "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": "0e41b3de-923a-4616-9bce-1d8fecaef697",
      "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 Tools: Pivot Tables and PowerPivot",
      "Course_Url": "/course/excel-advanced-data-analysis-tools-pivot-tables-and-powerpivot",
      "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": {}
    }
  ]
}