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.
Functions
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…
Microsoft recently introduced 14 new functions for Excel—they are sure to help you save some time. We’ll start with a short description of each and then jump into some demonstrations. To view the demonstrations and learn more about each function, check out the Full Article Published in CalCPA Magazine.
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…
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…
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…