Microsoft Office Excel Course Objectives

Level 1:

  • Describe similarities and differences between Office 2019 for the desktop, Office 365, and Office Online,

  • Identify parts of the Office user interface,

  • Use the spelling checker and other review features,

  • Format text in Office applications,

  • Search for Help within Office applications,

  • Enter data into a worksheet,

  • Format a worksheet,

  • Apply number and date formats,

  • Enter a series of related data,

  • Use formulas to perform calculations,

  • Rearrange data on a worksheet,

  • Manage multiple worksheets,

  • Create formulas with functions,

  • Use relative and absolute cell references in formulas,

  • Define names for cells and ranges,

  • Use names in formulas,

  • Insert charts,

  • Move and size charts,

  • Add images to a worksheet,

  • Apply conditional formatting,

  • Create a template,

  • Start a workbook from a template,

  • Sort and filter data,

  • Create IF functions, and

  • Create and modify tables.

Level 2:

  • Apply and customize themes,

  • Create and use cell styles,

  • Apply cell borders and fill,

  • Create custom number formats,

  • Customize the page setup,

  • Edit document properties,

  • Identify date serial numbers,

  • Apply custom date formatting,

  • Enter times,

  • Create functions using dates,

  • Perform date and time calculations,

  • Create customized conditional formatting rules,

  • Edit rules using the Conditional Formatting Rules Manager,

  • Use functions to format text,

  • Create conditional functions using IF and IFS criteria,

  • Create formulas using nested functions,

  • Find and correct errors in formulas,

  • Use 3-D cell references in formulas,

  • Create formulas using lookup functions,

  • Use the Outline feature,

  • Create subtotals,

  • Use the Quick Analysis tool,

  • Create PivotTables,

  • Modify and format PivotTables,

  • Apply a filter to a PivotTable,

  • Insert a slicer to filter a PivotTable,

  • Create a calculated field,

  • Create PivotCharts,

  • Change the macro security settings,

  • Create macros to automate tasks,

  • Run macros, and

  • Create macro buttons to run macros quickly.

Level 3:

  • Manage data using a table,

  • Create a custom filter,

  • Name a table,

  • Use structured references in a formula,

  • Create sparklines,

  • Create PivotTables,

  • Modify and format PivotTables,

  • Apply a filter to a PivotTable,

  • Insert a slicer to filter a PivotTable,

  • Create a calculated field,

  • Create PivotCharts,

  • Change the macro security settings,

  • Create macros to automate tasks,

  • Run macros,

  • Create macro buttons to run macros quickly,

  • Import data from various sources,

  • Consolidate data from multiple sheets into one sheet,

  • Create a series of data using different methods,

  • Chart trends and save chart templates,

  • Use additional functions for lookups and logic,

  • Create hyperlinks for navigation,

  • Insert comments,

  • Add alt text to objects,

  • Inspect your workbook for issues,

  • Create forms, and

  • Protect your workbook