VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Pivot Table Excel Tips & Tricks - Kevin Stratvert

Pivot Table Excel Tips & Tricks - Kevin Stratvert

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Pivot Table Excel Tips & Tricks - Kevin Stratvert learn the top 14 best pivot table tips and tricks in Microsoft Excel. For example, use natural language to create pivot tables, get automatic insights on your data using ML, use multiple tables as sources, add calculated fields, quickly filter data with slicers & timelines, build dashboards, and many more. These are sure to take your analysis skills with pivottables to the next level. And most importantly, you'll be able to answer business questions even faster. - Additional resources - Sample data to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whLkz3v27FyEe1w4O_A?e=GiHJal - How to use Pivot Tables Tutorial for Beginners: https://youtu.be/m0wI61ahfLc - How to use Power Pivot in Excel: https://youtu.be/rB_IiYbOo7w
Date: 2022-03-15

Comments and reviews: 7


Thank you so much Kevin, this video and all other of your videos really helped my study. I have a question on 1:51, on my excel I don't see this -type and search- icon, only the suggestions of graphs. Is there any way i can search this -unit sold to customer..-? my excel is the newest version. Thank you.
reply

Hi Kevin, I found your video super helpful. However, when I tried to practice on creating Relationship between two tabs, I found the -Relationships- commend is grey-out. Why is this and how I can turn it back on? Thanks.
reply

Great learning and training we have here. Many thanks to Kelvin. The sample data excel link is taking long and not opening. Please help. i need a sample data for practice. Thanks
reply

Hi Kevin, I'm using the 2019 version of Microsoft office tool. I don't find the option -Analyze Data- in the Home tab. Pls guide me how to get it.
reply

yes its very fantastic...! and i am using distinct count in excel but in pivot table , blank cells are also counting, here showing 1. how rectify this ?
reply

if you have multiple pivot tables but want to use the same slicer to filter the data in all pivot tables all at once, how would you do that?
reply

Wasn't aware of the Analyse Data option first, and the dufferent data views it gives in addition to PT's. Thanks so much for this -
reply
Add a review, comment






Other channel videos