1
00:00:04,510 --> 00:00:06,890
I know learning Excel can be overwhelming.

2
00:00:06,900 --> 00:00:09,080
It's a program that can do so much.

3
00:00:09,210 --> 00:00:13,310
Each feature serves a purpose and there's so much information out there.

4
00:00:13,350 --> 00:00:15,990
What's important and what's not.

5
00:00:15,990 --> 00:00:20,130
I've designed this course with the corporate professional in mind.

6
00:00:20,190 --> 00:00:27,630
I've carefully picked out the essentials and designed practical real world examples to help you understand

7
00:00:27,720 --> 00:00:30,320
the full potential of each feature.

8
00:00:30,390 --> 00:00:35,270
What you're going to be able to do is to use Excel to find answers from your data.

9
00:00:35,280 --> 00:00:38,900
It's also going to act as your problem solving tool.

10
00:00:38,940 --> 00:00:44,580
You're going to be able to present your analysis in a compelling organized manner.

11
00:00:44,580 --> 00:00:48,360
Let me give you a quick overview of how we're going to do that.

12
00:00:48,420 --> 00:00:53,370
You're going to start off learning how to input data including some hidden features that will save you

13
00:00:53,460 --> 00:00:55,280
a ton of time.

14
00:00:55,350 --> 00:01:01,530
You're going to learn how to navigate large data and how you can protect your workbook and worksheets

15
00:01:01,890 --> 00:01:07,360
so the information isn't intentionally or unintentionally changed.

16
00:01:07,590 --> 00:01:13,240
There are some rules you need to follow and understand when you write Excel formulas.

17
00:01:13,260 --> 00:01:19,170
We're going to be covering these before we move on to the important Excel functions section that will

18
00:01:19,170 --> 00:01:21,880
help you automate your analysis.

19
00:01:22,080 --> 00:01:27,610
If you want to work smarter instead of harder, it's important to start with proper datasets.

20
00:01:27,660 --> 00:01:33,750
You're going to learn what these are and the tools you can use to get your messy data to become a proper dataset.

21
00:01:33,750 --> 00:01:40,980
To create compelling reports you need to follow a set of spreadsheet design principles.

22
00:01:40,980 --> 00:01:46,410
We're going to cover these with examples as well as printing and formatting to bring attention to your

23
00:01:46,410 --> 00:01:47,790
analysis.

24
00:01:47,850 --> 00:01:51,280
You're going to be equipped with different ideas to visualize your data.

25
00:01:51,780 --> 00:01:56,970
So if you get a task to present results, you're going to have options to choose from.

26
00:01:57,120 --> 00:02:03,690
You're going to be able to impress your managers with interactive charts and tables which you can design

27
00:02:03,690 --> 00:02:09,680
the pivot tables and find better ways to import and transform data with tools like Power Query.

28
00:02:09,930 --> 00:02:11,570
It's going to be easy and fun.

29
00:02:11,610 --> 00:02:13,450
Let's enjoy the process together.

30
00:02:13,590 --> 00:02:15,330
Go through the quiz questions.

31
00:02:15,330 --> 00:02:17,010
Take part in the challenges.

32
00:02:17,160 --> 00:02:20,670
Try to solve them on your own before you see my version.

33
00:02:20,670 --> 00:02:26,430
This is going to embed the concept in your mind so you can apply it when you come across a similar scenario

34
00:02:26,460 --> 00:02:27,990
at your work.

35
00:02:27,990 --> 00:02:33,250
If you're a beginner I strongly suggest that you follow the lectures in order.

36
00:02:33,420 --> 00:02:38,610
If you're looking to fill in the gaps in your knowledge, feel free to jump through the different sections

37
00:02:38,970 --> 00:02:40,940
as you see fit.

38
00:02:40,950 --> 00:02:45,820
I've included a downloadable course outline at the end of this section.

39
00:02:45,870 --> 00:02:48,690
It has the complete list of all the lectures.

40
00:02:48,690 --> 00:02:50,670
Use it as a quick reference.

41
00:02:50,700 --> 00:02:55,520
You can also print it out to check off the topics you've mastered or add your notes

42
00:02:55,620 --> 00:03:01,010
If you need to revisit a topic later on. Next, let me show you how you can download the course files.