Google Sheets Training Course
Comprehensive training on Google Sheets. Store, manage & analyze your data, use functions, build lookup, pivots, charts.
IT & Software,IT Certification,Google Sheets
Lectures -14
Duration -2.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
A warm welcome to the Google Sheets course by Uplatz.
Google Sheets is the spreadsheet application software available within Google's cloud-based office suite. Google Sheets has been designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. Based on Google’s infrastructure, Sheets provides the flexibility to create amazing spreadsheets while helping to keep your information secure.
Google sheets is being used by more and more companies instead of Microsoft Excel. There are many advantages to using Google Sheets the main one being the ability to share a sheet with multiple users. It is free to use and works in a browser! So there is no need to install anything on your machine neither to buy any license.
This Google Sheets training course by Uplatz will get you used to Google sheets and be able to create and manage it in practical situations even if you have never used spreadsheets before. The Google Sheets course will introduce you to the basics of creating spreadsheets using the free Google Sheets application. This course will teach you some of the essential features of Google Sheets and how they can be used to work together in an interactive and graphical way. You will be able to take a deep-dive into all the features and options available in Google Sheets. This Google Sheets training provides detailed demonstration on how to use functions, build pivot tables, charts, formatting, filtering, sorting, AI-based and dynamic functions, analyze data on the fly, and more in Google Sheets.
Course Topics at high-level
An Introduction to Google Sheets
Create a new Google Sheet
Name a Spreadsheet
Upload an Existing Excel Spreadsheet
Edit Cells
Use Auto-fill
Format Cells
Format Text and Numbers
Basic Formulas and Functions
Use the Sum function
Create and Copy Formula using Auto-fill
Sort and Filter data
Finding your way around Google Sheets
Opening Files
Move data from Excel Files to Google Sheets and vice-versa
What about saving files?
File Management
Adding/Deleting Worksheets
Renaming Worksheets
Basic Formatting
Formatting Numbers
Dealing with Dates
Changing the Typeface
Adding more fonts
Adding Colors
Format Painter
Formulas in Google Sheets
Basic Arithmetic
Operator Preference
Absolute References
Using Functions
Calculating between Worksheets
Printing Google Sheets
Selecting a print area
Fitting everything onto a page
Creating a PDF
Printing all sheets
Sharing a Google Sheet
Choosing people to share with
Restricting Editing
Preventing others from downloaded and printing
Google Sheets course curriculum
Introduction
Menu Options - File
Menu Options - Edit
Menu Options - View
Menu Options - Insert
Menu Options - Format
Menu Options - Data and more
Entering Data and Filtering
Functions - Numeric Function
Functions - Text Function
Functions - Data Functions
Charts and Conditional Formatting
Pivot Tables
Saving, Sharing, Collaboration
Course Objectives
Learn how to navigate around Google Sheets
Learn how to adjust the way data and information are displayed
Learn how to write formulas quickly and easily
Learn how to create powerful calculations
Learn how to visually represent your data with charts and graphs
Learn how to use data tools like sorting, subtotaling, and filtering
Learn Google sheets shortcuts, tips, tricks
Who this course is for:
- Data Analysts and Consultants
- Project Managers
- Newbies aspiring to learn Google Sheets
- Beginners aspiring to become Data Analysts
- Data Management Professionals
- Business and Financial Analysts
- Project Support Personnel
- Students aspiring for a career in Management Consulting or IT Operations
- Students who want to build quick and easy-to-share online spreadsheets
Goals
End-to-end knowledge of Google Sheets
Understand fully the Menu options - File, Edit, View, Insert, Format, Data, more
Entering Data and Editing
Format and Customize Data
Filtering, Sorting, Conditional Formatting
Functions - Numeric, Text, Date
Pivot Tables, VLookup, HLookup
Charts and Graphs
Advanced Functions such as Google Translate
Introduction to Script Editor
Saving, Sharing, Collaboration in Google Sheets
Get fully familiarized in a spreadsheet environment
Tips and Tricks
Prerequisites
- Enthusiasm and determination to make your mark on the world!
![Google Sheets Training Course Google Sheets Training Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/5799/course_5799_image.jpg)
Curriculum
Check out the detailed breakdown of whatās inside the course
Introduction to Google Sheets
1 Lectures
-
Introduction to Google Sheets 02:31 02:31
Menu Options
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Entering Data and Editing
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Functions
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Charts and Conditional Formatting
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Pivot Tables
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Saving, Sharing, Collaboration
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Uplatz](https://www.tutorialspoint.com/assets/profiles/400058/profile/200_3442963-1637821062.jpg)
Uplatz
Uplatz is a UK-based leading ITĀ Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market.
Within a short span of 6 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.
Our specialization includes Data Science, Machine Learning, Deep Learning, Data Engineering, AWS, SAP, Oracle, Salesforce, Microsoft Azure, GCP, DevOps, SAS, Python, R, JavaScript, Java, C, C++, Full Stack Web Development, Angular, React, NodeJS, Django, IoT, Cybersecurity, BIĀ & Visualization, Tableau, Power BI, Data warehousing, ETL tools, ServiceNow, Software Testing, RPA, Embedded Engineering, Automotive Engineering, DSP, VHDL, Microcontrollers, Electronics, Computer Hardware Engineering, MATLAB, Digital Marketing, Product Marketing, Finance, Accounting, Tally, and more.
Founded in March 2017, Uplatz has seen a phenomenal rise in the training industry providing training on 300+ self-paced courses and 5000+ tutor-led courses across 180 countries having served 1.5 million students in a period of just a few years.
Uplatz's training courses are highly structured, subject-focused, and job-oriented with strong emphasis on practice and assignments. Our courses are designed and taught by highly skilled and experienced instructors who have strong expertise in varied fields whether it be Cloud Computing, SAP, Oracle, Salesforce, Programming Languages, Web Development, or any other technology and in-demand software.
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)