Mo-210: Microsoft Excel (Microsoft 365 Apps)

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.

Requirements

Before beginning, you will need to know how to use a Windows computer, including a mouse.

It would be good if you have used Microsoft Excel before, but this is not essential.

You should have MS Excel (or Office) from 2022 or later installed on your PC computer. This program is also known as a Microsoft 365 App.

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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 How to get the best out of your Udemy course

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 Curriculum

Lecture 6 Resources

Section 2: Import data into workbooks and Navigate within workbooks

Lecture 7 Microsoft Excel - a quick tour

Lecture 8 Inserting text and moving the cursor

Lecture 9 Formatting cells

Lecture 10 Cut, copy and paste, and saving text

Lecture 11 1. Import data from text files (.txt and .csv files)

Lecture 12 2. Import data from online sources

Lecture 13 3. Search for data within a workbook

Lecture 14 5. Insert and remove hyperlinks

Lecture 15 Practice Activity Number 1

Lecture 16 Practice Activity Number 1 - The Solution

Section 3: Format worksheets and workbooks

Lecture 17 9, 13. Change window views and using zoom

Lecture 18 6. Modify page setup

Lecture 19 6. Modify margins setup

Lecture 20 8. Customize headers and footers - text

Lecture 21 8. Customize headers and footers - pictures

Lecture 22 16. Set a print area

Lecture 23 7. Adjust row height and column width

Lecture 24 34. Select multiple items and format multiple worksheets by grouping

Lecture 25 Practice Activity Number 2

Lecture 26 Practice Activity Number 2 - The Solution

Section 4: Customize options and views

Lecture 27 10. Customize the Quick Access toolbar

Lecture 28 9, 11. Display and modify workbook content in different views

Lecture 29 12. Freeze worksheet rows and columns

Lecture 30 14. Modify basic workbook properties

Section 5: Configure content for collaboration

Lecture 31 17. Save workbooks in alternative file formats

Lecture 32 20. Manage comments and notes

Lecture 33 18. Configure print settings

Lecture 34 19. Inspect workbooks for issues

Lecture 35 Practice Activity Number 3

Lecture 36 Practice Activity Number 3 - The Solution

Section 6: Manipulate data in worksheets

Lecture 37 21. Paste data by using special paste options

Lecture 38 22. Fill cells by using Auto Fill

Lecture 39 23. Insert and delete multiple columns or rows

Lecture 40 24. Insert and delete cells

Lecture 41 Practice Activity Number 4

Lecture 42 Practice Activity Number 4 - The Solution

Section 7: Format cells and ranges

Lecture 43 28. Format cells by using Format Painter

Lecture 44 29. Wrap text within cells

Lecture 45 27. Modify cell alignment, orientation, and indentation

Lecture 46 26. Merge and unmerge cells

Lecture 47 30. Apply number formats - commonly used number formats

Lecture 48 30. Apply number formats - less-commonly used number formats

Lecture 49 31, 33. Apply cell formats from the Format Cells dialog box, clear formatting

Lecture 50 32. Apply cell styles

Lecture 51 Practice Activity Number 5

Lecture 52 Practice Activity Number 5 - The Solution

Section 8: Summarize data visually

Lecture 53 38. Applying conditional formatting - highlighting

Lecture 54 38, 39. Applying and removing conditional formatting - top/bottom

Lecture 55 38, 39. Applying and removing conditional formatting - Bars, Scales and Sets

Lecture 56 Practice Activity Number 6

Lecture 57 Practice Activity Number 6 - The Solution

Section 9: Create and format tables

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

Lecture 59 43. Add or remove table rows and columns

Lecture 60 41, 44. Apply table styles and configure table style options

Lecture 61 45. Insert and configure total rows

Lecture 62 Practice Activity Number 7

Lecture 63 Practice Activity Number 7 - The Solution

Section 10: Filter and sort table data

Lecture 64 46. Filter records - numbers

Lecture 65 46. Filter records - text

Lecture 66 46. Filter records - dates, and setting up your own filter

Lecture 67 47. Sort data by multiple columns

Lecture 68 Practice Activity Number 8

Lecture 69 Practice Activity Number 8 - The Solution

Section 11: Creating formulas

Lecture 70 Using basic operators

Lecture 71 Order of operations

Lecture 72 Referencing cell ranges in formulas and Practice Activity Number 9

Lecture 73 Practice Activity Number 9 - The Solution

Lecture 74 15, 48. Insert relative, absolute, and mixed references & display formulas

Lecture 75 Practice Activity Number 10

Lecture 76 Practice Activity Number 10 - The Solution

Section 12: Calculate and transform data

Lecture 77 50. Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions

Lecture 78 50. More about the SUM() function

Lecture 79 51. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions

Lecture 80 52. Perform conditional operations by using the IF() function

Lecture 81 52. More conditional operations using the IF() function

Lecture 82 Practice Activity Number 11

Lecture 83 Practice Activity Number 11 - The Solution

Section 13: Define and reference named ranges

Lecture 84 35, 36. Define a named range and reference named ranges in formulas

Lecture 85 49. Reference named tables in formulas

Lecture 86 4. Navigate to named cells - Reminder

Lecture 87 Practice Activity Number 12

Lecture 88 Practice Activity Number 12 - The Solution

Section 14: Format and modify text, and other formulas

Lecture 89 55. Format text by using RIGHT(), LEFT(), and MID() functions

Lecture 90 56. Format text by using UPPER(), LOWER(), and LEN() functions

Lecture 91 57. Format text by using the CONCAT and TEXTJOIN functions

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

Lecture 93 25. Generate numeric data by using RANDBETWEEN() and SEQUENCE()

Lecture 94 Practice Activity Number 13

Lecture 95 Practice Activity Number 13 - The Solution

Section 15: Create and modify charts

Lecture 96 58, 59. Create charts, create chart sheets, and moving charts

Lecture 97 58, 59. The most commonly-used chart types

Lecture 98 60. Add data series to charts

Lecture 99 61. Switch between rows and columns in source data

Lecture 100 Practice Activity Number 14

Lecture 101 Practice Activity Number 14 - The Solution

Section 16: Format charts and create sparklines

Lecture 102 62. Add chart elements

Lecture 103 62. Modifying chart elements

Lecture 104 63, 64, 65. Apply chart layouts and styles, and add alternative text

Lecture 105 37. Insert Sparklines

Lecture 106 Practice Activity Number 15

Lecture 107 Practice Activity Number 15 - The Solution

Section 17: Well done for finishing the Excel course

Lecture 108 What's Next?

Lecture 109 Congratulations for finishing the Excel course

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.