Best Pivot Table Design Tips to Impress Anyone

Design beautiful pivot tables with these 8 pivot table tips.

Learn how to design and format pivot tables to make them beautiful. Let's be honest, Excel's default pivot tables don't look great. Their number formatting, color choice, and header text are rather questionable. But if you follow the 8 pivot table design tips in this video, you'll go from ugly pivot tables to something much more impressive. First, you'll learn to remove ugly field names with the sum of, count of etc. Then, you'll learn to avoid losing all the formatting when clicking refresh. Third, you'll learn to add spaces, subtotals, and more. Fourth, you'll learn to remove the filters on pivot tables. Fifth, you'll learn to remove blank cells. Then, you'll learn to make awesome templates to create beautiful pivot tables. Then you'll learn timelines in pivot tables. Finally, you'll add conditional formatting to pivot tables. And there's one bonus feature in the end!

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Field Names Tip
1:55​ - Text & Column Format
3:31​ - Layout Tips
6:26​ - Blank Cells
7:25​ - Templates
8:55​ - Adding Dates Tips
10:02​ - Visual Support
10:56​ - Bonus Feature!

[musamaiza]

You're just a blessing to me Bro. Can't stop looking out for your videos. Truly appreciate

[adderlyacevedo]

All of your videos are pure gold! I learn something new in every one!

[MrFuegi]

loved this video! you don't always have time to make a nice chart/graph or put it all in a PPT so these tricks to make a pivot table more "share-friendly" are great

[AmolMY]

This was one of the most useful videos I have seen. Thanks for teaching new skills to make my excel sheet impressive. 🙌

[oirfdjz]

Excellent Kenji. Thanks for the incredible teaching

[kamlabhatt]

Kenji...you are amazing...one of the best learning youtube channel!!

[nurasafewo]

As helpful as usual, thank you indeed.

[joaolucas]

The camera tip is a gold bonus! Awesome!

[drbrambedkaruniversityysur]

thank u so much sir for better and clean explanation

[Quintero]

This has become my new favorite channel on YouTube.😇 Props to you for all the hard work you put into these videos, I've been a member of this amazing society of investors for a while now, and I can't articulate how much it has transformed my life. We're not just here to earn money; we're here to uphold one another, grow collectively, and rejoice in every stride toward our financial aspirations...

[hishamsenossy]

thaaanks you helped me a lot in my work 😄😍😍

[luisllontopbarahona]

Good job with the video. THE last feature is very good. Quick question... does it also update when copied in a word document?

[vvimohe]

Extremely impressed by the camera function !!!🎉 really superrrr nice vedio 🎉❤

[imronnesia]

Many years doing many stuffs with excel, i realize i knew camera icon just know. it's amaze me. subscribe

[navdeepagarwal]

Generally I forget to post comments on the videos that I like. But posting it today since I really really loved this video. Great work, keep it up!

[williamchurch]

This has become one of my favorite YouTube channels.

[kaushiksrivatsa]

The camera feature could be a game changer in my line of work❤

[atatinatiqotulm.f]

Thank you Kenji, Excel looks great and interesting to me now. It's really nice meet your channel :)

[AprilAi-sjpp]

This is a really good video, thank you! a question for you, on 4:59, when you move your cursor to the minus sign, the cursor changed to a black arrow and pointed to the right, my cursor does not work this way, it is still a white arrow and pointed to the upper left. The reason I am asking is I need to get this black arrow and click a cell so the values on the same category will be highlighted for a formatting task, do you have any idea?

[helmyhelmy]

A question. When I click on a value in the pivot table, it opens a new sheet with the values, how to fix the column width and the number formatting each time ?