jackmyers.info

Topics to be covered on the Excel Test

Basics

  • Cell references
  • Absolute and relative references (video)
  • Arithmetic operations using cells
  • Draggable formulas

Functions

Charts and Pivots

  • Making basic pie chart
  • Making basic column chart
  • Making basic line chart
  • Adding/modifying chart titles and axes titles
  • Modifying an axis, e.g. max, min, major units, minor units, tick marks
  • Making a pivot table (basic pivot video, value field settings video)
  • Making a pivot chart (video)

Data Validation and display

  • Validating against constant values
  • Validating against a list
  • Validating against a named range (list)
  • Conditional formatting
  • Sorting
  • Filtering