The Spreadsheets Masterclass

The
Spreadsheets
Masterclass

The Google Sheets/Excel Course

Beginner to Advanced

Instructor: Yakir Havin

English

What You Will Learn...

MEET YAKIR

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.

WATCH TRAILER

MORE CLASS INFO

SIGN UP

About this Course

Yakir Havin
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

SIGN UP

Meet Your Instructor

Yakir Havin

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.

WATCH TRAILER

MORE CLASS INFO

LET'S DO THIS!

What they say.

Not too bad, huh?

Yakir's spreadsheet course was amazing - it's helping me personally & professionally. I can now streamline my work, which uses spreadsheets a lot... doesn't everyone? It is an investment that I'll have forever.

- Ben F.

Something I found valuable in Yakir's course was that after learning all the fundamentals, I felt confident to figure things out on my own. The mystery and fear of spreadsheets was gone.