Excel Office Script
Automate Excel for the web with Office Scripts and Power Automate, with no VBA needed.
Course highlights
Sujeet Sir
21 Years Exp.
Excel | VBA | Power BI | SQL | Python
Data Analytics Expert & Corporate Trainer
- Sujeet Kumar Singh (MCA), founder of IPT Excel School since 2007
- Worked as MIS Executive and VBA Developer in 10+ companies
- Report consultant for 40+ organizations
What you will learn
Office Scripts vs VBA and the script editor.
Your first script and the Workbook, Worksheet and Range objects.
Formatting, tables, multiple sheets, rows and columns.
If, switch, for, while and forEach with live projects.
Reusable functions, parameters and return values.
Summaries, charts and dashboards with Power Automate.
Daily reports, scheduling and auto-mail reports.
Data cleaning, invoice report, attendance sheet and dynamic dashboard.
BENEFITS
- Automate Excel online and in the browser
- Record and edit scripts easily
- Schedule reports with Power Automate
YOUR GOAL
Build and run your first Office Script automations.
WHO SHOULD LEARN
Excel users who work online and want automation without VBA.
COURSE OUTLINE
⬇ Download PDFModule 1 - Introduction to Office Scripts in Excel
- What is an Office Script
- Difference between VBA and Office Scripts
- Enabling Office Scripts in Excel online
- Understanding the script editor
Module 2 - Office Scripts basics
- Creating your first script
- Naming and saving
- Running and editing
- Workbook, Worksheet and Range objects
Module 3 - Automating tasks
- Automating formatting
- Creating and managing tables
- Working with multiple sheets
- Inserting and deleting rows and columns
Module 4 - Conditions and loops
- If, else if and switch statements
- For, while and forEach loops
- Live projects
Module 5 - Functions and modular scripting
- Reusable functions
- Calling functions within scripts
- Parameters and return values
Module 6 - Data analysis and reporting
- Summarising data with scripts
- Automating charts and dashboards
- Integration with Power Automate
Module 7 - Project automation
- Daily report automation
- Task scheduler via Power Automate
- Creating auto-mail reports
Module 8 - Real-world projects
- Data cleaning project
- Invoice report automation
- Attendance sheet generator
- Dynamic dashboard scripting
Final assessment and certificate
- Capstone project
- Q and A
- Viva
- Feedback and certification
COURSE DETAILS
| Duration | 20 hours |
|---|---|
| Level | Beginner |
| Class time | Mon to Fri: 1 hour daily, or Sat and Sun: 2-hour classes |
| Batch size | 1 to 3 students (one-to-one or small group) |
| Mode | Live online on Google Meet |
| Language | Hindi or English |
| Certificate | Yes, with real project work |
| Support | Phone and Google Meet doubt support |
| Demo | Free 3-4 day demo class |
| Fees | Contact Sujeet Sir: +91 88025 79388 |
HOW IT IS TAUGHT
Live on Google Meet by Sujeet Sir in Hindi or English, with real company examples, projects, a certificate and doubt support on phone after the course.
Join a free demo
Questions about this course
What is the fee of the Excel Office Script course?
Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.
Is there a free demo?
Yes. Join the 3-4 day free demo before you pay.
Which language is it taught in?
Hindi or English, as you prefer.