Catalog

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.

Our Excel Level 1 course covers Tips & Tricks for selection, navigation and using shortcuts for all the things that normally would take twice the time (which you do a lot!). You’ll learn all the basics to create and manage spreadsheets yourself and we cover the 5 basic formulae everyone should know! We teach the secrets of formatting super-fast to make your spreadsheets look great.

To help you become an Excel Ninja we cover manipulating multiple files and worksheets, 3D formulas, linking cells and special number formats to speed up data entry; ways to collapse large workbooks to see the totals you need and advanced charting; Making amazing tables in one click with secret built in formula; You'll learn how to speed up navigation around your spreadsheet and use range names in formula;

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. You'll be looking at the Advanced Data Management features and how you can use them; You'll use Goal Seek and Solver to show how to answer business questions; We will look at what macros are, best practise and create a simple macro in our session.

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 Business Intelligence 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 the tools – Get & Transform, Power Pivot, Power Maps and Desktop BI Visualisations.

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

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.

Do you need to know the basics of Microsoft Word? We’ll teach you shortcuts and quicker ways of working from the outset. If you need to create stunning documents which are beautifully formatted, with tables and using heading styles to quickly make an impact, this is an ideal course for you! This course is ideal for beginners or those wanting to learn quicker ways to work. We take the stress out of working with Word. This syllabus will be covered over two x 3 hour sessions.

In this course, you will learn how to create complex and professional documents with a consistent look and feel. Creating professional-looking documents can help you give your organisation a competitive edge and mastering these techniques will make you a valued employee in your organisation.

This course takes basic PowerPoint delegates on to gain Advanced skills. The course covers using graphics and media clips and animating slides.

An introduction to PowerPoint for those who have little or no experience in creating presentations. This is a brilliant course for beginners who will gain confidence and learn to produce compelling PowerPoint presentations quickly and easily. Slightly more experienced delegates will benefit from learning the shortcuts and quicker ways of working!

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.

This course is designed for existing SharePoint site users who will create and manage a SharePoint site. Prerequisites: To ensure your success in your course you should be have basic end-user skills with Microsoft Windows 8 or later and any or all of the Microsoft Office 2010, or 2013 suite components, plus basic competence with Internet browsing. You should also have basic SharePoint site user skills such as the ability to access and use lists, libraries, and documents on a typical SharePoint team site.

End User SharePoint for Content Authors

Run as two 3 hour sessions, this Interactive Online course allows presenters to explore how to run sessions using Microsoft Teams. Over both sessions we cover the role of Teams, Channels, Files, Meetings and Chat using Office 365. Additional topics to help trainers prepare and run classes are included.

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

Run as two 3 hour sessions, this Interactive Online course allows presenters to explore how to run sessions using Microsoft Teams. Over both sessions we cover the role of Teams, Channels, Files, Meetings and Chat using Office 365. Additional topics to help presenters prepare and run meetings are included.

Introduction to Computers - for those who feel 'left behind' by computers we cover the basics of keyboard, mouse, software and the internet. This course is specifically designed for anyone with little or no knowledge of computers or no formal training. It is ideal for those who would like the opportunity to gain hands on experience, giving you an overview of using Microsoft Office at work.