Google Sheets Fundamentals

Google Sheets Fundamentals
Information Technology

Google Sheets Fundamentals

R5 690,00 R1 820,80 68% Off
Study Online Self-Paced Certificate Available Beginner Friendly

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...

About This Course

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.

Why Learn This Course?

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.

What You Will Learn

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.

Frequently Asked Questions

Is Google Sheets Fundamentals suitable for beginners?

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.

Is this course free to study online in South Africa?

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.

What will I learn in this course?

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.

How long does it take to complete this course?

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.

Do I get a certificate after completing the course?

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.

Why are these skills useful in South Africa?

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.

Course Information

Course Fee R5 690,00 R1 820,80
CategoryInformation Technology
ProviderDurban City Academy
Learning LevelBeginner
Estimated Time2-4 Hours
DeliveryOnline, Self-Paced
CertificateAvailable
Enroll Now
Available offers: SUMMER26
10Lessons
30Topics
10Exams
YesCertificate
YesAvailable

Skills You Can Build

  • Create and organise spreadsheets in Google Drive.
  • Enter, edit and format text, numbers, dates and times.
  • Use formulas, cell references and essential functions to calculate results.
  • Sort and filter records, and improve data entry with dropdown lists.
  • Use conditional formatting to draw attention to selected values.
  • Create charts and share work with suitable permissions.

Who This Course Helps

  • New to Google Sheets or returning to spreadsheets after a break.
  • A student organising notes, deadlines, research or project information.
  • Building basic digital skills for everyday or workplace tasks.
  • Interested in keeping simple budgets, trackers, lists or records.
  • Looking for free online Google Sheets training with a certificate option.