Study a Free Google Sheets Fundamentals in South Africa with Durban City Academy. Enrol in the Free Google Sheets Fundamentals Course with Certificate in South Africa to learn how to organise information, work with formulas and present data...
Enrol in the Free Google Sheets Fundamentals Course with Certificate in South Africa to learn how to organise information, work with formulas and present data clearly. This online course is for learners who want practical spreadsheet skills for school, study, personal tasks or work. You will practise creating spreadsheets, entering and formatting data, using basic functions, building charts and sharing files, with a certificate available after completing the course.
If you are new to spreadsheets, or have only used them for simple lists, this course gives you a clear place to start. You will learn how to manage cells and files, make calculations, sort and filter records, and check your work for common errors.
Google Sheets is a spreadsheet tool for recording and working with information. Learning its fundamentals can make everyday tasks easier, whether you are planning a budget, keeping track of study deadlines or preparing a simple report.
The lessons build skills step by step. You will move from entering text, numbers and dates to using formulas and functions that calculate results for you.
As you practise, you will also learn ways to make a spreadsheet easier to read. Clear headings, consistent formats and useful charts help other people understand what your information shows.
Online learning makes it possible to study these skills from anywhere in South Africa. You can apply the examples to your own tasks and practise with spreadsheets you create in Google Drive.
Later lessons introduce tools for organising and checking data, including filters, dropdown lists and conditional formatting. These features can help you focus on relevant records and spot details that may need attention.
You will also practise sharing a spreadsheet with specific people and choosing an appropriate access level. Comments and version history can support collaboration and help you review changes.
The final learning areas bring these skills together in a practical workbook. You will plan a simple tracker, combine formatting with formulas, and review the finished spreadsheet before sharing it.
When you complete the course, you can use your new skills as a foundation for further study and practical spreadsheet projects. Explore guides on formulas, budgets and collaboration below to continue learning.
Spreadsheets are useful whenever information needs to be recorded, compared or summarised. A well-organised sheet can turn a jumble of figures into a clear list, calculation or chart. Learning the fundamentals means you can spend less time fixing confusing layouts and more time using the information.
Google Sheets skills are relevant to many everyday and workplace tasks: tracking stock, recording expenses, maintaining contact lists, planning projects or preparing simple reports. Knowing how to use formulas and data tools can also help you contribute confidently when a group shares a spreadsheet.
Start with a practical example, such as a monthly spending tracker. Our guide to building a monthly budget tracker in Google Sheets shows how categories and calculations can work together. If a formula gives an unexpected result, use this troubleshooting guide to references, ranges and cell formats as a useful next step.
Open Sheets, create a spreadsheet and get familiar with its layout. You will also practise naming and organising files in Google Drive.
Work with text, numbers, dates and times. Learn to select cells and ranges, edit entries, clear data and undo changes.
Format text, numbers and dates, adjust row heights and column widths, and use alignment, borders and colours to improve readability.
Write formulas using operators, understand relative and absolute references, and copy formulas across a range.
Calculate totals with SUM, find averages and identify minimum or maximum values. You will also use COUNT and COUNTA to count entries. For more examples, explore what the SUM function does in Google Sheets.
Build structured tables with clear headers, sort records into a useful order and filter the view to focus on selected information.
Create dropdown lists with data validation, highlight values with conditional formatting, and look for common data errors.
Choose a chart to suit your data, then add titles and labels and adjust its appearance to make the main message easier to understand.
Share a spreadsheet with specific people, select an access level, add comments and review version history.
Plan a simple tracker for a real task, bring together formatting and calculations, then review and share your finished workbook.
Google Sheets Fundamentals is designed for beginners who want a clear introduction to the subject, with practical lessons, guided learning, and simple explanations that are easy to follow online.
Yes, learners in South Africa can study this course online at their own pace, which makes it useful for flexible learning, personal development, and building practical knowledge from home or work.
This course covers practical learning areas such as Opening Sheets and creating a spreadsheet, Understanding the spreadsheet layout, Naming, saving and organising files in Google Drive, Entering text, numbers, dates and times, helping learners build foundational knowledge that can be applied in study, work tasks, and everyday digital learning.
Most learners can work through the course in a few focused hours, but the online format allows you to move at your own pace and revisit lessons whenever you need extra practice.
A certificate is available after successful completion, which gives learners a simple way to show that they finished the course content and assessment requirements online.
These skills are useful because they support workplace readiness, digital confidence, and practical day-to-day tasks, which can help learners strengthen their knowledge in a South African learning and work environment.