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.

Power Query

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

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

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
Man making notes on a large calendar underneath an open laptop

Top 5 Excel Calendar Tutorials & Free Templates

By Excel University | June 28, 2022 |

Do you use Excel to keep track of your to-do lists, upcoming events, deadlines, etc.? Since spreadsheets are so customizable, many Excel users rely on the software to create unique calendars tailored to their needs. It’s one of the most popular uses for Excel and great practice for users of all skill levels. If you’re…

Read More
Businesswoman walking up steps that represent how to become proficient in Excel in 6 easy steps

How to Become Proficient in Excel in 6 Easy Steps

By Excel University | June 15, 2022 |

Do you know the Excel basics, but want to become a pro? We’re outlining the six steps you can take to learn how to become proficient in Excel.

Read More
Woman looking at a desktop computer screen comparing two lists.

Excel University’s Top 5 Power Query Tutorials

By Excel University | May 31, 2022 |

Power Query is one of the most useful Excel tools, and it’s surprisingly easy to learn! See our top 5 Power Query tutorials to get hands-on practice.

Read More
Woman sitting in front of laptop with a cup of coffee while learning the top Excel skills

These Top Excel Skills are Surprisingly Easy to Learn

By Excel University | May 24, 2022 |

You don’t need to be a spreadsheet pro to master these top Excel skills! See our list of easy-to-learn Excel skills with hands-on tutorials.

Read More

What Excel Skills are Employers Looking For in 2022?

By Excel University | March 1, 2022 |

Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.

Read More

Excel for Budgeting

By Moss Levenson | November 23, 2021 |

Overview During an Excel University webinar, Jeff gave a demonstration of Power Query that related to a company’s annual budget process. Initially, I was not familiar with Power Query but decided to learn it. Ultimately, I was able to incorporate Power Query into our annual budget process, eliminating the need for the software we were…

Read More