Quick Analysis tool allows you to quickly create graphs, sparklines, PivotTable, PivotChart and summary functions by just clicking on a button. Conditional formatting is a feature which allows you to apply a format to a cell or a range of cells based on certain criteria such as highlight duplicate records, highest values and lowest values. A Sparkline is a tiny chart in a worksheet cell that allows you to quickly visualize the overall trend of a set of values or to indicate maximum and minimum values.
Building Interactive Spreadsheet Report
Excel table enables you to manage and analyze a group of related data easier. You can create calculated columns, add slicer to Excel table and create relationships between two tables.
Participant will learn how to create table-driven reports using Excel data and external data, sort data in different ways using custom list, filter the table data to show highest cost and revenue, filter the table using Slicers and create relationships between two tables.
Creating Dynamic PivotTable Report
Participant will learn powerful report features such as creating PivotTable report from different data sources, using the Automatic relationship detection to discover and create relationships among the tables used for your workbook’s data model, using Timeline to filter date field, using multi-select Slicer to filter multiple items, adding subtotals by grouping field, calculating sales performance and comparing two customer lists by using a PivotTable.
Creating Impressive PivotChart Report
Participant will learn how to create PivotChart to represent data in a graphical portrayal, create a line-column PivotChart to show different data series, use multi-select Slicer to filter PivotChart, use Timeline to filter PivotChart based on dates and out across groupings of time and other hierarchical structures within your data.
The case studies are based on real-life business scenarios and problems encountered by Excel users in daily jobs.