excel dashboard for tracking income part 3
In part 3 we’ll be going over how to build guage charts so we can have an easily readable visual reference on our goal progress.
Excel Dashboard for Tracking Income Part 2
Key Concepts Covered Here Are Using The “INDEX” Function In Combination With Several Other Functions(SMALL, ROW & ROWS), To Create An Array Function. This Function Is Then Copied Across A Range Of Cells Pulling Our Requested Data. We’ll Be Using This Data To Drive Our Visualizations That We Will Create In The Upcoming Videos In […]
Excel Dashboard for Income Tracking Part 1
This is the first video in a series to create an Excel dashboard to track income. Here we create a master table to enter income data and perform a few calculations. One of the key concepts covered here is the importance of properly formatting your data. Incorrectly formatted data can lead to undesirable or incorrect […]