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

Woman typing on a laptop at her desk with colorful question marks around her

Your Most Common Excel Questions, Answered

By Excel University | August 23, 2022 |

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…

Read More

2022 Scholarship Winner

By Jeff Lenning | August 11, 2022 |

I am excited to announce this year’s Excel University scholarship winner! This scholarship is supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible over the past 7 years. The winner will receive a cash award plus an Excel University training pass. This year’s recipient…

Read More
Man holding a long list on a page that touches the floor before learning how to create a Microsoft Excel drop-down list

How to Create a Microsoft Excel Drop-Down List

By Excel University | August 9, 2022 |

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…

Read More
Man multitasking while using Microsoft Excel macros to make his spreadsheets faster

Make Your Spreadsheets Faster Using Microsoft Excel Macros

By Excel University | August 2, 2022 |

Do you use Excel frequently and find that you often have to repeat the same tasks over and over? If so, you can use Microsoft Excel macros to automate those tasks and cut down on how much time it takes to complete them! You can create a macro by recording your keystrokes and mouse clicks,…

Read More
Woman looking through a magnifying glass at how to highlight duplicates in excel

How to Highlight Duplicates in Excel

By Excel University | July 26, 2022 |

A duplicate value is a value that shows up more than once in a spreadsheet. These pop up all the time when working with datasets, and they can be tedious to sort through if you don’t know the quick ways to find them. Learn how to highlight duplicates in Excel to make the process take…

Read More
Hand writing a lesson on how to find the interquartile range in Excel on a chalkboard

How to Find the Interquartile Range in Excel

By Excel University | July 19, 2022 |

Did you know you can find the interquartile range in Excel in only 4 steps? See how to make an easy chart that calculates any dataset’s IQR!

Read More

Import Data from a Picture Image

By Jeff Lenning | July 12, 2022 |

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…

Read More
Woman holding her face while trying to find out how to recover an Excel file not saved

Don’t Panic! Here’s How to Recover an Excel File Not Saved

By Excel University | July 5, 2022 |

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…

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
Woman pointing to the left while thinking about advanced Excel tips

Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

By Excel University | June 21, 2022 |

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!

Read More