# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# Posts

## Skipping Excel 2

| November 29, 2022 |

In this post, the second in the Skipping Excel series, I’ll walk you through the details of the next iteration of this process. In case you are just joining this series, in the first post Skipping Excel 1, I reviewed the manual process of getting my e-commerce transactions into QuickBooks Online. It took about 30…

## Skipping Excel 1

| November 22, 2022 |

Excel is used for many different tasks, such as budgeting, reporting, comparing bank statements, and other things. It can also be used to export, clean, and import data between two separate systems. For example, suppose you export transactions from an e-commerce system, open them in Excel, tidy up the information a little, and then transfer…

## What’s #REF in Excel and How to Fix It

| November 15, 2022 |

When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in Excel is short for reference, and you’ll usually see it pop up when cells that were referenced in formulas are deleted. They can be a nuisance, but they’re usually pretty simple to find and fix. Here’s how to…

## How to Clean Data in Excel – 8 Easy Ways

| November 8, 2022 |

Man sitting at a desk with an open computer learning How to Clean Data in Excel

## CalCPA Article Instant Reconciliations

| November 1, 2022 |

When you have two different lists that you need to compare, how do you do it? For example, you want to identify which items on one list (e.g., a check register) appear on the other (e.g. bank activity)? I used to print both lists, grab a ruler and go down row by row ticking items…

## How to Count Cells That Contain Specific Text

| October 25, 2022 |

Have you ever wanted to see how many times a certain text string pops up in a set of data? While you can use Ctrl + F to find values, you may need a search feature that’s more discerning and responsive.  Luckily, there are several (much faster!) ways you can count cells that contain specific…

## How to Hide Formulas in Excel (And Protect Your Worksheets)

| October 18, 2022 |

Let’s say you’ve been building a worksheet to share with your coworkers. When you share it, they’ll be able to see, edit, and change everything that’s in the workbook, including your formulas. It can sometimes be a little too easy to make those changes accidentally. That’s why it’s a good idea to lock and even…

## How to Merge Excel Files (Without Using VBA)

| October 11, 2022 |

You might be surprised how much time is lost flipping between Excel workbooks trying to find information – especially if you have a lot to sort through. Learning how to merge Excel files will make finding information easier, faster, and more user-friendly (especially if you’re sharing workbooks). While you can use VBA to combine files,…

## Two Easy Ways to Combine Date and Time in Excel

| October 4, 2022 |

Excel contains plenty of options that make it easy to format cell values exactly how you want them: as a number, date, currency, percentage, and so on. Often, an individual cell contains only one type of value. But, there are actually some really simple ways to combine date and time values in Excel into a…