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

Practical Ms Excel | Ms Excel 2016, 2019, 365/2023 - Printable Version

+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Practical Ms Excel | Ms Excel 2016, 2019, 365/2023 (/Thread-Practical-Ms-Excel-Ms-Excel-2016-2019-365-2023--144548)

Practical Ms Excel | Ms Excel 2016, 2019, 365/2023 - BaDshaH - 08-25-2023

[Image: dba5bbdb38c246a80e69643b7aa0c41e.jpg]

Published 8/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.64 GB | Duration: 5h 19m

Road Trip To Paris | Practical | Compatible with MS Excel 2016, 2019, 365 | MS Excel Beginner To Advanced

[b]What you'll learn[/b]
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.

[b]Requirements[/b]
You preferably have access to Excel (version is not that important).

[b]Description[/b]
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 Confused

tructure 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.

Homepage