Excel Resources

Introduction

In this module we will cover the fundamentals of Excel including how to clean and visualise data as well as use basic statistics.

Learning Objectives

• Learn strategies for visualising data in Excel
• Understand data cleaning best practices
• Demonstrate basic statistical functions in Excel

Files to Download

• Workbook
• Demo Worksheets
• Subtotal Demo Worksheet
• Diamond Inventory
• Standards
• Project Write Up Template

Slides

Solutions

• ACS Solutions
• Aggregation Solutions
• Conditional Format Solutions
• Pivot Table Solutions
• Referencing Solutions
• Scavenger Solutions

Session Attendance Logs

Session 1

Session 2

Session 3

Session 4