Microsoft Excel - Data Analysis 


Price:                                       1800 AED
Duration:                                  16 Hours
Timings:                                    Flexible

 

Topics Covered: 

Introduction

  • 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