Course Overview

In Google Sheets Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target delegates for this course are those who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

Course Content

• RECAP of performing calculations in Sheets

  Adding and Subtracting Numbers
  Multiplication and Division
  Understanding BODMAS
  Cell references
  SUM function
  AUTOSUM
  Useful Basic Functions AVERAGE, MIN, MAX and COUNT

• Using Absolute Referencing

  Difference between Relative and Absolute References
  Absolute Reference and the Dollar Sign
  Why use Absolute References?
  Using an Absolute Reference in a formula
  

• Naming Cells (Ranges)

  Giving names to cells and ranges of cells
  Names in formulas
  Editing and deleting names
  

• Linking within a workbook

  Linking within a workbook
  Simple referencing in a worksheet
  Calculating across multiple sheets
  

• Calculating Data with Logical Functions (IF Function)

  IF functions
  IF function criteria
  Using IF’s to test or check your data
  

• Conditional Formatting

  Conditional Formatting Types
  Highlight Cells different colours based on their value
  Single colour and colour scales
  Customising Conditional Formatting
  

• Performing Date and Time Calculations

  Date Shortcuts
  TODAY and NOW functions
  DATEDIF function
  YEAR, MONTH, DAY, TEXT functions
  NETWORKDAYS function

• Comments

  Adding, Editing and Deleting Comments

• Cleaning Data

  Remove Duplicates
  Trim whitespace
  Use Clean up suggestions

• Data Validation

  Specifying validation criteria
  Controlling entry into a cell
  Types of Validation Criteria
  Creating a drop-down list
  

• Security

  Protecting a range or a worksheet

• Presenting Data Using Charts

  Creating a chart
  Modifying charts
  Formatting charts
  Advanced Chart Features
  

• Slicers

  Using Slicers

• Sharing and Collaborating

  Sharing in Sheets
  Emailing a Document as an Attachment
  Collaborating in Real-Time