• HOME
  • LOGIN

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.

 

-  C. Fried 

 Yakir's spreadsheets course stood out

for me because he explained not only the how, but also the why!

This course is now proudly affixed on my resume.

- Moshe Green

SIGN UP

Choose a Plan.

Immediate two-year access to your DAASS course.

Online Instant Access

 

  You will receive access to the course via email immediately. 
         $600        
 $450
SIGN UP
USB Option

Your USB will be shipped out to your address in the next 3 business days.

$650
$500
SIGN UP

© Copyrights by DAASS All Rights Reserved.

PRIVACY POLICY TERMS OF USE

Got questions? Text or WhatsApp 718-400-9877

{:lang_general_banner_cookie_disclaimer}
{:lang_general_banner_cookie_cookie} {:lang_general_banner_kartra_cookie}
{:lang_general_banner_cookie_privacy}
{:lang_general_powered_by} KARTRA