Google Sheet

Google Sheet with Dashboard

The Google Sheets & Dashboard course at IPT Excel School is designed to equip learners with essential skills in Google Sheets, automation, and dashboard creation. The program begins with Google Sheets Essentials, covering formatting, shortcuts, data validation, and key formulas like IF, VLOOKUP, FILTER, QUERY, and ARRAYFORMULA. Learners then explore Google Apps Script (GAS), gaining hands-on experience with scripting, macros, and triggers for automating tasks. The course delves into JavaScript fundamentals for Sheets, teaching variables, loops, functions, and error handling. Participants work on data automation projects, such as cleaning and formatting data, generating reports, and integrating Sheets with web services like Google Translate. The curriculum also includes Google Workspace integration, enabling users to automate emails, manage files in Google Drive, and interact with Google Forms, Calendar, and Docs. The dashboard design module focuses on dynamic charts, interactive controls, and auto-updating dashboards using scripts. Advanced topics cover APIs and Webhooks, allowing learners to fetch live data, build custom CRM solutions, and set up real-time data input. The course culminates in capstone projects, including an automated invoice generator, employee attendance system, and task tracker with email alerts. Led by Sujit Kumar Singh, an experienced MIS and data analyst with over 21 years in the industry, the program emphasizes practical applications and real-world problem-solving

Instructor Name - Sujit Kumar Singh