1
00:00:00,460 --> 00:00:08,560
Now we know about the financial formulas and financial statements, and we have also learned how to

2
00:00:08,560 --> 00:00:12,760
use formulas and financial analysis and excel.

3
00:00:14,850 --> 00:00:23,190
But when we create financial reports or analyze the financial data, we usually don't only use the numbers,

4
00:00:23,670 --> 00:00:31,670
but we represent data in the form of charts, graphs or any other visual formatting as well.

5
00:00:34,740 --> 00:00:43,470
Doing that is important because charts and graphs allows us to easily identify trends and pattern in

6
00:00:43,470 --> 00:00:44,030
our data.

7
00:00:45,270 --> 00:00:45,690
So.

8
00:00:46,600 --> 00:00:52,030
If you look at this first graph, you can clearly see that the sales are going down.

9
00:00:54,090 --> 00:01:03,000
If you look at this map, you can clearly see that the most users we are getting are coming between

10
00:01:03,000 --> 00:01:06,960
Tuesday and Thursday from 6:00 a.m. to 12:00 p.m..

11
00:01:09,450 --> 00:01:17,720
Feels graphs or charts, it will be much easier for us to communicate insights from our data.

12
00:01:20,020 --> 00:01:26,700
Now, let's take an example to compare numeric data vs. Chuck.

13
00:01:30,830 --> 00:01:40,040
So suppose you own a large clothing store and you want to compare sales of sweaters versus Dowell's.

14
00:01:42,490 --> 00:01:51,760
There is this data of last 12 months since not try to identify the pattern in this data in just five

15
00:01:51,760 --> 00:01:52,380
seconds.

16
00:01:57,330 --> 00:02:05,400
You can see it is somewhat difficult to analyze this 24 numeric data values in just five seconds.

17
00:02:06,870 --> 00:02:10,130
Now, let's look at a graph.

18
00:02:10,830 --> 00:02:11,910
This the line chart.

19
00:02:12,780 --> 00:02:17,010
Again, I'm giving you five seconds to analyze this line chart.

20
00:02:21,860 --> 00:02:29,530
I think the difference between chart and numeric data is not clear to you, you can identify the pattern

21
00:02:29,540 --> 00:02:32,660
in this chart and just two to three seconds.

22
00:02:34,520 --> 00:02:41,240
Now, we know that the charts are important, so in the next couple of lectures, we will see how to

23
00:02:41,240 --> 00:02:44,310
create different types of charts in Excel.

24
00:02:45,230 --> 00:02:51,370
We will look at Collum charts, bar charts, line charts, pie charts, etc..

25
00:02:53,780 --> 00:03:02,300
We are using Excel and not other software such as Tableau, Spotfire or Google Data Studio, because

26
00:03:02,300 --> 00:03:10,070
most people are used to using Excel and Excel is capable of handling some basic data visualization,

27
00:03:10,190 --> 00:03:13,250
which is enough for financial dashboards.

28
00:03:15,150 --> 00:03:23,280
But if you are looking for budgeting tool, I recommend you to look at our Google Data Studio course

29
00:03:23,280 --> 00:03:29,700
where we have discussed data visualization and dashboards in detail and Google data studio.