MO-210 Microsoft Excel Certification (Microsoft 365 Apps)

109

LESSONS

ALL

SKILL LEVEL

8:24 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

This course takes you through the skills required for the new Microsoft Excel MO-210 exam.

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

Regular quizzes, practise activities and a practise test support your learning and help you build confidence.

WHO IS THE COURSE FOR?

This course is for anybody who wants to develop Microsoft Excel skills. No prior knowledge is required.

This course covers the skills requirements for the official Microsoft certification MO-210.

This course will use Excel 2022, but is also accessible with any modern version – Excel 2007, 2010, 2013, 2016 or 2019.

This course is NOT for you if you want to learn Excel for Mac.

LEARNING PATH

IMPORT DATA AND NAVIGATE

  • Text and cursor.
  • Formatting cells.
  • Cut, copy and paste, and saving text.
  • Importing and searching data.
  • Hyperlinks.

WORKSHEETS AND WORKBOOKS

  • Window views and zoom.
  • Page and margins setup.
  • Headers and footers.
  • Print area.
  • Format rows and columns.
  • Grouping.

OPTIONS AND VIEWS

  • Quick Access toolbar.
  • Different views.
  • Freeze rows and columns.
  • Modify basic properties.

COLLABORATION

  • Alternative file formats.
  • Manage comments and notes.
  • Configure print settings.
  • Inspect workbooks for issues.

MANIPULATE DATA IN WORKSHEETS

  • Paste data by using special paste options.
  • Fill cells by using Auto Fill.
  • Insert and delete multiple columns or rows.
  • Insert and delete cells.

CELLS AND RANGES

  • Format cells by using Format Painter.
  • Wrap text within cells.
  • Modify cell alignment, orientation, and indentation.
  • Merge and unmerge cells.
  • Apply number and cell formats.
  • Apply cell styles.

SUMMARISE DATA VISUALLY

  • Apply and remove conditional formatting.

CREATE AND FORMAT TABLES

  • Create Excel tables from cell ranges & back, and name a table.
  • Add or remove table rows and columns.
  • Apply table styles and configure table style options.
  • Insert and configure total rows.

FILTER AND SORT TABLE DATA

  • Filter records.
  • Sort data.

CREATING FORMULAS

  • Using basic operators.
  • Order of operations.
  • Referencing cell ranges in formulas.
  • Insert relative, absolute, and mixed references & display formulas.

CALCULATE AND TRANSFORM DATA

  • Perform calculations by using the AVERAGE(), MAX(), MIN(), SUM() functions.
  • Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions.
  • Perform conditional operations by using the IF() function.

DEFINE AND REFERENCE

  • Define a named range and reference named ranges in formulas.
  • Reference named tables in formulas.
  • Navigate to named cells.

FORMAT AND MODIFY TEXT

  • Format text by using RIGHT(), LEFT(), and MID() functions.
  • Format text by using UPPER(), LOWER(), and LEN() functions.
  • Format text by using the CONCAT and TEXTJOIN functions.
  • Sort data and get unique values by using the SORT and UNIQUE functions.
  • Generate numeric data by using RANDBETWEEN() and SEQUENCE().

CREATE AND MODIFY CHARTS

  • Create charts, create chart sheets, and moving charts.
  • The most commonly-used chart types.
  • Add data series to charts.
  • Switch between rows and columns in source data.

FORMAT CHARTS & CREATE SPARKLINES

  • Add and modify chart elements.
  • Apply chart layouts and styles, and add alternative text.
  • Insert Sparklines.

READY TO START?