Microsoft Excel for Reporting and Business Analysis

Course Outline

Module 1

• Introduction to Microsoft Excel
• Introduction, Outline and Objectives
• Functions and Formulae
• Entering and Copying Formulae
• Creating Formulas using Names
• Managing Names using, Name Manager
• Searching for Functions
• Naming Ranges
• Creating Named Ranges
• Using Names in Movement
• Inserting Names in Formulae
• Formatting
• Number Formatting
• Cell Styles
• Copying and Clearing formatting

Module 2

• Calculating with Formulas and Functions
• Use Date and Time Functions
• Use Statistical Functions
• Use Database Functions
• Use Lookup Functions
• Use Logical Functions

Module 3

• Visualizing Data with Charts
• Use Recommended Charts Tool
• Create Chart with Quick Analysis
• Align Chart Axis Labels
• Display Value Axis in Millions
• Create Chart with Multi-Line Labels
• Create Combo Chart
• Create Chart Template for Sharing
• Build Dynamic Chart with Table

Module 4

• Analyzing Data with Table
• Create Table with Quick Analysis
• Remove Duplicate Records
• Add Total Row to Table
• Insert Calculated Columns
• Filter Table Data with Custom Filter
• Use Slicer to Filter Data
• Apply Conditional Formatting
• Sort and Filter Data by Color
• Create In-Cell Chart with Sparklines
• Analyzing Data with PivotTables
• Overview of PivotTable and PivotChart
• Create PivotTable from Table
• Change Report Layouts
• Show and Hide Report Totals
• Create Custom Calculations
• Filter Pivot Data with Slicer and Timeline
• Group Fields in a PivotTable
• Create Calculated Fields in PivotTable

Module 5

• Importing External Data Sources
• Import Data from Text Files
• Create PivotTable from Microsoft Access
• Create PivotChart from Microsoft Access
• Manage Data Connections
• Creating Dashboard Report
• Overview of Dashboard
• Create PivotTable and PivotChart
• Hide Field Buttons from PivotChart
• Use Slicer to Connect PivotTables
• Build a Slicer Dashboard Report
• Other Tips and Tools
• Flash Fill
• Quick Analysis
• Slicer to Filter Excel Table
• Timeline to Filter PivotTable
• Connecting Multiple PivotTables
• Sparklines