[this] is the first in a series of videos about pivot tables So I want to introduce you to my friend andy Andy is new on the job and he has been asked by his boss to create some reports and ultimately a dashboard for an upcoming presentation all Andy was given is this giant sheet of data and a list of reports that his boss needs
although he's excited about the challenge [andy] is wondering how it's going to turn this data into a nice looking dashboard of Course he wants to save the day and become the superhero of the office So what andy really needs is to learn how to use pivot tables? In this video series, I'm going to show you how we're going to solve Andy's problem
We're going to take this sheet of data and turn it into a [nice-looking] interactive dashboard using pivottables and pivotcharts We are going to build each of these reports using pivot tables and then bring it all together to create the dashboard And don't worry if you think this looks complicated Pivot Tables are very easy to use and don't require any complex formulas or VBa Macros just simple drag-and-drop Throughout this video series.
Related Topics:
Post a Comment