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

Stack of coins next to a model house that represents how to make a Basis Points calculator in Excel

How to Create a Simple Basis Points Calculator in Excel

By Excel University | February 7, 2023 |

Microsoft Excel is fantastic since it simplifies the process of creating and managing a portfolio (especially an investment portfolio). Basis Points can be referenced in stock trading, indexing, and interest rates when expressing percentage changes. Having a handy calculator makes them much easier to determine. Building a Basis Points calculator in Excel is probably easier…

Read More
Woman looking through several credit cards while learning how to create an average daily balance calculator in Excel

Create an Average Daily Balance Calculator in Excel

By Excel University | January 31, 2023 |

Whether you’re tracking your personal or business finances, an average daily balance calculator in Excel can help you get a better understanding of your loan payments, and it can also be useful for creating payment projections. The average daily balance method is commonly used to calculate finance charges for credit card balances, as well as…

Read More
Woman looking at her laptop computer reading how to find merged cells in Excel

How to Find Merged Cells in Excel (& What You Can Do Instead)

By Excel University | January 24, 2023 |

You’ve probably come across situations where Excel didn’t allow you to make certain changes to your data because some of the cells you selected were merged. But, it can be tough to find merged cells in Excel because they often look so similar to others.  Working with large datasets makes it even more difficult as…

Read More
Man at computer learning how to remove leading spaces in Excel

How to Remove Leading Spaces in Excel

By Excel University | January 17, 2023 |

Any work you do in Excel is built around data. The cleaner the data is, the easier worksheets are to read and maintain – and correct formatting plays a big role. Being able to remove leading spaces in Excel helps make your data look clean and keeps your formulas operating as expected. Extra leading spaces…

Read More
Woman using a calculator before learning how to square numbers in Excel

How to Square a Number in Excel

By Excel University | January 10, 2023 |

Squaring numbers are helpful in all different kinds of calculations, but it can be a tedious task if you have a lot of data. However, Excel’s tools and functions make it pretty simple! There are four easy ways to square a number in Excel: two that utilize functions and two that don’t.  Here’s how to…

Read More
Women holding her glasses up close to a computer screen and reading about how to select every other row in Excel

Four Ways to Select Every Other Row in Excel

By Excel University | January 3, 2023 |

Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. However … if you’ve ever tried to select every other row in Excel, you…

Read More

Skipping Excel 3

By Jeff Lenning | December 13, 2022 |

In this third and final post of the Skipping Excel series, we’ll connect all the dots and use Zapier to complete our automation. In case you are just joining the series … I’ve been documenting my journey for getting my e-commerce sales into QuickBooks Online. In an ideal situation, there would be a direct built-in…

Read More

Skipping Excel 2

By Jeff Lenning | 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…

Read More

Skipping Excel 1

By Jeff Lenning | 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…

Read More
Frustrated woman looking at a computer screen while learning how to fix #REF in Excel

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

By Excel University | 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…

Read More