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.

Functions

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
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
Man sitting at a desk with an open computer learning How to Clean Data in Excel

How to Clean Data in Excel – 8 Easy Ways

By Excel University | November 8, 2022 |

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

Read More

CalCPA Article Instant Reconciliations

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

Read More
Woman sitting at a desk with a calculator after learning how to count cells containing specific text in Excel

How to Count Cells That Contain Specific Text

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

Read More
man looking at a computer while learning How to Merge Excel Files without using VBA

How to Merge Excel Files (Without Using VBA)

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

Read More
Clock sitting next to a calendar that represents how to combine date and time in Excel

Two Easy Ways to Combine Date and Time in Excel

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

Read More
Woman sitting at a desk making an Excel dynamic chart

How to Make an Excel Dynamic Chart & Keep Updates Consistent

By Excel University | September 20, 2022 |

For the purposes of this discussion, an Excel dynamic chart is a chart that automatically updates itself whenever new data rows are added. The opposite is a static chart, which won’t incorporate any new data rows added to the existing range. To be clear, when Excel creates a chart based on a range of cells,…

Read More