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

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 TrainingBecome a CPA: Chose to work for public accountant in
“Big Four Firms “Pass your CPA with Labros. Apply for 25% Discount

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

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

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

Intermediate MS Excel Training Outline

Course Duration: 16 Hours

Introduction

  • Spreadsheets & Its Terminology
  • Understanding Excel Interface
  • Entering & Editing Data
  • Opening, Closing & Saving Workbook
  • Prevent Data Loss in the Event of System Crash
  • Didn’t Save a Workbook? Don’t Worry – Recover Unsaved
  • Workbooks

Basic Formula & Function

  • Difference between a Formula & Function
  • Learning the Core Excel Functions
  • Nesting Functions
  • Understanding Relative, Absolute & Mixed Referencing
  • Defining Names and Using them in Functions

Formatting Techniques

  • Useful Formatting Tools
  • Using Special Number Formatting
  • Applying Predefined Styles & Themes
  • Inserting Pictures, Objects & Smart Art

Working with Dates & Time

  • The Science of Dates & Time in Excel
  • Useful Date & Time Functions

Efficient Handling of Large Data

  • Quick Data Selection Techniques – Use of Ctrl & Shift Keys
  • Quick Data Entry Techniques
  • Using the Fill Handle
  • Accelerating Copy Paste
  • Learning Sorting & Filtering

Analyzing Data with Conditional Formatting

  • Highlighting Cells based on Different Criteria
  • Using the Data Bars, Icon Sets & Color Scales

Working with Tables

  • Exploring the Power of Excel Tables
  • Creating Dynamic Ranges with Tables

Working with Charts & Graphs

  • Dos & DONTs of Excel Charting
  • Creating a Chart in no Time!
  • Useful Charting Techniques

 

Lookup Functions

  • Learning the Powerful IF Function
  • Evaluating Multiple Results with Nested IF
  • Learning the All Important VLOOKUP & Its
  • Limitations
  • Analyzing Data with Criteria – SUMIF Family
  • Functions

 

Pivot Tables

  • Understanding the Power of Pivot Tables – An
  • Excellent Reporting Tool!
  • How to Create a Pivot Table
  • How to Generate Reports from Pivot Tables
  • Managing & Presenting Pivot Table

 

Managing Workbook & Worksheet

  • Linking Worksheets & Workbooks
  • Performing Calculations across Worksheets with
  • 3D Formula
  • Creating a Hyperlink

 

Printing

  • Printing Fundamentals

 

Security

  • Protecting Workbook with Password
  • Restrict Editing Data
  • Hiding the Contents of the Cell