MO-210: Microsoft Excel (from beginner to intermediate)

Focused View

Phillip Burton

8:16:32

89 View

1. Introduction

1. Introduction.mp4

02:29

2. Welcome to Udemy.html

3. How to get the best out of your Udemy course.mp4

02:00

4. Do you want auto-translated subtitles in more languages.html

5. Curriculum.mp4

05:08

6.1 CSVFile.csv

6.2 fixedwidthfile.zip

6.3 MO-210ExamRequirements230124.pdf

6.4 Section 2 Start.xlsx

6.5 textdelimitedfile.zip

6.6 textfile.zip

6. Resources.html

2. Import data into workbooks and Navigate within workbooks

1.1 Section 2 Start.xlsx

1. Microsoft Excel - a quick tour.mp4

06:36

2. Inserting text and moving the cursor.mp4

08:16

3. Formatting cells.mp4

03:02

4. Cut, copy and paste, and saving text.mp4

06:05

5.1 CSVFile.csv

5.2 fixedwidthfile.zip

5.3 textdelimitedfile.zip

5.4 textfile.zip

5. 1. Import data from text files (.txt and .csv files).mp4

11:06

6.1 Link.txt

6. 2. Import data from online sources.mp4

05:17

7.1 Section 2 Start.xlsx

7. 3. Search for data within a workbook.mp4

05:03

8. 5. Insert and remove hyperlinks.mp4

07:25

9. Import data into workbooks and Navigate within workbooks.html

10.1 practiceactivity1.zip

10. Practice Activity Number 1.html

11. Practice Activity Number 1 - The Solution.mp4

05:48

3. Format worksheets and workbooks

1.1 Section 3 Start.xlsx

1. 9, 13. Change window views and using zoom.mp4

05:32

2. 6. Modify page setup.mp4

06:59

3. 6. Modify margins setup.mp4

04:14

4. 8. Customize headers and footers - text.mp4

06:07

5. 8. Customize headers and footers - pictures.mp4

05:39

6. 16. Set a print area.mp4

04:55

7. 7. Adjust row height and column width.mp4

07:27

8. 34. Select multiple items and format multiple worksheets by grouping.mp4

08:05

9. Format worksheets and workbooks.html

10.1 PracticeActivity02.xlsx

10. Practice Activity Number 2.html

11. Practice Activity Number 2 - The Solution.mp4

04:09

4. Customize options and views

1.1 Section 4 Start.xlsx

1. 10. Customize the Quick Access toolbar.mp4

04:24

2. 9, 11. Display and modify workbook content in different views.mp4

04:28

3. 12. Freeze worksheet rows and columns.mp4

07:09

4. 14. Modify basic workbook properties.mp4

03:06

5. Customize options and views.html

5. Configure content for collaboration

1.1 Section 5 Start.xlsx

1. 17. Save workbooks in alternative file formats.mp4

05:55

2. 20. Manage comments and notes.mp4

04:59

3. 18. Configure print settings.mp4

06:17

4. 19. Inspect workbooks for issues.mp4

05:17

5. Configure content for collaboration.html

6.1 PracticeActivity03.xlsx

6. Practice Activity Number 3.html

7. Practice Activity Number 3 - The Solution.mp4

03:53

6. Manipulate data in worksheets

1.1 Section 6 Start.xlsx

1. 21. Paste data by using special paste options.mp4

05:14

2. 22. Fill cells by using Auto Fill.mp4

05:18

3. 23. Insert and delete multiple columns or rows.mp4

04:43

4. 24. Insert and delete cells.mp4

03:42

5. Manipulate data in worksheets.html

6.1 PracticeActivity04.xlsx

6. Practice Activity Number 4.html

7. Practice Activity Number 4 - The Solution.mp4

03:39

7. Format cells and ranges

1.1 Section 7 Start.xlsx

1. 28. Format cells by using Format Painter.mp4

02:39

2. 29. Wrap text within cells.mp4

04:12

3. 27. Modify cell alignment, orientation, and indentation.mp4

08:32

4. 26. Merge and unmerge cells.mp4

04:36

