Excel Nerds - Page 2 of 3 - Learn Pivot Tables, Vlookup, and Data Analysis

Using AUTOFILL in Excel – Part 2

(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste

The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the

When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?

The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the

There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post

Text to Columns is a very fun feature of Excel. This feature will help you break apart cells that have information that

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to

Below are a list of commonly used shortcuts in Excel. I’ll be updating this over time, and you feel like some important