Microsoft Excel – Data Analysis

• Benefits of Performing Data Analysis
• Stages of Data Analysis

Summarizing & Analyzing Large Data

• Analyzing Performance against Target
• Using Powerful New Features
• Flash Fill
• Quick Analysis
• Advanced Data Sorting techniques
• Advanced Filtering Techniques
• Applying Validation Checks on Data

Conditional Formatting

• Highlighting Data Based on Specified Criteria
• Create your own Formatting Rules
• Using Non Charting Visualization
• Data Bars
• Icon Sets
• Color Scales

Excel New Feature: Sparklines

• What are Sparklines?
• Inserting & Modifying Sparklines
• Analyzing Data with Sparklines
• Performing Tweaks with Sparklines
• Handling Missing Data
• Making the Sparklines Dynamic (Auto-Update)

Advanced Charts & Graphs

• Going through different types of Charts
• Modifying Charts and Working with Chart Options
• Advanced Charts Formatting
• Inserting Text and Pictures inside Charts
• Modifying Chart Axis
• Creating Specialized Charts for Measuring Performance
• Combo Chart
• Dynamic Chart
• Thermometer Chart
• Bullet Chart

Pivot Tables

• Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
• Creating & Modifying Pivot Tables
• Performing Calculations within Pivot Tables
• Working with Pivot Charts
• Analyzing Data with Excellent New Features in Pivot Tables
• Slicers
• Timelines

What-IF Analysis

• Using the brilliant Goal-Seek Feature
• Performing Sensitivity Analysis with Data Tables
• Using Scenario Manager to Summarize Results

Data Validation

• Creating Drop Down List
• Regulating & Managing the Entry of Data
• Custom Input Message and Error Alert

Enhancing Interactivity

• Adding Interactive Advanced Controls
• Buttons Control
• Check Box
• Spin Buttons
• Option Buttons

Automating Reports

• Using Macros to Automate Reports
• Recording a Macro
• Running a Macro
• Assigning Macros to Objects & Buttons