courses.exceloffthegrid.com Open in urlscan Pro
2a06:98c1:3120::3  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Home Become a member Customer Support
Log In



Click for sound













INCLUDES:

 * Over 9 hours of lessons
   Value $227
 * BONUS: Office Scripts Cheat Sheets
   Value $75
 * BONUS: Power Automate Ready Script Library
   Value $200
 * BONUS: Q&A Support Package
   Value $300

TOTAL VALUE: $802


Buy Now: $227

--------------------------------------------------------------------------------

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 that have plagued users for
decades. 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.


WHAT YOU WILL GET

Office Scripts: Automate Excel Everywhere is the most comprehensive training on
the marking for learning Office Scripts.

The course starts with the fundamentals and shows how all the pieces fit
together. This means 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.

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 - it runs while you sleep!)

With these skills, you can save days of time each month (meaning you can go home
on time more often).


TAUGHT BY SOMEBODY WHO HAS BEEN THERE

About 10 years ago, I set out on a mission…

My work life had become a common routine. Sometimes, I worked until 9:30 pm;
other times, it was 11:30 pm. The exact time was irrelevant. What mattered was
that I constantly missed seeing my children.

I had a young family, and wanted to be around and see them grow up. But due to
work pressures, I hardly saw my children, I rarely saw my wife, and most days, I
didn't even see daylight.

In his book, The ONE Thing, Gary Keller states that answering and actioning the
following question is the secret to efficiency: "What's the ONE Thing I can do,
such that by doing it, everything else will be easier or unnecessary?"

For me, the answer was obvious... automating Excel. That is where my journey
began.

Through this journey, I discovered the best ways to combine Excel's features to
automate tasks. But, I didn't save minutes; I saved months of time every year.

Having learned these skills, I decided to share them with others; this is when I
set up Excel Off the Grid. Now, each year, we reach millions of people through
our blog, YouTube channel, books, and courses.

Because of this commitment to helping others and uncovering new techniques, I
was recognized as a Microsoft MVP. This award is saved for those who make the
most significant impact on the community.



--------------------------------------------------------------------------------


DETAILED COURSE CURRICULUM

We've made it easy for you to learn Office Scripts with a clear structured
approach.

Course includes: 

Over 9 hours of training videos  |  Real-world projects to work through  |
Downloadable workbooks and scripts
Exercises to practice new skills  |  Quizzes to test your knowledge  | 
Certificate of completion  |  English closed captions


MODULES:

INTRODUCTION (18 MINS)

Welcome 00:01:00 What are Office Scripts? 00:02:53 Office Scripts infrastructure
00:03:54 Office Scripts vs VBA: What's the difference? 00:05:23 Do you have
Office Scripts? 00:03:47 Golden rule for learning Office Scripts 00:01:15
Download the support files 00:00:00

GETTING STARTED WITH OFFICE SCRIPTS (49 MINS)

Getting started with Office Scripts - Introduction 00:00:40 Writing your first
script 00:04:39 Editing your first script 00:04:07 Save and delete Office Script
files 00:03:11 Writing your second script 00:01:52 Exploring the Office Scripts
user interface 00:07:36 Using the script recorder 00:03:53 The script recorder
does not capture everything 00:04:08 Sharing scripts with others 00:08:41
Creating an Office Scripts button 00:06:06 Undo Office Script actions 00:04:31
Getting started with Office Scripts - Quiz 00:00:00

UNDERSTANDING THE DOCUMENT OBJECT MODEL (49 MINS)

Understanding the Document Object Model - Introduction 00:00:34 What is the
Document Object Model? 00:04:06 Basic examples of using the Document Object
Model 00:06:27 Learning the DOM 00:13:07 Optimize code using variables with DOM
00:04:30 Active and relative reference with DOM 00:06:47 Objects and collections
in the DOM 00:04:04 DOM - Exercise 00:01:26 DOM - Exercise answers 00:02:47 DOM
- Exercise - Alternative approach 00:05:19 Document Object Model - Quiz 00:00:00

PROGRAMMING FUNDAMENTALS (82 MINS)

