Google Sheets Functions - Be The Hero In The Office

Master Google Sheets functions

What you'll learn

Master essential Google Sheets functions to analyze and transform data efficiently.

Unlock powerful data manipulation techniques using key formulas for common tasks.

Learn to clean and organize messy datasets with practical function applications.

Apply conditional logic and lookup functions for dynamic spreadsheet solutions.

Gain confidence in creating robust formulas to solve real-world data challenges.

Requirements

No previous experience is required. You will learn everything you need to know.

Description

Hi and welcome to 'Google Sheets Functions: Be the hero in the office!'I'm Baz Roberts, and I'm thrilled to guide you through this journey.I've been showing people how to use Google Sheets for over 10 years, and I absolutely love them!This practical course on Google Sheets Functions is designed to equip you with the skills to effortlessly organise and analyse your data.This course is fully up-to-date, even incorporating the latest functions like XLOOKUP and AI, ensuring you learn the most relevant and powerful tools available.Don’t worry we'll start with the basic functions, like SUM and COUNT and then progress to more advanced ones like IMPORTRANGE and the incredibly powerful QUERY.Basic CalculationsYou'll begin by fully grasping everyday functions like AVERAGE, MIN, MAX, COUNT, and ROUND, to allow you to understand your data better.Conditional LogicUncover the power of conditional functions like IF statements, COUNTIF, and SUMIF. This will enable your spreadsheets to intelligently respond to conditions, and extract precisely what you need.Data Filtering & OrganizationLearn to FILTER information, identify UNIQUE data and rows, and SORT data. Plus, functions like IS NUMBER will help you easily check and clean your lists.Data LookupGoodbye to manual searching! You'll learn different important lookup functions like VLOOKUP, INDEX/MATCH, and the modern XLOOKUP, which get the data you want instantly.Text ManipulationBecome a star at handling text! Functions like PROPER, TRIM, CONCATENATE, and TEXTJOIN will allow you to clean, combine, and restructure your text. You’ll even learn how to understand those horrible long, complex formulas by breaking them down.External SourcesExpand your spreadsheet’s horizons! You’ll discover how to pull data from other spreadsheets using Import Range and even translate text in real-time with Google Translate, truly expanding Google Sheets’ capabilities.Date & Time ManagementEasily calculate dates and times, along with working days to be able to do things like track deadlines, and manipulate date and time-orientated data.Advanced Data Manipulation with QUERYYou’ll learn how to use the unique QUERY function to filter, group, sort, and reformat extensive datasets with just one function.Gemini and AIFinally, we delve into the world of AI. We'll see how tools like Gemini for Workspace can assist you in analysing data and creating charts. Plus, how we can prompt Gemini directly from our cells, to quickly get the answers we need.You’ll possess a robust toolkit of Google Sheets functions. This course is all about giving you the practical skills and confidence to solve real-world problems and take complete control over your spreadsheets.We'll go through practical examples in every lecture, with accompanying Google Sheets files so you can follow along. And to reinforce your learning, each section has a practical challenge, complete with raw data and solution files so you can check your work.By the end of this course, you'll be able to use Google Sheets with confidence, saving time and effort, and impressing your boss and colleagues! You'll enhance your professional and academic prospects and open doors to new opportunities.None of this is difficult, and sometimes you just need to be shown what's possible and be guided in the right direction. This course provides just that – a straightforward path to practical mastery, ensuring you can use the functions in each video with confidence. There’s lots to cover, so let’s get started!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Introduction to Google Sheets

Lecture 3 Course files

Lecture 4 Course Files Folder

Lecture 5 Introduction to formulas and functions

Section 2: Basic Calculations

Lecture 6 AVERAGE, MAX, MIN

Lecture 7 COUNT and COUNTA

Lecture 8 ROUND, ROUNDUP, ROUNDDOWN

Lecture 9 Practical Challenge 1

Section 3: Conditional Logic

Lecture 10 IF and Nested IFs

Lecture 11 OR, AND

Lecture 12 COUNTIF, COUNTIFS

Lecture 13 SUMIF, SUMIFS

Lecture 14 Practical Challenge 2

Section 4: Data Filtering

Lecture 15 FILTER

Lecture 16 UNIQUE, COUNTUNIQUE, SORT

Lecture 17 ISEMAIL, ISNUMBER, ISURL, NOT

Lecture 18 Practical Challenge 3

Section 5: Data Lookup

Lecture 19 VLOOKUP

Lecture 20 INDEX, MATCH

Lecture 21 XLOOKUP

Lecture 22 HYPERLINK

Lecture 23 OFFSET

Lecture 24 Practical Challenge 4

Section 6: Text Manipulation

Lecture 25 PROPER, UPPER, LOWER, TRIM, LEFT, RIGHT, LEN

Lecture 26 Understanding long formulas

Lecture 27 CONCATENATE, &, TEXTJOIN

Lecture 28 TRANSPOSE

Lecture 29 Practical Challenge 5

Section 7: External Sources

Lecture 30 IMPORTRANGE

Lecture 31 GOOGLETRANSLATE

Lecture 32 Practical Challenge 6

Section 8: Date & Time

Lecture 33 NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND

Lecture 34 WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH, CHOOSE

Lecture 35 Practical Challenge 7

Section 9: Advanced Data Manipulation

Lecture 36 QUERY 1

Lecture 37 QUERY 2

Lecture 38 Practical Challenge 8

Section 10: Summary, Gemini & End of course

Lecture 39 Functions Summary

Lecture 40 Gemini and AI

Lecture 41 End of course summary

Section 11: Bonus: Next Steps

Lecture 42 Next Steps

Beginners to Google Sheets who want to build foundational skills.,Professionals needing to organise and analyse data effectively in their workplace.,Students and Educators aiming to improve spreadsheet skills for academic or teaching purposes.,Small Business Owners and Freelancers seeking to streamline business processes and data management.,Google Sheets users who want to take their skills to the next level.