MICROSOFT EXCEL AND PIVOT TABLE

MODULE 1: PIVOT TABLE

• Creating Pivot Table
• Working with Pivot Tables
• Updating a Pivot Table
• Changing the Layout of the Pivot Table
• Adding and Removing Fields in a Pivot Table
• Pivot Table Formatting
• Pivot Tables Formatting Options
• Format Report Using Conditional Formatting inside Pivot Tables
• Add a conditional format
• Pivot Table Toolbar

MODULE 2: CALCULATIONS FROM PIVOT TABLES

• Pivot Table Formula
• Adding Calculated Fields
• Adding Calculated Items
• Edit a calculated field formula
• Edit a single formula for a calculated item
• Edit individual formulas for specific cells of a calculated item
• Using VLOOKUP with the Pivot Tables
• GETPIVOTDATA

MODULE 3: ADVANCED PIVOT TABLE OPTIONS

• Pivot Table Summaries
• Pivot Table Field Options
• Changing Pivot Table Options
• Other Pivot Table Options Setting

MODULE 4: POWER PIVOT

• Loading external data
• Basic cleaning of data
• Creating model
• Adding calculated columns
• Creating Power Pivot

MODULE 5: CREATING PIVOT TABLES FROM DIFFERENT SOURCES

• Creating a Pivot Tables based on another Pivot Table
• Creating a Pivot Tables from External Data
• Consolidating Information Using Pivot Tables
• Create a Pivot Table Consolidate from multiple worksheets

MODULE 6: DASHBOARD CHARTING TECHNIQUES

• Creating Charts
• Creating user-defined chart types
• Changing the default chart type
• Combining different chart types in one chart
• Creating custom markers
• Creating miniature charts suitable for dashboards
• Using Sparklines
• Target vs Actual charts
• Bubble charts

MODULE 7: CREATING A DASHBOARD

• Dashboard layout
• Best Practice
• Effective use of color
• Creating interactive dashboard