MICROSOFT EXCEL – DATA ANALYSIS

Additional information:

• Price: 1800  AED
• Duration: 16 Hours
• Timings: Flexible

Course Overview: 

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