Programming fundamentals - Introduction 00:01:06 The Main function 00:03:18
Adding and using comments 00:04:46 Colors used in the code editor 00:02:49
Whitespace, line breaks and semi-colons 00:02:44 Declaring & assigning variables
00:09:23 Understanding variable types 00:07:14 Working with strings 00:04:45
String properties and methods 00:06:39 Concatenating text strings 00:03:27
Working with numbers 00:03:31 Number and Math object methods and properties
00:04:18 Arithmetic operators 00:05:30 Working with booleans 00:02:17 Comparison
operators 00:06:11 Type conversion 00:05:49 String converter - Exercise 00:01:15
String converter - Exercise Answers 00:05:09 Multiplication tester - Exercise
00:01:43 Multiplication tester - Exercise answers 00:04:49 Programming
fundamentals - Quiz 00:00:00

OBJECTS, ARRAYS AND FUNCTIONS (102 MINS)

Objects, arrays and functions - Introduction 00:01:31 What are objects? 00:05:21
Working with objects 00:06:30 Object references 00:02:59 What are arrays?
00:04:32 Working with arrays 00:04:37 Ranges vs arrays 00:06:13 Working with
ranges and arrays of unknown sizes 00:07:37 Concatenating array values 00:03:43
Split a string into an array 00:04:06 Adding and removing the first and last
items 00:06:40 Other uses for pop() and shift() 00:01:45 Adding, removing and
joining multiple items 00:07:14 Introduction to functions - Part 1 00:05:05
Introduction to functions - Part 2 00:04:35 Understanding the return statement
00:03:23 Filtering arrays 00:11:49 Sorting arrays 00:04:21 Applying a function
to every item in array with map 00:03:30 Arrays - Exercise 00:01:43 Arrays -
Exercise answers 00:05:22 Objects, arrays and functions - Quiz 00:00:00

LOGIC AND LOOPS (65 MINS)

Logic and loops - Introduction 00:01:34 Logical operators (and, or, not)
00:06:40 If statements 00:07:03 Switch statements 00:06:47 Alternative if
statement syntax 00:04:50 Catching and handing errors 00:05:07 For loop 00:05:44
For loop over collections 00:03:40 While loop 00:04:39 Alternative looping
methods - map() and forEach() 00:03:50 Looping over cells in a range 00:08:22
Logic and loops - Exercise 00:02:00 Logic and loops - Exercise answers 00:05:05
Logic and loops - Quiz 00:00:00

PROJECT: TABLE OF CONTENTS (45 MINS)

Project: Table of Contents - Introduction 00:00:39 Overview 00:01:06 Create the
worksheet 00:06:45 Format the worksheet 00:09:27 Listing the worksheets 00:04:19
Add the hyperlink 00:06:08 Working with hidden sheets 00:04:58 Final formatting
00:05:09 Bug fixing and tidy up 00:06:40

PROJECT: CHART AXIS (23 MINS)

Project: Chart axis - Introduction 00:00:35 Overview 00:02:29 Setting the axis
value 00:07:20 Chart selection based on a list 00:04:41 Parameters based on
named ranges 00:04:15 Testing and tidy-up 00:03:46

PROJECT: USER INPUT (39 MINS)

Project: User input - Introduction 00:00:37 Overview 00:02:16 Worksheet setup
00:04:56 Toggle between views 00:07:11 Improving the user experience 00:05:14
Save process 00:06:03 Enhancing the save process 00:10:18 Tidy up and
enhancements 00:02:22

USING POWER AUTOMATE WITH OFFICE SCRIPTS (70 MINS)

Using Power Automate with Office Scripts - Introduction 00:01:24 What is Power
Automate? 00:04:54 Getting started with Power Automate 00:09:49 Run an Office
Script with Power Automate 00:04:35 Run an Office Script on all files in a
folder 00:05:45 Passing parameters from Power Automate to Office Scripts
00:06:08 Using Table values as Office Script parameters 00:04:32 Passing values
from Office Scripts back to Power Automate 00:12:09 Auto PivotTable Project -
Overview 00:02:29 Auto PivotTable Project - Script #1 00:02:22 Auto PivotTable
Project - Script #2 00:04:45 Auto PivotTable Project - Script #3 00:00:46 Auto
PivotTable Project - Build the flow 00:07:10 Auto PivotTable Project - Testing
00:02:56

