Posts Tagged 'Google Sheets'

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

Excel add-ins and Outlook tools -
Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Older posts →