Category Archives: Excel Formulas

Excel VLOOKUP Formula Examples – Including how to create dynamic vlookup formulas

In part 1 of this series we took a look at VLOOKUP formula basics. If you want to learn how a VLOOKUP formula works, or know someone else who is struggling with VLOOKUPs, check out the first article “Discover a simple way to understand how VLOOKUP formulas work in Excel“, and come back to this…

Discover a simple way to understand how VLOOKUP formulas work in Excel

If you are struggling to understand VLOOKUP formulas or want to explain VLOOKUPs to someone else who is struggling with VLOOKUPs, this article is for you! Before we get started let me explain that VLOOKUP formulas are simple when you know how, but it can take a while to “get it”. A year or so…

A Quick Way to Name Ranges and use Named Ranges in Formulas

In this 6 minute video I show you how to quickly name cell ranges with a powerful keyboard shortcut, and also show you how to use three math functions – SUMIF(), COUNTIF() and AVERAGEIF(). These are good building blocks that you’ll use in spreadsheet calculations and building spreadsheet models – I covered their friends SUM(),…

Dicover three basic math functions in Excel

In this 12 minute video I cover three math functions – SUM() COUNT() and AVERAGE(). These are pretty fundamental building blocks that you’ll use often in spreadsheet calculations and building spreadsheet models. If you have any trouble watching the Youtube video embedded above, you can view it directly on Youtube by clicking here. This will…

Learn Excel Functions Fast with the Formula 1 Ebook

As an Excel user do you want to master basic Excel functions and formulas? Excel Expert “Chandoo” created a pdf ebook showing how to use 75 useful Excel functions, and describes it all in plain English to make it simple to understand. I recently bought a copy of his ebook, called “Excel Formula 1” and…