rewardsGroup Discounts!
Group of three or more? Contact us for a group Discount…

Labros Financial TrainingBook a Free trial Lecture.
Call us Today| 042-667364

Labros Financial TrainingEnhance your career Potential, become a globally recognized CMA.
Save up to 33% on Fee in upcoming batch.

rewardsGet Reward! Each time you refer a friend & Family member
you will receive referral bonus other than applicable discount (T&C Applies).

Labros Financial TrainingSecure your future, Invest right, Invest now.
Study 4 ACCA paper at the Price of 3.

Labros Financial TrainingMighty Saving!
Save up to 40% when you book five or more CIMA Paper.

Labros Financial TrainingBecome a CPA: Chose to work for public accountant in
“Big Four Firms “Pass your CPA with Labros. Apply for 25% Discount

Labros Financial TrainingAchieve your Charter: A Career Tool for Finance Professional.
Pass your CFA in first attempt. 20% Discount available 14th of Aug Batch Call us now 04-2667364

Data Analysis with Excel

Course Duration 16 Hours

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