G-TABH

New Google Spreadsheets - Advanced

Google Spreadsheets courses level two
Form of participation
Form of training
Length of training
  • 2 day (2×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

The course is designed for users with a working knowledge of Google Spreadsheets basics, who are expected to use Google Spreadsheets on a daily basis, and to create and format more complex spreadsheets, apply common functions and formulas, and create and format charts.

Suggested For

The course is also recommended for users who have advanced skills in other spreadsheet programs, such as Microsoft Excel, but have never worked with Google before.

Outline

LOGICAL STATEMENTS AND FUNCTIONS

  • Logical statements
  • IF, IFS, AND, OR, NOT functions
  • IFERROR, COUNTIF(S), SUMIF(S), AVERAGEIF(S) functions

SEARCH FUNCTIONS

  • VLOOKUP, MATCH, INDEX functions

TEXT FUNCTIONS

  • LEN, LEFT, RIGHT, MID functions
  • TRIM and CLEAN functions
  • FIND, SEARCH functions
  • REPLACE, SUBSTITUTE functions
  • Text concatenation

DATE AND TIME FUNCTIONS

  • Date and time data basics
  • TODAY, NOW, YEAR, MONTH, DAY functions
  • TIME, TIMEVALUE, HOUR, MINUTE, SECOND functions
  • WEEKDAY, NETWORKDAYS, WORKDAY functions

NESTING OF FUNCTIONS

  • Rules for writing compound functions

DIAGRAMS

  • Creating a diagram
  • Formatting a diagram

MINIDIAGRAMS

  • Creating a minidiagram
  • Editing a minidiagram
  • Delete a minidiagram

CONDITIONAL FORMATTING

  • Entering simple conditions
  • Condition with formula/function

DATA VALIDATION

  • Data validation with list
  • Validation by date
  • Validation using formula/function

EXPLANATION

  • Preparing a statement
  • Formatting a statement
Outline (PDF)

Prerequisites

Completion of or knowledge and practice of the Google Spreadsheets - Basics course.