Excel essentials

Home

Links:

Coggle: link

Visualization PPT: link

List of all math function in 1 page: link (Microsoft) / link (Exceljet)

If you excel in Excel, you will excel in life

Projects list:

• How to make a Personal Income Statement
• How to analyze titanic dataset (dataset link)
• Create a simple task to-do list
• How to make a business model of lemonade stand (or Tea Time) (Game simulator link) [franchise link ] [with cost link]
• How to create a Dashboard on IT Helpdesk (dataset link)
• Create your own school dataset on Maths, Science, and Arts
• Throw 2 dice and simulate it for 1000 times

Topics to be covered

• Importance of Table functions
• Importance of Stressors or Debugging
• Why formatting is very important.
• Try the minimalistic design

Trivia

• Quiz on excel functions.

Break the ice

• Tea Time

GL Topics

• Introduction
• Cell Reference
• Tables and Borders
• Basic Functions
• Sorting
• Filtering
• Date and Time
• If-Else
• Sub string
• Text Data

Bloggers:

Chandoo.org

Leila Gahrani

Books:

Head First Excel