Course Information
Course Overview
Master Google Sheets and boost your productivity
Description:
Learn how to effectively use Google Sheets, from basic functions to advanced features. This course will simplify and demystify Google Sheets, helping you become a master at data manipulation and analysis.
Key Highlights:
Master the fundamentals of Google Sheets
Create powerful formulas and calculations
Get to know some heavyweight topics: Vlookup, Xlookup, Pivot Tables.
Data Visualization with professional-looking charts and graphs
Collaborate and share spreadsheets with others using Importrange and Query Functions
What you will learn:
Getting Started with Google Sheets
Discover the interface, navigation, and basic functions of Google Sheets.Working with Formulas and Functions
Learn how to use formulas and functions to perform calculations and manipulate data.Data Visualization Techniques
Explore various ways to visualize and present data with charts and graphs.Advanced Google Sheets Features
Unlock advanced features and techniques to streamline your workflow and enhance productivity.Collaboration and Sharing
Learn how to collaborate and share spreadsheets with others, making collaboration seamless and efficient.
YOUR INSTRUCTOR
RAUNAK SINGH
A subject-matter expert in a range of data analytics and visualization tools, including Google Sheets, Power BI, Tableau, Advanced Excel, Power Query, SQL, SPSS, SQL, GCP, Python and Predictive Modelling. Known for dynamic and engaging training methods that empower participants to harness the full potential of these tools for data-driven decision-making.
Have facilitated 10k+ learners across professionals and students at all levels, from beginners to advanced users.
MY JOB IS TO MAKE IT AS SIMPLE AS POSSIBLE FOR YOU
Course Content
- 9 section(s)
- 62 lecture(s)
- Section 1 Introduction
- Section 2 Module 1: Basics of Google Sheets
- Section 3 Module 2: Data Management in Google Sheets
- Section 4 Module 3: Family of Lookups
- Section 5 Module 4: Thinking Logically
- Section 6 Magic with PIVOT Tables
- Section 7 Visualize Your Data using Charts and Graphs
- Section 8 Importrange and Query in Google Sheets
- Section 9 Module 8: Fun with Google Sheets
What You’ll Learn
- Master the fundamentals of Google Sheets, Create powerful formulas and calculations, Get to know some heavyweight topics: Vlookup, Xlookup, Pivot Tables., Data Visualization with professional-looking charts and graphs, Collaborate and share spreadsheets with others using Importrange and Query Functions, Increase your speed by learning shortcuts, Add Data Validations, Named Ranges, Cell references and much more
Skills covered in this course
Reviews
-
SSheetal Sinha
Really enjoyed this course! Everything was explained in a simple and clear manner, and I learned so many useful shortcuts which I can apply right away. Perfect for anyone wanting to get confident using Google Sheets.
-
AAarti Sahi Khattri
Each & every topic is explained with clarity & examples which are basic yet practical & holds significance in present job place. Great overall spreadsheet learning tool very well designed.