Automation with Google Sheets: 2-Day Workshop

Unlock Efficiency with Google Sheets Automation

Discover the power of automation in Google Sheets in this dynamic 2-day workshop. "Automation with Google Sheets" introduces participants to tools and techniques that transform repetitive workflows into streamlined processes. Using built-in macros and Google Apps Script, attendees will learn how to automate data handling, reporting, and other time-consuming tasks. This hands-on workshop provides practical insights into increasing productivity and enhancing data accuracy in professional workflows.

Master Advanced Automation Techniques

This workshop not only covers the basics of Google Sheets automation but also delves into advanced techniques to optimize your workflow. Participants will gain hands-on experience with Google Apps Script to create custom automation solutions. By the end of the course, you'll be equipped to handle large datasets effortlessly, automate routine tasks, and elevate your efficiency with tailored scripts and macros, empowering you to focus on more strategic initiatives.

By the end of this course, participants will be able to:

• Understand and effectively utilize Google Sheets’ automation tools, including macros.
• Create, record, and customize macros to handle repetitive tasks efficiently.
• Develop and implement basic scripts using Google Apps Script for advanced automation needs.
• Manage and troubleshoot automation workflows, including error handling in macros and scripts.
• Apply automation techniques to optimize data management and reporting processes.

This course is ideal for:



• Business Professionals: Individuals managing large datasets and seeking to automate repetitive tasks for increased efficiency.
• Data Analysts: Professionals aiming to enhance their workflows in Google Sheets through automation.
• Small Business Owners: Entrepreneurs looking to streamline data management and reporting processes.
• Google Sheets Users: Anyone eager to explore automation tools and techniques to improve productivity.

No prior programming experience is required, though familiarity with Google Sheets basics will be beneficial.

"The instructor is patient and clear in his explanation. He uses useful and easy-to-understand examples to illustrate his points."

– Sylvia Sim, Senior Manager (Strategic Engagement), Elections Department

"The trainer provided good references to real-life scenarios. Understanding various data concepts was the key takeaway for this course."

– Peh Jun Zhong, Vice President, GIC Pte Ltd

Dwight Tan: Data Analytics and Automation Specialist

Dwight Tan is a seasoned educator and data professional with over a decade of experience in analytics and database management. A graduate of NUS with a degree in Biotechnology, Dwight furthered his expertise with an Advanced Diploma in Pharmaceutical Management from MDIS and a Master’s in Education from NTU. In 2014, he transitioned into data analytics, mastering programming languages such as Python and R, along with advanced techniques in machine learning, big data analytics, and web applications.

Dwight’s deep knowledge extends to creating predictive models and performing advanced analytics using healthcare data, giving him practical insights into automation's transformative potential. His passion for teaching has made him a sought-after trainer, recognized for his ability to simplify complex topics and deliver actionable skills in data analytics and automation. From macros to advanced Google Apps Script, Dwight equips learners with the tools they need to excel in their data-driven roles.