Microsoft Excel Intermediate Training
Course outline
- Import and export from external files
- Data validation (drop down lists)
- Conditional formatting
- Auto fillers
- advanced auto filtering (subtotal)
- Named cells
- Ranges
- Calculation across worksheets
- advanced functions such as IF, VLOOKUP, HLOOKUP, CONCATENATE