Create Dashboards Using Tables or Pivot Tables and Quickly Query Your Information

In this Webinar you will learn how to create Tables and Pivot Tables from large databases in excel! 

This Webinar teaches:

• What is a Normalized Table
• Creating a Pivot Table Automatically and Manually
• Laying out and Formatting a table
• Modifying a Pivot Tables
• Creating Slicers to Create a Dashboard to Answer Questions against the Data

Bonus Handout: Creating Dashboards using tables or Pivot Tables and Quickly Query Your Information

Hot Tip: Creating A Pivot Table Automatically

If your data is in a worksheet, select any cell within the data range Choose Insert > Tables Recommended PivotTables. Excel quickly scans your data, and the Recommended PivotTables dialog box presents thumbnails that depict some pivot tables that you can choose from.

Selecting a Recommended PivotTable

The pivot table thumbnails use your actual data, and there is a good chance that one of them will be exactly what you're looking for — or at least close to what you're looking for. Select a thumbnail, click 0K, and Excel creates the pivot table on a new worksheet.

When any cell in a pivot table is selected, Excel displays the PivotTable Fields task pane. You can use this task pane to make changes to the layout of the pivot table.
 

About Neil Malek: Neil Malek is the Principal at Knack Training, a software and professional development training and consulting company. For the last twenty years, Neil has worked with universities, governments, non-profits, and Fortune 100 companies to identify and close skill gaps.