profile

Daily Finance & Accounting Tips

[E.C. 1 of 7] Make your formatting come to life!

Published almost 2 years ago • 1 min read

Hey Reader,

Welcome to our first Excel lesson from this course! I'm excited to kick things off with you today.

We're starting our journey right where most Excel users spend a lot of their time - the Home ribbon.

It's probably the most familiar part of Excel for many of us, but I bet there are still some cool tricks hiding in there that you might not know about.

One of the most popular things you can do in the home ribbon is that you can control your cell formatting and conditional formatting.

Custom formatting lets you control how your data is displayed. It's not just about bold and italics - you can create formats that make your numbers more meaningful at a glance.

Conditional formatting automatically applies styles to your cells based on their values. It's a great way to highlight important data or trends without manual work.

In today's video lesson, I'll show you how to use these features to turn a basic profit and loss statement into a clear, informative visual tool.

After you've watched the video and tried these techniques, let me know what you think.

Did you discover any new ways to use these features?

Tomorrow, we'll be exploring the Insert ribbon and diving into some chart creation tips.

Talk soon,
Josh

You are receiving this email because you signed up for a free Excel email course. To unsubscribe from this email course, click here.

​
​Looking to change the frequency of emails, or unsubscribe?

​​Click here to manage your preferences​

​​Unsubscribe me from everything​

​

Daily Finance & Accounting Tips

by Josh Aharonoff

Sign up now to join a community of 80,000+ people who receive my curated selection of the most exciting and thought-provoking content straight to your inbox every week!

Read more from Daily Finance & Accounting Tips

Read Online The Tool You Need for Meeting Notes You Can Act On SPONSORED BY WISPR FLOW NOTETAKER If you're still taking your own notes in meetings in 2026, you're working harder than you need to. But a lot of AI notetakers mishear the words that matter most in your business, so your follow-ups repeat the mistake. That's why I run my calls through Wispr Flow Notetaker. It pulls the attendee names from your calendar invite, so no more wall of Speaker 1 and Speaker 2. And it gets the technical...

1 day ago • 9 min read

Hey Reader, Get my top 14 dashboards and 6 modules, free. They arrive already filled in with your own company's numbers. All of it comes with my free masterclass on September 3rd. Let me tell you why I'm doing this. Almost every business I've worked with needs a proper financial model. Hardly any of them have one. And the ones that do usually have a file somebody built two years ago that nobody has had time to touch since. It's one of the most important tools you can own, and it's also the...

16 days ago • 2 min read

Hey Reader, On Thursday, September 3rd I'm running a free 60 minute masterclass, and when it starts there will already be a complete financial model of your own company sitting on your screen. Your actual business, or your actual client, built from your own accounting data. Not my demo company with the perfect numbers in it. I know how that sounds, so here's how it works. When you save your seat, I'm also giving you a full week of my software, Model Wiz, completely free. Every dashboard and...

19 days ago • 1 min read