Microsoft Excel Review

Upon completion of this course, students will be able to:
  • Use over 60 keyboard shortcuts to navigate and/or manipulate an Excel workbook
  • Change font type, size and color, alignment, and number formats
  • Insert and delete rows and columns
  • Freeze data rows and columns at the top or left edge of the screen
  • Use the AutoFill feature to quickly fill in and duplicate values, formulas, and patterns
  • Filter and sort data
  • Prepare data for printing
  • Design an Excel PivotTable
  • Create simple and advanced formulas
  • Use multiple Summary, Lookup, Logical, and Advanced functions