Practical Ms Excel | Ms Excel 2016, 2019, 365/2023

Road Trip To Paris | Practical | Compatible with MS 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.

Requirements

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

Description

MS Excel Professional | MS Excel 2016, 2019, 365/2023: Road Trip From Holland To ParisBeing 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.

Overview

Section 1: STRUCTURE DATA

Lecture 1 WELCOME TO THIS MS EXCEL COURSE

Lecture 2 QUESTIONS

Lecture 3 HARLINGEN START

Lecture 4 APPEARANCE OF DATA FILE IN MS EXCEL

Lecture 5 BASIC REFERENCES IN MS EXCEL PART 1

Lecture 6 BASIC REFERENCES IN MS EXCEL PART 2

Lecture 7 RELATIVE & ABSOLUTE REFERENCING IN MS EXCEL

Lecture 8 CONDITIONAL FORMATTING IN MS EXCEL

Lecture 9 ADDING, REMOVING AND HIDING CELLS IN MS EXCEL

Lecture 10 EXERCISE 1-1

Lecture 11 SOLUTION EXERCISE 1-1

Lecture 12 CANCEL OPERATION AND SHORTCUTS IN MS EXCEL

Lecture 13 DATA VALIDATION IN MS EXCEL

Lecture 14 FIND AND REPLACE IN MS EXCEL

Lecture 15 FREEZE PANE IN MS EXCEL

Lecture 16 PATTERN RECOGNITION IN MS EXCEL

Lecture 17 PROTECTING DATA IN MS EXCEL

Lecture 18 SHEETS IN MS EXCEL

Lecture 19 SORT & FILTER IN MS EXCEL

Lecture 20 EXERCISE 1-2

Lecture 21 SOLUTION EXERCISE 1-2

Lecture 22 SECTION 1 CONCLUSION

Section 2: FUNCTIONS

Lecture 23 AMSTERDAM START

Lecture 24 LANGUAGE OF FUNCTIONS

Lecture 25 SUM, AVERAGE, MIN, MAX FUNCTION IN MS EXCEL

Lecture 26 SUMIF FUNCTION IN MS EXCEL

Lecture 27 COUNT FUNCTION IN MS EXCEL

Lecture 28 MACHINE ROMANCE

Lecture 29 EXERCISE 2-1

Lecture 30 SOLUTION EXERCISE 2-1

Lecture 31 AND FUNCTION IN MS EXCEL

Lecture 32 IF FUNCTION IN MS EXCEL

Lecture 33 NESTED IF FUNCTION IN MS EXCEL

Lecture 34 EXERCISE 2-2

Lecture 35 SOLUTION EXERCISE 2-2

Lecture 36 LEAVING AMSTERDAM

Section 3: VISUALIZING DATA

Lecture 37 ARRIVING IN WATERLOO

Lecture 38 CHOOSING RIGHT TYPE OF CHART IN MS EXCEL

Lecture 39 BAR CHART IN MS EXCEL

Lecture 40 PIE CHART IN MS EXCEL

Lecture 41 LINE CHART IN MS EXCEL

Lecture 42 MULTIPLE LINE CHART IN MS EXCEL

Lecture 43 SECONDARY AXIS IN MS EXCEL

Lecture 44 LOGARITHMIC SCALE IN MS EXCEL

Lecture 45 SCATTERPLOT IN MS EXCEL

Lecture 46 ARRIVING AT ATOMIUM

Lecture 47 EXERCISE 3-1

Lecture 48 SOLUTION EXERCISE 3-1

Lecture 49 PARETO CHART IN MS EXCEL

Lecture 50 EXERCISE 3-2

Lecture 51 SOLUTION 3-2

Lecture 52 BOXPLOTS THEORY

Lecture 53 BOXPLOTS IN MS EXCEL

Lecture 54 EXERCISE 3-3

Lecture 55 LEAVING WATERLOO

Section 4: ANALYZING DATA

Lecture 56 ARRIVING IN PARIS

Lecture 57 PIVOT TABLES IN MS EXCEL

Lecture 58 EXERCISE 4-1

Lecture 59 PIVOT CHARTS IN MS EXCEL

Lecture 60 EXERCISE 4-2

Lecture 61 GOAL SEEK IN MS EXCEL

Lecture 62 EXERCISE 4-3

Lecture 63 SOLVER IN MS EXCEL

Lecture 64 EXERCISE 4-4

Lecture 65 IMPORTANT INSTRUCTIONS

Lecture 66 THEORY CORRELATION

Lecture 67 THEORY SINGLE OLS REGRESSION

Lecture 68 SINGLE OLS REGRESSION IN MS EXCEL

Lecture 69 EXERCISE: 4-5

Lecture 70 SOLUTION EXERCISE 4-5: SINGLE OLS REGRESSION

Section 5: FINALE

Lecture 71 BONUS LECTURE

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