Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.
You can use the COUNTIF function in Google Sheets to find the number of items in a range that meet certain criteria.
You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.
You can use the IMPORTRANGE function in Google Sheets to easily copy data from one spreadsheet to another.
You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.
A CSV (comma-separated values) file is a simple text file in which information is separated by commas, and is common in spreadsheet apps.
To help secure your Google Drive, use two-factor authentication and be careful when giving other apps permission to use your Drive.
To convert an Excel file to a Google Sheets spreadsheet, you need to upload the Excel file to Google Drive. Once you’ve uploaded the Excel file to Google Drive, you can save it as a Sheets file. You can adjust your settings in Drive so that Excel files are automatically […]
You can see the edit history for cells in Google Sheets to track changes and help prevent mistakes in a spreadsheet. The feature is useful for collaborative work or for people who use the same spreadsheet frequently and need to update data. Visit Business Insider’s Tech Reference library for more […]
You can use Google Sheets keyboard shortcuts to save time and make the most of the spreadsheet program. The keyboard shortcuts perform the same functions regardless of platform, but require you to press different keys depending on whether you’re using Windows or MacOS. Visit Business Insider’s Tech Reference library for […]
The best Google Drive add-ons give your Google apps new capabilities and, in those we’ve selected, allow you to work more efficiently or creatively. You can add extra features to Google Drive apps using a library of add-ons available from the Add-ons menu in any of the Google apps. Most […]
To become a Google Drive master, you should know all of Google Drive’s best tips and tricks. Many are given to you right from the start, but some of Google Drive’s best features are hidden or require installing a free add-on for your browser. Below are 19 of the best […]
You can easily copy a Google Sheet into a new or existing spreadsheet with a few clicks on your desktop. You can either right-click on the sheet that you’d like to duplicate or select “Edit” from the top menu bar. You use basically the same method to copy a Google […]
You can convert Google Sheets files to Excel files by using the “Download” option. Google Sheets allows you to download your spreadsheets in a format that can be opened in Microsoft Excel. Visit Business Insider’s homepage for more stories. Google Sheets and Microsoft Excel are similar in many ways. They […]
You can change the date format in Google Sheets and customise the appearance of calendar dates. Google Sheets is similar to Microsoft’s Excel application, but is web-based and offers a few different features. Visit Business Insider’s homepage for more stories. Google is the most popular search engine, and it also […]
You can sort alphabetically in Google Sheets to help you better organise term data in your document. Here’s how to sort alphabetically in Google Sheets on desktop or on mobile. Visit Business Insider’s homepage for more stories. Google Sheets is Google’s answer to Excel, helping you to create a multitude […]
You can easily hide rows in Google Sheets in a few quick steps on a computer or mobile device. You can also unhide rows in Google Sheets using the same method. Visit Business Insider’s homepage for more stories. You can hide rows in Google Sheets just as easily as in […]
Next Page »