Microsoft Excel Beginner to Advanced

Focused View

Six Sigma Academy Amsterdam

5:17:43

42 View

1 - STRUCTURE DATA

1 - WELCOME TO THIS MS EXCEL COURSE.mp4

01:17

2 - QUESTIONS.html

3 - HARLINGEN START.mp4

02:37

3 - Kim-restaurant-Copy.xlsx

4 - APPEARANCE OF DATA FILE IN MS EXCEL.mp4

06:00

5 - BASIC REFERENCES IN MS EXCEL PART 1.mp4

04:33

6 - BASIC REFERENCES IN MS EXCEL PART 2.mp4

03:22

7 - RELATIVE ABSOLUTE REFERENCING IN MS EXCEL.mp4

07:55

8 - CONDITIONAL FORMATTING IN MS EXCEL.mp4

03:43

9 - ADDING REMOVING AND HIDING CELLS IN MS EXCEL.mp4

03:17

10 - EXERCISE 11.mp4

05:19

10 - FISH-AND-SHRIMP-RESTAURANT-Copy.xlsx

11 - SOLUTION EXERCISE 11.mp4

03:50

12 - CANCEL OPERATION AND SHORTCUTS IN MS EXCEL.mp4

05:11

12 - EXCEL-SHORTCUT-KEYS-Copy.pdf

13 - DATA VALIDATION IN MS EXCEL.mp4

06:27

14 - FIND AND REPLACE IN MS EXCEL.mp4

02:24

15 - FREEZE PANE IN MS EXCEL.mp4

03:13

16 - PATTERN RECOGNITION IN MS EXCEL.mp4

01:51

17 - PROTECTING DATA IN MS EXCEL.mp4

03:44

18 - SHEETS IN MS EXCEL.mp4

06:34

19 - SORT FILTER IN MS EXCEL.mp4

04:29

20 - EXERCISE 12.mp4

04:20

20 - FISH-AND-SHRIMP-RESTAURANT-Copy.xlsx

21 - SOLUTION EXERCISE 12.mp4

06:42

22 - SECTION 1 CONCLUSION.mp4

01:07

2 - FUNCTIONS

23 - AMSTERDAM START.mp4

03:08

23 - AMSTERDAM-BRIDGE-Copy.xlsx

24 - LANGUAGE OF FUNCTIONS.mp4

04:55

25 - SUM AVERAGE MIN MAX FUNCTION IN MS EXCEL.mp4

05:06

26 - SUMIF FUNCTION IN MS EXCEL.mp4

03:37

27 - COUNT FUNCTION IN MS EXCEL.mp4

02:54

28 - MACHINE ROMANCE.mp4

01:52

28 - PLANE-MANUFACTURER-Copy.xlsx

29 - EXERCISE 21.mp4

02:57

29 - PLANE-MANUFACTURER-Copy.xlsx

30 - SOLUTION EXERCISE 21.mp4

05:42

31 - AND FUNCTION IN MS EXCEL.mp4

03:12

32 - IF FUNCTION IN MS EXCEL.mp4

04:51

33 - NESTED IF FUNCTION IN MS EXCEL.mp4

08:38

34 - EXERCISE 22.mp4

03:07

34 - PLANE-MANUFACTURER-Copy.xlsx

35 - SOLUTION EXERCISE 22.mp4

09:13

36 - LEAVING AMSTERDAM.mp4

01:43

3 - VISUALIZING DATA

37 - ARRIVING IN WATERLOO.mp4

02:24

37 - MR-FARMER-Copy.xlsx

38 - CHOOSING RIGHT TYPE OF CHART IN MS EXCEL.mp4

08:44

39 - BAR CHART IN MS EXCEL.mp4

04:39

40 - PIE CHART IN MS EXCEL.mp4

03:12

41 - LINE CHART IN MS EXCEL.mp4

04:59

42 - MULTIPLE LINE CHART IN MS EXCEL.mp4

03:22

43 - SECONDARY AXIS IN MS EXCEL.mp4

03:54

44 - EXTRA-EXPLANATION-LOGARITHMIC-SCALES-kopie.pdf

44 - LOGARITHMIC SCALE IN MS EXCEL.mp4

07:22

45 - SCATTERPLOT IN MS EXCEL.mp4

03:24

46 - ARRIVING AT ATOMIUM.mp4

02:32

47 - ATOMIUM-Copy.xlsx

47 - EXERCISE 31.mp4

01:45

48 - SOLUTION EXERCISE 31.mp4

06:59

49 - PARETO CHART IN MS EXCEL.mp4

03:59

50 - ATOMIUM-Copy.xlsx

50 - EXERCISE 32.mp4

