Course description
Use Excel to analyse and manage external data linked to a spreadsheet: filters, advanced filters, lookup and reference functions, connections to external data, subtotals and pivot tables.
Course content
1. REVIEW OF CONCEPTS
2. DATA VALIDATION
3. AUTOFILTERS
4. ADVANCED FILTERS
5. LOOKUP FUNCTIONS
6. WORKING WITH DIFFERENT SHEETS, 3D FUNCTIONS
7. LINKING DATABASES TO THE SPREADSHEET, EXTERNAL DATA
8. SUBTOTALS AND OUTLINES
9. PIVOT TABLES
10. INTRODUCTION TO MACROS.
2. DATA VALIDATION
3. AUTOFILTERS
4. ADVANCED FILTERS
5. LOOKUP FUNCTIONS
6. WORKING WITH DIFFERENT SHEETS, 3D FUNCTIONS
7. LINKING DATABASES TO THE SPREADSHEET, EXTERNAL DATA
8. SUBTOTALS AND OUTLINES
9. PIVOT TABLES
10. INTRODUCTION TO MACROS.