0 (0 Ratings)
Google Sheets: Basic Formulas and Pivot Tables
£30.00
£40.00
Enrollment is now paused
-
LevelBeginner
-
Last UpdatedMay 30, 2025
-
CertificateCertificate of completion
Hi, Welcome back!
Description
Harness the power of your data with Google Sheets! This introductory course will equip you with two fundamental skills: writing basic formulas to perform calculations and using Pivot Tables to effortlessly summarise and analyze information. Learn how to add, subtract, multiply, divide, and utilise essential functions to extract valuable insights from your spreadsheets. Then, discover the simplicity of Pivot Tables, allowing you to transform raw data into clear summaries and reports with intuitive drag-and-drop functionality. Whether you’re managing personal finances, analysing survey results, or organising project data, this course will provide you with practical, immediately applicable Google Sheets skills.
Course Curriculum
Getting Started with Basic Formulas
-
Introduction to Google Sheets Formulas
-
Performing Basic Arithmetic
-
Introduction to Basic Functions
Unleashing the Power of Pivot Tables
-
What are Pivot Tables?
-
Creating Your First Pivot Table
-
Basic Pivot Table Operations
Analysing Data with Pivot Tables
-
Grouping Data in Pivot Tables
-
Utilising Filters and Slicers
-
Presenting Insights with Charts from Pivot Tables