There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Udemy Get MOS Excel Associate Certification MO-200 from Microsoft

Video Introducing this tutorial

About the MOS Excel Certification and this course :
About the MOS Excel Certification and this course

Introduction :
Review useful Excel shortcuts

Manage Worksheets - Import Data into Workbooks :
Import data from .txt files
Import data from .csv files

Manage Worksheets - Navigate within Workbooks :
Search for data within a workbook
Navigate to named cells, ranges, or workbook elements
Insert and remove hyperlinks

Manage Worksheets - Format Worksheets and Workbooks :
Modify page setup
Adjust Row Height and Column Width
Customize headers and footers

Manage Worksheets - Customize options and views :
Customize the Quick Access toolbar
Display and Modify Workbook Content in Different Views
Freeze worksheet rows and columns
Change window views
Modify basic workbook properties
Display formulas

Manage Worksheets - Configure content for collaboration :
Set a print area
Save workbooks in alternative file formats
Configure print settings
Inspect workbooks for issues

Manage data cells and ranges - 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

Manage data cells and ranges - Format cells and ranges :
Merge and unmerge cells
Modify cell alignment, orientation, and indentation
Format cells by using Format Painter
Wrap text within cells
Apply number formats
Apply cell formats from the Format Cells dialog box
Apply cell styles
Clear cell formatting

Manage data cells and ranges - Define and reference named ranges :
Define a named range
Name a table

Manage data cells and ranges - Summarize data visually :
Insert Sparklines
Apply built-in conditional formatting
Remove conditional formatting

Manage tables and table data - Create and format tables :
Create Excel tables from Cell Ranges and Apply Table Styles
Convert tables to cell ranges
Manage tables and table data - Modify tables
Add or remove table rows and columns
Configure table style options
Insert and configure total rows

Manage tables and table data - Filter and sort table data :
Filter records
Sort data by multiple columns
Perform operations by using formulas and functions - Insert references
Insert relative, absolute, and mixed references
Reference named ranges and named tables in formulas
Perform operations by using formulas and functions -Calculate and transform data
Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
Perform conditional operations by using the IF() function

Perform operations by using formulas and functions - Format and modify text :
Format text by using RIGHT(), LEFT(), MID(), and LEN() functions
Format text by using UPPER(), LOWER(), PROPER(), and TEXTJOIN() functions
Manage charts - Create charts
Create charts
Create chart sheets

Manage charts - Modify charts :
Add data series to charts
Switch between rows and columns in source data
Add and modify chart elements
Manage charts - Format charts
Apply chart layouts
Apply chart styles
Add alternative text to charts for accessibility

Practice Exercises :
How to use the Practice Exercises
Sample solution for Project 1
Sample solution for Project 2
Sample solution for Project 3
Sample solution for Project 5
Sample solution for Project 4
Sample solution for Project 6
Sample solution for Project 7
Thank You and Final Thoughts
Thank You and Final Thoughts