In this Webinar you will learn how to create Tables and Pivot Tables from large databases in excel!
This Webinar teaches:
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.
Welcome to the ASAP Circle, a community platform for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We even have designated spaces for weekly Tuesday Coffee Breaks.