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
Although Excel provides a great deal of flexibility in creating financial statements, it has several limitations: If you use Excel to create financial statements, you will want to read on. In this article, we’ll show how the patented FSM technology allows you to easily produce exactly the custom financial reports you need in Excel. They…
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.
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…
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…