4.2  51 reviews on Udemy

Google Spreadsheet: Writing Complex Formula

Get an edge on others by writing complex functions and getting results in less time than others
Course from Udemy
 233 students enrolled
 en
Better grip on functions of Google Spreadsheet
Combining two or more function into one function
Writing formula and function that does not change with structure change of Spreadsheet
Creating Complex Dashboards using complex functions

Since I am a full time Google Spreadsheet consultant, with clients all over the world, I know what are the things that are important and should be taught to students.

Google Spreadsheet gives you a lot of options to present the data and use it appropriately. While basic function is used to do basic stuff, by using the same basic function in a more intelligent way, can give you result that in otherwise, would seem a lot of manual work and calculation. There is no end to complexity of a function. Some examples are:

  • Combining ARRAYFORMULA and VLOOKUP to achieve the result for entire column with one function
  • Combining INDEX and MATCH to get value of columns on the left that is not possible with simple VLOOKUP

This course compels you to think in right direction by giving some example, so that in future, you can create your own functions in tough times.


Happy Sheets !!!

Google Spreadsheet: Writing Complex Formula
$ 94.99
per course
Also check at

FAQs About "Google Spreadsheet: Writing Complex Formula"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK