Dec
29
How to split cells in Google Sheets
If you ever needed to split text from one cell into separate columns, this is your lucky day. Today I'm going to share a few quick tips on how to do that. Continue reading
Posts tagged "Google Sheets functions", page 2
Nov
30
How to calculate currency exchange rates in Google Sheets with GoogleFinance
Find out how to use the GOOGLEFINANCE function to get the current currency exchange rates or the rates over some period of time in Google Sheets. You'll get to know what arguments the function has and how to manage them easily. Continue reading
Nov
16
Google Sheets COUNT and COUNTA functions with formula examples
Learn how to count the number of cells with various data types. What data is processed by COUNT? How does COUNT differ from COUNTA? What can I count with these functions? Find out the answers to these and some other questions in today's article. Continue reading
Oct
19
Calculating time in Google Sheets: subtract, sum and extract date and time units
It's time to talk about the ways of calculating time in Google Sheets. We'll discuss the ways of finding time difference in detail, see how to sum dates and time together, and learn to display only date or time units and set them apart completely. Continue reading
Sep
7
How to work with conditional formatting in Google Sheets
Highlighting certain data with color is a great way to draw attention to the records. Wouldn’t it be great if such format change happened automatically for specific cells? This is where conditional formatting comes in handy. Google Sheets can do this work for us, all we need is to explain what we want to get. Continue reading
Jul
5
Google Sheets VLOOKUP with examples
A widespread opinion is that VLOOKUP is one of the most difficult and obscure functions. But that's not true! In fact, it's easy to do VLOOKUP in Google Sheets, and in a moment you will make sure of it. Continue reading
Jun
29
Google Spreadsheet COUNTIF function with formula examples
We continue exploring the possibilities of Google Spreadsheets with COUNTIF function. Learn why you may need it and how it can be applied to your daily work with the tables. Continue reading
May
16
Google Sheets IF function - usage and formula examples
Get to know Google Sheets IF function better with this tutorial: when it's used, how it works and how it contributes to a much simpler data processing. Formula examples are included! Continue reading
Jan
26
Google Sheets pivot table tutorial - make your job easier
Pivot table Google Sheets can help you to represent your data in a more convenient and presentable form. Continue reading
