Microsoft Excel for the MOS Exam (MO-210)

Everything the Excel Associate exam tests: workbooks, cells, tables, formulas and charts.

MSBA-171 12 lessons planned ▶ Video lessons coming soon

Offered by HSM University · Microsoft Certification Prep

Course content

  1. 1The Excel workspaceComing
  2. 2Managing worksheets and workbooksComing
  3. 3Importing dataComing
  4. 4Formatting cells and rangesComing
  5. 5Named rangesComing
  6. 6Excel tablesComing
  7. 7Sorting and filteringComing
  8. 8Formulas and cell referencesComing
  9. 9Common functions: SUM, AVERAGE, IF and text functionsComing
  10. 10Conditional formattingComing
  11. 11Creating and formatting chartsComing
  12. 12Practice project: a sales trackerComing

Description

Everything the Excel Associate exam tests: workbooks, cells, tables, formulas and charts.