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 This Series.
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.