Get WordPress
Headlines
Loading...

 Whether you are tracking student enrollment costs or tracking clients in the CRM homebrew (as we will establish in Chapter 3), you will want to organize and format your data.

The basic formatting options in Google Sheets are at the top of your first cell. They are labeled in the image below, but for quick reference while you are working on the sheet, just hover over the icon to see its description and shortcut keys.



Print, undo, and font / style settings are similar to what you would expect from your favorite typewriter. Shortcut keys are the same, so just treat it like you are editing another file!

For everything else, the best way to show you how things work is to go into examples.

I will make a quick list of potential breakfast options for tomorrow, along with ingredients, pricing and a link to a YouTube video for how to make (who knows, you can make a 3 minute video about fried eggs ?)


It has enough functions that you can easily use it to track information. In fact, most of my personal spreadsheets look like this - Google Sheets makes it very easy to capture information, share it and come back to it later for reference as it acts as a structured recorder. My high.

But suppose you have to deal with dozens of spreadsheets a day (or worse, you have to share spreadsheets going forward) and this is what someone sends you. It's really boring and if it's a big data set it's going to be painful to go through.

For the simple example above, the lack of a key profile is "okay". It basically saves my information and allows me to save it. But it's not something I want to come back to every day.

Since I eat breakfast every morning, please take some time to make this spreadsheet easier to use with some form!

First we will "freeze" the first row in place. That means that if we scroll down the spreadsheet, the first row will still be visible no matter how much data is under it. This allows you to have a long list and helps keep tabs on what you are actually viewing.


0 Comments: