When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Complete Google Sheets Training - Beginner to Advance Level
Master Course in Google Sheets - Free Cloud based alternative to Microsoft Excel
This Course Includes
udemy
4.1 (19 reviews )
5h 50m 
english
Online - Self Paced
professional certificate
Udemy
About Complete Google Sheets Training - Beginner to Advance Level
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
What You Will Learn?
- 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.