Upgrade your skillset

Dinosaurs are extinct, your skills don't have to have the same fate. Start with our courses now with best in class faculty from industry and upskill to stay in the game

Microsoft Excel - 2 months

Course outline

  • Introduction to Microsoft Excel

  • Data Input and structuring

  • Basic Mathematical Operations

     

  • Introduction to basic formulas and Functions

  • Data Formatting

  • Logical Operators and Conditions

  • Data Analysis using Charts

  • Work with Cells and Worksheets

  • Collaborating with Others

  • Analyzing your Data

  • Work with Macros and the Web

  • Additional functions and features customized for trainees

  • Case Study

  • Vlookup, Hlookup, Index & Match functions

  • Sumif & Countif functions

  • Creating and Analysing Pivot Tables

  • What-If Analysis(Goal Seek)

  • Advance Charting

  • Pivot Tables and Pivot Reporting

  • Data Validation

  • Methods of Summarizing Data

  • Report Visualization Techniques in Excel

  • VBA & Macros

  • Excel Productivity

  • Data Tables, Simulations & Solver

  • Integrating Excel with other tools & Optimizing Excel

  • Decision Making with Excel

  • Dynamic Charts & Donut Charts

  • Additional functions and features customized for trainees

  • Case Study

Live
Classes

Premium
Faculties

Certificate

Recorded
Sessions

Basic Excel

For people who are new to exce with 0-2 years of experience
₹4999
2999
1 month
  • Live Classes - Late Nights
  • Expert Mentor
  • Recorded Sessions
  • 8 hours of dedicated classes

Advance Excel

For analysts and people who uses Excel on daily basis
₹6999
3999
2 months
  • Live Classes - Late Nights
  • Expert Mentor
  • Recorded Sessions
  • Project
  • 16 hours of dedicated classes

*Pricing exclusive of taxes