## Google Sheets - training contents

Excelkurs Direkt provides courses in Google Sheets, which is an online spreadsheet service very similar to Excel. Below are examples of available modules and topics.

• Setup account
• Types of data in cells
• Navigate spreadsheets with keyboard shortcuts
• Basic content formatting

## Basic functions

• Basic calculation functions (SUM, COUNT, AVERAGE, ...)
• Common functions (COUNTA, MAX, MIN, ...)

## Rounding and randomizing

• Randomise values (RAND, RANDBETWEEN, ...)
• Round values (ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, MROUND, ...)

## Conditional functions

• Name cell ranges
• Make decisions (IF)
• Use logic functions (AND, OR, NOT, ...)
• Nest IF statements (IF(IF(...))) versus IFS function
• Highlight cell contents with conditional formatting
• Calculate values conditionally (SUM + IF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, ...)

## Errors and handling errors

• List of all possible errors and their typical causes
• Handle formula errors (IFERROR)

## Sorting and filtering

• Set up for sorting and filtering
• Sort lists
• Filter lists
• Sort and filter using functions (ARRAYFORMULA)

## Charts, diagrams and graphs

• Introduction to charts, graphs and diagrams
• Create charts
• Comparison with Microsoft Excel capabilities

## Data analysis and lookups

• Find data using key values (VLOOKUP, HLOOKUP, XLOOKUP, ...)
• Understand complex lookups (INDEX, MATCH, OFFSET, XMATCH, ...)
• Sort and filter using matrix functions (ARRAYFORMULA)

## Pivot tables

• Handle raw data
• Use the section format
• Introduction to pivot tables
• Intermediate pivot tables
• Comparison to Microsoft Excel pivots / Power pivots

## Cleaning text data

• Introduction to Text Functions: Adding words together and changing their case
• Extract words/ characters / id's from text (LEFT, RIGHT, MID, LEN, ...)
• Benefit from other text functions (SUBSTITUTE, TRIM, ...)

## Transforming date and time data

• The Excel date and time system
• Get current values (NOW, TODAY, ...)
• Create dates and time from values (TIME, DATE, ...)
• Calculate dates in future and past (EDATE, EOMONTH, ...)

## Data validation

• Data validation overview
• Restrict valid cell values