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


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

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

There were eight of us in that classroom. Eighth grade. "Remedial science." A polite way of saying: these students don't get it. I remember staring at the poster on the wall - pictures of cells, diagrams of atoms - and feeling embarrassed. Everyone else seemed to understand this stuff. Why didn't I? The teacher would explain mitochondria - "the powerhouse of the cell" - and I'd just sit there. What does that even mean? I couldn't picture it. Couldn't visualize any of it. Biology was abstract....

Hey Reader, I used to check my bank account way too often. We'd finish client work, send the invoice, and then... I'd just wait. Checking QuickBooks every couple days to see if payment came through. Wondering if I needed to send another reminder. It wasn't just the waiting. It was the mental space it took up. I'm trying to work on forecasts for clients but I'm thinking about who still owes us money. I see the same thing with so many of the firm owners and consultants I talk to. Accountants,...

The client reached out and said, "Josh, our customer wants a discount. Can I still record the revenue on this deal?" Honestly? I wasn't really sure. My team didn't know either. And the client needed an answer fast. So I opened ChatGPT and explained the situation. Within two minutes, I had an answer. But I wasn't about to just copy and paste it... I mean, let's be real, ChatGPT probably hallucinated half of it. So I asked for the source. Then I actually read it. And there it was. The...