In this Excel Tutorial on Pivot Tables you will learn a key data analysis skill for consultants. Pivot tables are a key feature of Microsoft Excel and Office 365 to conduct effective data analyses. This Excel Pivot Tables tutorial for beginners contains key tips to effectively use Pivot Tables at work. Learn how to use Pivot Tables with advanced Pivot Tables tips such as calculated fields and building dashboards with Pivot Tables in Microsoft Excel. This video explains Pivot Tables for dummies, learn Pivot Tables with this video.
Download the Pivot Tables data set from the video:
[ Ссылка ]
Chapters
00:00 Power of Pivot Tables
01:16 Getting to know the data set
02:14 Creating the first Pivot Table
03:32 Using Values, Rows, Columns and Filters
09:37 Creating standardized tables with Pivot
11:39 Calculated Fields for advanced analyses
16:00 Building Dashboards with Pivot Tables
#excel #pivottable #dataanalysis
🎓 COMMUNICATIONS AND SLIDE WRITING COURSE
Learn to create PowerPoint presentations and communicate like leading consulting firms with this Firm Learning Signature Course
[ Ссылка ]
📄 CV AND COVER LETTER TEMPLATE*
Get a CV and cover letter template based on my own documents. With earlier versions of this CV and cover letter, I successfully applied to McKinsey as consultant:
[ Ссылка ]
✅ THINK-CELL - EXTENDED TRIAL AND SINGLE LICENSES*
think-cell is the leading PowerPoint tool to create professional slides. It is used by 8 of the top 10 consulting firms and the entire DAX 40. Get access to an extended free trial and single licenses:
[ Ссылка ]
👍 CHANNEL MEMBERSHIP
Become a member of Firm Learning to support my work and get access to perks:
[ Ссылка ]
📩 NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter for more regular content:
[ Ссылка ]
☑️ RECOMMENDATIONS*
Book recommendations: [ Ссылка ]
Travel like a consultant: [ Ссылка ]
GMAT study material: [ Ссылка ]
My video equipment: [ Ссылка ]
💬 SOCIAL MEDIA
Instagram: [ Ссылка ]
TikTok: [ Ссылка ]
LinkedIn: [ Ссылка ]
Discord: [ Ссылка ]
Twitch: [ Ссылка ]
Facebook: [ Ссылка ]
* Links are Affiliate or Sponsored links. I receive a fixed fee or revenue share whenever a purchase is made. The price for you stays the same. Thanks for your support!
All views expressed on this channel are private opinions of this channel's creator Heinrich. This is NOT an official channel of any consulting firm.
