Overview
-
Manage your work and life with Google Sheets
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
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**