5. 30. Apply number formats - commonly used number formats.mp4

05:58

6. 30. Apply number formats - less-commonly used number formats.mp4

05:14

7. 31, 33. Apply cell formats from the Format Cells dialog box, clear formatting.mp4

08:42

8. 32. Apply cell styles.mp4

02:57

9. Format cells and ranges.html

10.1 PracticeActivity05.xlsx

10. Practice Activity Number 5.html

11.1 PracticeActivity05.xlsx

11. Practice Activity Number 5 - The Solution.mp4

04:45

8. Summarize data visually

1.1 Section 8 Start.xlsx

1. 38. Applying conditional formatting - highlighting.mp4

05:30

2. 38, 39. Applying and removing conditional formatting - topbottom.mp4

04:39

3. 38, 39. Applying and removing conditional formatting - Bars, Scales and Sets.mp4

04:49

4. Summarize data visually.html

5.1 PracticeActivity06.xlsx

5. Practice Activity Number 6.html

6. Practice Activity Number 6 - The Solution.mp4

02:59

9. Create and format tables

1.1 Section 9 Start.xlsx

1. 40, 42. Create Excel tables from cell ranges & back, and name a table.mp4

05:21

2. 43. Add or remove table rows and columns.mp4

05:36

3. 41, 44. Apply table styles and configure table style options.mp4

03:38

4. 45. Insert and configure total rows.mp4

04:21

5. Create and format tables.html

6.1 PracticeActivity07.xlsx

6. Practice Activity Number 7.html

7. Practice Activity Number 7 - The Solution.mp4

03:10

10. Filter and sort table data

1.1 Section 10 Start.xlsx

1. 46. Filter records - numbers.mp4

09:48

2. 46. Filter records - text.mp4

05:33

3. 46. Filter records - dates, and setting up your own filter.mp4

05:01

4. 47. Sort data by multiple columns.mp4

07:14

5. Filter and sort table data.html

6.1 Section 10 Start.xlsx

6. Practice Activity Number 8.html

7. Practice Activity Number 8 - The Solution.mp4

04:16

11. Creating formulas

1.1 Section 11 Start.xlsx

1. Using basic operators.mp4

07:10

2. Order of operations.mp4

03:40

3.1 PracticeActivity09.xlsx

3. Referencing cell ranges in formulas and Practice Activity Number 9.mp4

06:21

4.1 PracticeActivity09.xlsx

4. Practice Activity Number 9 - The Solution.mp4

02:48

5. 15, 48. Insert relative, absolute, and mixed references & display formulas.mp4

08:33

6. Creating formulas.html

7.1 PracticeActivity10.xlsx

7. Practice Activity Number 10.mp4

02:41

8. Practice Activity Number 10 - The Solution.mp4

04:23

12. Calculate and transform data

1.1 Section 12 Start.xlsx

1. 50. Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions.mp4

04:35

2. 50. More about the SUM() function.mp4

05:32

3. 51. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions.mp4

05:40

4. 52. Perform conditional operations by using the IF() function.mp4

07:23

5. 52. More conditional operations using the IF() function.mp4

08:04

6. Calculate and transform data.html

7.1 PracticeActivity11.xlsx

7. Practice Activity Number 11.html

8. Practice Activity Number 11 - The Solution.mp4

05:21

13. Define and reference named ranges

1.1 Section 13 Start.xlsx

1. 35, 36. Define a named range and reference named ranges in formulas.mp4

08:19

2. 49. Reference named tables in formulas.mp4

07:25

3. 4. Navigate to named cells - Reminder.mp4

03:16

4. Define and reference named ranges.html

5.1 PracticeActivity12.xlsx

5. Practice Activity Number 12.html

6. Practice Activity Number 12 - The Solution.mp4

04:54

14. Format and modify text, and other formulas

1.1 Section 14 Start.xlsx

1. 55. Format text by using RIGHT(), LEFT(), and MID() functions.mp4

05:03

2. 56. Format text by using UPPER(), LOWER(), and LEN() functions.mp4

08:04

3. 57. Format text by using the CONCAT and TEXTJOIN functions.mp4

