The Ultimate 2022 Pivot Tables & Dashboard in Excel Bundle

Pivot Tables is an essential Excel skill for jobs that involve analyzing and visualizing large amounts of data. Pivot Tables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating sets of data and letting you analyze data in a clear and effective way. This course will discuss the importance of cleaning your data before you can create your first Pivot Table. You will also learn how to create Pivot Charts and how to format your Pivot Tables and Charts.

• Access 64 lectures & 5.5 hours of content 24/7
• Clean & prepare your data
• Create a Basic Pivot Table
• Ue the Pivot Table Fields pane
• Add Fields & Pivoting the Fields
• Format Numbers in Pivot Table
• Learn different ways to Summarize Data
• Group Pivot Table Data
• Use multiple Fields & Dimension
• Learn the methods of Aggregation
• Choose & lock the Report Layout
• Apply Pivot Table styles
• Sort data & use Filters
• Create Pivot Charts based on Pivot Table data
• Select the right Chart for your data
• Apply Conditional Formatting
• Add Slicers & Timelines to your dashboards
• Add New Data to the original source dataset
• Update Pivot Tables & Charts

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

• Access 48 lectures & 7.5 hours of content 24/7
• Do a PivotTable (a quick refresher)
• Combine data from multiple worksheets for a PivotTable
• Group, ungroup & deal with errors
• Format a PivotTable, including adjusting styles
• Use the Value Field Settings
• Learn Advanced Sorting & Filtering in PivotTables
• Use Slicers, Timelines on multiple tables
• Create a Calculated Field
• Learn all about GETPIVOTDATA
• Create a Pivot Chart & add sparklines and slicers
• Use 3D Maps from a PivotTable
• Update your data in a PivotTable & Pivot Chart
• Learn all about Conditional Formatting in a PivotTable
• Create a basic macro to refresh PivotTable data

A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. This in-depth course will prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more. It takes you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects. If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!

• Access 77 lectures & 9.5 hours of content 24/7
• Learn about Dashboard architecture & inspiration
• Prepare data for analysis (cleaning data)
• Learn useful formulas for creating dashboards in Excel
• Create & edit Pivot Tables in Excel
• Create Pivot Charts from Pivot Tables
• Learn advanced chart techniques in Excel
• Add interactive elements (form controls) into your dashboards
• Create a Sales Dashboard from scratch
• Create an HR Dashboard from scratch