1
00:00:04,470 --> 00:00:09,920
In this section we'll take a look at some useful formatting options which we haven't covered yet in the course.

2
00:00:09,960 --> 00:00:15,440
You may think that formatting is just about how your report looks in the end.

3
00:00:15,780 --> 00:00:22,830
But it's not just about the looks. You can actually mess up your calculations or make formulas more difficult

4
00:00:22,830 --> 00:00:29,020
to write. Interesting, right? How wrong formatting can impact your formulas.

5
00:00:29,040 --> 00:00:31,440
Make sure you watch the lecture after next.

6
00:00:34,980 --> 00:00:40,470
We'll also cover one Excel feature that personally saved me a ton of time and headache. When I found

7
00:00:40,470 --> 00:00:41,920
out about this feature.

8
00:00:42,000 --> 00:00:45,480
I wasn't new to Excel. I had already used it for years.

9
00:00:45,480 --> 00:00:47,990
I was an advanced Excel user.

10
00:00:48,000 --> 00:00:51,600
Still I had no clue this existed.

11
00:00:51,600 --> 00:00:52,770
It's called justified.

12
00:00:52,770 --> 00:00:58,080
We're going to cover that too. We'll then take a look at the various number formatting options you can

13
00:00:58,080 --> 00:01:04,750
apply to your data and how you can format cells and values based on a condition.

14
00:01:04,750 --> 00:01:08,680
Now there's a lot more to formatting than we can cover in the basics course.

15
00:01:08,700 --> 00:01:14,570
One of my favorite techniques is to take advantage of Excel's custom number formatting.

16
00:01:14,640 --> 00:01:16,940
There is a lot of tricks you can use there.

17
00:01:16,950 --> 00:01:23,070
I have some YouTube videos on this so make sure you check it out. But that topic is something that's

18
00:01:23,070 --> 00:01:26,070
probably more suitable for an advance course.

19
00:01:26,100 --> 00:01:29,670
Now let's get started and take a look at some useful formatting Tips.