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

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
Padlock on top of a keyboard that represents how to hide formulas in Excel

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

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

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

List of files in Excel (easy way, no VBA macros or formulas)

By Jeff Lenning | September 27, 2022 |

In this post, I’ll answer a question about how to create a list of files in a folder (and any subfolders) in Excel. For this illustration, we’ll use Power Query instead of VBA/Macros. Objective Before we jump into the details, let’s look at the objective. We want to create a list of files in 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

How to Perform a Frequency Distribution in Excel (no formulas)

By Excel University | September 13, 2022 |

Are you a school administrator who wants to see how student test scores are distributed, or maybe an accountant who needs to analyze trends in spending or accounts receivable? If so, creating a frequency distribution in Excel is one of the easiest ways to do it!  Essentially, frequency distributions come in handy whenever you need…

Read More

Use an Excel formula to insert pictures into cells with the IMAGE function

By Jeff Lenning | September 6, 2022 |

Microsoft recently announced the rollout of the new IMAGE function. It enables us to write a formula that inserts an image directly into a cell. This opens up many new interesting possibilities.

Read More
Woman quickly entering data sets on two computer monitors using the Excel fill handle

How to Save Time Using the Microsoft Excel Fill Handle

By Excel University | August 30, 2022 |

Long lists of data can be time-consuming to enter in Excel. Here’s how to use the Excel fill handle to save yourself hours of work!

Read More