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
PC, Chromebook or other device to work with Google Sheets
A Google or Gmail account
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**
Who this course is for:
Anyone who wants to improve the Google Sheets knowledge
Anyone who wants to enhance own life with this tool
Tony is experienced Manager working in IT and Telecommunication environment over 20 years. He is leading the Project management activities as well as the Training and Support activities. Furthermore he designs the new solutions processes and applications. He focus on the simplicity and clarity of the solutions and training materials.He is experienced with Training management for global teams.