Beplugged Tech — home
All courses
Google

Google Sheets for Finance and Reporting

Three days of Google Sheets for people who work with money: formulas for financial calculations, pivot tables for summarising transactions, charts and dashboards for management reporting, and importing data from accounting systems. Each exercise uses realistic finance data.

Duration
3 days
Level
Intermediate
Delivery
In Pretoria, at your offices, or live online
Group size
Individuals or whole teams
What you will learn
  • Build financial models with formulas, named ranges and data validation
  • Summarise transactions with pivot tables and QUERY functions
  • Create management dashboards with charts that update automatically
  • Import and clean data from accounting systems and CSV exports
  • Protect sensitive sheets and control who can edit what
Course outline
  1. 1Financial formulas and functions. SUMIFS, VLOOKUP, QUERY, named ranges and financial calculation functions.
  2. 2Data import and cleaning. Importing from CSV, accounting systems and APIs; cleaning and validating financial data.
  3. 3Pivot tables and analysis. Summarising transactions, building pivot tables and cross-tabulations for management.
  4. 4Dashboards and charts. Creating dashboards with sparklines, charts and conditional formatting for monthly reporting.
  5. 5Collaboration and security. Sharing reports, protecting sensitive sheets, version history and audit trails.
Upcoming dates
22–26 Mar 2027Live online15 seats left
Book

Need a different date? Tell us when suits you — we schedule courses on demand for teams and individuals.

Who it is for

Finance officers, accountants, budget managers and analysts who report in Google Sheets.

Before you start

Basic use of Google Sheets or Excel.

How the training runs
  • In person in Pretoria, South Africa; at your offices anywhere; or live online on Microsoft Teams or Google Meet.
  • International delegates are welcome in Pretoria — we arrange invitation letters for visa applications and recommend hotels near the venue.
  • Run for your team only, on dates that suit you, with examples from your own work; or join an open course.
  • Hands-on throughout: learners practise each step on their own device, not just watch.
  • A certificate of completion that can be verified online.
Questions
Where is the training held?

At your offices anywhere in South Africa or at our training centre in Pretoria. For international delegates, we arrange training in Pretoria with joining instructions and hotel recommendations. Live online delivery on Microsoft Teams or Google Meet is also available.

Do you train organisations outside South Africa?

Yes. We work with organisations across Africa and beyond. International delegates can attend in person in Pretoria, South Africa, or join live online. We arrange invitation letters for visa applications and handle all logistics.

Can the course be run for our team only?

Yes. Most courses are run in-house for one organisation, on dates that suit you, with examples from your own work. Larger teams are split into groups.

What do learners receive?

A Beplugged Tech certificate of completion that anyone can verify online. Where a course prepares for a certification exam (Certiport, Microsoft, Oracle, Google), the exam can be arranged at our testing centre or through the certification body.

How do we book, and what does it cost?

Send the enquiry form on this page with the number of people and your preferred dates. We reply within one working day with dates, the full outline and a quote.

Related courses