Geeky Gadgets

NEW Excel Formulas to improve your spreadsheet calculations

The CHOOSECOLS formula is a catalyst when it comes to selecting specific columns from a table. This formula allows you to streamline your data analysis process by quickly and easily extracting the ...
How-To Geek on MSN

Document formulas in Excel like code with N() function

The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...
Geeky Gadgets

How to use MS Excel advanced formulas for data analysis

In this guide, you will learn how to use Excel’s advanced formulas such as INDEX-MATCH, OFFSET, and INDIRECT to enhance your data analysis capabilities. First, let’s explore the INDEX-MATCH ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...