Dashboards are a powerful tool for managing data in Excel. They allow you to view and analyze large data sets in one attractive and easy to manage location. With earlier versions of Excel, reporting frequently meant generating different reports for different people or departments depending on their needs. With dashboards, the same report can be quickly customized to meet the needs of everyone who needs a report.
Dashboards apply PivotTables, PivotCharts and PivotTable tools such as filters, sorting, slicers and timelines to data so your worksheet displays only data you want to see. Want to view a different set of data? Because dashboards are dynamic and interactive, all you have to do is click a slicer and the dashboard updates automatically to show you only the data that is important to you.
If you use Excel to manage data, this class will give you tools to make your job much easier! Class topics include: Database terminology and design, Naming ranges, Excel tables vs. data ranges, Sorting and Filtering, PivotTables, PivotCharts, Slicers, Timelines and Creating Dashboards.