Intro to Formulas and Functions

Google Sheets offers powerful tools to help you analyze, calculate, and visualize data through functions and formulas. In this post, I’ll cover the essentials of using formulas in Google Sheets and how using functions makes working with data a breeze. Values v Formulas: What’s the Difference? Cells in Google Sheets can hold values (like numbers… Continue reading Intro to Formulas and Functions

Step-by-Step Guide to Mastering the new XLOOKUP Function

If you’ve used functions for a little while, no doubt you will have seen or used VLOOKUP. It’s a really popular function and one of the first that most people start using but it does come with some limitations. Fortunately, we have a new function on the blocks which doesn’t have these limitations and does… Continue reading Step-by-Step Guide to Mastering the new XLOOKUP Function

How to use CHOOSECOLS and CHOOSEROWS

Google have recently added two useful new functions to Google Sheets, CHOOSECOLS and CHOOSEROWS, which allow us to easily show certain rows or columns we want from a data range. Let’s see how they work with a couple of examples. choosecols Here, we have some questionnaire feedback on a group of teachers and the academy… Continue reading How to use CHOOSECOLS and CHOOSEROWS

Google Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH

Following on from my post on the basic date functions, let’s look at some really useful functions that work with dates, namely: WEEKDAY, WORKDAY, NETWORKDAYS, EDATE and EOMONTH, plus we’ll see an example with the CHOOSE function. With these we’ll: Find out the day of the week of a particular date Work out a deadline date Work… Continue reading Google Sheets Functions – WEEKDAY, WORKDAY, NETWORKDAYS, EDATE, EOMONTH

Google Sheets Functions – GOOGLETRANSLATE, DETECTLANGUAGE

Lots of people know about and have used Google Translate either on their phones or on the Google website but what they often don’t know is that there is a built-in function in Google Sheets, which will allow you to translate from one language to another, and even automatically recognise the language and translate it. So,… Continue reading Google Sheets Functions – GOOGLETRANSLATE, DETECTLANGUAGE

Google Sheets Functions – NOW, TODAY, DAY, MONTH, YEAR

In this post, we’re going to look at some of the basic date functions and in particular, how we can extract parts of a date or a time.  We’ll cover: NOW, TODAY, DAY, MONTH, YEAR, HOUR, MINUTE, and SECOND. Example 1 – Getting the current date and time We can add the current date and… Continue reading Google Sheets Functions – NOW, TODAY, DAY, MONTH, YEAR