Google Sheets Functions - Be the hero in the office

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 Calculations

You'll begin by fully grasping everyday functions like AVERAGE, MIN, MAX, COUNT, and ROUND, to allow you to understand your data better.

Conditional Logic

Uncover 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 & Organization

Learn 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 Lookup

Goodbye 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 Manipulation

Become 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 Sources

Expand 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 Management

Easily 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 QUERY

You’ll learn how to use the unique QUERY function to filter, group, sort, and reformat extensive datasets with just one function.

Gemini and AI

Finally, 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!