No platform is perfect and that includes Google Sheets. However, these five tips will give your sheets an extra step-up! 1. Set Data Caching correctly to match your data
This is one of the trickiest, but most important steps. When you first set up a sheet, it’s going to ask which type of data you want visible: “Row-based” or “Column-based”. You should select “Row-based” unless your data is already organized in records per employee instead. Once this setting is set, you’re probably
Use COLUMNS over ROWS
Columns work better when you have to see huge numbers of items in your spreadsheet. Rows are good for things like text summarizing the numbers in a column. GoldMine has a built in feature with attributes to automatically handle Rows when you have more than 1 attribute in a row.
When working with multiple columns, you can use the F2 key to instantly make all of your columns into rows by pressing F2 on a column name. You can also select the top bar and single or multiple columns using your arrow keys, or marking them with Shift+Left/Shift+Right. Once all of the columns are selected, you can now add a few more rows to them.The text in your file can then be edited within Rows and Columns with F3. You may want to use the narrow or wide editing mode for Rows if you’ve got a long list of items, like for constructing GoldMine’s summary page. When moving around the list of items in Row, use your arrow keys and limit moves using Shift+Arrow keys. For simple copy and paste purposes within Columns in Row and Column, use End -End
Reduce number of SHEETS
Google Sheets can be a valuable tool for organizations to collaborate on tasks, as well as contribute to each others’ Excel documents by syncing them. However, it is important that users keep their Google Sheets pages up-to-date. One way to do this is with checklists. These will help the user stay organized and focused while they work in these sheets. true
Use enhanced features
Google sheets is a great way for students to manage their classwork. Google sheets also has many enhanced features beyond just storing notes, including automated forms and hot-keys. Many students are unaware of these features which can lead to them wasting time doing things incorrectly, or worse, not using the sheet at all. Below are five tips that will help optimize the sheet, and make it easier to get work done efficiently: Create multiple sheets. Typing on the same sheet, will make information appear in order, obviously. However many students have the tendency to skip around the sheet and end up with a disorganized sheet. This extra step leaves students tired and frustrated out of material that they had just finished. By creating 2 or 3 task sheets (while keeping it simple), students can quickly move between tabs, instead of keeping everything in their main working/assessment chart. Create an index tab. If navigation is
Access dashboards using Apps Script
Dashboards in Google Sheets allow you to keep an up-to-date and accurate overview of your data anywhere. You can also create dashboards that access third party APIs or view a certain data point from one or more sheets within the same spreadsheet. Once you have an API key, you can use your APIs Key in Apps Script.
To get started with Apps Scripting, Sign into Google for Work, and go to the Script Console at https://developers.google.com/work/script-console/. When you create new scripts or workflows, remember that only users with the appropriate permissions can see and run the script. See Run Google Sheet Dashboards in this document for more information about signing up.
These instructions assume
Import data using Spreadsheets
importing data into your sheet is a good way of working with large amounts of data. Calculations happen on the spreadsheet and will do advanced functions to make sure you get the calculation results in cells that match the criteria. Automatic backup of your data a great way of ensuring that you have the data backed up in the first place and exported at regular intervals.
Two steps are worse than clumsy, indecisive traditional forms and imprecise interfaces but rather inexact integration and automation . . . .