General Introduction to Excel

Formulas in MS Excel

Assignment 01

Applications of VLOOKUP

Assignment no 4 (Vlookup)

VLookup and Nested IF

Assignment 02 & 03

Range Lookup using VLookup, named ranges, and data validation list

How to use Named ranges in Excel

How to use Match and Index in excel

Page layout and print settings in Excel

Data validation and drop-down menu in Excel

How to use tables and slicers in Excel

Data visualization Part 2

Data visualization part 3

Data visualization part 4

How to use pivot tables in Excel

Pivot tables Part 2

How to create Dashboard in Excel

How to remove duplicates in Excel

How to use Power Query in Excel

Data manipulation using Power query

How to do Statistical analysis in Excel

How to do statistical analysis in Excel part-2

How to do statistical analysis in Excel | T-test

How to do statistical analysis in Excel | F-test, ANOVA

How to enable and use macro in Excel

Using Macro and VBA in Excel part-1

Using Macro | relative reference | part-2

How to use VBA editor in Excel

How to use vba editor in Excel | part 2

How to use vba in Excel | making custom functions

How to use custom functions in vba | learn with example

How to make automatic invoicing system in Excel | part 1

How to use message box and input box in Excel

How to use input box in vba Excel

How to make Invoice in Excel | Exporting invoice to pdf

How to make automatic mailing system using vba

How to use variables in vba | Declaring variable in vba | Excel

Assignment no 4 (Vlookup)

Assignment no 5 (Data Visualization)

Types of Variables in vba