Microsoft Courses

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool that uses artificial intelligence to provide real-time intelligent assistance within Microsoft 365 productivity apps including Word, Excel, PowerPoint, Teams and Outlook. It is designed to transform productivity, creativity, collaboration for users, teams and organisations.

The course is beginner-friendly and requires no previous AI expertise.

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.

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

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

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.

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.

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.