Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 CompTIA Security+
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Data Analysis Data Warehouse
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

BusinessBusiness Analytics & IntelligenceGoogle Sheets

The Complete Google Sheets Course: Beginner to Advanced!

A crash course in basic and advanced functions: Learn VLOOKUP, QUERY & MORE! Use many of these skills in Excel too!
Bestseller
Rating: 4.6 out of 54.6 (6,940 ratings)
27,549 students
Created by Evan Ramsey, Sansone Partners
Last updated 12/2021
English
English [Auto], Arabic [Auto], 

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:

  1. Learn the basics like how to create a Google Account and a Google Spreadsheet

  2. Arithmetic Functions like SUM, COUNT, and AVERAGE

  3. Shortcuts like filling formulas across THOUSANDS of cells

  4. Advanced charts & Beautiful Visualizations

  5. PIVOT TABLES - though I don't particularly like them...

  6. Advanced functions like INDEX MATCH MATCH and IMPORT RANGE

  7. 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!


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
Nick M.
8 courses
2 reviews
Rating: 5.0 out of 5a year ago
This course has been helping me prepare to enter a new job field, and there's no way I'd be able to prepare myself so quickly if it were not for Evan and this amazing series of lectures and activities!

Instructors

Evan Ramsey
Professional Spreadsheet Nerd
Evan Ramsey
  • 4.6 Instructor Rating
  • 6,940 Reviews
  • 27,549 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.

Sansone Partners
Teaching Strategic & Operational Excellence
Sansone Partners
  • 4.6 Instructor Rating
  • 6,937 Reviews
  • 27,549 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.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.