Yakir Havin
The Google Sheets/Excel Course:
Beginner to Advanced
6 hours 30 minutes (58 video lessons)
Language: English
WHAT 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.


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


Learn from the best in Google Sheet/Excel Course.

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.
ENTER YOUR DETAILS