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

Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

By Excel University | June 21, 2022 |

Looking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!

How to Become Proficient in Excel in 6 Easy Steps

By Excel University | June 15, 2022 |

Do you know the Excel basics, but want to become a pro? We’re outlining the six steps you can take to learn how to become proficient in Excel.

How to Use Excel for Finance: Balancing Your Personal Budget

By Excel University | June 7, 2022 |

Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.

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.

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…

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. To view the demonstrations and learn more about each function, check out the Full Article Published in CalCPA Magazine.

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.

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…

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.

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…