ASYNCHRONOUS OFFICE SCRIPTS (27 MINS)

Asynchronous code - Introduction 00:00:38 Understanding asynchronous code
00:07:31 Getting external data with an API 00:11:33 Getting external images into
the workbook 00:07:10

WRAP-UP (1 MINS)

Wrap-up 00:01:22 Course Feedback 00:00:00 Certificate of completion 00:00:00

Buy Now: $227

The Office Scripts: Automate Excel Everywhere course is also available inside
the Excel Academy membership.

Sign up today and get these FREE bonuses!

If you sign up today, not only will you get the full training course, but you
will also receive three amazing bonuses.

These bonuses make the training even easier to implement in your day-to-day
work.


BONUS #1


OFFICE SCRIPT CHEAT SHEETS




($75 Value)

This bonus includes over 22 pages of code snippets and examples that you can
copy and use in your own scripts.

Combine these code snippets together for infinite possibilities.

This bonus alone will save you hours of time and effort in learning to write
your own scripts.


BONUS #2


POWER AUTOMATE READY SCRIPT LIBRARY



($200 Value)

Ready to use scripts to plug into your Power Automate flows.

Includes:

 * Moving data between workbooks
 * Converting CSV to Excel
 * Passing cell values as parameters
 * Moving images between workbooks
 * Sorting worksheets


BONUS #3


Q&A SUPPORT PACKAGE

 



($300 Value)

Get course support from a Microsoft MVP. 

If you get stuck, this gives you access to an expert to answer your questions.

Each lesson page has space for Q&A. You can ask about specific lessons, and we
will do our best to help you. If necessary, we can take things to the next level
by providing 1:1 support via email/video.

Buy Now: $227


30 DAY MONEY BACK GUARANTEE

Your purchase is covered by a no questions asked, 100% money-back guarantee.

We never want you to be disappointed. So, if you are not satisfied, please get
in touch with us within 30 days, and we will give you a full refund.


WHAT DO PEOPLE SAY ABOUT OUR CONTENT AND TRAINING?


JOHN

"Mark, you're an absolute legend! 🏆

You've just guided me through the final steps I needed in order to finish
building a tool I've been working on most of the day.

The tool is to be used to work through over 100 separate cases, with more likely
to come, which each take 15 minutes to complete, at best.

This has changed my individual case time down to a little under two minutes.
That's a massive saving of over 22 hours on just this current batch!!! 😲"


JIM

"Mark, you are one of the best mentors I have ever had the privilege of learning
from. Your down to earth and easy explained examples are tremendous. You stand
apart by your endless willingness to help where you can. Thank you sir. I will
forever be in your debt and will endeavour to share what knowledge I have as you
have demonstrated so skillfully.

Cheers!"


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.

My first Office Scripts experience was in 2021. 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.

Six times per day:

 * An email would arrive containing new data.
 * The data was downloaded and used in various reports
 * The reports were emailed to a select set of individuals

VBA would have been a great option. However, with VBA, you still need to click
the buttons. I had a gut feeling Power Automate and Office Scripts were the way
to go.

After playing around for a while, I unveiled the solution. 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 didn't
even need to think about it... it just happened.

This course covers every technique used in that solution, along with every
technique I've discovered since.


FREQUENTLY ASKED QUESTIONS

WHAT SKILL LEVEL DO I NEED TO JOIN?

The course has been designed with non-programmers in mind. So, provided you have
some experience of working with Excel, you will be fine.

WHAT SOFTWARE DO I NEED?

You will need access to Office Scripts in Excel 365 for Windows, Mac, or Online.

Basically, if you have the Automate tab, you're good to go.

Even if your Windows or Mac version of Excel does not have the Automate tab, go
to https://excel.new and check if you have the Automate tab in Excel Online.

