A crash course in basic to advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
In this course you will learn the fundamentals of Google Sheets (some of which translates to Microsoft Excel!). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like VLOOKUP, INDEX(MATCH()MATCH()), and IMPORTRANGE.
Never heard of those before? Don't worry! I start from the beginning - so those terms will become clear when the time is right.
Along the way, you will develop an amazing spreadsheet toolkit. Wondering what tools will be in that toolkit? Check out the list below for some highlights of the course:
Learn the basics like how to create a Google Account and a Google Spreadsheet
Arithmetic Functions like SUM, COUNT, and AVERAGE
Shortcuts like filling formulas across THOUSANDSÂ of cells
Advanced charts & Beautiful Visualizations
PIVOTÂ TABLES - though IÂ don't particularly like them...
Advanced functions like INDEX MATCH MATCH and IMPORTÂ RANGE
QUERY, the function that DOESÂ ITÂ ALL!
Ultimately, the point of this course is to get some awesome skills for professional or personal use. And - above all - have fun doing it!
My course isn't like a lot of other online Excel or Google Sheet courses. Most of these courses force you to watch them build things and hope that you understand what they are doing. Instead of that old model, I've incorporated everything I've learned from my experience in the real professional world to make this the best online Google sheets course. The course includes:
Lectures
Activities
Projects
Exercises
Slides
Comprehensive Workbooks WITH Answer Keys
Extra Learning Resources
If you have any questions, please don't hesitate to contact me. Sign up today and see how fun, exciting, and rewarding web development can be!
There are some updates to Google Sheets like Tables and others. We may be adding more content to the course to address these - stay tuned!
Create beautiful spreadsheets with amazing formatting tricks
Learn to manipulate text in formulas
Connect multiple Google Sheets together using a single formula
8 Lectures
4 Lectures
6 Lectures
10 Lectures
4 Lectures
5 Lectures
4 Lectures
4 Lectures
4 Lectures
4 Lectures
4 Lectures
3 Lectures
6 Lectures
Hey! My name is Evan. I've worked in analytics and operations roles at several top tier Silicon Valley companies like LinkedIn and Udemy after earning a degree in Economics at Harvard.Mastering spreadsheets has allowed me to accelerate my career and dramatically increase my efficiency. I've realized how useful spreadsheets are in my professional and personal life, and how much I ...
Sansone Partners is a consulting arm focused on operational excellence. We not only want to help solve your problem, but teach you how to solve your future problems.
Yes, I'm learning quite a bit already!
little fast on 1st and 2 second
Good Learning Session
This course was exceptional content-wise and the instructor did a fantastic job in keeping me hooked in spite of some topics being quite complex. It would be a full five stars for me if I would've somehow been advised that this content should be taken over the course of a few months in order to better assimilate each lesson (and not last-minute scrambling for my yearly skill assessment). I will most likely come back for guidance given the need to employ one of the functions. Thanks!
Great Explanations
good
The explanation is very clear.
This course did a great job of building on different skills overtime until you are able to perform advanced analysis. For those who are already versed, stick it out through the beginning and take advantage of the shortcuts and tricks the instructor provides to make you faster and even more knowledgeable.
My work involves using google sheets. this course is super helpful and showed me things I have never even thought of using.
Your email address will not be published. Required fields are marked *
Akshita D. T.
IT WAS GOOD