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.

Pivot Chart

Unbelievable Dashboards (in 3 easy steps)

By Jeff Lenning | February 11, 2025 |

Creating an interactive Excel dashboard doesn’t have to be complicated. With just a few steps, we can transform raw data into a dynamic, easy-to-read report that updates automatically as new data comes in. In this guide, we’ll walk through the process of building an Excel dashboard using pivot tables, pivot charts, and a timeline filter.…

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

Power BI CalCPA Article

By Jeff Lenning | January 9, 2019 | Comments Off on Power BI CalCPA Article

You’ve heard the terms “Power BI,” “Power Query” and “Power Pivot,” but maybe aren’t sure what they are. Good news! They are free tools from Microsoft and this article will talk you through them. And, while we’re at it, we’ll also talk about Pivot Tables and Pivot Charts. Power and Pivot  

Read More