Catalog

Become an Excel Ninja as you master working with multiple files and sheets, 3D formulas, links, special formats, collapsing large workbooks, advanced charts, and one‑click tables with built‑in formulas. Enjoy expert‑led online training via Microsoft Teams with a Microsoft Certified Trainer, plus a full session recording to revisit every tip anytime.

On this course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Learn the new XLOOKUP function.

Knowing your numbers - your core metrics - is absolutely critical to your success. Sometimes the numbers you need to track are spread out across different systems. It's so useful to have everything on one screen and all you need is to give it a glance. Yes, it's time to make a dashboard. It's like the instrument panel for your business. Your car has one. Planes have one. Let's make one for your business too.

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

Our Excel Level 1 course teaches smart selection, navigation and shortcut techniques to speed up tasks. You’ll learn essential skills to create and manage your own spreadsheets, plus the five key formulas everyone needs. Enjoy expert led training live online via Microsoft Teams with a Microsoft Certified Trainer, and receive a full video recording to revisit every tip anytime, which you may find incredibly useful later on.

Run as two 3 hour sessions, this Interactive Online Awareness session is packed with ideas of how your Sales Team can master using Microsoft Teams to collaborate with colleagues and how to use it for meetings with clients and making presentations. Over both sessions we cover the role of Teams, Channels, Files, Meetings and Chat using Office 365. Additional specific topics to help Sales Teams are included.

Looking at the potential of using Teams better

These sessions will teach you the skills to create forms with drop down boxes and other interactive features, as well as showing you how to customise the program to suit the way you work. Imagine having all the buttons you want at your fingertips! Macros are covered so that you will learn how to record actions you repeat frequently.

This introductory course is designed for office staff and managers with little or no formal training in Microsoft PowerPoint. It covers creating, editing, and formatting presentations, adding graphics and tables, using Copilot for efficiency, and essential tools for building effective and engaging slideshows.

This Advanced course takes experienced users of Outlook through more complex email actions and allows delegates to set rules and prioritise what they see in their Inbox. You will want to set Out of Office messages when you are away from your desk, and Archive emails you don't want to see in your Inbox but don't want to delete. Learn how to find specific messages with Search and how to use Categories throughout the package. When sharing your calendar or contacts, we can show you how to set up permissions.

SharePoint Site Owner 1 day course – can be customised for closed / on-site course delivery Student Pre-requisites: Assumes basic end user knowledge of a current or previous version of SharePoint, or attendance of a one day SharePoint End user course. NB. This course can be tailored for Office 365 SharePoint Online or SharePoint on-premises environments.

SharePoint Administrator

This a 2 Day course catering to SharePoint End User and SharePoint site content authors

Learn how to use Power Automate and the business value and features available. Attendees should have basic experience of SharePoint and a grasp of business processes or workflows (maybe from other environments or from SharePoint Designer workflows)

SharePoint Site Owner 1 day course – can be customised for closed / on-site course delivery Student Pre-requisites: Assumes basic end user knowledge of a current or previous version of SharePoint, or attendance of a one day SharePoint End user course. NB. This course can be tailored for Office 365 SharePoint Online or SharePoint on-premises environments.

Copilot enhances HR efficiency by automating tasks, providing data-driven insights, and personalising communication. It streamlines processes by integrating with existing HR systems and reduces manual data entry and errors. Additionally, it integrates with M365 apps like Teams, Outlook, SharePoint, and Excel, facilitating collaboration, document management, and data analysis.

Audience: Professionals aiming to improve efficiency through the use of AI tools. Delivered over three full-day sessions

Microsoft Copilot for Microsoft 365 is an AI-powered productivity tool. Enhances efficiency, creativity, and information analysis in apps like Outlook, Excel, and Teams. Course for executives and business leaders with a Microsoft 365 Copilot license. Covers crafting effective prompts and offers an interactive experience. Demonstrates seamless integration into daily workflows to boost productivity and innovation.

Microsoft Copilot is an AI-powered productivity tool that helps users work more efficiently. It leverages the power of AI to boost productivity, unlock creativity, and helps you understand information better with a simple chat experience.