Price: AED 1,800

Duration: 18 Hours

Timing: Flexible

Course Overview

Microsoft Excel Data Analysis is the world’s most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will increase your productivity. You will be a very efficient and highly competent

 

Course Outline

Introduction to Microsoft Excel Data Analysis

  1. Benefits of Performing Data Analysis
  2. Stages of Data Analysis

 

Summarizing & Analyzing Large Data

  1. Analyzing Performance against Target
  2. Using Powerful New Features
  3. Flash Fill
  4. Quick Analysis
  5. Advanced Data Sorting techniques
  6. Advanced Filtering Techniques
  7. Applying Validation Checks on Data

 

Conditional Formatting

  1. Highlighting Data Based on Specified Criteria
  2. Create your own Formatting Rules
  3. Using Non Charting Visualization
  4. Data Bars
  5. Icon Sets
  6. Color Scales

 

Excel New Feature: Sparklines

  1. What are Sparklines?
  2. Inserting & Modifying Sparklines
  3. Analyzing Data with Sparklines
  4. Performing Tweaks with Sparklines
  5. Handling Missing Data
  6. Making the Sparklines Dynamic (Auto-Update)

 

Advanced Charts & Graphs

  1. Going through different types of Charts
  2. Modifying Charts and Working with Chart Options
  3. Advanced Charts Formatting
  4. Inserting Text and Pictures inside Charts
  5. Modifying Chart Axis
  6. Creating Specialized Charts for Measuring Performance
  7. Combo Chart
  8. Dynamic Chart
  9. Thermometer Chart
  10. Bullet Chart

 

Pivot Tables

  1. Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
  2. Creating & Modifying Pivot Tables
  3. Performing Calculations within Pivot Tables
  4. Working with Pivot Charts
  5. Analyzing Data with Excellent New Features in Pivot Tables
  6. Slicers
  7. Timelines

 

What-IF Analysis

  1. Using the brilliant Goal-Seek Feature
  2. Performing Sensitivity Analysis with Data Tables
  3. Using Scenario Manager to Summarize Results

 

Data Validation

  1. Creating Drop Down List
  2. Regulating & Managing the Entry of Data
  3. Custom Input Message and Error Alert

 

Enhancing Interactivity

  1. Adding Interactive Advanced Controls
  2. Buttons Control
  3. Check Box
  4. Spin Buttons
  5. Option Buttons

 

Automating Reports

  1. Using Macros to Automate Reports
  2. Recording a Macro
  3. Running a Macro
  4. Assigning Macros to Objects & Buttons

 

Who is it for?

This course Microsoft Excel Data Analysis are for those who are in reporting areas like accountants and other professionals who uses the application to make their work easier. 

Related Courses