The Ultimate Microsoft Excel Course



Learn Excel with a Touch of Finance from a Chartered Accountant and Corporate Banker

What you will 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 PivotTables

Problem-solving using Solver & What-if Analysis

Wow your Boss with Dynamic Charts

Make data DISAPPAER but still use it for Calculations (Pro Hack)

Access to a Finance Professional with 10+ years of experience in Excel

Description

To master Microsoft Excel is an inevitable skill one needs especially if you’re or want to work in the field of Accounting & Finance, not only in India but anywhere in the world.


I’m a Chartered Accountant & ex-Corporate Banker putting my decade of experience into 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 modeling 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. Below are just a few of the topics that you will master:


  • Creating effective spreadsheets
  • Managing large sets of data
  • Formatting data like never before
  • Make data DISAPPEAR but still use it for Calculations (Pro Hack)
  • The Art of Printing Excel Sheets
  • Mastering the use of some of Excel’s most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, SUBTOTAL and many more…)
  • Importing Data from various sources including the internet
  • Create dynamic report with Excel PivotTables
  • Getting over the dreadful Custom Cell formats
  • Wild Card Characters in Excel no one talks about.
  • Conducting What-if Analysis
  • Problem-solving using Solver
  • Automate your day-to-day Excel tasks by mastering the power of Macros and VBA
  • Creating Dynamic Charts

Enroll now and take the next step in mastering Excel and become the Excel champ at your workplace!

Introduction to the Course

Introduction

A Tour of MS Excel & Key Basic Shortcuts

Excel Tour & Basic Shortcuts

Entering Data in a worksheet

How to Enter Data in Excel & use the ‘Go To’ feature

Formatting data in Excel

Formatting Tools

Learning about 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

The Art of Printing Excel sheets & Using Math Formulae

Printing Tools & Math functions

Working with Text functions, Flash Fill & Consolidate

How to use Text function, Flash Fill & Consolidate

Dealing with Conditional Formatting & IF Function

Conditional Formatting & use of IF Function

Managing Data Using SUBTOTAL & the dynamic CHOOSE Formula

Using CHOOSE & SUBTOTAL

Amazing Pivot Table

Pivot Table

Working Wonders with HLOOKUP, INDEX, MATCH & OFFSET

Working Wonders with HLOOKUP, INDEX, MATCH & OFFSET

VLOOKUP & its alternative DGET

VLOOKUP & DGET

The Crucial WHAT-IF ANALYSIS

WHAT-IF ANALYSIS

How to FORECAST & The Magical WILD Card Characters

FORECAST & Wild Card Characters

Introduction to VBA & The Problem ‘Solver’

Using Macros, VBA & Solver

Creating Dynamic Charts

Interactive Charts

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock

Check Today's 30+ Free Courses on Telegram!

X