Excel Tutorials

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 what each of the Excel function keys does. First, When Function Keys Won’t Work… Fn key Some keyboards contain an “Fn” […]

If you’re growing a small business, you’re probably all about saving money where you can. As you begin to hire employees, you may wonder if you can do employee time tracking in Excel to track your employees’ hours worked. Good news! Take a look below at a way that you can track employee hours worked […]

Wildcard characters in Excel can help you find specific content in your spreadsheet even when that content isn’t perfect. Whether you need to filter a list of items or reference the contents of cells in a formula, Excel usually needs perfectly matched data to work its magic. But this isn’t always possible; items may be […]