MS Excel: Zero to Hero Course

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This Course has been designed for beginner to advanced excel enthusiasts using a practical approach.

The Instructor is a Chartered Accountant & ex-Corporate Banker putting his decade of experience in this course to guide you step by step in Hinglish (English with a mix of Hindi) through the beginner to advanced level and beyond.

As you participate in this course you will not only master Excel tools but also build a solid foundation for financial modelling and valuation.

At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace.


Key Benefits of this Course:

  • Solid Excel foundation
  • Learn basic to advanced skills
  • Gain confidence in Excel work
  • Become job-ready
  • Enhance work productivity
  • Reduce mouse usage
  • Learn new applications
  • Update your Excel knowledge with the latest features
Show More

What Will You Learn?

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Automate your day to day Excel tasks by mastering the power of Macros and VBA
  • Wild Card Characters in Excel no one talks about
  • Create dynamic report with Excel Pivot Tables
  • Problem-solving using Solver & What-if Analysis
  • Wow your Boss with Dynamic Charts
  • Make data DISAPPEAR but still use it for Calculations (Pro Hack)
  • Access to a Finance Professional with 10+ years of experience in Excel

About the instructor

CA Kuldeep Sharma
Kuldeep is a Chartered Accountant by qualification. He is experienced in the field of project financing and financial analysis for over 8 years. He has been working in the Commercial Business Banking division of a reputed bank managing an asset portfolio of over INR 3000 million to his credit. He also teaches Financial Modelling & Valuation, Project Financing, Financial Statement Analysis, Corporate Finance etc. He's been a mentor to numerous students both offline and online. He has been into teaching for over a decade which is very well reflected in his teaching style. Experienced in Banking and Financial services, his work exposure includes financial modeling, financial analysis, financing green-field projects, working capital finance, corporate debt-restructuring, strategic debt-restructuring, loan documentation, exposure to various loan products, LCs & BGs and similar activities. In his spare time, he likes cruising across the hills on his Royal Enfield somewhere in the North-Eastern region of India.

Course Curriculum

Introduction to the Course

  • Introduction

Tour of Ms Excel & Key Basic Shortcuts

  • Excel Tour & Basic shortcuts

Entering Data in a Worksheet

  • How to enter data in Excel and use the ‘Go To’ feature

Formatting Data in Excel

  • Use of Formatting Tools

Custom Cell format, Paste special & Hyperlink

  • Custom Cell Format, Paste Special & Hyperlink

How to Filter data, create a Table & Import data

  • Using Filter. Table & Import features

Art of Printing Excel sheets & using Math formulae

  • Printing Tools & Math Function

Working with TEXT functions. Flash Fill & Consolidate

  • How to use TEXT function, Flash Fill & Consolidate

Conditional Formatting & Use of IF function

  • Conditional Formatting & Use of IF Function

Managing data using SUBTOTAL and the dynamic CHOOSE formula


Amazing Pivot Table

  • Creating a Pivot Table

Working wonders with HLOOKUP, INDEX, MATCH & OFFSET

  • Working Wonders with HLOOKUP, INDEX, MATCH & OFFSET

VLOOKUP & Its alternative DGET

  • Use of VLOOKUP & DGET formula

The Crucial WHAT-IF Analysis

  • What-if Analysis

How to FORECAST & the Magical Wild Card Characters

  • FORECAST & Wild Card Characters

Introduction to VBA and the Problem SOLVER

  • Using Macros, VBA & Solver

Creating Dynamic Charts

  • Interactive Charts