![Excel PivotTables Part 1 PivotTables 101](https://i.postimg.cc/FFV2D66r/image.jpg)
Video: .MP4, 1280x720 | Audio: AAC, 44kHz, 2ch | Duration: 3h 3m
Genre: eLearning | Language: English | Size: 1,05 GB
This class is Part 1 of a three-part series covering data analysis with Excel PivotTables and PivotCharts.
PivotTables are an absolutely essential tool for anyone working with data in Microsoft Excel. Pivots allow you to quickly explore and analyze raw data, reveal powerful insights and trends otherwise buried in the noise, and provide fast, accurate and intuitive solutions to even the most complicated questions.
In Part 1 of this course, I'll show you when, why, and how to use PivotTables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and exercises every step of the way.
We'll cover everything you need to know to get up and running with PivotTables, including:
Raw data structure
Table layouts & styles
Design & formatting options
Sorting, filtering, & grouping tools
Calculated fields, items & values
From there we'll take what we've learned and move on to Part 2, which introduces PivotCharts, slicers, timelines and custom dashboards. Finally we'll wrap up with Part 3, where we'll tie it all together and explore several advanced, real-world case studies!
Requirements:
Microsoft Excel (2010, 2013, 2016), ideally for PC
Mac users are welcome, but note that the PivotTable interface varies across platforms
Basic experience with Excel functionality (charts & formulas a plus!)
[i][/i]Screenshots
![Excel PivotTables Part 1 PivotTables 101](https://i110.fastpic.ru/big/2019/0524/6a/0a2ce03fe03cc2cc9e323563f922f76a.jpg)
https://rapidgator.net/file/9375541a83957c16f3ebba09309053dd
https://rapidgator.net/file/a1616273c5b7b6eef7d1c65308cd10ce
uploadgig_com:
https://uploadgig.com/file/download/acC42e4fDfDef6dA/ExcelPivotTablesPart1PivotTables101.part1.rar
https://uploadgig.com/file/download/8e3607aE94f35ce7/ExcelPivotTablesPart1PivotTables101.part2.rar
![High Speed Download](/images/download.gif)