Microsoft Courses

Course Overview This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

Course Overview This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Course Overview ChatGPT is a revolutionary technology that’s reshaping the world of work. Everybody is talking about it, but most people are not using it effectively.

ChatGPT gained 100,000,000 users in less than 60 days but 99% of people don't know how to use it to its full potential.

This course will help you harness the full potential of ChatGPT. It’s designed to take you from beginner to expert.

Course Overview The aim of this course is to educate users in the basics of using Office 365 and its services and cover basic administration processes.

Aimed at the user wishing to acquaint themselves with the basic features and administration of Office 365. The course stresses the role of OneDrive, SharePoint and Teams in document management.

Familiarity with the basics of Windows is highly recommended to get the most out of this course.

Course Overview Online meetings often fall short. Discover how you can make your meetings more interactive with Zoom and MS Teams.
This course looks at best practice and how the tools in Zoom and MS Teams can help you achieve this.

Course Overview This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.

It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.

For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.

Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.

Course Overview This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.
The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.

Course Overview This course is split into 3 main areas:

1. Get and Transform (Power Query)
2. Power Pivot - Data Models and DAX calculations
3. Dashboard Creation with Pivot Tables, Charts and Slicers

It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.
This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.

Course Overview This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.

Course Overview Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

Course Overview In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

Course Overview This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

Course Overview The Technical overview of Microsoft 365 Copilot for the IT Professional Course, delves into the capabilities of Microsoft 365's AI-powered feature designed to enhance productivity and efficiency within organizations. This course will explore the following key areas:

Microsoft 365 Copilot Features: Uncover the ways in which Microsoft 365 Copilot can streamline tasks across applications such as Word, Excel, PowerPoint, Outlook, Teams (and many more applications!). Understand Microsoft 365 Copilot functionality including content generation, summarization, text refinement and tone suggestions via natural language prompts.

Microsoft Business Chat, an innovative cross-app experience unlocking capabilities to improve information discovery and context across multiple apps including calendar, emails, chats, documents, meetings and contacts. Microsoft Business chat is available to users from Microsoft 365.com, Bing (when signed in with a work account), or within Microsoft Teams.

Microsoft 365 Copilot Architecture: Gain insights into the inner workings of Microsoft 365 Copilot as it harnesses vast language models (LLMs) and organization's data via the Microsoft Graph. Discover the power of Microsoft Semantic Index, a cutting-edge technology facilitating swift and accurate retrieval of contextually relevant information.

Microsoft 365 Copilot Prerequisites and Licensing: Navigate the technical prerequisites and feature enablement necessary for an organization to leverage Microsoft 365 Copilot's potential. Explore pricing and licensing options for both Microsoft 365 Copilot and Business Chat.

How Microsoft 365 Copilot ensures enterprise-grade data security and privacy through integration with Microsoft 365 security and compliance features including Data Loss Prevention, Sensitivity Labels, Defender for Cloud Apps File Policies, Data Access Governance Reports

Microsoft 365 Data Collaboration, Classification and Reporting features to identify and protect sensitive data including Collaboration Insights, Sensitive Information Types, Microsoft Syntex and Microsoft Priva.

IT Professional's Readiness and Deployment Tasks for Microsoft 365 Microsoft 365 Copilot: Understand required the skills and tasks to ready your organization for Microsoft 365 Microsoft 365 Copilot's integration. This includes configuring permissions, managing administrative controls, change management, promoting adoption, and overseeing usage monitoring.

Upon completing this course, you will possess a holistic comprehension of Microsoft 365 Copilot and its potential transformative impact on an organization and requirements as an IT Professional to deploy, secure, manage, promote and support a Microsoft 365 Copilot Deployment.

Course Overview This Microsoft Forms Essentials course covers how Forms, SharePoint and Power Automate integrate into data collection and storage solutions in Office 365.

Course Overview This course covers how Forms, SharePoint and Power Automate integrate into data collection and storage solutions in Office 365.

Course Overview As desktops has evolved, so have methods for deploying and updating them. In this course, you'll learn how to plan and implement an operating system deployment strategy. This course will help you understand the various methods available, the scenarios they're suited for, as well as how to deploy Windows using modern methods. This course will also cover planning and implementing an update strategy for Windows.

During this course, you’ll be introduced to key components of modern management and co-management strategies. You’ll examine what it takes to incorporate Microsoft Intune into your organization and how to use it to manage modern desktops and devices. You’ll also learn about methods for deployment and management of apps and browser-based applications.

In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

Course Overview Are you ready to unlock the potential of the Power Platform? Our beginner-friendly course will empower you to build applications using Microsoft’s powerful suite of tools. Whether you’re a non-technical enthusiast or a budding developer this course is tailored for you.

Since this is a beginner's course we will cover two of the four Power Platform tools within the course curriculum Power Apps and Power Automate. You will also learn to integrate with common Office 365 products such as Outlook and One Drive.

Course Overview This course is available on a private course basis only.
We run the Microsoft Power BI Desktop course as a public scheduled event and also as a private course.

This 4-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI Desktop and the Power BI Service. The course structure is very comprehensive and provides a total immersion in the subject matter. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI is continually evolving, this course is regularly reviewed and updated to keep the content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience. Due to the very comprehensive nature of this course, the content delivered may vary depending on new and updated features, and client requirements.

The course structure takes a broad and practical approach to Power BI, defining best practices and demonstrating useful techniques that will prove extremely useful in the workplace. The content delivered will also help delegates prepare for the “PL-300 Microsoft Power BI Data Analyst” exam.

The first part of the course introduces the capabilities and components of Power BI before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create robust queries, students will learn about issues surrounding data quality, how to cleanse data, how to transform and then restructure data, and how to mashup data from various sources by merging and appending data. We will also examine how to manage, structure, and parameterise queries. Although a lot can be achieved working with the user interface in Power Query, we will also delve behind the scenes and introduce the M language, highlighting ways in which existing code can be tweaked and how user defined code and functions can be implemented.

Part two of the course introduces students to tabular data modelling concepts, preparing the data in readiness for use in reports and dashboards. The importance of implementing relationships is also covered. In order to enhance the data model, students will also learn about the DAX expression language to enable them to implement calculated columns, measures, and calculated tables. Consideration is also given to implementing time intelligence in the design of data models.

In part three, you will learn how to create and design reports and implement visuals. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). The implementation of maps in reports is also given coverage. To create interactivity in reports, students will also learn how to implement various types of filters and slicers.

Finally, in part four, we initially look at how we can further enhance the user experience by implementing features such as drill through reports, bookmarks, and showing and hiding content. Then, in order to share reports created in Power BI Desktop, we turn our attention to the Power BI Web Service. Attendees will learn how to publish reports to the Power BI Service and how to organize and secure content. The creation and use of dashboards will be considered, and different ways of sharing content will also be given coverage. We will look at user accessibility issues and consider how users, including mobile users, can interact with report content. Managing and refreshing datasets in the Power BI Service is also included.

Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.

Course Overview Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.

This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.