Course curriculum

    1. Welcome to the Formulas Crash Course!

    1. Introducing Formulas and Functions

    2. Finding Data with VLOOKUP

    3. Transposing your Data

    4. Finding Data with HLOOKUP

    5. Using SUMIF, SUMIFS, COUNTIF

    6. Using Index and Match

    7. Using SUM, AVERAGE, MIN, MAX, ROUNDUP, ROUNDDOWN

    1. Congratulations!

About this course

  • $19.00
  • 9 lessons
  • 0.5 hours of video content

Prefer to take the full course?

Your Instructor

Yahya Zakir Sait

As a Google Certified Professional, Yahya Zakir Sait has instructed thousands of students with in-person and online courses. He is also the instructor for SpreadsheetPoint's Google Forms and Sheets Masterclass.

Formula Checklist

Want to master Google Sheets? This crash course covers all of the following (and more!)

  • VLOOKUP and HLOOKUP

  • SUM, AVERAGE, MIN, MAX

  • SUMIF and COUNTIF

FAQ

  • Do I need experience with spreadsheets to take the course?

    We designed this course for students who know how to open Google Sheets but who don't already feel comfortable with writing their own formulas in cells. You don't need to be a spreadsheet wiz to get started. That's where we come in!

  • Does the course cover more advanced formulas or just basic math?

    This crash course covers basic math formulas and more advanced formulas, which you can use to quickly find, sort, and manipulate data.

  • Is this the same information I'll get in the full Google Forms and Sheets Masterclass?

    All of the material in this mini-course comes from module 9 of the full course. Note that students who sign up for this mini course also get a discount on the main course, if they choose to pursue it later.

Maximize productivity in Google Sheets

Enroll today