Excel Pivot Tables Explained with Samples and Bonuses
In this video you will learn how to use Pivot Tables. You will learn the entire process of creating it, its requirements and several samples. Along the way I'll also teach you how the data can be manipulated in several aspects as well as some of the most common limitations that you must keep in mind when using Pivot Tables. Finally, towards the end, I'll give several bonuses for free!
Excel Pivot Tables Explained with Samples and Bonuses!
Enjoy!
-------------------------------------------------------------------
Links
▶ File used in this video: https://bit.ly/3nlPtPg
▶ My Excel Tips & Tricks Playlist: • How to Create Automated Charts and Ta...
-------------------------------------------------------------------
Content Breakdown
00:00 Business Case & Introduction
01:12 Creating Your First Pivot Table
03:17 Explaining the PivotTables Panel with Samples
08:43 Consolidating Large Amount of Data
10:58 Bonus #1: How to Manually Group Columns
13:16 Bonus #2: Working With Slices
16:36 Bonus #3: Working with Timelines
17:57 Bonus #4: Using Charts Over the Pivot Table
19:18 Bonus #5: The "Analyze" and "Design" Tabs
23:55 Conclusion and Thank You!
-------------------------------------------------------------------
A little background about myself
I'm a Program Manager working for a prestige world-wide IT and Telecom corporation, present in more than 100 countries and having more than 35 thousand employees. I'm 8 years working for this company and within this period I managed to grow from a technician to a Director and be relocated several times. All of these before 40's. I was only 35 years old when I was relocated to USA and only 36 years old when I was promoted to Direction level. My ultimate goal is to teach you my path, how I managed to do it, my right choices and the bad ones as well, to short the several years long corporate journey from expert to Director into just few years. Among several skills you have, dominating MS Office was one of the success keys to call attention to my efficiency, organization and outstanding results delivered.
-------------------------------------------------------------------
Let's get in touch
▶ e-Mail: [email protected]
▶ Web: http://officetothepoint.com
▶ LinkedIn: / diogoroldao
▶ YouTube: / @diogoroldao-officetothepoi610
▶ Instagram: / diogo_rpc
▶ Facebook: / diogo.rpc
▶ Twitter: / diogoroldao
#Excel #PivotTables #PivotTablesExplained #OfficeToThePoint #DiogoRoldao
