Loading

Alison's New App is now available on iOS and Android! Download Now

Study Reminders
Support
Text Version

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

Google Sheets for Home and Business SummaryThe key points from this module are:
Opening a Google Account & How to Use ItOpening a Google account: Create a user’s account on Google with your details, and verify your information to be able to access the Google sheets application and other docs.Google Drive: This is Google’s storage service for saving or storing your spreadsheets. It is a cloud-based service that gives you 15 gigabytes of data to store your files. It can be used for organizing your files and folders. Likewise, it allows you to modify the folder colours, name a file, and customize the file options in the template gallery.Create new documents with Google sheets: This task involves a simple process. From your Google account, click apps and select Google sheets. Open the spreadsheet and select ‘New Spreadsheet’ under the file menu, then, select a blank sheet or template to create a new document.The autosave feature of Google sheets: Spreadsheets are saved automatically to your Google Drive, which is hosted on Google servers. The Google Spreadsheet MenusFile menu: The menu contents can be used for creating new documents, print your spreadsheets, open an existing document, etc.Edit menu: The menu contents include cut, copy, paste, etc.View menu: The menu contents include zoom, gridlines, formula bar, freeze, etc.Insert menu: For inserting objects. You can insert rows, columns, new sheets, cells, images, charts, etc.Data menu: For sorting, filtering and sorting data. It also contains the button/icons and functions for data validation.Tools: Can be used to create a form, edit scripts, check spellings, etc. It also has a personal dictionary feature, and protect sheet feature for protecting your spreadsheets.Add-ons: For adding applications and pluginsHelp menu: For searching or seeking technical support, knowledge base, and for reporting problems/bugs or copyrights abuse.Google sheets also has secondary menus, which contain vital buttons and icons that can be used to analyse your data.Understanding Rows Columns and CellsRows: Refers to the horizontal grouping of cells defined by a number usually found at the left side of the spreadsheets (e.g. 8 or row 8).Columns: Refers to the vertical grouping of cells, defined by a letter (.g. B or column B). They can be found at the top of spreadsheets after the main and secondary menus.Cells: Are the specific, box shaped location defined by a number and a letter (e.g. cell E5).Beginner FormattingThis refers to the various menu content/options used to format font sizes, font-weight, text colour, text wrapping style, etc. You can fix typing (typographical) errors with the undo or redo functions and perform other operations.Formatting texts in Google sheets: This refers to the procedure for changing text properties/styles in your spreadsheets.Text wrapping: This refers to the system whereby users can change the length or lines of texts within a cell, by defining whether it should be truncated, rolled to the next line or displayed as it is (usually by using the tools in your Google sheets app).Merge cells: This refers to the method for adding two or more rows into one big cell to create a text header or content header. You can unmerge merged cells by using the undo function.Format painter: This refers to the tool that allows users to use artistic or fanciful fonts to display texts. It allows users to be able to clone the formatting styles/properties of one cell and implement it into another cell.Border tool: This refers to the tool for changing the border styles and properties of a cell.Changing cell colours: Using the fill colour tool to apply background colour to a cell.The altering colours tool: It implements an alternating colour scheme within a defined range.Freezing rows and columns: This can be achieved by using the freeze tool that allows users to keep a row or column pinned to the top or left of the sheets so that it is always visible no matter how far you scroll through the sheets.Working with Numbers and Basic FormulasThe 5 primary operations of the function button/icon (Sigma), includes the sum, average, count, max, and min computation. The formulas will be used with figures to provide shortcuts for processing data to get prompt results.Sort tool: It allows you to arrange pieces of data in a particular order based on your specifications. Information can be arranged in ascending or descending order.Filter tool: It allows users to hide irrelevant data from view, based on a series of user-defined parameters. Filtering information involves setting a specific parameter or conditions (or values) for categorizing your data.Rank tool: It is a tool that allows you to create a ranking order, which is independent of, but based on, the original dataset.Fill handle: The small square in the bottom right corner of every cell in a Google sheets. When used, the fill handle allows the user to:i. Copy data from one cell to anotherii. Create sequential steps forward through proceeding cells based on a series of user-defined parameters.Auto sum and Average tool: This tool provides the functionality which automatically finds the sum, average, maximum, minimum, and counts for a set of selected or highlighted numbers.Data validation: It enables users to create rules surrounding cell inputs, thereby issuing warnings or rejecting the inputs altogether if the data does not align with the set rules. The feature is also used for creating dropdown lists. Data that can be validated include lists from a range, a list of items, numbers, texts, dates, etc.Essential formatting and Analysis TricksConditional formatting: This is a feature that allows Google sheets users to be able to create formatting changes in cell ranges based on rules and specifications. When the predefined conditions are met, the condition for the cell formatting will be fulfilled. The formats are added using ‘new rules’.Paste Special: This tool allows you to paste the attributes of a string, including the value, formatting, data validation or conditional formatting properties of the string without pasting everything from the original copied source.