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.
HSTACK
Sometimes, we need the flexibility of a PivotTable without actually building one. Whether we’re automating dashboards, preparing recurring reports, or just streamlining our workbooks, Excel’s PIVOTBY function gives us a powerful, formula-based solution. In this post, we’ll explore how to transform raw data into dynamic summary reports using a single formula — no PivotTable required.…
Ever find yourself combining data from multiple reports—maybe quarterly exports or regional summaries? If you’ve been manually copy-pasting data together, it’s time to meet your new best friends: VSTACK and HSTACK. Video Tutorial These two functions make it easy to stack datasets vertically or horizontally without breaking a sweat. In this post, we’ll explore both…
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.
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…
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…