Home | Back to Courses
Google Sheets Functions - Be the hero in the office
Partner: Udemy
Affiliate Name:
Area:
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 Sources</strong
Category:
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course