Excel 2
Emily wanted an Alexa, scooter, and makeup kit but got chocolates instead. She started selling them to save for her dream items and needs your help to track sales and profits with an Excel dashboard to grow her business.
What will you learn in this chapter?
Columns, Rows and Cells
Cell merging & size | fonts & colours | alignment & orientation
Formatting Numbers
QUIZ: Formatting
What will you learn in this chapter?
Basic Operations
Exercise: Excel Functions
Count function
Exercise: Cell Referencing
Conditional Formatting
TASK: Operations & Calculations
QUIZ: Operations and Calculations
What will you learn in this chapter?
Create and Format Charts
Combo chart
TASK: submit your chart
QUIZ: Charts
Well done. Next steps
End of Course Survey