Skip to Content
Suggested Study Topic: Excel
- BASICS
- Enter data
- Enter labels
- Copy
- Paste
- Paste Special
- Working with multiple sheets
- DATA MANIPULATION
- Formulas
- Entering fomulas
- Copy a formula with relative and absolute cell references
- Calculation with dates
- Functions
- Financial: PMT, FV
- Statistical: Average, Max, Min, Count, CountA
- Logical: IF
- Date/Time: NOW
- Sort and Filtering
- Sorting with multiple fields
- Filtering with AND and OR conditions
- Subtotaling data
- FORMATTING
- Row height and column width
- Format cells
- Freeze column/rows when viewing
- Repeat print column/rows
- CHARTS
- Create chart: Pie, Line, Bar, Column
Skip to Local Navigation, Skip to Content