Another application for Google Sheets is to keep track of the ages of characters in a novel or memoir that spans several years. The example below also shows the use of functions, the difference between relative and absolute addresses. and how to freeze row and column headings while scrolling the rest of the cells down … Continue reading Table of Ages
My initial objective was to learn WordPress and spend three months blogging about my Chromebook. I have tried to cover the basics: the Google platform, "What is a Chromebook," basic word processing, spreadsheets, and how to get Google Drive with the office apps on a Macintosh or PC. A good book for learning and reference … Continue reading Now what?
Files available on Google Drive are maintained on storage protected by Google. By signing on to a Google account, the owner can access these files from any computer, tablet or smartphone with internet access. The owner can also email files or share them by specifying collaborators under the File menu of Google Docs, Sheets, or … Continue reading File Storage
Have you ever found a receipt in your jacket pocket a month or two later? With a paper journal it may not be possible to tuck it in sequence where it belongs. With a spreadsheet, it's as easy as one-two-three: select the nearest date, Insert a new line, and type that outlier where it belongs. … Continue reading More about Spreadsheets
Tracking expenses should be as close to effortless as possible. For my purposes, a business-sized envelope and a spreadsheet suffice. Once a month I collect and enter receipts in the spreadsheet and add them, face down, to the envelope. This keeps the original records roughly in chronological order. Set up new Google Sheets file Information … Continue reading Expense Journal