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

Рет қаралды 165,701

Күн бұрын

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

Пікірлер: 54

@KenjiExplains 7 ай бұрын

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

@lihelen8982 7 ай бұрын

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 7 ай бұрын

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 6 ай бұрын

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

@homerisian 5 ай бұрын

I made a career out of doing that :)

@subindad 4 ай бұрын

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

@shraddhasoni5449 3 ай бұрын

Then only useful

@querrythis 3 ай бұрын

Haha! That's exactly what I do too.

@AliceShisori 7 ай бұрын

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 7 ай бұрын

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

@Explickt 7 ай бұрын

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 7 ай бұрын

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

@varunmittal5196 7 ай бұрын

Always a productive time spent on your videos 🤝

@LouisSpectorCMT 7 ай бұрын

Great video. Thanks so much!

@jyotiprasadchaudhary8527 6 ай бұрын

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

@camlex6310 7 ай бұрын

So helpful!!! Thanks

@ferrao1970 Ай бұрын

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

@wambulerai7539 7 ай бұрын

Thank you for this video❤

@williamwedding5317 6 ай бұрын

Great explanation and Presentation

@garkitv23 5 ай бұрын

Thank you a lot

@maradonasembiring2342 6 ай бұрын

Good Informative

@stiertjuh 7 ай бұрын

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

@KenjiExplains 7 ай бұрын

Lets go! Thanks for watching :)

@nywzhizhang 7 ай бұрын

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

@mamdouhbassiouny5811 5 ай бұрын

EXCELLENT

@2centts 7 ай бұрын

Awesome!

@KenjiExplains 7 ай бұрын

Thank you! Cheers!

@sarathchandran2185 7 ай бұрын

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

@2Wiix 7 ай бұрын

PowerBi is next level lol

@arindamdutta9371 7 ай бұрын

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

@kealebogapoifo6703 7 ай бұрын

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

@Rood67 6 ай бұрын

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

@quyduongnguyen9660 6 ай бұрын

nice

@varunmittal5196 7 ай бұрын

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

@arhinscosolutech 7 ай бұрын

Nice

@KenjiExplains 7 ай бұрын

thank you!

@laudnunoo1915 7 ай бұрын

First comment! Just excited 😂 Great videos!

@KenjiExplains 7 ай бұрын

Haha thank you! Glad you like them :)

@munnabhaishiyal 6 ай бұрын

How to send excel data on outlook seperat using VBA

@HafizHaroonAsghar 7 ай бұрын

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

@ed8623 7 ай бұрын

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 4 ай бұрын

Same Here I also tried multiple times but same output.

@eshrakkader5996 4 ай бұрын

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?