Google Sheets Training - Beginner to Advance Level
Master Course in Google Sheets - Free Cloud based alternative to Microsoft Excel
G Suite,Google Office,Google Sheets,Office Productivity,Google
Lectures -41
Duration -5.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more. You may expect to learn following topics in detail.
Learn how to adjust the way data and information are displayed in Google Sheets
Learn how to apply function with function arguments
Learn how to use relative, absolute, and mixed references in Google Sheets
Learn how to create powerful calculations with Google Sheets functions
Learn how to visually represent your data with charts and other tools in Google Sheets
Learn how to use Google Sheets data tools like Slicer, Sorting and filtering
Learn how to use Google Sheets to leverage data with Pivot Tables
Learn how to automate Google Sheets tasks with recording Macros
Learn how to organise your data based on Condition.
Learn to validate proper entry in the data.
Mastering Date and time related formulas and format.
Mastering all important Text function with nested methodology
Mastering Logical and Lookup and reference Function.
Mastering Operators use and Math Functions
Sharing, protecting and Restricting Sheets File
Working and collecting data on Google Forms
Goals
- Mastering Google Sheets at MIS level
- Expertise in Text, Logical, Math, Financial, Lookup and Reference Functions
- Understanding Date and Time Format and Functions
- Mastery in Pivot Table and Chart Preparation
- Learning Data Validation, Filter, Conditional Formatting, Named Ranges, Link and Record Macro
- Sharing and Protection of data
- Have a solid understanding of Google Docs and how to use the program effectively
- Be able to create professional looking presentations, as well as share and present them
- Create forms and surveys, as well as collect and analyze data from them
Prerequisites
- Basic Computer Knowledge
![Google Sheets Training - Beginner to Advance Level Google Sheets Training - Beginner to Advance Level](https://d3mxt5v3yxgcsr.cloudfront.net/courses/15318/course_15318_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Getting started in Google Sheets
2 Lectures
-
Understanding Google Sheets 09:29 09:29
-
Autofill and Smart fill option 08:27 08:27
Mathematical Operators and Math Functions
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Logical Operators and Logical Functions
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Text Functions and Text to Column
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Organizing and Formatting in Google Sheets
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Naming, Linking and Validating
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Table and Chart Preparation
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Lookup and Reference Functions
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Date and Time Management
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Financial Functions and Record Macro
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Sharing, Protection and Google Forms
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Himanshu Kumar Dhar](https://www.tutorialspoint.com/assets/profiles/519212/profile/200_296504-1692624874.jpg)
Himanshu Kumar Dhar
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)