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

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

14 New Excel Functions CalCPA Article

By Jeff Lenning | May 9, 2022 |

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. TEXTSPLIT: splits text into columns and/or rows based on one or more delimiters. TEXTBEFORE: returns the text before the specified delimiter. TEXTAFTER: returns the text…

Read More

How to easily Automate Your Customized Excel Financial Statements

By Jacques Nault | May 3, 2022 |

Although Excel provides a great deal of flexibility in creating financial statements, it has several limitations: It is not integrated with accounting data. It requires a substantial amount of data manipulation. It is difficult to ensure completeness of the financial statements without excessive review. Excel cannot easily and automatically update the financial statements. If you…

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
Text over a man standing underneath lightbulbs that reads "How to Use Pivot Tables in Excel - Our Top 5 Posts"

Learn How to Use Pivot Tables in Excel – Our Top 5 Posts

By Excel University | April 12, 2022 |

Excel’s PivotTables are one of its most useful features. Learn how to use pivot tables in Excel with our Top 5 PivotTable posts!

Read More
Piggy bank with a clock on top to represent time saved by learning Excel tips and tricks

Top 8 Excel Tips and Tricks to Save You Time

By Excel University | April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

Read More

Create a Dynamic PivotTable Style Report with One Formula

By Jeff Lenning | March 29, 2022 |

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…

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