Linkedin Facebook-f Instagram

Digital skills courses

Microsoft Digital Skills Courses

Our range of courses aim to empower, develop and enhance the in-house capabilities of your business.

With different levels for all abilities, flexible delivery, and affordable pricing, these courses will provide you with the tools for positive change.

Microsoft in Education Global partner training badge - Digital Empowerment for Organisations

Power BI Essentials

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Power BI Essentials

Course Outcomes

  • Getting started with Power BI
  • What is Power BI & how it works with data
  • How to use the Power BI dashboard
  • How to create a simple Power BI via a data source
  • Editing data
  • How to extract data online and convert into usable sources
  • Creating visually appealing Power BI reports and visualisations
  • Sharing, collaborating and publishing
  • How to add a Power BI into Teams
  • Filtering data and options (save as image, charts view, highlighting, export)
  • Options/Filtering
  • Using AI to analyse data with Q & A and smart narrative
  • Forecasting and further analysis

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff with either an interest in data or working in a role which requires access to data to explore trends in workflow or statistics
  • Learners must have access to an active Microsoft 365 for Business Teams account and Power BI (web version) to attend this training
READ MORE

Power BI/Excel Data Analytics

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Power BI/Excel Data Analytics

Course Outcomes

  • Import data from Excel and other locations into Power BI.
  • Understand the Power BI environment and its three Views.
  • Build beginner-to-moderate level skills for navigating the Power BI product.
  • Explore influential relationships within datasets.
  • Design Power BI visuals and reports.
  • Build effective dashboards in Power BI Online.
  •  

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff with either an interest in data or working in a role which requires access to data to explore trends in workflow or statistics and to take this further when using Excel
  • Learners must have access to an active Microsoft 365 for Business Teams account and Power BI (web version) to attend this training
  •  
READ MORE

Teams Essentials

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Teams Essentials

Course Outcomes

  • The components and elements of Microsoft Teams
  • The creation process of Microsoft Teams channels
  • Using apps & tabs through Microsoft Teams 
  • Collaborative features within Teams
  • Key features within Microsoft Teams meetings & communications solutions

Course Delivery

  •  6 hour interactive webinar
  • Suitable for all staff 
  • Learners must have access to an active Microsoft Teams account 
READ MORE

Teams Advanced

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Teams Advanced

Course Outcomes

  • The components and elements of Microsoft Teams
  • The creation process of Microsoft Teams channels
  • Using apps & tabs through Microsoft Teams 
  • Collaborative features within Teams
  • Key features within Microsoft Teams meetings & communications solutions

Course Delivery

  •  6 hour interactive webinar
  • Suitable for all staff 
  • Learners must have access to an active Microsoft Teams account 
READ MORE

Microsoft 365 AI Essentials

  • Interactive Webinar
  • Remote Delivery

Microsoft 365 AI Essentials

Course Outcomes

This two-day course is designed for learners who have experience with using and have access to the Microsoft Edge browser and a Microsoft 365 account.

Course Delivery

In this two-day training, participants will delve into how Microsoft Copilot via the Edge browser can streamline communication and enhance content creation. The learning path, designed to be both practical and enlightening, spans three key modules. These modules will guide attendees through the basics of Copilot for Microsoft 365, showcase its versatility across web content, various Microsoft 365 applications, and offer advice on maximizing its potential.

READ MORE
enquire today

Excel Essentials

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Excel Essentials

Course Outcomes

  • Know and understand the basic components of Excel including cell referencing
  • Navigate and optimise the Microsoft Excel interface
  • Structure basic spreadsheets
  • Construct basic formulas with Excel functions to perform calculations
  • Apply formatting to spreadsheets to create a professional look
  • Utilise all Excel features for working with large spreadsheets/databases
  • Apply the basic analysing tools of Excel to analyse/filter/sort large data sheets
  • Working with multiple data sheets and the importance of cell referencing
  • Creating and Understanding Tables
  • Working with Dates and Times
  • Basic Charts
  • Add basic security to spreadsheets

Course Delivery

  • 6 hour interactive webinar
  • Suitable for all staff
  • Learners must have access to  an active Microsoft 365 for Business Teams account and Excel (desktop version)
