Скачать или смотреть Excel Pivot Tables Tutorial - Data Analysis Skills for Consultants

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:
https://link.firmlearning.com/pivotta...

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
https://link.firmlearning.com/slides

📄 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:
https://link.firmlearning.com/learning

✅ 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:
https://link.firmlearning.com/think-c...

👍 CHANNEL MEMBERSHIP
Become a member of Firm Learning to support my work and get access to perks:
https://link.firmlearning.com/join

📩 NEWSLETTER
Sign-up to the Firm Learning e-mail newsletter for more regular content:
https://link.firmlearning.com/e-mail

☑️ RECOMMENDATIONS*
Book recommendations: https://link.firmlearning.com/books
Travel like a consultant: https://link.firmlearning.com/travel
GMAT study material: https://link.firmlearning.com/gmatstudy
My video equipment: https://link.firmlearning.com/myequip...

💬 SOCIAL MEDIA
Instagram: https://link.firmlearning.com/instagram
TikTok: https://link.firmlearning.com/tiktok
LinkedIn: https://link.firmlearning.com/linkedin
Discord: https://link.firmlearning.com/discord
Twitch: https://link.firmlearning.com/twitch
Facebook: https://link.firmlearning.com/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.