 | |
| Intro to Pivot Tables |
[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