Dark site-logo
  • Registration
    • Class Registration
    • Account Registration
  • Members
    • Our Members
    • Testimonial
  • Courses
    • All Courses
    • Resource Material
    • Live Class Access
    • Learner Dashboard
    • Quiz Reports
    • Groups Dashboard
    • Paid Membership Levels
  • Support 24/7
  • Blogs
Login
  • Registration
  • Members
  • Courses
  • Support 24/7
  • Blogs
  • Class Registration
  • Account Registration
  • Our Members
  • Testimonial
  • All Courses
  • Resource Material
  • Live Class Access
  • Learner Dashboard
  • Quiz Reports
  • Groups Dashboard
  • Paid Membership Levels

Microsoft Office Specialist: Associate (Office 365 and Office 2019) Excel

Instructor Image IITAE Admin
12 Lessons
1 year
$99.99 for 4 weeks
IITAE Course UpdateCooperate CoursesProfessional Training

Microsoft Office Specialist: Associate (Office 365 and Office 2019) Excel

Instructor Image IITAE Admin
12 Lessons
1 year
$99.99 for 4 weeks
Course Materials Introduction

Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)

Demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Associate Certification. This certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.

Skills Measured

  • Manage worksheets and workbooks
  • Manage data cells and ranges
  • Manage tables and table data
  • Perform operations by using formulas and functions
  • Manage charts

Exam MO-200: Microsoft Excel (Excel and Excel 2019)

This exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. Candidates are expected to demonstrate the correct application of the principal features of Excel and complete tasks independently.

Certiport_MOS_Program_Trifold_Final_0121_Online_Download
MOS_Employability Evidence of Microsoft Certifications Brochure (1)Download
MOS_Value of Microsoft Certification Brochure (1)Download

Value of Microsoft certification

Microsoft certification gives students and workforce candidates the power to chart their own course, fulfill their ambition, and realize their potential. See the statistics that validate that these certifications give you the tools to build a brighter future and prepare yourself for a successful career.

Course Outline

https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE3WKkC

 

Lessons

Quick Start
5 Topics
  • Create a Workbook
  • Save your Workbook to OneDrive
  • Analyze and Format
  • Collaborate
  • Set Up Your Mobile Apps
Intro to Excel
7 Topics
  • Create a New Workbook
  • Insert or Delete a New Worksheet
  • Move or Copy Worksheets or Worksheet Data
  • Print a Worksheet or Workbook
  • Use Excel as your Calculator
  • Fill Data Automatically In Worksheet Cells
  • Create a Drop-Down List
Rows & Columns
7 Topics
  • Insert or Delete Rows and Columns
  • Select Cell Contents in Excel
  • Freeze Panes to lock Rows and Columns
  • Hide or Show Rows or Columns
  • Filter for Unique Values or Remove Duplicate Values
  • Split text into different columns with the Convert Text to Columns Wizard
  • Create a list of Sequential Dates
Cells
6 Topics
  • Move or copy cells and cell contents
  • Change the column width or row height in Excel
  • Find or replace text and numbers on a worksheet
  • Merge and unmerge cells
  • Apply data validation to cells
  • Import or export text (.txt or .csv) files
Formatting
8 Topics
  • Available number formats in Excel
  • Conditional Formatting
  • Align or rotate text in a cell
  • Change the format of a cell
  • Copy cell formatting
  • Add a watermark in Excel
  • Display or hide zero values
  • Create a custom number format
Formulas & Functions
10 Topics
  • Overview of formulas in Excel:
  • XLOOKUP
  • VLOOKUP
  • SUM function
  • COUNTIF function
  • IF function
  • IFS
  • SUMIF
  • SUMIFS
  • MATCH
Tables
5 Topics
  • Create and format tables
  • Sort data in a table
  • Filter data in a range or table
  • Total the data in an Excel table
  • Use slicers to filter data
Charts
7 Topics
  • Create a chart from start to finish
  • Add or remove titles in a chart
  • Show or hide a chart legend or data table
  • Add or remove a secondary axis in a chart in Excel
  • Add a trend or moving average line to a chart
  • Choose your chart using Quick Analysis
  • Update the data in an existing chart
PivotTables
- - -
Share & Co-author
- - -
Linked Data Types
- - -
Get to know Power Query
- - -

Ratings and Reviews

0.0
Avg. Rating
0 Ratings
5
0
4
0
3
0
2
0
1
0
What's your experience? We'd love to know!
Login to Review
No Reviews Found!
Show more reviews
What's your experience? We'd love to know!
Login to Review

We at Skills are pleased to provide a place to learn at your own pace with updated and current content. 

  • About Us
  • Contact us
  • FAQ
  • Help Desk
  • LMS
  • Blog
  • Privacy Policy
  • Our Team
Copyright 2021 - All Rights Reserved | Designed by IITAE Ltd
Skip to toolbar
  • About WordPress
    • WordPress.org
    • Documentation
    • Learn WordPress
    • Support
    • Feedback
  • Log In
  • Register