Join 300,000+ professionals in our courses:
In this video I’ll share my Excel Pivot Table pro tips to make the best use of Pivot Tables in Microsoft Excel. You’ll discover hidden productivity tips as well as pivot table hidden tricks for example using a hidden pivot table so you can use Slicers on formulas as well. There is a lot of Excel tips and tricks that many Excel experts don’t know yet.
00:00 10 Best Pro Tipps for Pivot Tables in Excel
00:23 No 1: Fast PivotTable
01:06 No 2: Adjust Field Settings
01:59 No 3: Timeline slicer
03:17 No 4: Pivot Table Without Using a PivotTable 🤔
04:56 No 5: Top N Analysis
06:36 No 6: Type Over Sorting
07:12 No 7: Repeating VS Centering Labels
08:15 No 8: Custom Sorting Pivot Table Fields
08:54 No 9: Easy %-Change Calculations in Pivot Tables
10:31 No 10: Disable Double-Click for Details
🌍 My Online Courses ►
🎬 LINKS to related videos:
Excel Pivot Tables EXPLAINED in 10 Minutes:
Advanced Pivot Table Techniques:
👕☕ Get the Official XelPlus MERCH:
🎓 Not sure which of my Excel courses fits best for you? Take the quiz:
🎥 RESOURCES I recommend:
More resources on my Amazon page:
🚩Let’s connect on social:
Instagram:
Twitter:
LinkedIn:
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #pivottable…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Like the tip#3 .. Thank you for sharing
You’re hot!
no.9
Number 2 is my favourite.
Number 9. Thanks for all the tips though.
Awesome, Leila. Mast
Very helpful! I've been centering labels manually for about a million years. You've probably saved me hours!
you are a great teacher in Microsoft excel. I have learn a lot from your videos. Now i have my own channel and i am trying to publish the videos in regular basis in my own language.
Dear Ms. Leila,
#7 was my favorite. I would’ve said #4, but I didn’t understand how it was made or see how to replicate it. It was cool to watch
Fantastic! Thank you Leila!
I do like the disable double click and the change % to the previous item in the list when looking at months and years.
Thank you for this video, my favorites tip are 4 and 7.
Hi Leila, your videos are excellent – simple but thorough, insightful and engaging. Thank you for sharing your knowledge and tips
super
Hi Leila, I appreciate your tips on how to use the PIVOT TABLE more effectively. You have shown me many features that I was unaware of. I can't pick a single tip as my favorite because they are all extremely useful. Thank you for sharing your knowledge.
TIp 8
At 3:32, how did you get your slicers to have that slick, professional appearance?
I like number 3 and 7. Thank you!!
Option 10 is cool
I love tip #3. I had no idea we culd do this in excel.