05:09

4. 53, 54. Sort data and get unique values by using the SORT and UNIQUE functions.mp4

05:12

5. 25. Generate numeric data by using RANDBETWEEN() and SEQUENCE().mp4

03:37

6. Format and modify text, and other formulas.html

7.1 PracticeActivity13.xlsx

7. Practice Activity Number 13.html

8. Practice Activity Number 13 - The Solution.mp4

05:25

15. Create and modify charts

1.1 Section 15 Start.xlsx

1. 58, 59. Create charts, create chart sheets, and moving charts.mp4

06:08

2. 58, 59. The most commonly-used chart types.mp4

03:32

3. 60. Add data series to charts.mp4

07:22

4. 61. Switch between rows and columns in source data.mp4

02:29

5. Create and modify charts.html

6. Practice Activity Number 14.html

7. Practice Activity Number 14 - The Solution.mp4

02:46

16. Format charts and create sparklines

1. 62. Add chart elements.mp4

04:57

2. 62. Modifying chart elements.mp4

08:14

3. 63, 64, 65. Apply chart layouts and styles, and add alternative text.mp4

08:02

4. 37. Insert Sparklines.mp4

06:57

5. Format charts and create sparklines.html

6. Practice Activity Number 15.html

7. Practice Activity Number 15 - The Solution.mp4

05:03

17. Well done for finishing the Excel course

1. Whats Next.mp4

02:28

2. Excel Practice Test.html

3. Congratulations for finishing the Excel course.mp4

01:03

Description

Learn the skills for the new MO-210 Excel certification. Create tables, formulas, charts and manage workbooks.

What You'll Learn?

Create, configure and save Excel worksheets and workbooks.
Navigate through and format worksheets and workbooks.
Customise options and views for worksheets and workbooks.
Configure Excel worksheets and workbooks to print (e.g. page setup).
Insert data into and format cells and ranges, and create and modify tables.
Highlight, filter, sort and group cells, ranges and tables.
Create and format Excel charts.
Create formulas in Excel, including using conditional logic and modifying text.

Who is this for?

This course is for you if you want to develop your Microsoft Excel skills.

This course will use the latest version of Excel, but is also for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 2019.

This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.

You will cover the content tested in Microsoft Office Specialist Exams MO-210 (for Excel 2022 and later)

This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

More details

Description
The MO-210 certification is the new certification for Excel. Microsoft says that this certification demonstrates that you have the skills needed to get the most out of Excel by earning a Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.
This course has been created using Udemy's Accessibility guidelines.
In this MO-210 course:
Weâ€™ll start with create and manage worksheets and workbooks. Weâ€™ll import data into workbooks, navigate and format workbooks, and prepare them for collaboration and distribution.
Weâ€™ll then look at managing data cells and ranges and create tables. Weâ€™ll insert data into and format workbooks, summarise and organize data, manage table styles and options, and filter and sort table data.
Weâ€™ll then perform operations with Excel formulas and functions. Weâ€™ll use functions for summarising data, performing conditional operations, formatting and modifying text, sorting and generating numeric data.
Finally, weâ€™ll look at creating charts and sparklines. Weâ€™ll use different chart types, such as line, bar, area and pie charts, weâ€™ll add legends and apply layouts and styles, and insert sparklines.
No prior knowledge is required. And there are 15 Practice Activities, 15 quizzes and a Practice Test to help you remember the information, so you can be sure that you are learning.
Once you have completed this course, you will have an expanded knowledge of Microsoft Excel. With some practice, you could even take the official Microsoft MO-210 exam, which gives you the "Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)" certificate. This would look good on your CV or resume.
It is also the first stage to you getting the "Microsoft Office Specialist: Associate (Microsoft 365 Apps)" certification.
Who this course is for:
This course is for you if you want to develop your Microsoft Excel skills.
This course will use the latest version of Excel, but is also for you if you use any modern version - Excel 2007, 2010, 2013, 2016 or 2019.
This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
You will cover the content tested in Microsoft Office Specialist Exams MO-210 (for Excel 2022 and later)
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Phillip Burton

Instructor's Courses

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

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.