Advance Google Spreadsheet: Writing Complex Formula

30 case studies of solving complex problem using Function and formulas

4.10 (66 reviews)
Udemy
platform
English
language
Other
category
instructor
Advance Google Spreadsheet: Writing Complex Formula
412
students
7 hours
content
Mar 2023
last update
$27.99
regular price

What you will learn

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

Description

As a full-time Google Spreadsheet consultant, I have worked with clients from different parts of the world, helping them optimize their business processes using Google Sheets. Through my experience, I have learned what are the essential skills and concepts that should be taught in Google Sheets, and I have designed a course to share this knowledge with others.


One of the unique features of this course is that I have taken different real-world scenarios where complex functions were required to solve a particular problem. I have broken down these complex functions into smaller functions, which makes them easier to understand and apply. By working through these cases, learners will develop critical thinking skills and learn how to apply the right function for a specific task.


Towards the end of the course, we delve into the QUERY function, which is one of the most powerful functions in Google Sheets. The QUERY function allows you to extract specific data from a large dataset, perform calculations, and even create pivot tables. With the QUERY function, you can achieve amazing results and simplify your data analysis process.


The course is not only about learning the functions and formulas of Google Sheets but also about understanding how to apply them in real-world scenarios. I have also included practical exercises and quizzes to help learners reinforce their learning and apply the concepts covered in the course.

In conclusion, this course is designed to equip learners with essential Google Sheets skills and to give them the confidence to use these skills to optimize their business processes.


Happy Sheets!

Content

Introduction

Introduction

ARRAYFORMULA

ARRAYFORMULA Part-1
ARRAYFORMULA Part-2
ARRAYFORMULA Part-3

FILTER

FILTER : Part-1
FILTER : Part-2
FILTER : Part-3

VLOOKUP

VLOOKUP: Part-1
VLOOKUP: Part-2

Combining ARRAYFORMULA and SUMIF

ARRAYFORMULA and SUMIF : Part-1
ARRAYFORMULA and SUMIF : Part-2

MATCH and INDEX

MATCH and INDEX: Part-1
MATCH and INDEX: Part-2

INDIRECT, CONCATENATE & IMPORTRANGE

INDIRECT Function
CONCATENATE and it's alternative
IMPORTRANGE to get data from other spreadsheet

LIVE PROJET 1: User Filter

User Filter: Part1
User Filter: Part2
User Filter: Part3

Reviews

Tomislav
October 20, 2022
A lot of mistakes made the video longer than it should be without any real or good content. With some preparation and editing, this would be better. This section lacks the good final world and logic at the end to explain the way Arrayformula works.
Melinda
June 11, 2022
I learned so much in this course. I do wish there was downloadable learning material so I could follow along and apply and work it at the same time without having to pause to recreate on my own. Past that I thought it was done very well. I loved seeing the Errors and working through them as I know I will make many as I start to use and try these out on my own.
Joanna
June 5, 2021
It is teaching me how to use formulas that I need in my job. I can pause the videos and practice the techniques in the videos.
Naoufel
September 27, 2019
Plusieurs de ses fonction complexes peuvent être remplacé par un pivot table. Mon problème est de réaliser une synthèse de 60 fichiers plutôt que des les importer à la main et cette formation n'a pas répondu à mon besoin. J'essaie de valider query({IMPORTRANGE("1ko4NCVmmtIIy_gBcJ07m-AlnDYhRREvk15d9yI1NV14", "Detailed list!A3:G");( "1rJh3ui2HpeGJbMyPsOgpOswqVwVSJubzRNrRhhpiHRg", "Detailed list!A3:G"); IMPORTRANGE(", ""Detailed list"!A3:G")}, WHERE * GROUP BY Col2, 1)
Lee
July 25, 2019
This course was not a good fit for me--partially rehashing things I already know; new material explains how to use the formulas but doesn't clearly explain what cases they should be used in.
Leana
July 1, 2019
Would be best to show instruction without making mistakes and having to correct them. The subtitles had many many errors as well.
Cathy
June 10, 2019
I'm having to go back and listen multiple times because it is sometimes difficult to understand the instructor. I believe he could be a bit more thorough, sometimes types in wrong items and has to go back & correct because he goes too fast.
Arumdyah
March 8, 2019
Honestly, I need to rewatch 2-3 times (with 0.75x speed :D) until I fully get the explanation, since English is not my first language (and auto-generated subtitle doesn't help much for these videos). But, once I get the point, I know that the lesson are very helpful and worth to watch! I use Google sheet for work, in daily basis. And I thanked to Mr. Shahbaz for creating this course, I learnt some new things and ideas for using the formulas. In addition, learn this course help me also to become more understand about Microsoft Excel, since basically both tool use similar formulas :) A suggestion: please add material to be downloaded (the data and worksheet that you use for explaining, as example) and more examples/study cases to be learnt. That will be awesome! Greetings from Indonesia! :)
Rick
January 28, 2019
Very good in-depth explanations. Mr. Haidar really knows his stuff. I followed along with each exercise and understood as I was going through it. I will need more practice to know it well. I thoroughly enjoyed learning this material. It seems like the lessons were a bit rushed, however, as if he was trying to get through the material as fast as he could. My recommendation is to perhaps take things a bit slower with more in-depth explanations. Another thing that would be helpful is to have a few learning exercises within each section to make sure we understand. Then add another supplemental section, maybe at the very end, where you explain the answers if folks do not understand. Thank you.
John
August 1, 2018
Short course on using more complex formulas. I see direct application to my needs, but would like to have had a few more exercises. Instructor is clear and to the point. If he offered another course, I would take it.
Matthew
June 10, 2018
I was pleasantly surprised. I often have trouble understanding accents, but the instructor was clear and understandable even speaking rather quickly. I was plunged into Google Sheets after years of Excel and have been disappointed with what I was able to find about it on the web, which is why I decided to try this course. Very glad I did and am sure I'll review it more than once. Thank you all for teaching and putting this on your site. I have already recommended it to friends. My only disappointment has been that it didn't answer my specific application, but that would be asking too much, wouldn't it?
Brian
January 28, 2018
That tip for using a semi colon instead of a comma in arrayformula was GOLD. I have jumped through so many hoops trying to achieve that easy result!

Charts

Price

Advance Google Spreadsheet: Writing Complex Formula - Price chart

Rating

Advance Google Spreadsheet: Writing Complex Formula - Ratings chart

Enrollment distribution

Advance Google Spreadsheet: Writing Complex Formula - Distribution chart

Related Topics

1444950
udemy ID
11/24/2017
course created date
2/24/2021
course indexed date
Bot
course submited by