Posted on by

(Incl Formulas, Pivots & Charts )

Introduction

Learn proven quantitative tools and methods of Microsoft Excel for analysing, interpreting, and utilizing data, so that more informed and reliable business decisions can be made.

By the end of the workshop you will have a Strong command over

  • Formulas with Multi dimensions
  • Combining more than one formula
  • Lookup with match, row, column, index, match, array formulas
  • User define array formulas
  •  Pivot table and charts 
  • Creating Dashboards and MIS reports.
  • Consolidating and managing data from multiple workbooks.

Course Objectives

  1. Analysing large data
  2. Avoid manual data entry – User restrictions
  3. Working on the large file size
  4. Complete control over your data
  5. Insights
  6. Automating Repetitive business task
  7. Importing data from different sources
  • Formulas and Functions: 
  • Logical – IF, OR, AND , SUMIF, COUNTIF, AVERAGEIF
  • Lookup & Reference Functions – VLOOKUP, HLOOKUP, XLOOKUP  
  • Conditional Formatting
  • Filters
  • Working on the large size files
  • Sparklines, Slicers & Timelines
  • Pivot Tables
    • Create Dashboards using Pivots
    • Get Pivot data from different sources
    • PivotTable calculations
    • Using slicers in PivotTables
    • Conditional formatting in PivotTables
    • Creating PivotCharts
  • Charting
  • Importing data from different sources
  • Avoid manual data entry – User restrictions with Data Validation  
  • Tips & Tricks