MS Excel: Zero to Hero Course

Uncategorized
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
Instructor
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
    32:05

Tour of Ms Excel & Key Basic Shortcuts

  • Excel Tour & Basic shortcuts
    01:50:23

Entering Data in a Worksheet

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

Formatting Data in Excel

  • Use of Formatting Tools
    54:14

Custom Cell format, Paste special & Hyperlink

  • Custom Cell Format, Paste Special & Hyperlink
    56:00

How to Filter data, create a Table & Import data

  • Using Filter. Table & Import features
    01:10:32

Art of Printing Excel sheets & using Math formulae

  • Printing Tools & Math Function
    01:22:19

Working with TEXT functions. Flash Fill & Consolidate

  • How to use TEXT function, Flash Fill & Consolidate
    01:31:52

Conditional Formatting & Use of IF function

  • Conditional Formatting & Use of IF Function
    58:11

Managing data using SUBTOTAL and the dynamic CHOOSE formula

  • Using CHOOSE & SUBTOTAL
    36:23

Amazing Pivot Table

  • Creating a Pivot Table
    35:10

Working wonders with HLOOKUP, INDEX, MATCH & OFFSET

  • Working Wonders with HLOOKUP, INDEX, MATCH & OFFSET
    52:40

VLOOKUP & Its alternative DGET

  • Use of VLOOKUP & DGET formula
    49:51

The Crucial WHAT-IF Analysis

  • What-if Analysis
    54:27

How to FORECAST & the Magical Wild Card Characters

  • FORECAST & Wild Card Characters
    01:09:28

Introduction to VBA and the Problem SOLVER

  • Using Macros, VBA & Solver
    01:29:05

Creating Dynamic Charts

  • Interactive Charts
    43:06