Even if you don't work with or around spreadsheets on a daily basis, you likely understand the basics: data (names, numbers, dates) are placed into cells and organized into rows and columns. Although ...

You can use VLOOKUP with Google Sheets; it's similar to how the function works in Excel. The VLOOKUP formula can find values in tables on the same sheet or a different sheet, but it can only find ...

While there are all kinds of spreadsheet programs for professionals, sometimes you just need a place where you can fumble around with some formulas while you attempt to make a monthly budget. Making a ...

To sum and subtract in Google Sheets, use the formula =SUM(x:y) or =MINUS(x,y) in the desired cells and input the relevant values. Press Enter to get the results. Adding up columns or rows of numbers ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...

Manually sifting through a giant Google Sheets file isn't efficient. A built-in search function can look through all your open documents in seconds. In addition to Google's Find function, there are ...

Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you’re trying to analyze. For example, typing “=” ...

Welcome to TNW Basics, a collection of tips, guides, and advice on how to easily get the most out of your gadgets, apps, and other stuff. From budgeting and keeping track of your investments, to ...