Рет қаралды 2,366
Pivot Tables are one of THE best ways to analyze and show your data. But sometimes you want to show different views of the same data like the counts and then percentage from totals. Were you used to having two pivot tables? One with the count and one with percentages? Takes out a lot of space? We put it on one table and still make it look good. You don’t have to have separate pivot tables to show different views of the same data. You can combine them into one pivot table and still have it look presentable. This gives you a way to make your data insightful and look good at the same time.
0:00 Intro
0:42 Create Pivot Table
1:10 Create Count
1:22 Create Percentage
1:29 Create two Pivot Tables
1:49 Create Pivot Table with Count & Percentage
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~