Still not sure? Here are the license and system requirements.

Licences & system requirements:

 * Excel for Windows (version 2210 or higher), Excel for Mac (version 16.66 or
   higher), or Excel on the web.
 * OneDrive for Business.
 * Any commercial or educational Microsoft 365 license with access to the
   Microsoft 365 Office desktop apps:
   * Office 365 Business
   * Office 365 Business Premium
   * Office 365 ProPlus
   * Office 365 ProPlus for Devices
   * Office 365 Enterprise E3
   * Office 365 Enterprise E5
   * Office 365 A3
   * Office 365 A5

NOTE: The action recorder is not currently released for the Semi-Annual release
channel. This is not a problem; you can follow the action recorder lessons using
Excel Online.

If you have all the licenses and requirements and still don't have the Automate
tab, speak to your IT department. They may need to give you the latest updates,
or they may have disabled Office Scripts for all users.

HOW LONG DO I HAVE ACCESS TO THE COURSE?

The course comes with lifetime access. After joining, you can access this course
for as long as you like.

HOW LONG DOES IT TAKE TO LEARN OFFICE SCRIPTS?

This partly depends on your previous experience and requirements.

The course contains over 9 hours of training videos. Plus, there are exercises
and quizzes to complete. The total training time is approximately 12 hours.

However, learning Office Scripts requires practice. Therefore the bonuses
provide additional support to help you implement Office Scripts in your
scenarios.

I ALREADY KNOW VBA, SO WHY SHOULD I LEARN OFFICE SCRIPTS?

Office Scripts and VBA both allow users to automate tasks. And both are
designed to empower people who may not consider themselves programmers to create
small programs in Excel.

While there are a lot of crossovers, Office Scripts and VBA operate in different
ways and different environments:

 * Office Scripts are a new feature for Office 365, built with modern
   security protocols in mind, while VBA is increasingly being seen as a
   security risk.
 * Office Scripts are cloud-based; they can be run from any device with an
   internet connection; while VBA can only run from a desktop PC.
 * Office Scripts are easier to write than VBA, as they are written
   in TypeScript and contain less ambiguity in the Document Object Model.
 * Office Scripts integrate directly with Power Automate for cross-application
   no-code automation.

 

WHEN DOES THE COURSE START AND FINISH?

It is a self-paced online course, so you can decide when you start and finish.

WHAT IF I'M NOT SATISFIED WITH THE COURSE?

We would never want you to be disappointed. So, if you're not satisfied with the
course, contact us at https://exceloffthegrid.com/customer-support within 30
days, and we will give you a full refund.

WHAT IF I HAVE QUESTIONS DURING THE COURSE?

We want you to succeed, so if you have questions about the content, we want to
answer them.

Below each lesson is a comment section for you to ask questions. We will do our
best to help you.

Plus, the Q&A Support Package means that, if necessary, we can provide 1:1
support via email/video.

HOW MUCH DOES THE COURSE COST?

The total value of the course and bonuses is $802.

But, we are offering the entire package for just $227.

I'VE GOT MORE QUESTIONS, WHO CAN I CONTACT?

If you have any further questions, please send a message through our Customer
Support pages: https://exceloffthegrid.com/customer-support

WHAT WILL I RECEIVE AFTER COMPLETING THE COURSE?

Firstly (and most importantly), you will have a clear understanding of Office
Scripts and how you can apply them to automate your work.

Secondly, you will receive a certificate of completion to include on your CV and
LinkedIn profile.

--------------------------------------------------------------------------------


PACKAGE INCLUDES:

 * Over 9 hours of lessons
   Value $227
 * BONUS: Office Scripts Cheat Sheets
   Value $75
 * BONUS: Power Automate Ready Script Library
   Value $200
 * BONUS: Q&A Support Package
   Value $300

TOTAL VALUE: $802


Buy Now: $227


Home Library Customer Support Terms and conditions Privacy
© 2024 Twenty Seven Solutions Limited


JOIN OUR FREE TRIAL

Get started today before this once in a lifetime opportunity expires.