Business Spreadsheets to Dashboards

← Back to Training

Self-paced Data & Productivity Beginner to Intermediate 5 weeks at your own pace · about 12 hours 12 lessons

About this course

For owners, admins, accountants and managers who run their business on spreadsheets. Learn the structure, formulas and charts that turn messy data into decisions.

All lessons work in Google Sheets (free) and most also work in Excel.

What you will learn

• Structure data so it is easy to analyse
• Use key formulas: SUMIFS, XLOOKUP, IF, text and date functions
• Clean messy data quickly
• Summarise with pivot tables
• Build charts and a one-page dashboard
• Protect, share and back up business spreadsheets

Syllabus

Module 1 · Set up your data properly 3 lessons + quiz

• Rules of good spreadsheet data Free preview 10 min
• Formatting, tables and data validation 🔒 12 min
• Cleaning messy data 🔒 14 min

Module 2 · Formulas that matter 3 lessons + quiz

• Totals, averages and logic 🔒 14 min
• SUMIFS, COUNTIFS and conditional summaries 🔒 15 min
• Lookups: XLOOKUP and VLOOKUP 🔒 14 min

Module 3 · Pivot tables and charts 3 lessons + quiz

• Pivot tables in 15 minutes 🔒 15 min
• Choosing the right chart 🔒 13 min
• Telling the story with data 🔒 10 min

Module 4 · Dashboards, sharing and automation 3 lessons + quiz

• Build a one-page dashboard 🔒 16 min
• Sharing, permissions and protection 🔒 12 min
• Capstone: your business dashboard 🔒 45 min

Taught by: Prine Fellowship team