READ MORE

Excel Intermediate

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Teams Intermediate

Course Outcomes

  • Understanding of Dynamic, Relative and Absolute Formulas and using named ranges in formulas
  • Apply conditional formatting to highlight data that meets specific criteria
  • Use Excel’s Logical functions in formulas to perform different calculations based on specified criteria
  • Splitting and joining separate columns of data
  • Manipulate data without using formulas
  • Understand how Excel handles dates & times
  • Use the Analyse Data tool to extract insights from data
  • Combining formulas together to match criteria and extract information
  • Use different cell referencing in formulas to ensure the calculations are applied to the correct data
  • Consolidating data to perform summaries on data sheets

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff who have completed the Excel Essentials course and use Excel on a regular basis.
  • Learners must have access to  an active Microsoft 365 for Business Teams account and Excel (desktop version)
READ MORE

Excel Advanced

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Excel Advanced

Course Outcomes

  • Summarise data across multiple worksheets
  • Use 1D, 2D and 3D lookup functions to extract data
  • Use the XLOOKUP function to extract data
  • Use What If Analysis tools to work with through data modelling scenarios –Goal Seeker, Scenario Manager and Solver
  • Apply advanced data filtering techniques to extract data based on complex criteria
  • Understanding Excel Tables and the part they play in Pivot Tables
  • Introduction to Pivot Tables
  •  

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff who have completed the Excel Intermediate course and use Excel on a regular basis.
  • Learners must have access to  an active Microsoft 365 for Business Teams account and Excel (desktop version)
  •  
READ MORE

Excel Pivot Table

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Excel Pivot Table

Course Outcomes

  • Understanding Excel Tables and the part they play in Pivot Tables
  • Use pivot tables to summarise vast amounts of data and professionally present the summary
  • Creation and Design of Pivot Tables
  • Understanding Segmentation of a Pivot table
  • Changing the Design of a Pivot Table to manipulate the data
  • Formatting, Sorting and Filtering Data within a Pivot Table
  • Designing Missing/Error Values
  • Updating Data and Refreshing Pivot Tables
  • Grouping Data and Using Slicers
  • Creating Calculated Fields within a Pivot Table
  • Inserting Pivot Charts and Slicers
  • An Introduction to the  GETPIVOTDATA function
  • Moving a Pivot Table
  • Showing/Hiding Fields
  • Clear and Delete Old Items

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff who have completed the Excel Intermediate course and use Excel on a regular basis.
  • Learners must have access to  an active Microsoft 365 for Business Teams account and Excel (desktop version)
READ MORE
enquire today

PowerPoint Essentials

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

PowerPoint Essentials

Course Outcomes

  • Work with presentations and save them in different file formats, locally or in the cloud.
  • Use available help resources to enhance productivity.
  • Understand different presentation views and when to use them, choose different built-in slide layouts, designs and themes.
  • Enter, edit and format text in presentations. Recognise good practise in applying unique titles to slides and creating consistent slide content by using the master slide.
  • Choose, create and format organisational charts.
  • Insert, edit and align pictures and drawn objects.
  • Apply animation and transition effects to presentations, and check and correct presentation content before printing and presenting.

Course Delivery

  • 6 hour interactive webinar
  • Suitable for all staff
  • Learners must have access to  an active Microsoft 365 for Business Teams account and PowerPoint (desktop version)
READ MORE

PowerPoint Advanced

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

PowerPoint Advanced

Course Outcomes

  • Create and modify templates and themes, and work with slide master layouts.
  • Enhance a presentation using built-in drawing and image tools. Use alternative text for accessibility.
  • Create and edit diagrams.
  • Insert audio and video, create audio and screen recordings, and apply built-in animation features.
  • Apply Morph transitions.
  • Use linking, embedding, importing to integrate data.
  • Work with custom slide shows and apply slide show settings.
  • Use presenter view and control a slide show.

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff who have completed the PowerPoint Essentials course and work with PowerPoint on a regular basis. 
  • Learners must have access to  an active Microsoft 365 for Business Teams account and PowerPoint (desktop version)
