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
  1. Format worksheets and workbooks
    1. Modify page setup
    2. Adjust row height and column width
  1. Customize options and views
    1. Customize the Quick Access Toolbar
    2. Modify the display of content
  1. Display formulas
  2. Modify basic workbook properties
  1. Configure content for collaboration
    1. Inspect workbooks for issues
    2. Print workbook content
  1. Manage data cells and ranges
    1. Manipulate data in worksheets
      1. Create data
      2. Reuse data
  1. Format cells and ranges
    1. Merge and unmerge cells
    2. Modify cell alignment, orientation, and indentation
  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
  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
  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
  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

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
800-453-596 (Toll Free)