Do This in Excel to Save Hours of Time (99% of People Don't Know It)

Build custom Excel Templates for charts, themes, sheets, and even entire excel files to save hours of time.
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
If you spend most of your time tediously formatting Excel sheets, what you're about to learn is going to be a gamechanger. We're going to build 4 custom Excel templates for charts, themes, worksheets, and even entire workbooks. Best part is, you do them once, and you can forget about them entirely. First, we'll work on custom Excel themes, so you can match the font and color palette of your company. Second, we'll work on adding default worksheets (like a cover page) that you already have every time you open Excel. Third, create custom chart templates in Excel. Finally, make file templates and add them to Excel's default templates section.
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/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Custom Excel Theme (Colors & Font)
2:18 - Add as Default
3:23​ - Worksheet Defaults (Default Cover Page)
4:35​ - Protecting Excel Sheets
6:12​ - Chart Templates
7:56​ - Workbook Templates

[@KenjiExplains]

Black Friday Sale! Get 25% OFF all our courses: www.careerprinciples.com/all-courses

[@lihelen8982]

Hello Kenji, I love your videos, they have been really helpful. Jus wondering if the courses are live teaching or we jus buy the materials for self study?

[@stevetheanalyst]

HELLO @kenji, thanks for all your amazing videos. since you are a guru in this field, would you recommend learning python as a financial analyst in a corporate environment. is python needed in the field of finance?

[@Catalyst8487]

Even if I can do it in two minutes, I'm gonna make sure my boss continues to think it takes two hours.

[@homerisian]

I made a career out of doing that :)

[@subindad]

Next level is convincing your boss that it takes uninterrupted two days

[@shraddhasoni5449]

Then only useful

[@querrythis]

Haha! That's exactly what I do too.

[@AliceShisori]

Kenji you're a godsent!! I think you're one of the absolute best excel/office youtubers I've ever had the opportunity to follow!
keep up the great work K.

[@KenjiExplains]

Thanks so much Alice really appreciate your comment! Made my day :)

[@Explickt]

Your videos really provide an insane amount of value! To the point, very well explained, and extremely helpful overall! Thanks a lot for sharing all of this.

[@KenjiExplains]

Awesome to hear that thank you for the nice comment! :)

[@jyotiprasadchaudhary8527]

It's really tricky and efficiency & time saving approach.

[@varunmittal5196]

Always a productive time spent on your videos 🤝

[@LouisSpectorCMT]

Great video. Thanks so much!

[@kealebogapoifo6703]

Hi Kenji I love your videos, this is unrelated but I wanted to ask..how can make a graph that displays data label thats a value that moves to the next data entry as the graph progresses, your help will be highly appreciated, thanks

[@camlex6310]

So helpful!!! Thanks

[@wambulerai7539]

Thank you for this video❤

[@ferrao1970]

Your videos are very insightful....always productive time spent. Thank you!🙏

[@williamwedding5317]

Great explanation and Presentation

[@stiertjuh]

Awesome! With this tutorial I entered in the 1% bracket! Keep them comng!! Thanks a lot

[@KenjiExplains]

Lets go! Thanks for watching :)

[@garkitv23]

Thank you a lot

[@nywzhizhang]

Thanks for the sharing, Kenji. Can you please make M&A model / LBO model?

[@maradonasembiring2342]

Good Informative

[@mamdouhbassiouny5811]

EXCELLENT

[@arindamdutta9371]

Fantastic...
Can we do the same with PPT?

[@2centts]

Awesome!

[@KenjiExplains]

Thank you! Cheers!

[@sarathchandran2185]

Please teach us Networkdays.Intl and Workday.Intl functions. Thank you

[@Rood67]

I get more with these videos in ten minutes or less than hours with other content creators.

[@2Wiix]

PowerBi is next level lol

[@varunmittal5196]

Can we do this standardization also in PowerPoint? That would be 1000 times more useful (at least in my case)

[@ed8623]

Hello, I use Microsoft 365, and I followed your steps. However, when I use Ctrl + N, it only opens a new blank workbook without using the template. Do I need to set up any additional links or others? thank you!

[@roshandhumal1193]

Same Here I also tried multiple times but same output.

[@quyduongnguyen9660]

nice

[@arhinscosolutech]

Nice

[@KenjiExplains]

thank you!

[@eshrakkader5996]

Hi there Kenji! I followed all the steps, but when I open a new Excel file the default theme still shows Office instead of the custom theme. I tried multiple times no luck. Am I missing something?

[@munnabhaishiyal]

How to send excel data on outlook seperat using VBA

[@laudnunoo1915]

First comment! Just excited 😂
Great videos!

[@KenjiExplains]

Haha thank you! Glad you like them :)

[@Influenceless-influencer]

How do I make that custom line chart?

[@KenjiExplains]

I did it in this video: th-cam.com/video/jeYjtEX3RAE/w-d-xo.html

[@HafizHaroonAsghar]

I need excel formula of unsolved ....
Duty timing 9 to 17 =8 hrs including break time 13:00-14:30
Employee in out details
Time in 8:55 out for break at 13:10 - 14:30 and duty ends 17:00
Duty hours =8 not less

[@vanmorrison4014]

OK

[@willzinner8813]

didnt know you can make chart template

[@KenjiExplains]

Few people do!

[@shahriarrafid7078]

Doesn't work on any of my PCs. Office theme remains the default. I followed all the steps, but nothing happened.

[@allen3158]

Seems like there is no custom colour button in Mac office

[@whitehillclassical5760]

How to open finder ?

[@whitehillclassical5760]

Can't able to do the next step of ctrl +x ....

[@deweywsu]

Assumes a lot to say 99% of people don't know it.