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

Course Content

Introduction to the Course

  • Introduction
    32:05

Tour of Ms Excel & Key Basic Shortcuts

Entering Data in a Worksheet

Formatting Data in Excel

Custom Cell format, Paste special & Hyperlink

How to Filter data, create a Table & Import data

Art of Printing Excel sheets & using Math formulae

Working with TEXT functions. Flash Fill & Consolidate

Conditional Formatting & Use of IF function

Managing data using SUBTOTAL and the dynamic CHOOSE formula

Amazing Pivot Table

Working wonders with HLOOKUP, INDEX, MATCH & OFFSET

VLOOKUP & Its alternative DGET

The Crucial WHAT-IF Analysis

How to FORECAST & the Magical Wild Card Characters

Introduction to VBA and the Problem SOLVER

Creating Dynamic Charts