Posts Tagged 'Google Sheets'
How to calculate percentage in Google Sheets - formula examples included
You may think percentage calculations are useful only if you use them for work. But in reality, they help you in everyday life. Do you know how to tip properly? Is this discount a real deal? How much will you pay with this interest rate? Come find the answers to these and other similar questions in this article. Continue reading
How to compare data in two Google sheets or columns
Whether there's summer knocking on our doors or winter invading Westeros, we still work in Google Sheets and have to compare different pieces of tables with one another. In this article, I'm sharing ways of matching your data and giving away tips on doing that swiftly. Continue reading
Merge data from duplicate rows in Google Sheets based on a unique column
Combining duplicate rows in your spreadsheets may turn to one of the most intricate tasks. Let's see what Google formulas can help and get to know one smart add-on that does all the job for you. Continue reading
Convert formulas to values in Google Sheets
In this article, you will learn about two ways of replacing all formulas with their results in a spreadsheet. Continue reading
Google Sheets: everyday formulas examples
Google Sheets is a great platform to manage data tables. But are there any easy functions you can use for daily calculations? Find out inside. Continue reading
Back to Basics: create and edit Google Sheets formulas
After reading this article, you’ll be able to make and edit your own simple Google Sheets formulas. Here you’ll find examples of nested functions and a few tips on how to swiftly copy a formula to other cells. Continue reading
Back to Basics: formulas in Google Sheets
Today I'm going to bring formulas in Google Sheets to the table. I'll start with the elements they consist of, remind you how they are calculated, and tell a difference between plain and complex formulas. Continue reading
If VLOOKUP in Google Sheets is not working
How to do a Vlookup without errors in Google Sheets? Take a closer look at the most common mistakes made when working with the VLOOKUP function. Continue reading
Ways to move, merge, hide, and change rows in Google Sheets
Google Sheets lets you manage rows in many different ways: move, hide and unhide, change their height, and merge multiple rows into one. A special styling tool will also make your table easy to understand and work with. Continue reading
SUMIFS in Google Sheets to sum cells with multiple criteria (AND / OR logic)
Google Spreadsheets provide two functions to conditionally sum cells, SUMIF and SUMIFS. Regular visitors of our blog are already familiar with the SUMIF function that we covered last week, and today we are going to have a closer look at its plural version. Continue reading
SUMIF in Google Sheets with formula examples
Google Sheets has two functions to add up numbers based on conditions: SUMIF and SUMIFS. The former evaluates just one condition while the latter can test multiple conditions at a time. In this tutorial, we will focus solely on the SUMIF function. Continue reading
Working in Google Sheets: add, freeze, and remove rows
It's time to learn more about rows in Google Sheets. Learn how to insert new rows to your table – one or many at once; freeze lines in a spreadsheet in a few clicks; delete selected or only empty rows in your table. Some useful shortcuts and the add-on are there to ease your work. Continue reading
Filter by condition in Google Sheets and work with filters in shared documents
Filters make working with Google Sheets a lot easier even when you work within a shared document. Fine-tune filtering options and apply filters based on your own formulas. To share different filters with people, get to know Filter Views option. Continue reading
How to add and use filters in Google Sheets
When you analyze your tables in Google Sheets, very often you need only a limited amount of information, while the table may contain dozens of additional datasets. Here's your chance to learn how to filter your data in Google Sheets. Continue reading
Columns in Google Sheets - split text to columns and convert columns to rows
I'd like to share with you a few more pieces of advice about columns in Google Sheets. If you ever needed to split the content from one column into separate ones or turn the table around so that columns become rows, this is your lucky day. Today I'm going to reveal a few quick tips on how to do that. Continue reading
Columns in Google Sheets - move, merge, hide and freeze columns in a spreadsheet
Today I invite you to learn a little bit more about columns in Google Sheets. Did you know that you can move and hide columns in your spreadsheet? And what about freezing and merging them? Let's explore these functions together! Continue reading
Columns in Google Sheets - add, delete, and resize columns in a spreadsheet
Let's get back to fundamentals of working with columns in Google Sheets. Today I want to remind you all the ways of adding new empty columns, deleting old or unnecessary ones, and resizing them so that all the data you have is visible. This knowledge is the basis of any work within a spreadsheet. Continue reading
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
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
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
Date and time in Google Sheets: enter, format and convert dates and time in your sheet
Today we dig into the ways of working with dates and time in Google spreadsheet. See the ways of inputting date and time values into your table, learn why you may need to convert them to decimal, and find out about custom number formats Google tables offer. Continue reading
How to add, edit and delete checkboxes and drop-down lists in Google Sheets
When you work with Google spreadsheet, sooner or later you might need to use some functionality that you've never used before. Checkboxes and drop-downs can quickly turn out to be such features. Let's see how useful they can be in Google Sheets. Continue reading
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
Back to Basics: edit and comment on data, review the changes, print and download from Google Sheets. Even offline
We continue our "Back to Basics" journey by digging deeper into editing Google Sheets. Today, in addition to learning some simple features like formatting and deleting the data, we’ll discuss how to add comments and notes, work offline, and quickly review all the changes made to the file. Continue reading
Back to Basics: sharing, moving and protecting the data in Google Sheets
Moving on to another stop of our "Back to Basics" journey, today I will tell you more about managing your sheets. Learn how to share, move and protect your data in Google Sheets. Continue reading
Google Sheets Chart Tutorial
Whether you analyze business indicators, make presentation or write a report, charts and graphs will help your audience to understand complex dependencies and regularities. This tutorial will teach you different ways to build charts and graphs in Google Sheets to make your presentations informative and impressive. Continue reading
Back to Basics: Google Sheets for newbies
It's not a secret that most people are used to work with the data tables in MS Excel. However, now it has a worthy competitor. Allow us to introduce you to Google Sheets. Continue reading
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
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
Google Sheets IF function - usage and formula examples
Get to know Google Sheets IF function better with this tutorial: when is it used, how does it work and how it contributes to a much simpler data processing. Formula examples are included! Continue reading
