Microsoft Office
Excel Automation with Office Scripts
This in-depth course develops directly applicable capability in Excel Automation with Office Scripts. It connects Office Scripts Object Model, Data Transformation and Control, and Reusable Script Design to the decisions, controls, and activities participants need to perform in their workplace.
Overview
Practical learning for workplace transfer.
This in-depth course develops directly applicable capability in Excel Automation with Office Scripts. It connects Office Scripts Object Model, Data Transformation and Control, and Reusable Script Design to the decisions, controls, and activities participants need to perform in their workplace. The five-module curriculum progresses toward Excel Automation Lab, using evidence, scenarios, and work products appropriate to the subject.
Prerequisites
Relevant workplace familiarity is recommended; exact technical prerequisites can be adapted to the participant group.
Objectives
- Analyze office scripts object model, including workbooks, worksheets, ranges, tables, charts, and named items.
- Configure or structure data transformation and control, including find dynamic ranges and table rows.
- Evaluate reusable script design, including functions, parameters, arrays, loops, conditions, and interfaces.
- Manage power automate integration, including run scripts from cloud flows.
- Apply excel automation lab, including automate a recurring workbook preparation process.
Target audience
- Professionals responsible for this subject area
- Managers, supervisors, and team leaders
- Analysts, specialists, engineers, or coordinators working with the relevant processes
- Project, implementation, assurance, or improvement team members
- Professionals preparing for broader responsibilities in this field
Program outline
A clear structure for the learning journey.
Outline points are grouped in one designed block instead of being treated as separate module cards.
01Office Scripts Object Model3 topics
- Workbooks, worksheets, ranges, tables, charts, and named items
- Script recorder versus edited TypeScript
- Read and write values, formulas, and formats efficiently
02Data Transformation and Control3 topics
- Find dynamic ranges and table rows
- Clean, validate, sort, filter, and aggregate data
- Handle blanks, errors, dates, and data types
03Reusable Script Design3 topics
- Functions, parameters, arrays, loops, conditions, and interfaces
- Batch operations for performance
- Error handling, logging, and safe reruns
04Power Automate Integration3 topics
- Run scripts from cloud flows
- Pass parameters and return structured results
- Store files, schedule jobs, notify users, and manage failures
05Excel Automation Lab3 topics
- Automate a recurring workbook preparation process
- Trigger the script from Power Automate
- Test abnormal inputs and produce operating instructions
Materials provided
- ○ Course-specific presentation slides
- ○ Guided exercises, scenarios, or configured-environment activities appropriate to the subject
- ○ Course-specific worksheets, checklists, or calculation templates
- ○ Applied workplace case materials
- ○ 4D Certificate of Completion issued by 4D Training & Consultancy
- ○ Post-course support for implementation questions
Training Options
Programs can be delivered in-house, online, or in a blended format depending on your team's schedule, location, and learning objectives. When an external certificate or exam is included, certification rules and fees remain under the relevant awarding body's policies, while 4D provides the training and preparation support.
Why choose 4D
4D Training & Consultancy adapts the program to the client’s operating environment. Delivery combines structured explanation with subject-specific analysis, exercises, and implementation decisions so participants can transfer the learning to real responsibilities without implying vendor authorization.
Related courses
Advanced Power BI, DAX and Microsoft Fabric Analytics
This advanced analytics course helps Power BI users build stronger models, dashboards, and reporting solutions using DAX and Microsoft Fabric concepts. Participants learn data modeling, advanced measures, performance improvement, governance, semantic models, and practical reporting patterns for business decision-making.
View courseMicrosoft Access
This training provides a comprehensive introduction to Microsoft Access for database management and design. Participants will learn how to create and manage databases, design tables and forms, write queries, and generate reports. This course emphasizes the ability to organize and retrieve data efficiently using relational databases.
View courseMicrosoft Copilot and AI Productivity for Microsoft 365
This practical course helps professionals use Microsoft Copilot and AI features across Microsoft 365 to improve writing, email, meetings, analysis, presentations, and daily productivity. Participants learn how to prompt effectively, review AI outputs, protect confidential information, and build repeatable AI-assisted workflows.
View course