Data Analysis Fundamentals with Excel

Focused View

7:59:57

112 View

1 - Data Analysis Fundamentals with Excel - Introduction.mp4

04:48

2 - Learning objectives.mp4

00:34

3 - 1.1 Discuss course style.mp4

01:34

4 - 1.2 Introduce the Data Lifecycle.mp4

04:53

5 - 1.3 Understand Excel versions.mp4

01:56

6 - Learning objectives.mp4

02:26

7 - 2.1 Introduce Get and Transform data.mp4

11:19

8 - 2.2 Load an Excel spreadsheet.mp4

06:11

9 - 2.3 Load a folder of data.mp4

10:49

10 - 2.4 Load data from a website.mp4

05:59

11 - 2.5 Understand data source settings.mp4

06:34

12 - 2.6 Introduce the Power Query Editor.mp4

07:07

13 - 2.7 Remove columns.mp4

07:52

14 - 2.8 Filter rows.mp4

08:27

15 - 2.9 Rename columns and set data types.mp4

05:32

16 - 2.10 Add new columns.mp4

05:50

17 - 2.11 Append queries.mp4

05:49

18 - 2.12 Merge queries.mp4

07:49

19 - 2.13 Transform and cleanse data.mp4

11:07

20 - 2.14 Unpivot data.mp4

13:22

21 - 2.15 Better manage Get and Transform.mp4

10:49

22 - Learning objectives.mp4

01:30

23 - 3.1 Review cell reference styles and types.mp4

04:24

24 - 3.2 Use names in Excel.mp4

05:23

25 - 3.3 Structure data within Excel tables.mp4

12:56

26 - 3.4 Review formulas, functions, and compatibility.mp4

04:39

27 - 3.5 Spill data with dynamic arrays.mp4

07:12

28 - 3.6 Troubleshoot spill errors.mp4

03:06

29 - 3.7 Understand implicit intersection.mp4

04:38

30 - 3.8 Apply concepts for a data analysis solution.mp4

11:40

31 - Learning objectives.mp4

02:23

32 - 4.1 Design complex Excel models.mp4

01:56

33 - 4.2 Author formulas for complex models.mp4

09:13

34 - 4.3 Implement and maintain data integrity.mp4

17:42

35 - 4.4 Create a reusable data quality dashboard.mp4

37:09

36 - 4.5 Design a Budget and Forecast model.mp4

15:40

37 - 4.6 Identify required data structures and functions.mp4

10:32

38 - 4.7 Populate data within the model.mp4

25:20

39 - 4.8 Highlight results and data insights.mp4

15:36

40 - Learning objectives.mp4

01:26

41 - 5.1 Create and understand basic PivotTables.mp4

10:53

42 - 5.2 Interact with a PivotTable.mp4

05:25

43 - 5.3 Understand layout options.mp4

06:05

44 - 5.4 Format PivotTables.mp4

11:07

45 - 5.5 Use PivotTable commands.mp4

08:29

46 - 5.6 Filter and sort data in a PivotTable.mp4

15:48

47 - 5.7 Review chart types.mp4

02:55

48 - 5.8 Create PivotCharts.mp4

16:35

49 - 5.9 Format PivotCharts.mp4

09:30

50 - 5.10 Create an interactive dashboard.mp4

07:31

51 - Learning objectives.mp4

01:13

52 - 6.1 Inspect a document for issues.mp4

05:46

53 - 6.2 Check for accessibility and compatibility.mp4

08:42

54 - 6.3 Use collaboration and distribution features.mp4

13:21

55 - 6.4 Protect sheet contents and workbook structure.mp4

13:36

56 - 6.5 Setup a printable package.mp4

08:34

57 - Data Analysis Fundamentals with Excel - Summary.mp4

01:15

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Pearson's video training library is an indispensable learning tool for today's competitive job market. Having essential technology training and certifications can open doors for career advancement and life enrichment. We take learning personally. We've published hundreds of up-to-date videos on wide variety of key topics for Professionals and IT Certification candidates. Now you can learn from renowned industry experts from anywhere in the world, without leaving home.