BC Physical Geography Spreadsheet Tutorial.
       Author Dr. Craig Nichol Creative Commons 4.0 BY NC SA
       Version 1.5  July 27 2020.
       Welcome
       This Excel Workbook has been created to provide tutorials on how to use spreadsheet software to conduct basic data storage, calculations and graphing.
       These tutorials are not intended to be all done at once, but to be done on an as-needed basis.
       Several labs in the BC Physical Geography lab manual utilize spreadsheets for calculations or for graphing.  
       The lab instructions will list specific tutorials, or tutorial sections, that should be completed and practised prior to coming to the lab.
       General Instructions
       Menu options or keyboard commands are contained within <> marks.  
       For example,  indicates that the mouse button should be double clicked.
         would mean that on the upper menu you should use the left mouse button to click on the Tools menu,
       and then select the Options sub-menu
       Cell B20 is highlighted in green.  In this spreadsheet tutorial, green or white cells are used to indicate places where you should be entering data.  
       Cell B22 is highlighted in red.  In this spreadsheet tutorial, red cells are cells in which you should not change the values otherwise the tutorial may not function.
       A large space will be shown to separate the text you should write.
       If this includes single quotes ' or double quotes “ these characters should be entered
       For example, if you are asked to enter the number twelve into a cell, the text will say     
            Type              12             and press  will enter the number 12.
            Type              '12            and press  will enter the text characters 1 and 2.
       Software and Hardware
       These tutorials have been written for Microsoft Excel on a computer running Windows 10 equipped with a mouse.
       The tutorials can be opened in OpenOffice Calc, Google Sheets, or other common spreadsheet software.
       However, some of the functions, and the screenshots will not be the same in other software.
       These tutorials are not intended to be opened in mobile operating systems versions of Excel, or on a touchscreen based phone or tablet.
       A version for OpenOffice Calc is in preparation (July 2020).
       PC vs Mac
       In some cases, some guidance has been given in the tutorials on how those using MAC versions of Excel may find the experience to be different.
       The  and  instructions for PC can translate as  and  in most cases.
       The  instruction to reveal the target cells of formulas on a PC can be achieved by a  on either a MAC or PC.
       Please email craig.nichol@ubc.ca with suggestions for PC vs MAC instructions.
     Edits, additions and Updates
     Please email craig.nichol@ubc.ca if you have suggestions for edits or improvements.
     Instructors: 
     Version 1.5 is the first public release of this spreadsheet.
     Please email to craig.nichol if you adopt this tutorial in your course.
     Please send suggestions of how the tutorials can be best arranged to suit the types of spreadsheet skills you expect in your course.
     Licensing and Attribution
     This work by Craig Nichol is licensed under CC BY-NC-SA 4.0
     This spreadsheet may be modifed or adapted. 
     An attribution must be made to the the original spreadsheet:
     This spreadsheet may not be used for commercial purposes.
     Any derivatives must be released under the same licence.
     Author:  Dr. Craig Nichol, Earth, Environmental and Geographic Sciences, Univerity of British Columbia Okanagan.
              Please email to craig.nichol@ubc.ca if you adopt this tutorial in your course, or with any suggestions or edits.
     Acknowledgements:
     Peer Reviewers: Stuart MacKinnon, UBC (June 2020)
              Nina Hewitt, UBC (June 2020)
              Crystal Huscroft, TRU (June 2020)
This Excel Workbook has been created to provide tutorials on how to use spreadsheet software to conduct basic data storage, calculations and graphing.
These tutorials are not intended to be all done at once, but to be done on an as-needed basis.
Several labs in the BC Physical Geography lab manual utilize spreadsheets for calculations or for graphing.  
The lab instructions will list specific tutorials, or tutorial sections, that should be completed and practised prior to coming to the lab.
  would mean that on the upper menu you should use the left mouse button to click on the Tools menu,
Cell B20 is highlighted in green.  In this spreadsheet tutorial, green or white cells are used to indicate places where you should be entering data.  
Cell B22 is highlighted in red.  In this spreadsheet tutorial, red cells are cells in which you should not change the values otherwise the tutorial may not function.
These tutorials have been written for Microsoft Excel on a computer running Windows 10 equipped with a mouse.
The tutorials can be opened in OpenOffice Calc, Google Sheets, or other common spreadsheet software.
These tutorials are not intended to be opened in mobile operating systems versions of Excel, or on a touchscreen based phone or tablet.
In some cases, some guidance has been given in the tutorials on how those using MAC versions of Excel may find the experience to be different.
The  and  instructions for PC can translate as  and  in most cases.
The  instruction to reveal the target cells of formulas on a PC can be achieved by a  on either a MAC or PC.
Please send suggestions of how the tutorials can be best arranged to suit the types of spreadsheet skills you expect in your course.
Dr. Craig Nichol, Earth, Environmental and Geographic Sciences, Univerity of British Columbia Okanagan.
Please email to craig.nichol@ubc.ca if you adopt this tutorial in your course, or with any suggestions or edits.