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.

Excel University

Child sitting in front of a computer screen learning how to count text in Excel

Count Text in Excel – Characters, Words, & Cells With Text

By Excel University | September 26, 2023 |

Need to know the word count of a spreadsheet you’re working on, or maybe the number of cells that contain text? Even though there’s no built-in counting tool, you can still count text in Excel using a few simple formulas! Count the Number of Characters in a Cell or Range Using the LEN function is…

Read More
Man holding dice that represent how to random sort in Excel

Random Sort in Excel

By Excel University | May 23, 2023 |

Despite the many ways you can shuffle rows, columns, and cells, there’s no built-in option to random sort in Excel. That can be useful for randomly assigning tasks or responsibilities, selecting samples, and much more. Instead, you can write a formula that allows you to randomly sort any data you select. Video How to Random…

Read More
Woman holding paperwork and looking at a laptop while learning how to create a simple dot plot in excel

Create a Simple Dot Plot in Excel

By Excel University | May 16, 2023 |

Dot plots contain a series of dots, with each dot representing a single data point. They’re straightforward, easy-to-read charts that help you see trends and find any potential outliers in your samples. Creating a dot plot in Excel can be done in only a few steps which makes them a popular choice for displaying data!…

Read More
Woman happily looking at her laptop after learning how to hide rows in Excel based on cell value

Hide Rows in Excel Based on Cell Value (Without VBA)

By Excel University | February 28, 2023 |

Being able to hide rows based on cell value in Excel is a handy skill for anyone who needs to organize a large spreadsheet. Imagine you have a huge list of data, but only some of the rows are relevant to you at the moment. When you hide rows based on cell value, you can…

Read More
Woman sitting on couch with a laptop giving a high five sign after learning how to round to the nearest 5 in Excel

Round to the Nearest 5 in Excel Using 3 Different Functions

By Excel University | February 14, 2023 |

Whether you’re working with something like test scores, tracking expenses, or any other type of data, being able to round numbers to the nearest 5 in Excel is a handy skill. This is helpful when you need to round to the nearest multiple (like 5) instead of simply to the nearest whole number.  Here are…

Read More
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