READ MORE

Word Essentials

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Word Essentials

Course Outcomes

  • Work with documents and save them in different file formats, locally or in the cloud.
  • Use available help resources, shortcuts and tools to enhance productivity.
  • Create and edit Word documents that will be ready to share and distribute.
  • Apply different formats and styles to enhance documents and recognise good practice in choosing the appropriate formatting options.
  • Insert tables, pictures and drawn objects into documents.
  • Adjust document page settings and check and correct spelling before printing.
  • Prepare documents for mail merge operations.

Course Delivery

  •  6 hour interactive webinar
  • Suitable for staff
  • Learners must have access to  an active Microsoft 365 for Business Teams account and Word (desktop version)
  •  
READ MORE

Word Advanced

  • Interactive Webinar
  • Remote Delivery
  • 9:30 - 15:30

Word Advanced

Course Outcomes

  • Apply advanced text, paragraph, column and table formatting.
  • Maintain a consistent design using paragraph styles.
  • Work with referencing features like footnotes, endnotes and captions. 
  • Create tables of contents, indexes and cross-references.
  • Enhance productivity by using fields, forms and templates.
  • Apply advanced mail merge techniques.
  • Collaborate and review documents. Apply document security features.
  • Work with watermarks, sections, and headers and footers in a document.

Course Delivery

  • 6 hour interactive webinar
  • Suitable for staff who have completed the Word Essentials course and work with Word documents on a daily basis.
  • Learners must have access to an active Microsoft 365 for Business Teams account and Word (desktop version)
READ MORE

Getting Started with Microsoft 365

  • Interactive Webinar
  • Remote Delivery

Getting Started with Microsoft 365

Course Outcomes

  • Extend your understanding of Microsoft 365 and how to access tools for workplace productivity. 
  • Experience working in a simulated business environment using various Microsoft 365 apps 
  • OneDrive to communicate and collaborate with colleagues 
  • Acquire the skills to reach out to your customers through a variety of engagement tools via Microsoft 365 

Course Delivery

  •  6 hour interactive webinar
  • Suitable for all staff 
  • Learners must have access to an active Microsoft 365 for Business account 
READ MORE
enquire today

FREQUENTLY ASKED QUESTIONS​

These courses are suitable for both businesses and individuals – they are ideal for anyone who wants to digitally upskill. If you use Microsoft 365 in your working environment, then these courses are the perfect way to enhance your efficiency and productivity, in a cost effective and time efficient way!

We are able to offer full and part-funded opportunities, subject to eligibility. We can also offer discounts for group bookings. Contact us for further information. 

Each course is different, and information is available on each course page. Courses are all delivered online (although face to face opportunities are available upon request), and if you are making a group booking, we can deliver these courses to best suit your business needs. 

Upon completion of your course, we will issue you with a certificate of achievement to demonstrate that you have successfully completed the training. We also have many pathways available if you’d like to progress further in your digital skills journey!  

YOU MAY ALSO BE INTERESTED IN...

Our Digital Skills for Business course is perfect if you'd like to continue your digital skills journey, whilst achieving a fully accredited qualification

FIND OUT MORE
2024-Top10_Best-Large-Companies
Regional_Top5_list_logo_Wales
2024Top5_EducationTrainingLogo
guernsey
premiership_rugby_logo
Bouygues copy
SwanseaUni copy
CITB
Jersey
NHS-Wales
kier copy
Ospreys
Principality
bridgendcollege
collegeswales
centerprise
awen
walesmilleniumcentre
jtrs
keepwalestidy
lenovo
moxton
coastalhousing
uwtsd
wrpa
fireservice
swp

Quick links

Stay up to date...

sign-Up To Our Newsletter

SIGN UP TO OUR MAILING LIST

Part of Educ8 Group

Registered office: Tredomen Gateway, Ystrad Mynach, Hengoed, CF82 7EH

Scroll to Top
Sorry to interrupt...
You're currently viewing our A2B Business site

If you’re in the right place, just close this pop-up or if you’re looking for our education site, click below!

Take Me To A2B Education