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
- today
- sum
- average
- count, counta
- min
- max
- vlookup (video, video with ranges of numeric values)
- sumif, averageif, countif (video)
- sumifs, averageifs, countifs (video)
- if (video)
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