Basic to Advanced Excel

Layout Overview

Main Tabs - I

Main Tabs - II

General Workbook Settings

Excel Layout & Settings Workbook

Basic Financial Setup

Forecasting

Basic Financial Setup Workbook

Structure of a Function

Basic Functions - I

Basic Functions - II

IF & Related functions

SumProduct

Text, Date, & Concatenate Functions

Basic Function Workbook

Vlookup & Hlookup

Index & Match

Dynamic Hlookup with Match Function

Choose & Offset

Nesting Index Match inside IFERROR

Advanced Function Workbook

Basic Charts

Advanced Charts

Dynamic Charts using Functions & Data Validation

Charts & Graphs Workbook

Sensitivity Analysis (Data Table) & Scenario Manager

Goal Seek & Solver

Pivot Tables

Financial Data Analysis Workbook

Basic Functions

Advance Functions

EMI Calculation

Time Value of Money Workbook

Introduction

Record & Run a Macro

Test the Macro

Macros Workbook

Introduction to VBA

The VBA Interface

Getting Started with Coding

The MsgBox function

Creating Variables

Building Logic using If Else

Case Method

Do While Loop

VBA Workbook

Regression Analysis

Shortcuts