Basics to Advanced MS-Excel Course

The truth is that having a working knowledge of Microsoft Excel, in most cases, is a requirement before attending a job interview. Microsoft Excel is used by every department, from human resources to growth, by everyone from a financial analyst to a marketing manager. Missing out on one of the most important skills for success at work would definitely not be a good idea. So, are you prepared to advance your professional career with our MS Excel course?

1. INTRODUCTION

INTRODUCTION

02 : 25

2. Excel Layout & Settings

Layout Overview

05 : 22

Main Tabs - I

11 : 00

Main Tabs - II

14 : 59

General Workbook Settings

09 : 29

Excel Layout & Settings Workbook

01 : 00

3. Basic Financial Setup

Basic Financial Setup

10 : 35

Forecasting

14 : 41

Basic Financial Setup Workbook

01 : 00

4. Basic Functions

Structure of a Function

06 : 38

Basic Functions - I

10 : 20

Basic Functions - II

07 : 29

IF & Related functions

13 : 46

SumProduct

03 : 55

Text, Date, & Concatenate Functions

17 : 17

Basic Function Workbook

01 : 00

5. Advanced Functions

Vlookup & Hlookup

08 : 47

Index & Match

06 : 52

Dynamic Hlookup with Match Function

06 : 08

Choose & Offset

03 : 15

Nesting Index Match inside IFERROR

04 : 52

Advanced Function Workbook

01 : 00

6. Charts & Graphs

Basic Charts

10 : 27

Advanced Charts

10 : 18

Dynamic Charts using Functions & Data Validation

09 : 41

Charts & Graphs Workbook

01 : 00

7. Financial Data Analysis

Sensitivity Analysis (Data Table) & Scenario Manager

08 : 32

Goal Seek & Solver

07 : 38

Pivot Tables

08 : 24

Financial Data Analysis Workbook

01 : 00

8. Time Value of Money

Basic Functions

11 : 34

Advance Functions

10 : 12

EMI Calculation

05 : 12

Time Value of Money Workbook

01 : 00

9. Macros

Introduction

03 : 08

Record & Run a Macro

07 : 17

Test the Macro

07 : 15

Macros Workbook

01 : 00

10. Basics of VBA

Introduction to VBA

02 : 57

The VBA Interface

06 : 43

Getting Started with Coding

05 : 21

The MsgBox function

03 : 47

Creating Variables

06 : 53

Building Logic using If Else

08 : 04

Case Method

04 : 20

Do While Loop

09 : 16

VBA Workbook

01 : 00

11. Bonus Session

Regression Analysis

09 : 22

Shortcuts

01 : 00

Your Instructor

Hi! I'm

Sanjana Choksi

Sanjana is a research analyst with experience of working closely with private equity clients on their investments, portfolio analysis, and investment memorandums