THE SPREADSHEETS TRAINING

Yakir Havin

The Google Sheets/Excel Course:

Beginner to Advanced

6 hours 30 minutes (58 video lessons)
Language: English

GET FREE ACCESS

WHAT YOU WILL LEARN

In this spreadsheet crash course, you will learn:

Fundamentals as well as advanced functions of Google Sheets/Microsoft Excel.
Formatting tricks to create beautiful and functional spreadsheets.
Skills to analyze data sets and automate business processes using functions and formulas.
Expert hacks to organize and present data professionally.
Hidden features as well as shortcuts to improve your workflow.

ABOUT THIS COURSE

6 Hours 30 Minutes (58 Video Lessons)

MODULE 1:

FRAMEWORK

Getting started with spreadsheets
User interface
Spreadsheet management

MODULE 2:

FOUNDATIONS

Spreadsheets best practice and skills- Structure, Normalization, Cell format, Freeze panes, Sorting, Filtering
Introduction to functions and formulas - Function syntax, Cell referencing

MODULE 3:

FUNCTIONS I

Introduction
Logical functions: AND, OR, IF, Nested IF
Mathematical functions: COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MIN, MAX, MEDIAN, MODE

MODULE 4:

FUNCTIONS II

Lookup functions: VLOOKUP, VLOOKUP- approximate match, SEARCH, INDEX, MATCH
Text manipulation functions: LEN, TEXT, LEFT, RIGHT, MID, SPLIT

MODULE 5:

FORMULAS

Introduction
Container functions: IFERROR, ARRAYFORMULA
Combining functions into formulas: IF / AND, IF / Blank, VLOOKUP / MATCH, INDEX / MATCH, MID / SEARCH

MODULE 6:

FEATURES

Introduction
IMPORTRANGE
Data validation
Dynamic labeling
Pivot Tables
Honorable mentions
Takeaway lessons

GET FREE ACCESS

ACADEMY INSTRUCTORS

Learn from the best in Google Sheet/Excel Course.

YAKIR HAVIN

ACADEMY INSTRUCTOR

Born and raised in Melbourne, Australia, Yakir has been involved in computers in some form since second grade. Throughout high school and then while studying Commerce and Computer Science at university, this interest blossomed into something more substantial. Yakir began to understand the power of spreadsheets, and they have since helped him in many corners of his life: from keeping track of income and expenses, to winning a Victorian state award in Information Technology, to getting a job as a Data Analyst at Charidy.com. Yakir has a passion for educating people about the many personal and work-related benefits of spreadsheets.