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.

VLOOKUP

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 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
Holding an Excel formulas cheat sheet in one hand and a pencil in the other

Excel Formulas Cheat Sheet for Beginners

By Excel University | May 17, 2022 |

Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…

Read More
Man sitting at a computer with an hourglass trying to learn how to get better at Excel

How to Get Better at Excel (Without Wasting Time)

By Excel University | April 25, 2022 |

Wondering how to get better at Excel? Whether you’re a new user or a pro, these are some easy steps to help you quickly master new skills.

Read More
Text that says "Excel Formulas Tutorial: What are Formulas and How to Use Them" over a man stacking blocks

Excel Formulas Tutorial: What are Formulas and How to Use Them

By Excel University | April 19, 2022 |

Formulas are what make Excel, Excel. They’re how we perform both simple and complex calculations, and the possibilities are nearly endless as far as what they can do. Today, we’re going back to the basics with an overview of what formulas are and how to use them, as well as sharing our Excel formulas tutorial…

Read More

Easily Create and Update Excel Reports from QuickBooks

By Trevor Lee | March 22, 2022 |

In this article, we’ll show how to easily create and update Excel reports from QuickBooks. But, let’s back up a second. When QuickBooks has the report you want, awesome! But, when it doesn’t, we often turn to Excel. This can happen when QuickBooks doesn’t have all of the data you need for the report, for…

Read More

These Are the Top 9 Most Useful Advanced Excel Functions

By Excel University | March 15, 2022 |

Looking to make work easier? Instead of trying to do it all, focus on learning these nine useful advanced Excel functions.

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

Convert Foreign Currencies to USD

By Penny Li | January 4, 2022 |

My name is Penny Li, a cross-border tax accountant, and I often come across instances in my work where I need to convert foreign currencies to US dollar. I have decided to build a foreign currency conversion tool in Excel that is capable of generating single-day as well as average foreign exchange rates for multiple…

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