Excel/Sheets Data Visualisation

This course will have you using excel for everything!

Course curriculum

1. What will you learn in this lesson?
  FREE PREVIEW
2. Navigation error - please take note
3. Creating, Renaming and Deleting Workbooks
4. Exploring the Ribbon
5. Formula Bar and Namebox
6. Autofill handle
1. What will you learn in this chapter?
2. Columns, Rows and Cells
3. Cell merging & size | fonts & colours | alignment & orientation
4. Formatting Numbers
5. TASK: Submit your formatted worksheet
6. QUIZ: Formatting
1. What will you learn in this chapter?
2. Basic Operations
3. Exercise: Excel Functions
4. Count function
5. Exercise: Cell Referencing
6. Conditional Formatting
7. TASK: submit your calculations
8. QUIZ: Operations and Calculations
1. What will you learn in this chapter?
2. Create and Format Charts
3. Combo chart
4. TASK: submit your chart
5. QUIZ: Charts
1. Introduction to Tables
2. Create a Table in Excel
3. Create a Pivot Table in Excel
4. TASK: Pivot Table
5. QUIZ: Tables
1. What will we learn in this chapter?
2. Import, Filter and Sort Data
3. EXERCISE: format views
4. Printing your workbook
5. FINAL TASK: managing data
1. Recap and next steps
2. Quick survey before you go

Enroll today