Excel Tutorials

You’ve probably heard someone talk about a nested formula in Excel and wondered what on earth is a nested formula??? After all, there’s no nest button or nest function. Turns out, you’ve probably been using nested formulas all along! So, what exactly is a Nested Formula in Excel? Click to Watch: What is a Nested […]

A viewer reached out wanting to know how he can count how many cells are referenced in a formula in Excel. Was this even possible??? For example, say he has a formula like AVERAGE(A1,A2,A3) in cell A4. What formula could he use to let him know that 3 cells were referenced? I thought about this for a while and […]

If you use Excel, you’ll inevitably need to link sheets in a workbook. Let’s go over different ways you can do this. 4 Ways You Can Create a Link Between Tabs in a Workbook WATCH: Ways to Link Sheets in an Excel Workbook – Tutorial 1. Use the Equal sign to create a reference to […]

If you need to sum by criteria, the SUMIFS function in Excel is what you’ll want to use. With it, you can sum multiple criteria – or just a single criteria. How to use SUMIFS in Excel Click to Watch: SUMIFS Function in Excel – Tutorial How Excel SUMIFS Works SUMIFS sum data after it […]

The Ideas feature in Excel quickly creates charts based on insights it spots in your data. If you’re anything like me, you love numbers, but your creative skills are not quite up to par. This means you might find it hard to come up with great looking charts or visuals for your data. Or you […]

Knowing how to use Excel function keys can save you a ton of time when working. These “f keys” are the shortcut keys along the top of your keyboard. Let’s take a look at each of the Excel function keys does. First, When Function Keys Won’t Work… Fn key Some keyboards contain an Fn key […]