The Microsoft Excel Data Analysis Toolkit Bundle

It seems like you've provided a comprehensive outline for a course on advanced Excel skills, specifically focusing on PivotTables, advanced formulas, and dashboard creation. This course is designed to take students from beginner to advanced level, covering a wide range of topics within Excel.

Here's a summary of what the course offers:

1. Basic PivotTable Creation and Usage

   • Understanding the different ways to create a PivotTable.
   • Learning about the methods of aggregation like SUM, COUNT, AVERAGE, etc.
   • Choosing and locking a report layout.
   • Applying PivotTable styles for better visual representation.
   • Sorting data and using filters to manage your data effectively.
   • Creating pivot charts based on PivotTable data.
   • Selecting the right chart type for different datasets.
   • Applying conditional formatting to highlight important data points.
   • Adding slicers and timelines to dashboards for interactive filtering.
   • Updating PivotTables and charts with new data.

2. Advanced PivotTable Techniques

   • A quick refresher on creating PivotTables.
   • Combining data from multiple worksheets.
   • Grouping, ungrouping, and dealing with errors in your data.
   • Formatting a PivotTable, including style adjustments.
   • Using Value Field Settings to change the way data is aggregated.
   • Advanced sorting and filtering techniques.
   • Utilizing Slicers and Timelines on multiple tables for better analysis.
   • Creating a Calculated Field within a PivotTable.
   • Exploring GETPIVOTDATA function to extract pivot table data.
   • Adding sparklines and slicers for an interactive dashboard.
   • Using 3D Maps from your PivotTable data.
   • Updating your data in a PivotTable and Pivot Chart.
   • Mastering conditional formatting within a PivotTable.
   • Creating amazing dashboards with the power of PivotTables.

3. Advanced Formulas in Excel

   • Using formulas to filter datasets.
   • Sorting data using formulas and defined variables.
   • Creating multi-dependent dynamic drop-down lists.
   • Performing 2-way lookups.
   • Complex logical calculations for decision making.
   • Extracting parts of a text string with Excel functions.
   • Dynamic chart titles using formulas.
   • Finding the last occurrence of a value in a list.
   • Utilizing XLOOKUP for lookup operations.
   • Finding the closest match to a value for more precise lookups.

The course promises over 30 hours of video tutorials, 230 individual video lectures, exercise files to practice the skills learned, and a certificate of completion. It's relevant to users of Excel 2019, Excel 365, Excel 2013, and Excel 2016.

Students have given positive feedback on the course, highlighting the clarity of the tutorials and the excitement it brings to those new to data analytics. The course is designed to cater to a wide audience, from those with IT knowledge looking to specialize in data analytics, to complete beginners.