Office Scripts
Automate Excel Everywhere
Build self-running automation processes that run while you sleep!
Discover how to boost your productivity, automate Excel,
and run tasks while you sleep!
Transform your Excel efficiency with the Office Scripts: Automate Excel Everywhere course.
Unlock the power of automation in Excel 365 without any prior programming knowledge.
Say goodbye to the complexities of VBA Macros. In Excel 365, Microsoft has introduced Office Scripts, a simpler and more intuitive language designed specifically for non-programmers.
Whether you’re using Windows, Mac, or Excel Online, Office Scripts empower you to streamline your workflow and reclaim countless hours spent on repetitive tasks.
Office Scripts: Automate Excel Everywhere is the most comprehensive Office Scripts course on the market.
Through this course, you will learn to become an Office Scripts expert:
✓ Write re-usable scripts to work with any spreadsheets.
✓ Create simple applications for collecting and managing data through worksheet-based user interfaces.
✓ Build self-running automation processes that operate in the background (you don’t even need to click a button).
With these skills, you can save days of time each month (meaning you can go home on time more often).
The course starts with the fundamentals and shows how all the pieces fit together.
By the end of the course, you will be able to write your own Office Scripts without needing to copy and paste from others or rely on the script recorder.
Office Scripts: Automate Excel Everywhere is only available within the Excel Academy.
What can you do with Office Scripts?
If you’ve never used or seen Office Scripts before, let’s explore what they are and how they work.
Watch the video:
Office Scripts:
✓ Enable Excel users to automate tasks.
✓ Can automate nearly everything in an Excel workbook (worksheets, ranges, PivotTables, charts, and much more).
✓ Are stored in OneDrive or SharePoint (accessible for PC, Mac, or web).
✓ Integrate with Power Automate to automate workflows involving other applications.
Case Study – How Office Scripts saved 28 working days per year.
“If it works, you pay me; if it doesn’t, you don’t”… I had no idea if it would work. But this was the agreement I made with the client
The client was looking for a VBA solution to replace a daily 45-minute reporting task. None of it was difficult, but it was time-consuming. They agreed to try an Office Script solution.
The result was a zero-click, runs while you do other things, solution. The client was blown away.
The 45 minutes of daily work was now zero minutes. That is 28 days of work per year, which they no longer needed to do. They don’t even need to think about it… it just happens.
This course shows how you can build similar solutions.
What’s included?
✓ 9 hours of on-demand video (120+ lessons)
✓ Downloadable workbooks and scripts
✓ Real-world projects to work through
✓ Exercises to practice new skills
✓ Quizzes to test your knowledge
✓ Certificate of completion
✓ English closed captions
✓ Ask questions and get expert answers
Syllabus:
Introduction
- Welcome
- What are Office Scripts?
- Office Scripts infrastructure
- Office Scripts vs VBA: What’s the difference?
- Learning journey
- Do you have Office Scripts?
- Golden rule for learning Office Scripts
- Download the support files
Getting started with Office Scripts
- Getting started with Office Scripts – Introduction
- Writing your first script
- Editing your first script
- Save and delete Office Script files
- Writing your second script
- Exploring the Office Scripts user interface
- Using the script recorder
- The script recorder does not capture everything
- Sharing scripts with others
- Creating an Office Scripts button
- Undo Office Script actions
- Getting started with Office Scripts – Quiz
Understanding the Document Object Model
- Understanding the Document Object Model – Introduction
- What is the Document Object Model?
- Basic examples of using the Document Object Model
- Learning the DOM
- Optimize code using variables with DOM
- Active and relative reference with DOM
- Objects and collections in the DOM
- DOM – Exercise
- DOM – Exercise answers
- DOM – Exercise – Alternative approach
- Document Object Model – Quiz
Programming fundamentals
- Programming fundamentals – Introduction
- The Main function
- Adding and using comments
- Colors used in the code editor
- Whitespace, line breaks and semi-colons
- Declaring & assigning variables
- Understanding variable types
- Working with strings
- String properties and methods
- Concatenating text strings
- Working with numbers
- Number and Math object methods and properties
- Arithmetic operators
- Working with booleans
- Comparison operators
- Type conversion
- String converter – Exercise
- String converter – Exercise Answers
- Multiplication tester – Exercise
- Multiplication tester – Exercise answers
- Programming fundamentals – Quiz
Objects, arrays and functions
- Objects, arrays and functions – Introduction
- What are objects?
- Working with objects
- Object references
- What are arrays?
- Working with arrays
- Ranges vs arrays
- Working with ranges and arrays of unknown sizes
- Concatenating array values
- Split a string into an array
- Adding and removing the first and last items
- Other uses for pop() and shift()
- Adding, removing and joining multiple items
- Introduction to functions – Part 1
- Introduction to functions – Part 2
- Understanding the return statement
- Filtering arrays
- Sorting arrays
- Applying a function to every item in array with map
- Arrays – Exercise
- Arrays – Exercise answers
- Objects, arrays and functions – Quiz
Logic and loops
- Logic and loops – Introduction
- Logical operators (and, or, not)
- If statements
- Switch statements
- Alternative if statement syntax
- Catching and handing errors
- For loop
- For loop over collections
- While loop
- Alternative looping methods – map() and forEach()
- Looping over cells in a range
- Logic and loops – Exercise
- Logic and loops – Exercise answers
- Logic and loops – Quiz
Project: Table of Contents
- Project: Table of Contents – Introduction
- Overview
- Create the worksheet
- Format the worksheet
- Listing the worksheets
- Add the hyperlink
- Working with hidden sheets
- Final formatting
- Bug fixing and tidy up
Project: Chart axis
- Project: Chart axis – Introduction
- Overview
- Setting the axis value
- Chart selection based on a list
- Parameters based on named ranges
- Testing and tidy-up
Project: User input
- Project: User input – Introduction
- Overview
- Worksheet setup
- Toggle between views
- Improving the user experience
- Save process
- Enhancing the save process
- Tidy up and enhancements
Using Power Automate with Office Scripts
- Auto PivotTable Project – Overview
- Auto PivotTable Project – Script #1
- Auto PivotTable Project – Script #2
- Auto PivotTable Project – Script #3
- Auto PivotTable Project – Build the flow
- Auto PivotTable Project – Testing
Asynchronous Office Scripts
- Asynchronous code – Introduction
- Understanding asynchronous code
- Getting external data with an API
- Getting external images into the workbook
Wrap up
- Wrap-up
- Course Feedback
- Certificate of completion
Also get access to:
Office Scripts Cheat Sheets
Includes over 22 pages of code snippets and examples you can use in your own scripts.
Combine these code snippets together for infinite possibilities.
Power Automate Ready Script Library
Ready-to-use scripts to plug into your Power Automate flows.
Your path to success is as simple as 1-2-3.
Join the Excel Academy
Enrol today to get instant access to the Office Scripts: Automate Excel Everywhere course.
Follow the course
Discover how to automate Excel, build self-running processes.
Apply the learning
Implement your new skills to remove manual work and save time every day.
Stop working harder than you need to. Let Excel do the heavy lifting.
Office Scripts: Automate Excel Everywhere is only available within the Excel Academy.