# Excel Course

Assignment 1 Basic Excel
Assignment 2 Basic Excel
Assignment 3 Excel Shortcuts and Tricks
Assignment 4 Vlookup Basics
Assignment 5 Vlookup -Advanced Cases
Assignment 6 Hlookup Cases
Assignment 7 If Command and Nested if
Assignment 8 Count Formulas and Filters
Assignment 9 Conditional Sum and Filters
Assignment 10 Pivot Tables and Charts
Assignment 11 What if Analysis
Assignment 12 Formating and Sorting
Assignment 13 Password Protection
Assignment 14 Index and Match
Assignment 15 Xlookup
Assignment 16 Data Validation
Assignment 17 Concatenate
Assignment 18 Text to Columns
Assignment 19 Macros and VBA
Assignment 20 Mixed Formula Assignment

Loading...