Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 22 Minute(s)
Language
English
Taught by
A Rezika
Rating
Course Overview
Learn and practice while building your Productivity assistant. Build 2 real life projects and collaborate with your team
This course will take you from wherever you are in your experience with Google Sheets, Forms, and Apps Script to automate your work on google sheets so it assists your personal or professional productivity. Even if you have never used google sheets before or you don't have a Google account, in few minutes you will create a jump-start. This course teaches you with practical examples that we shall build together in an easy and efficient way most of the secrets of the Forms so you can send tasks with full fledged information set and links to your friends or team. Then, you will be able to collect, store and process their feedback. Even you can send updates and replies without losing track of any the previous replies or updates. It is all like opening a toolbox full of potentials where all its tools will be easy for you to use and apply. Building 2 real life stimulates your creativity to continuously update your work processes and do not allow premade apps to be your limits. If you were ever curious about how to create survey forms, receive, log and analyze the feedback. You will learn all these topics and more. You will learn how to create visual feedback of the recorded or auto collected data.
Course Content
- 7 section(s)
- 38 lecture(s)
- Section 1 Introduction
- Section 2 Jump-start to Google sheets
- Section 3 Apps Script Step-By-Step
- Section 4 Share and collaborate
- Section 5 Take it to the next level
- Section 6 Build a stock tracking app
- Section 7 What's more?
What You’ll Learn
- Use Google sheets to build and automate your work, Create 2 real life projects using Apps Script, forms and sheets prebuilt and custom functions, Send tasks to your team and collect feedback., Send your forms and tasks via emails with a click., Create visual conditional formatting to help you take decisions and follow up tasks, Log tasks feedback and send updates from within your spreadsheet., Moreover, create your visual easy-to-use filters.
Skills covered in this course
Reviews
-
JJon Heath
The organization of the course is pretty good. It is hitting on a lot of the techniques that I want to use, but the style of the presenter is difficult. In some respects, having the errors occur because of some coding mistakes is good for follow-on troubleshooting experience. At the same time, a 20-minute lecture turns into a 45-minute lecture. Some things seem well thought out while others seem to just occur to the presenter, and he throws them in. Again, some benefit to that since we all may think of something we missed, but it just seems disorganized at other times.
