Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 57 Minute(s)
Language
English
Taught by
Tony Hat
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Manage your work and life with Google Sheets
This course will lead you from Basic to Advanced level. You will be able to manage your data, task, analysis, reports, queries, and other activities easily. You will learn great tools as a Pivot Tables and Vlookup Functions. By mastering the Queries you can see how Google Sheets can be better than Excel. You will also learn how to work with Adds-on templates.
The course contains practical training assignments so you can develop your knowledge by practice. Links to the Data, Assignments & Results are available in Bonus Section #7.
**Include Google Sheets May 2018 Updates**
Course Content
- 7 section(s)
- 40 lecture(s)
- Section 1 1 Introduction
- Section 2 2 The Best approach to Google Sheets Training
- Section 3 3 Google Ecosystem
- Section 4 4 Google Sheets Beginners
- Section 5 5 Google Sheets Intermediate
- Section 6 6 Google Sheets Advanced
- Section 7 7 Bonus section
What You’ll Learn
- Understanding of Google Ecosystem management
- Build a solid understanding on the Google Sheets Basics
- Create amazing visualisation with Google Charts
- Link sheets to Internet and Web data to the Sheets
- Creating dynamic reports with Pivot Tables
- Manage Surveys by using Google Forms
- Master the data by Lookup, IF, SUM & FILTER, GETPIVOTDATA and others..
- Analyze Data with Google Queries
- Automate your work by Macros and modify it by Scripting
Skills covered in this course
Reviews
-
TTANIA JAYANTI
very clear explanation and lots of information
-
KKURNIAWAN KUMALA
thank you for sharing knowledge
-
MMark Maharaj
very good learning experience
-
YYogesh Kumar
Good
