Course curriculum
1. 16 lessons
- Introduction to excelFree preview
- Overview of Excel and Tools
- Working with Spreadsheets and cells
- Basic Formulas and Functions
- Formatting data for readability
- Introduction to Data Types and Structures
2. 26 lessons
- 0. Introduction video
- Removing duplicates and blanks
- Find and replace, Text to column
- Data Validation and error checking
- Working with dates and text functions (LEFT, RIGHT, MID, TRIM)
- Sorting and Filtering
3. 36 lessons
- Introduction Video
- Logical Functions (IF, AND, OR)
- Lookup Functions
- Conditional formatting
- Named Ranges
- Error Handling Functions (IFerror)
4. 45 lessons
- Introduction video
- Pivot tables
- Grouping and Summarizing Data
- Subtotals
- Consolidating multiple datasets
5. 55 lessons
- Introduction video
- Creating Effective charts
- Customising chart elements
- Sparklines and data bars, Best practices for chat design
- Dashboard Basics
6. 61 lessons
- Dashboard creation
Certificate of completion
Finish every lesson and pass the assessments to receive a verifiable CareerThrive certificate.