Tag: Excel is Fun

How to use Fuzzy lookup in Excel

How to use Flash Fill in Excel

Excel Shortcut: Ctrl + Enter in Excel

vlookup-vs-Hlookup-in-excel

Vlookup vs Hlookup in Excel

Activate-developer-tab-in-excel

Activate Developer Tab in 2007-2016

Sumproduct - Function in Excel

Sumproduct formula in Excel

Calculate-fixed-deposits-in-excel

Calculating Fixed Deposit maturity amount – 1

Calculate-fixed-deposits-excel

Calculating Fixed Deposit maturity amount – 2

Filtering Data & Calculating AutoSum

Filtering Data & Calculating AutoSum

Excel Change Text Case – Upper, Lower, Proper

Trim function to remove excess space

Extract data using Left, Right, Mid function

Excel Horizontal Sort – Re arrange columns