Best Pivot Table Design Tips to Impress Anyone

Design beautiful pivot tables with these 8 pivot table tips.
🔥 10x Your Excel with our course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
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:
🔥 Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/all-...
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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!

[@KenjiExplains]

🔥 10x Your Excel with our course: www.careerprinciples.com/courses/excel-for-business-finance

[@adderlyacevedo8232]

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

[@musamaiza6259]

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

[@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

[@Quintero243]

This has become my new favorite channel on KZbin.😇 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...

[@Krystyna768]

I completely resonate with your experience, if you are talking about expert Mrs Josefina then yes ,working with her transformed my life also, suprised to see other people here work with her after her skills was talked about on the show i started working with her , Before, I was uncertain and made impulsive moves. With our her insights, I've learned patience and strategy. My investments are flourishing, and I'm on my way to achieving my financial goals. Let's inspire others to take control of their finances! Great channel

[@Quintero243]

Your words really hit home. I'm talking about expert Mrs Josefina She didn't just teach me about the market; she taught me about myself as an investor. I've found my niche, and my portfolio reflects that. Together, we're not just trading; we're building futures. Here's to more informed decisions and shared successes

[@razyadat4601]

I'm so grateful to have found this community and Mrs Josefina A. Gallardo, just like you her guidance helped me navigate the complexities of market. I used to fear losses, but now I view them as opportunities to learn and grow. I've not only seen huge monetary gains but also a boost in my confidence as an investor. i am happy to keep learning and evolving

[@martina7786]

Though I'm not a subscriber here, I've heard wonderful things about Mrs.Josefina A. Gallardo .It's disheartening that she's often fully booked, making it challenging to connect with her directly. I'm truly hoping for an opportunity to engage with her in the future.

[@shuchangtianyu2799]

Your story is inspiring , Expert Josefina Gallardo impact goes beyond numbers; it's about personal growth. I've learned discipline, resilience, and the importance of continuous learning. Every trade is a lesson, and I've gained a wealth of knowledge along the way. Let's stay committed to evolving as investors and supporting one another. Here's to meaningful growth and lasting success!..

[@joaolucas5396]

The camera tip is a gold bonus! Awesome!

[@KenjiExplains]

It really is! thank you

[@pahasha316]

Thank u. Thats a game changer ❤

[@navdeepagarwal7072]

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!

[@KenjiExplains]

Thanks so much!

[@kamlabhatt1824]

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

[@AmolMY]

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

[@user-oi2rf2dj3z]

Excellent Kenji. Thanks for the incredible teaching

[@nurasafewo9781]

As helpful as usual, thank you indeed.

[@brightappiah7809]

You are the best Kenji.. thanks

[@luisllontopbarahona3188]

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

[@drbrambedkaruniversityysur6481]

thank u so much sir for better and clean explanation

[@kaushiksrivatsa]

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

[@KenjiExplains]

Let's go!

[@camlex6310]

Super helpful!! The table looks great

[@KenjiExplains]

Thanks!

[@chimfwembechipili]

Indeed kenji explains 💯

[@imronnesia5170]

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

[@user-vv8im1oh5e]

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

[@aspectoflife]

amazing teacher.

[@adambalaz1604]

Really good tips, thanks! :)

[@shivakumars3204]

Bonus trick super

[@hishamsenossy7165]

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

[@williamchurch711]

This has become one of my favorite KZbin channels.

[@KenjiExplains]

lets go! thank you

[@wesamaraj8705]

many thanks

[@helmyhelmy3767]

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 ?

[@rexbk]

Thanks Kenji.

[@TamTinHoc2024]

Thanks so much

[@danielcandrawijaya4993]

Hi Kenji, if we have 3 sheet (raw, pivot, table), can the table(from pivot) automatically updated if we change the raw data?

[@atatinatiqotulm.f3950]

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

[@KenjiExplains]

Thank you for dropping by :) Really appreciate your comment!

[@PorshaLaVieBelle]

Kenji you have the best channel

[@danielhartjes2479]

Nice job!

[@alecqoh254]

KZbin University. Awesome

[@nishanth4323]

Yeah now that's some useful tips 👌👌......🙏

[@KenjiExplains]

Glad you think so!

[@antonynganga7868]

Awesome job Kenji,💪💯

[@KenjiExplains]

thank you!

[@jiggssales3071]

You're awesome!

[@rexbk]

Hi Kenji, oot. Do you sell an Accounting Book Keeping in Excel?

[@gecarll26]

Thus, this tutorial can apply in what windows version?

[@hasanmohammadtareq89]

Awesome!

[@SeemaSharma-lj3cf]

very useful👌

[@skip031890]

You uploaded this video right on time because I am trying to put something together using a pivot table right now and was having trouble. Amazing video and great channel. Thanks a lot.

[@KenjiExplains]

Glad I could help!

[@samuelkim5996]

@kenji Explains about the certificate pls?

[@willzinner8813]

thanks sir very useful

[@KenjiExplains]

Most welcome!

[@pradipmajhi8636]

Dear Kenji sir please again bring video tutorial on data cleaning deeply in a different way. Thank you

[@user-en4si5gh4g]

camera tip is mind blowing

[@TVSCDN]

Thanks🌹🌹🌹🙏🙏🙏😊 Would like to know from you how an individual should analyse his bank statements to present it easily to the Income Tax official😅

[@foreverriver4989]

What is the best to learn excel or access?

[@samuelkim5996]

Please is the certificate internationally recognized?

[@ReaganShrestha]

Make a video on KPIs for finance.

[@user-rx5fy8it2k]

You must add one more sheet in which we can see client requirements. So we can directly execute and practice by seeing the sheet of client requirements.

[@gecarll26]

Next, can you make a percentage computation using excel and also chart percentage. Thanks God bless, just wanna learn more. #favorpls

[@jessray721]

Why does my excel not have certain features such as "timeline" ?

[@joewahosky5223]

wow! camera could be a game changer

[@nitinchaudhary1439]

Can you just give a discount on that course I eagerly wanted to learn excel from you but im having fund issues!! Could you please help me get it in a low price pls

[@KenjiExplains]

Hey thanks for your interest. For queries regarding the courses reach out to [e-mail]

[@debasishsamal4646]

1st to comment 🤗

[@KenjiExplains]

haha thank you!

[@mrpdmasta]

Biggest problem with pivot tables, you can’t lock the work and filter by largest to smallest. You can only do that with tables, so I’ve abandoned pivot tables.

[@laminulams8723]

You can filter, just you don't know how.

[@mrpdmasta]

@@laminulams8723 you can sort largest to smallest with a locked pivot table?

[@waqasmaqbool3356]

you can filter on pivot

[@punditgi]

😊

[@KenjiExplains]

thanks for watching!

[@ajraol9032]

Do you think if investment bankers paid more attention to the content than to the presentation, it would save a lot of time ? 🤔 I mean yes, the format looks ugly but at least I don’t have to expect calls in midnight to correct the text alignments 😂

[@KenjiExplains]

hahaha

[@DzunisaniChauke-zp1dv]

Nah, he's good

[@user-pz8xq3ny4j]