1
00:00:00,690 --> 00:00:05,790
So you decide to enroll in this course and take it, what's the best way to get a solid grasp of the

2
00:00:05,790 --> 00:00:06,450
materials?

3
00:00:07,080 --> 00:00:09,610
Simply watching videos doesn't convey knowledge.

4
00:00:09,630 --> 00:00:15,360
So this course is designed around you performing the steps along the way with me to assist you in doing

5
00:00:15,360 --> 00:00:15,630
this.

6
00:00:15,960 --> 00:00:20,570
Each person has the workbook attached as a resource for you to download and follow along.

7
00:00:21,420 --> 00:00:26,340
You can use the download from the course introduction all the way through the course, or you can pick

8
00:00:26,340 --> 00:00:32,010
up the workbook specific to each lesson from any individual lesson if you happen to skip around.

9
00:00:32,700 --> 00:00:37,170
Except for one lesson of the exercise, everything in this course builds off of one data set.

10
00:00:37,620 --> 00:00:41,970
These files can be found under the resources dropdown associated with each video.

11
00:00:42,330 --> 00:00:45,300
You'll see them labeled based upon the video names.

12
00:00:45,540 --> 00:00:50,580
And each of these is the workbook that's from the beginning of the video prior to any changes being

13
00:00:50,580 --> 00:00:51,000
made.

14
00:00:51,970 --> 00:00:57,900
Alternatively, for this specific lesson, which is unpublished, as I'm obviously recording it right

15
00:00:57,900 --> 00:01:02,280
now, there's a zip file that contains all of the files for all of the lessons.

16
00:01:03,100 --> 00:01:08,410
Downloading this file will give you access to all of the files with the appropriate file names rather

17
00:01:08,410 --> 00:01:10,720
than the original DOT Excellence Act's.

18
00:01:11,650 --> 00:01:17,590
Once you've downloaded it, navigate to the file within your directories, right, click on it and within

19
00:01:17,590 --> 00:01:22,360
your options, you'll find and extract all command, choose that and follow the prompts.

20
00:01:22,600 --> 00:01:26,520
And it'll give you a folder with all of the files that you need for this course.

21
00:01:26,920 --> 00:01:32,580
The files are organized into two folders for lessons and exercises within the lessons folder.

22
00:01:32,650 --> 00:01:37,750
The files are ordered in conjunction with the course and even includes the PowerPoint presentation later

23
00:01:37,750 --> 00:01:38,140
on.

24
00:01:38,950 --> 00:01:44,290
The exercise folder contains just the starting file for the exercise, along with the solution that

25
00:01:44,290 --> 00:01:47,110
I created for the exercise.

26
00:01:47,140 --> 00:01:52,300
If you get stuck and something in the supporting videos are unclear, you can always compare your efforts

27
00:01:52,300 --> 00:01:54,580
against mine to see what might be different.

28
00:01:55,150 --> 00:02:00,700
If you do follow along with each of the lesson tasks, the exercise should be only a mild challenge

29
00:02:00,700 --> 00:02:03,210
that forces you to apply the concepts on your own.

30
00:02:03,730 --> 00:02:08,560
Once you've done that, hopefully you'll see some ways that you can apply power pivot in your day to

31
00:02:08,560 --> 00:02:09,280
day efforts.

32
00:02:10,090 --> 00:02:11,340
With that, let's go ahead.

33
00:02:11,360 --> 00:02:12,250
Begin the course.
