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
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
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
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
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
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
Pivot table Google Sheets can help you to represent your data in a more convenient and presentable form. Continue reading
