1
00:00:01,420 --> 00:00:09,010
Welcome to the Course Excel for financial analysis, where you will learn both the financial analytics

2
00:00:09,010 --> 00:00:13,270
concept as well as the implementation and exit.

3
00:00:14,590 --> 00:00:20,920
My name is Michelle and along with my co instructor Puckridge, I'll be leading you through this course

4
00:00:21,610 --> 00:00:22,840
as instructors.

5
00:00:23,350 --> 00:00:30,760
Our courses have been enrolled by over seven hundred thousand students worldwide, the bolthole, engineering

6
00:00:30,760 --> 00:00:39,340
and MBA degrees and have experience of data analytics and consulting industry and today's data driven

7
00:00:39,340 --> 00:00:39,750
world.

8
00:00:40,540 --> 00:00:45,830
More and more companies are looking for people skilled in finance and analytics.

9
00:00:46,840 --> 00:00:52,200
On the other hand, students are facing difficulty in figuring out where to start this topic.

10
00:00:53,410 --> 00:01:01,330
The available study material on this topic is either too generic or focuses completely on the chording

11
00:01:01,330 --> 00:01:01,690
part.

12
00:01:03,040 --> 00:01:06,380
A perfectly balanced course is really hard to find.

13
00:01:07,300 --> 00:01:13,690
We have designed this course for the people who are beginning their career in financial analysis and

14
00:01:13,690 --> 00:01:14,160
modeling.

15
00:01:15,010 --> 00:01:21,900
I need a sound understanding of financial analytics concepts without going too deep in the coding part.

16
00:01:22,900 --> 00:01:31,570
If you put one out day in discourse within 15 days, you will be able to master financial analysis.

17
00:01:31,570 --> 00:01:39,220
Using exit will start the scores by learning how to use formulas and functions in Excel.

18
00:01:39,880 --> 00:01:45,250
Then we will look at the important financial functions that Excel provides us.

19
00:01:46,480 --> 00:01:54,490
Will also see how to do horizontal and vertical analysis of a firm's profit and loss statement, after

20
00:01:54,490 --> 00:01:58,480
which we will cover financial ratio analysis and dissection.

21
00:02:00,370 --> 00:02:06,220
Then we will look at different types of charts and dashboards which we can use to visualize our data.

22
00:02:07,970 --> 00:02:14,550
Then we will see the application of pivot tables for slicing and dicing the data to create some reports.

23
00:02:15,840 --> 00:02:21,820
After this, we will learn the concept of predictive modeling using linear regression.

24
00:02:23,450 --> 00:02:29,550
At the end, we will also create a completely new regression model in Excel from Scratch.

25
00:02:30,280 --> 00:02:37,180
The ideal student for this course is a finance professional who wants to expand on the current skills

26
00:02:38,080 --> 00:02:43,520
of a student who wants to have a career in the field of financial analysis and modeling.

27
00:02:44,980 --> 00:02:47,170
There are no prerequisites for this course.

28
00:02:48,370 --> 00:02:52,770
We only ask that you do the practical exercises side by side.

29
00:02:54,250 --> 00:02:59,890
If you have any doubt or query throughout the course, you can post them in the discussion forum.

30
00:03:01,000 --> 00:03:07,090
I will be personally solving all your doubts, so feel free to have a look at the course description

31
00:03:07,480 --> 00:03:09,610
and we look forward to seeing you inside.