Genre: eLearning | Language: English + .VTT | Duration: 28 mins | Size: 145 MB
What you'll learn
Know why people use Pivot Tables
Create an Excel Pivot Table in 30 seconds
Be able to pull data from a Pivot Table into your own reports
Requirements
Microsoft Excel in any version (works also with 2003, 2007, 2010)
The killer trick requires some Excel knowledge. The other tricks are pretty basic to learn.
Description
Works with any Excel version!
Do you know why so many people use Pivot Tables in Excel?Many people use pivot tables in their daily work for fast, standardized requests. What does that even mean? Imagine you need to know the total sales of your business broken down to months. You don't need to filter that manually - pivot tables are the perfect tool to give you that answer every time fully automated!
This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!
What you will learn
Build up a pivot table in 30 seconds
Practice with a more detailed example
What to do if you need more than two dimensions (you'll understand when you see it)
Advanced killer trick: Pull data from a pivot table into your individual report!
Who is the target audience?
Anyone who wants to learn or to repeat the best Excel Pivot tricks professionals use every day
Interest in time-saving tricks for everyday use
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.