Excel Module 1 – Key Skills and Formula Creation

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Excel Module 2 – Data Analysis and Pivot Tables

Expand your Excel knowledge and learn how to structure and analyse large data sets.

Excel Module 3 - Data Management Techniques

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

Excel Module 4 – Advanced Formulas and Functions

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.

Excel – Mastering Formulas and Functions

Ideal for those already using Excel but who really want to get to grips with formulas and functions.

Excel - Pivot Table Specialist

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data.

Excel Power Query and Power Pivot

Learn how to work with and connect multiple data sets to effectively analyse and report on data.

Excel Charting Specialist

Look at the in depth features of charts and some specialist tools to make your charts come to life.

Excel Advanced Statistical Analysis

Use some of the hidden statistical analysis tools within Excel to build complex data models.

Excel – Working with Macros

Learn how to use Macros in Excel to automate your work and start to see the power these can give you.

VBA in Excel – Part 1

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.

VBA in Excel – Part 2

Expand your VBA knowledge further and learn some of the more advanced coding features.

Project – Planning and Control

Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle.

Project – Advanced Planning and Control

Look at some of the more advanced planning features available in Project.

Project – Master Projects and Resource Pools

Learn how to use Master Projects and Resource Pools to create better visibility across projects.

Project – Reporting

Use the features in project to report effectively on your plans.

Primavera P6 Planning and Control

Learn how create and structure enterprise projects and programmes.

Primavera Risk Analysis

Discover the powerful schedule and cost risk analysis features of PRA.

Nodes and Links – Project Insights and Managing Risk

Learn how to use this innovative tool to analyse and validate your schedule, to add and model uncertainty and risk and to work with updated plans to compare project progress.

Power BI – Introduction

Learn how to use this powerful tool to import and clean data and create some amazing visuals.

Power BI - Advanced Reporting

Expand your Power BI knowledge and take your reports to the next level.

Access – Database Design and Reporting

Learn how to create fully relational databases and how to input, extract and report on data.

Adobe Acrobat Standard/Professional

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available.

Adobe Acrobat Reader

There is so much more to this free tool than just creating PDFs.  Learn what else you can do for free.

Outlook - Improving Efficiency

We use it everyday but there are so many additional tools to save you time and make your work in Outlook more efficient and less stressful.

OneNote

Learn how to use OneNote to create, organize and populate electronic notebooks.

PowerPoint – Professional Presentations

Learn the proper way to use PowerPoint and the background features that can make a real difference.

Teams

Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings.

Visio – Flowcharts and Diagrams

Ensure you can fully utilize this powerful tool to create a range of flowcharts and diagrams.

Word Document Production

Part 1

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents.

Word Document Production

Part 2

Discover the more complex features of Word for long document creation.

Word Email Merge

Learn how to create a mail merge in Word to allow you to send personalized emails to groups of people.