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
Excel’s PivotTables are one of its most useful features. Learn how to use pivot tables in Excel with our Top 5 PivotTable posts!
These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.
Historically, we’ve had two basic ways to create reports in Excel. We could enter the report labels and use formulas to compute the report values or we could use a PivotTable. Both options had pros and cons. We’d have to pick the report type based on the context of our workbook. In this post, I’ll…
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…
Looking to make work easier? Instead of trying to do it all, focus on learning these nine useful advanced Excel functions.
Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.
Let’s say you have a hyperlink in a cell in Excel. The hyperlink may have friendly text, such as Click Here, but when you click the link it takes you to a URL such as https://www.excel-university.com. Now, let’s say you want to extract that URL from the hyperlink using an Excel formula. Well … to…
My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll definitely…
Microsoft just announced an enhancement in Excel desktop that enables autocomplete for data validation dropdown lists … YES! I have been waiting for this capability for literally decades … and it is finally here 🙂 Note: this feature is available in both Excel online and desktop. However, at the time of this writing, it is…
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…