Microsoft Excel Trainer Certification Course Syllabus

Return to Course Information Page

Class One

  • The Start Screen
  • Configuring Excel
  • The Excel Display
  • Workbooks and Worksheets
  • Add a Worksheet to a Workbook
  • Navigate workbook worksheets
  • JAWS for Window worksheet list
  • Rows, Columns and Cells
  • Insert Cell Data
  • Data Regions
  • Navigate a Worksheet
  • Windows Text Navigation Commands
  • JAWS for Windows Reading Commands
  • Formulas
  • Edit Cell Data
  • Read Cell Data
  • JAWS for Windows Cell List

Class Two

  • Select Text
  • Read Selected Text
  • Remove Text Selection
  • Add Font Attributes
  • The Font Dialog
  • Read Font Attributes and Cell Detail
  • Configure a Default Font

Class Three

  • Select Cells
  • Read Selected Cells
  • Remove Cell Selection
  • The “Go To” dialog
  • Cell Text Visibility Detection
  • Manual Carriage Return
  • Word Wrap

Class Four

  • Column Width
  • Row Height
  • Autofit
  • Format Cells
  • Functions

Class Five

  • Insert the Time and Date
  • Merge and Unmerge
  • Cell Data Alignment
  • Name Cell Ranges and Cells
  • Name Manager
  • Use Named Ranges in Formulas
  • Excel Go To Dialog and Names

Class Six

  • Column and Row Titles
  • Configure JAWS for Windows Title Reading
  • Read Titles with JAWS for Windows
  • Sort Data
  • Excel Find
  • Excel Find and Replace

Class Seven

  • JAWS for Windows Custom Summary Labels
  • SUM Rows or Columns
  • JAWS for Windows Total Rows and Columns
  • JAWS for Windows Monitor Cells

Class Eight

  • Borders
  • Hyperlinks
  • Clear Cell Elements
  • JAWS for Windows Cell Markers
  • Add Cell Background Colors
  • Color Worksheet Tabs
  • Gridlines

Class Nine

  • Split Text to Columns
  • Insert Random numbers
  • Display all formulas
  • Fractions
  • Conditional Formatting

Class Ten

  • Charts
  • JAWS for Windows Chart Commands
  • Chart Ribbons

Return to Course Information Page