Office Scripts Introduction

Learn with Wales leading Office Scripts training provider

Expert Office Script trainers with 5 Star customer ratings

Bespoke Office Script training courses available

Office Script support for businesses available

Classroom, Onsite and Virtual courses available

Welsh Government funding accepted

Duration: 1 Day
Accredited: No
Exams: N/A
Funding: Accepted
Type: Classroom, Onsite, Virtual
Company group booking discount available

Course Information

Course Overview

This Introduction to Office Scripts course is suitable for users who are looking to automate repetitive tasks. By writing simple scripts, you can streamline your data management processes, ensuring tasks are performed consistently and efficiently.

Outline

Office Scripts Introduction

Introduction

  • What are Office Scripts?
  • Where can I find Office Scripts?
  • Where are Office Scripts used for?

The Action Recorder

  • How to record an Office Script
  • Using an Office Script

Where are Office Scripts Stored?

  • The default file save location for office scripts
  • Using SharePoint to share a script with your team

Introducing the Code Editor

  • Accessing the editor
  • Using the editor to amend an existing script

Writing an Office Script

  • Create a script from scratch
  • Referencing a Worksheet
  • Referencing cells and ranges
  • Using variables to store information
  • What is a function?
  • Creating a function?
  • Formatting a range
  • Formatting a table
  • Creating calculations in Office Scripts

Using Power Automate

  • Running an Office Script from Power Automate

 

Assessment

Office Scripts Introduction

There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session.

What's Included

  • 1-days training from NILC’s accredited Office Scripts trainer
  • Course notes and practice files
  • Recording of the course (available on request for virtual courses only)

Dates & Prices

  • Can't find the course dates, location or delivery type you are looking for?

    Enter your training requirements below and a member of our team will be in contact with you to discuss them further.

    Number of Delegates
    Course Delivery Format

  • Can't find the course dates, location or delivery type you are looking for?

    Fill out the request dates form above and we'll try our best to accommodate or contact us directly.

    Why choose NILC for your training?

    Learn why we should be your training provider of choice.

    Awarding Winning Training Courses with industry leading customer satisfaction rates

    A family business with customer service at the heart of everything we do

    Trusted Training Partner to multiple colleges, government departments, businesses and unions

    UK based Trainers that are industry experts and fully qualified

    Rated "Excellent" with over 500+ Trustpilot Reviews

    How we deliver our courses

    Virtual
    Classroom
    Onsite
    Online

    Virtual

    Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.

    Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.

    Classroom

    Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.

    We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.

    Onsite

    Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.

    We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.

    Online

    Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.

    We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.

    Why choose NILC for your training?

    Learn why we should be your training provider of choice.

    Awarding Winning Training Courses with industry leading customer satisfaction rates

    A family business with customer service at the heart of everything we do

    Trusted Training Partner to multiple colleges, government departments, businesses and unions

    UK based Trainers that are industry experts and fully qualified

    Rated "Excellent" with over 500+ Trustpilot Reviews

    Testimonials

    “Highly Recommended”

    A complex course subject was delivered clearly and with great passion and enthusiasm by our tutor. Subjects were explained in clear, real-life examples. Without doubt, I'm sure my successful result is in large part due to his experience and skill in this area.

    - Neil Wilson

    “Fantastic Course Thank You”

    Fantastic course. Amazing from start to finish. Julie was absolutely outstanding. She was professional and has given me the knowledge and confidence to continue my studies. I cant thank Karim and team enough.

    - Jodie Gee

    “Great Tuition"

    Great tuition. Felt really comfortable to ask questions and the course was engaging. Tony and Karim were brilliant.

    - Amy Jones

    “Great Instructor”

    Great instructor. Well delivered and knows the subject inside and out. Friendly and provides a warm atmosphere conducive for feeling relaxed. A lot of context to cover in a short time.

    - David Schofield

    “Five Star Quality Course”

    I received all the resources in advance which helped me prep for the course. The tutor was engaging and explained complex topics really well. The exam coaching was a unique selling point for me as it got me prepared for the exams so that nerves were less of a factor. Great communication throughout, thank you Tony and the whole team.

    - Kim Darkin

    Office Script FAQ's

    What are Office Scripts?

    Office Scripts are a feature in Microsoft Excel, available on Excel for the web, that allows users to automate repetitive tasks. These scripts are written in TypeScript, which is a superset of JavaScript, offering a familiar syntax for those with some programming experience.

    What are Office Scripts used for?

    The primary function of Office Scripts is to enable users to record, write, and run scripts that automate tasks like data calculation, formatting, and other repetitive processes in Excel spreadsheets. For example, a user could create a script that automatically extracts data from specific cells, performs calculations, and formats the results in a designated report layout, all with the click of a button.

    What is the difference between VBA and Office Scripts?

    Office Scripts and VBA (Visual Basic for Applications) are both used for automating tasks in Microsoft Excel but differ significantly. Office Scripts, accessible only on Excel for the web, are written in TypeScript and offer a modern, user-friendly approach to automation, particularly suitable for cloud-based workflows within Excel. In contrast, VBA is available on desktop versions of Office applications and uses a more traditional programming language, enabling extensive automation capabilities across the entire Office suite.

    Trusted By