Excel/Sheets Data Visualisation
This course will have you using excel for everything!
What will you learn in this lesson?
FREE PREVIEWNavigation error - please take note
Creating, Renaming and Deleting Workbooks
Exploring the Ribbon
Formula Bar and Namebox
Autofill handle
What will you learn in this chapter?
Columns, Rows and Cells
Cell merging & size | fonts & colours | alignment & orientation
Formatting Numbers
TASK: Submit your formatted worksheet
QUIZ: Formatting
What will you learn in this chapter?
Basic Operations
Exercise: Excel Functions
Count function
Exercise: Cell Referencing
Conditional Formatting
TASK: submit your calculations
QUIZ: Operations and Calculations
What will you learn in this chapter?
Create and Format Charts
Combo chart
TASK: submit your chart
QUIZ: Charts
Introduction to Tables
Create a Table in Excel
Create a Pivot Table in Excel
TASK: Pivot Table
QUIZ: Tables