MICROSOFT EXCEL – DATA ANALYSIS

AED 1,800.00AED 2,300.00

Available!

  • Price: 1800  AED
  • Duration: 16 Hours
  • Timings: Flexible
Compare
Enquire Now

 

 

 

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

Reviews

There are no reviews yet.

Be the first to review “MICROSOFT EXCEL – DATA ANALYSIS”

Your email address will not be published. Required fields are marked *

Vendor Information

  • Address:
  • No ratings found yet!

No products in the cart.

Emotions

FREE
VIEW