04:19

51 - SOLUTION 32.mp4

06:24

52 - BOXPLOTS THEORY.mp4

07:13

53 - BOXPLOTS IN MS EXCEL.mp4

06:59

54 - ATOMIUM-Copy.xlsx

54 - EXERCISE 33.mp4

04:41

55 - LEAVING WATERLOO.mp4

01:47

4 - ANALYZING DATA

56 - ARRIVING IN PARIS.mp4

03:15

56 - NAPOLEON-APPARTMENT-Copy.xlsx

57 - PIVOT TABLES IN MS EXCEL.mp4

07:44

58 - EXERCISE 41.mp4

03:49

58 - NAPOLEON-APPARTMENT-Copy.xlsx

59 - PIVOT CHARTS IN MS EXCEL.mp4

05:23

60 - EXERCISE 42.mp4

03:09

60 - NAPOLEON-APPARTMENT-Copy.xlsx

61 - GOAL SEEK IN MS EXCEL.mp4

03:56

62 - EXERCISE 43.mp4

05:13

62 - NAPOLEON-APPARTMENT-Copy.xlsx

63 - SOLVER IN MS EXCEL.mp4

07:49

63 - SOLVER-Copy.xlsx

64 - EXERCISE 44.mp4

04:11

64 - SOLVER-Copy.xlsx

65 - IMPORTANT INSTRUCTIONS.html

66 - THEORY CORRELATION.mp4

09:27

67 - THEORY SINGLE OLS REGRESSION.mp4

09:29

68 - SINGLE OLS REGRESSION IN MS EXCEL.mp4

07:47

69 - EXERCISE 45.mp4

01:06

69 - NAPOLEON-APPARTMENT-Copy.xlsx

70 - SOLUTION EXERCISE 45 SINGLE OLS REGRESSION.mp4

07:57

5 - FINALE

71 - BONUS LECTURE.html

Description

Microsoft Excel In Practice | Compatible with Microsoft Excel 2016, 2019, 365 | MS Excel Beginner To Advanced

What You'll Learn?

Learn real life MS Excel skills that actually matter in practice!
Structure and analyze data, find patterns and visualize data.
Use Excel functions and save time.
Predict future demand, sales, needed resources etc.

Who is this for?

If you work with data and need to structure, analyze and visualize it, this course is for you.

What You Need to Know?

You preferably have access to Excel (version is not that important).

More details

Description
Microsoft Excel Beginner to Advanced (Compatible with Microsoft Excel versions 2016, 2019, 2021, 365/2023)
Being able to to work with MS Excel is considered to be a very important skill in today's data driven economy. But how much MS Excel skills is enough and how much MS Excel skills is too much? While you want to learn the needed Ms Excel skills for the labor market, you might not want to write a book about Microsoft Excel. What we have done is to create a Microsoft Excel course for you based on our research and experience. This Ms Excel course will very efficiently show you the important MS Excel skills that you are supposed to have to function in practice, in a bank, a hospital, a school, a factory etc.

We teach you to:
structure data with MS Excel and get overview.
analyze data with MS Excel functions and save time.
visualize data with MS Excel and better understand relationships and trends.
predict future developments with MS Excel.
We, as seasoned lecturers, have come to the conclusion that students learn more effectively when the content is being delivered in an engaging way. This whole course is set up as a road trip from the North of Holland all the way To Paris, France. Along the way, we will have stops. Each stop will provide us with a context for our MS Excel videos. So, you will learn about Microsoft Excel and a little bit about the history and culture of Europe, well at least the part of Europe between Holland and France ; )

Note: The version of Excel you use is (as long as it is not be older than 2016) not important if you want to keep up, but for the sake of formality please know that we are using Excel 365 as of 2023 which is the most up to date version as of 2023.

Who this course is for:
If you work with data and need to structure, analyze and visualize it, this course is for you.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Six Sigma Academy Amsterdam

Instructor's Courses

Six Sigma Academy Amsterdam started when a number of university lecturers from the Netherlands decided to make expensive Lean Six Sigma education more affordable, practical, time efficient and entertaining. Yes, education should not be punishment. It should be fun too. Education should not waste your time with knowledge that is only useful in an exam. It should make you better in practice.All course developers and lecturers involved are Six Sigma Master Black Belts and as such able to train students and future instructors. All the Lean Six Sigma programs we offer are accredited based on the Dutch BKO standards and our student experience shows that the degrees are globally accepted and respected.We have trained and certified more 100,000+ students in the Netherlands, Germany, US, India and UAE, both online and offline. Furthermore, our course designers have supervised projects for companies like Audi, the Dutch military and Lufthansa.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.