Google Sheets

On this page there are the following Google Sheets tutorials:

1. An overview of the Google Sheets workbook and worksheet 

2. Entering data into cells, using autofill

3. How to format data in cells

4. Create charts from your data

5. Write formulas to manipulate your data

6. Learn how to format cells conditionally, so that your data is easily readable

7. Learn the Countif formula, a great tool for counting your text based data

8. How to share charts to Google Docs and for them to update as you change your Google Sheet data

9. How to share data between different worksheets in workbook

10. How to freeze rows and columns in a worksheet

11. How to split text into columns to clean up your data

12. Create checklists with the tick box feature

13. Create drop-down lists from the smart chip feature

14. Use the smart chip feature to assign people, dates and documents to your worksheet