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.
Features
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…
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,…
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!
Even if you’ve been using Excel for a while, you may find yourself Googling how to use or access certain features. For example, if you rarely need to convert units of measurement, you might forget the function that does that for you. We’ve put together a list of very common Excel questions that you can…
Keeping your records organized is essential whether you’re running a business or taking care of the household. These days, there are a ton of apps you can use to keep track of daily to-dos, but they just can’t quite compare to the customization abilities and advanced features of Excel. One of those features is the…
Microsoft recently announced the ability to import data from a picture in Excel for Windows … yay! Let’s say you have an image that contains text or numbers. Perhaps the image is a file (like PNG, GIF or JPG). Or, perhaps you copied it to the clipboard or took a picture with your phone. You’d…
Have you ever worked on an Excel project for hours, only for all of that effort to be lost because of one power outage that shut down your system? Everyone knows the panic that sets in when they’ve accidentally deleted important work. But, the good news is that not all is lost! There are a…
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…
Looking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!
Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.