MO 200 Excel 2019 Associate Certification Course For experienced user prepping for Certification. Includes 1 Test Voucher. - Dynamics Edge
Course 20200

MO 200 Excel 2019 Associate Certification Course For experienced user prepping for Certification. Includes 1 Test Voucher.


To customize this class, call 800-453-5961 or click here to contact us

Course Description

Demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Associate Certification. This class will get you prepped for certification testing to demonstrate 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.

Course Topics

  1. Manage worksheets and workbooks
    1. Import data into workbooks
      1. Import data from delimited text files
    2. Navigate within workbooks
      1. Search for data within a workbook
      2. Navigate to named cells, ranges, or workbook elements
  • Insert and remove hyperlinks
  1. Format worksheets and workbooks
    1. Modify page setup
    2. Adjust row height and column width
  • Customize headers and footers
  1. Customize options and views
    1. Customize the Quick Access Toolbar
    2. Modify the display of content
  • Display multiple parts of a worksheet
  1. Display formulas
  2. Modify basic workbook properties
  1. Configure content for collaboration
    1. Inspect workbooks for issues
    2. Print workbook content
  • Save workbooks in alternative file formats
  1. Manage data cells and ranges
    1. Manipulate data in worksheets
      1. Create data
      2. Reuse data
  • Modify worksheet structure
  1. Format cells and ranges
    1. Merge and unmerge cells
    2. Modify cell alignment, orientation, and indentation
  • Wrap text within cells
  1. Apply cell formats and styles
  2. Apply number formats
  3. Reapply existing formatting
  1. Define and reference named ranges
  2. Summarize data visually
    1. Format cells based on their content
    2. Insert sparklines
  3. Manage tables and table data
    1. Create and format tables
      1. Create an Excel table from a cell range
      2. Apply styles to tables
  • Convert a table to a cell range
  1. Modify tables
    1. Add or remove table rows and columns
    2. Configure table style options
  2. Filter and sort table data
    1. Filter tables
    2. Sort tables
  3. Perform operations by using formulas and functions
    1. Insert references in formulas
      1. Insert relative, absolute, and mixed references
      2. Referenced named cell ranges and tables in formulas
    2. Calculate and transform data by using functions
      1. Perform calculations by using the SUM(), AVERAGE(), MAX(), and MIN() functions
      2. Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
  • Perform conditional operations by using the IF () function
  1. Format and modify text by using functions
    1. Select text by using the LEFT(), MID(), and RIGHT() functions
    2. Format text by using the UPPER (), LOWER(), and PROPER() functions
  • Count characters by using the LEN() and LENB() functions
  1. Combine text by using the CONCAT() and TEXTJOIN() functions
  1. Manage Charts
    1. Create Charts
    2. Modify Charts
      1. Modify chart content
      2. Modify chart elements
    3. Format charts
      1. Apply layouts and styles

Provide alternative text for accessibility

We look forward to your great success!!!

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Register


Price: $895   Duration: 1 day

- EST