Frozen rows and columns
You can use the Freeze Panes feature to freeze rows or columns. For example, if you want to keep a column of data visible while scrolling down through the rest of your spreadsheet, then you can freeze that column. If you want to keep a row of data visible while scrolling down through the rest of your spreadsheet, then you can freeze that row instead.
If you have frozen rows and columns in your sheet and move one of them around (by dragging it), then they won't revert back once they're un-frozen again!
Time-based events
-
The DATE function returns the current date, or a specified date in a range of dates.
-
To return a specific date using the DATE function, use an open-ended number (no closing parenthesis) followed by the year, month, and day. For example: =DATE(2012,1,10).
-
The DATEVALUE function converts a text string into its date value. For example: =DATEVALUE("11/7/2016").
-
The WEEKDAY function returns the day of week for the given date; it's useful if you want to display your data in different ways for different time periods (such as Monday through Friday).
Highlight and annotate
-
Highlight cells or ranges of cells, and add comments to them. You can highlight multiple cells at once, but you must first select the range of cells that you want to highlight before selecting the Highlight feature from the Home menu.
-
Use the drawing toolbar to add shapes, lines, text and images in your spreadsheet. This feature is available while editing a cell. To access it, click on Drawing Toolbar icon on the View tab or press Ctrl+Shift+M keys together (Windows) or Command+Shift+M keys together (Mac).
-
Use arrows for visualizing data relationships:
-
Arrows can be used to visualize directional flows within a model by drawing links between activities such as start/end times or cost estimates with their related activities and processes resulting from those activities
-
Arrows can also be used to indicate variable quantities (e.g., an arrow pointing towards a number will indicate that quantity increases by one unit when clicked)
Import data from Google Analytics
Google Analytics is the leading platform for measuring website traffic and data. But sometimes it can be hard to get the information you want out of Google Analytics. To make things easier, you can import your website data into Sheets and quickly start analyzing it with a few clicks.
To import data from Google Analytics, go to Google Sheets and click File > Import > More (the icon with three dots). In the menu that appears, choose "Google Analytics" under "More sources." This will open a new window where you can select which account you'd like to use (if applicable) and which report(s) have some data that needs importing. Once selected, click "Next step." The next step will allow you to choose how many rows of data should be imported into each new sheet based on how much time has passed since its last update; then click "Import" at the bottom right of your screen.
Ensure historical data accuracy
It's important that you have reliable data when it comes to your business. Even if the data doesn't change much from day to day, there are times when it may be necessary to ensure that everything is accurate.
One way you can do this is by using a formula that calculates the difference between the last row and whatever row is currently active in your spreadsheet. For example, let's say we're calculating how many days it has been since our company was founded: Our starting date would be listed as “1/1/2018” in cell A1. In order for this formula work correctly, we need to enter =SUM(D7:D10) into cell C7 (where D7 contains 1/1/18 and D10 contains today's date). The resulting value will tell us how many days have passed since our initial launch date; entering this value into our first month column will allow us to get an accurate count of all time periods covered within our dataset
Start a new spreadsheet quickly
Starting a new spreadsheet quickly is simple.
-
Click the “Create” button in the upper left corner of Google Sheets.
-
Enter a title for your new sheet and click “OK” to create it.
-
Or, if you already have a spreadsheet open, use keyboard shortcuts:
Ctrl + N (Windows) or ⌘ + N (Mac) to open a new window and start from scratch;
Ctrl + O (Windows), ⌘ + O (Mac), or Ctrl + Shift + P (on some Chromebooks) to open another tab; or
Ctrl + Shift + M for all three above options at once!
Read range names/cells with structured references
If you've ever worked with a spreadsheet, you know that they're not much to look at. Unless you're using Google Sheets, the writing and formatting in spreadsheets can be cumbersome. But there's another way of looking at these documents that is more flexible, readable and powerful than what you may have first seen: structured references.
Structured referencing lets you read range names or cell values by referring to them with an easy-to-use syntax instead of manually entering the exact cell reference each time (which can get tedious). Let's take a look at an example:
Master these tips for better business spreadsheets.
-
Frozen rows and columns: One of the most useful tools in Google Sheets is the ability to lock a row or column so that it remains in place as you scroll through your spreadsheet. This can be especially helpful when you're tracking time-based events, such as event dates.
-
Time-based events: Another helpful tool is the ability to highlight data based on time intervals, such as days or hours. This feature can also be used with frozen rows/columns to help visualize important pieces of information over time.
-
Highlight and annotate: As an alternative method for highlighting cells in Google Sheets (to indicate important values), use "Annotate" under "Format" -> "Styles," which lets you draw lines around cells and add comments directly onto spreadsheets. While this feature isn't quite as user friendly as some other methods (like highlighters), it does provide additional functionality by letting users add notes about what each highlighted value means for their business's success metrics--or even just why they chose it!
-
Import data from Google Analytics: If your business already uses other analytics tools like Google Analytics, there are many ways to bring those numbers into your spreadsheets so that they're easier accessible and more accurate than ever before! Just link up those accounts under "Connected Apps", then select which ones will give access - everything else should happen automatically after that!