Excel Automation with Office Scripts: From Basics to Advanced
The Office Scripts for Excel course is designed to help professionals automate tasks and enhance productivity in Excel Online using Office Scripts. It covers everything from basic scripting concepts to advanced automation techniques, providing a practical, hands-on approach to coding within Excel's web environment. Participants will learn to create, edit, and run scripts, automate formatting and data processing, work with multiple sheets, and integrate their scripts with Power Automate for seamless workflow automation. The course also includes real-world projects such as invoice automation, attendance tracking, and dashboard creation, ensuring learners gain applicable skills. Led by Sujit Kumar Singh, a seasoned MIS and Excel trainer with over 21 years of experience, this program offers expert guidance and certification, making it ideal for professionals seeking to streamline their Excel operations.
Instructor Name - Sujit Kumar Singh
About this Course
The Office Scripts for Excel course provides a comprehensive introduction to automating tasks in Excel Online through scripting. Unlike traditional VBA, Office Scripts offer a modern, cloud-based solution that enables users to streamline workflows and enhance efficiency across multiple workbooks. The course starts with fundamental concepts, guiding participants through script creation, naming, saving, and execution. As learners progress, they explore advanced techniques like data manipulation, table management, conditions, loops, and modular scripting.
Beyond technical skills, the program emphasizes real-world automation, covering projects such as invoice processing, attendance tracking, and dynamic dashboard creation. By integrating Office Scripts with Power Automate, professionals can schedule reports, automate data entry, and even set up auto-mailing systems—perfect for handling repetitive tasks effortlessly.
Led by Sujit Kumar Singh, a seasoned expert with over 21 years of experience in Excel automation and MIS, the course blends theoretical learning with hands-on applications. With certification upon completion, participants gain not only new skills but also a credential that strengthens their professional profile. Whether you're an Excel enthusiast, data analyst, or business professional seeking greater efficiency, this training empowers you to unlock the full potential of Excel automation.
Skills you'll gain
Script Writing & Automation Data Manipulation & Formattin Table & Worksheet Management Reusable Functions Integration with Power AutomateSyllabus (Download PDF)
- Semantic HTML
- Semantic HTML
About the Instructor
MR. Sujit Kumar Singh
MIS & Data Analyst
4.87 Instructor rating
25K reviews
>1L Students
29 Live courses
In 2007, Sujit founded IPT Excel School, one of the pioneering institutes in New Delhi offering online live classes in Advanced Excel and MIS training. The institute caters to working professionals, providing courses that cover Advanced Excel, VBA Macros, Dashboard creation, and Power BI.
Sujit also maintains an active presence on platforms like YouTube and LinkedIn, where he shares tutorials and insights on Excel and related tools. His YouTube channel, Sujeet Kumar Advanced Excel Training in Hindi, offers a range of videos aimed at enhancing Excel proficiency.
For more information or to enroll in his courses, you can visit IPT Excel School's website or contact him directly at +91 8802579388.
3 Days Free DEMO Class
₹ 10,000/- (INR)
Duration
35.0 Hrs
Lectures
45
Batch Size
One
Language
English / Hindi
Skill Level
Beginner to Expert
Mode
Online Live
Certificate
Yes
