|
Excel Pivot Table - Data Analysis with Pivot Tables
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 48.0 KHz
Language: English | Size: 887 MB | Duration: 1h 49m
Building Pivot Tables, Group, Sorting, Filtering, Slicers, Calculations, Pivot Charts, Pivot Styles
What you'll learn
Why pivot tables are so powerful, and how to set up a pivot table in less than 2 minutes
What it means to refresh a pivot table, and how to refresh a pivot table when your data changes (pivot tables work like a formula, but they don't automatically
The goofy names you need to know to talk about (and understand) the parts of a pivot table
How to "drill down" into a pivot table to extract the data (incredibly useful way to get just a subset of your data).
Why it makes sense to use an Excel Table for your pivot table (this one tip can save you hours of frustration).
How you can set up a pivot table so that you can add data every day, week, or month and have it work correctly every time.
How to add new fields to a pivot table, and easily move a field from one place to another
How to use (and understand!) pivot table layouts. (The default layout is often *not* what you want).
Why sometimes you get a count, and sometimes you get a sum (and how to get what you want).
The best way to format numbers in a pivot table (Hint: don't select the numbers and apply a format...there's a much better way!)
How to add and remove grand totals and sub totals with ease
How to rename pivot table fields (It's easy, and it can make your pivot table much nicer to look at.)
The easiest way to add the same field more than once (so you show sales by product as both $ and %, for example).
How (and why) you might want to add a calculated item or a calculated field to a pivot table (hands down the most confusing thing in the entire pivot table univ
Perhaps the coolest feature in pivot tables is grouping. This is what gives you clean breakdowns by month and year, by product, etc.
How to group a pivot tables by number (great for showing, say, purchases by age-range, or by order size).
How to easily group by year, month, and quarter, and how to arrange those groupings any way you want. (Even a cool way to group by day of week).
How to group by just moving things around. (Most people don't know that you can do ad hoc grouping almost way you like).
How to sort a pivot table alphabetically, or by value
A simple way to sort a pivot table with your own custom list, automatically.
How to filter a pivot table globally
Slicers are a cool tool that lets you filter a pivot table with large interactive buttons rather than tiny little filters (perfect for managers that want just w
How to create your own styles (a huge time saver when you start using pivot tables more often and want them to look the same).
Many More
Description
If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. Core Pivot is a step-by-step Excel video course that will teach you everything you need to know to use this very powerful tool. With a small investment, Pivot Tables will pay you back again and again
The basics
Why pivot tables are so powerful, and how to set up a pivot table in less than 2 minutes. |
|
udp://tracker.torrent.eu.org:451/announce udp://tracker.tiny-vps.com:6969/announce http://tracker.foreverpirates.co:80/announce udp://tracker.cyberia.is:6969/announce udp://exodus.desync.com:6969/announce udp://explodie.org:6969/announce udp://tracker.opentrackr.org:1337/announce udp://9.rarbg.to:2780/announce udp://tracker.internetwarriors.net:1337/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.stealth.si:80/announce udp://9.rarbg.to:2900/announce udp://9.rarbg.me:2720/announce udp://opentor.org:2710/announce |
