← All Courses
Beginner
Spreadsheets for Beginners: Track Sales, Budgets and Records
A free, hands-on course on spreadsheets (Excel, Google Sheets or similar): enter data, use formulas, sort and filter, make charts and build a simple sales and expense tracker.
A spreadsheet is one of the most useful tools for work and business. It can add up your sales, track what you spend, show which products earn the most and tell you whether you made a profit this month.
This free course teaches the essentials step by step, using examples from small shops, students and offices. Everything works in Microsoft Excel, Google Sheets and most other spreadsheet programs.
You will learn how to enter and format data, use formulas such as SUM, AVERAGE and IF, sort and filter lists, create charts and build a working sales and expense tracker. Finish all six lessons and pass the short final quiz to earn a certificate.
This free course teaches the essentials step by step, using examples from small shops, students and offices. Everything works in Microsoft Excel, Google Sheets and most other spreadsheet programs.
You will learn how to enter and format data, use formulas such as SUM, AVERAGE and IF, sort and filter lists, create charts and build a working sales and expense tracker. Finish all six lessons and pass the short final quiz to earn a certificate.
No experience needed. You can use a computer or a phone, and a free program such as Google Sheets is enough.
Lessons
Meet the Spreadsheet: Cells, Rows and Columns
text
Preview
View →
Formatting: Make Your Data Easy to Read
text
Formulas: Let the Spreadsheet Do the Maths
text
Sort, Filter and Summarise Your Data
text
Build a Sales and Expense Tracker
text
Good Habits: Accuracy, Backup and Sharing
text
Student reviews
Students who are enrolled in this course can leave a review.
No reviews yet. Be the first once you have started learning.