The Complete Google Sheets Course: Beginner to Advanced!
What you'll learn
- Create beautiful spreadsheets with amazing formatting tricks
- Learn to manipulate text in formulas
- Connect multiple Google Sheets together using a single formula
- Analyze data sets with ease using complex functions & formulas
- Learn to build incredible data visualizations using charts
- Feel completely comfortable in a spreadsheet environment
- Learn formulas that work in both Google sheets & Excel!
Requirements
- A computer, a Google account, and the ability to navigate the internet
- Know how to use a keyboard!
Description
In this course you will learn the fundamentals of Google Sheets (much of which translates to MS 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! NOTE: More lectures incoming on this one :)
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!
Who this course is for:
- Spreadsheet users of all levels, those who want to get better at analyzing data or building spreadsheets for personal use!
- This course is not for you if you are an experienced data analyst or power spreadsheet user.
- Students who want to start a career in management consulting or tech operations!
Featured review
![Nick Morganella](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Course content
- Preview00:24
- Preview01:20
- 02:50Pre-Work: Creating a copy of my Spreadsheet Templates!
- 06:22Spreadsheet Basics! What are they and how do they work?
- 10:27Toolbar Walkthrough
- 06:34Data Types in a Spreadsheet
- 11:19Navigating Spreadsheets with Shortcuts!
- Preview05:55
Instructors
- 4.6 Instructor Rating
- 3,404 Reviews
- 14,269 Students
- 1 Course
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 enjoyed teaching my coworkers and friends about them. I've coached top minds in the ways of Google sheets and Excel, and decided I wanted to share the most important aspects of these tools with you.
I know spreadsheets have a reputation for being boring or difficult to use, but I wanted to teach the world that ANYONE can use a spreadsheet like a pro. Join me and enroll in my course to build an incredible spreadsheet skillset that will set you up for success, no matter what your passions are.
- 4.6 Instructor Rating
- 3,404 Reviews
- 14,269 Students
- 1 Course
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.