Instructor-led IT courses across web, mobile, data, design and more.
Many employees already use Microsoft 365 Copilot comfortably to draft emails, summarise meetings and write documents. Yet much of the real work in a day is multi-step work that moves between Outlook, Teams, the calendar and Office files, and it is still done…
Power Apps built by a small team often work well until users grow into the hundreds and data into the tens of thousands of records. Then the app opens slowly, searches miss records because of delegation limits, the same formula is copied across many screens…
A desktop flow captured with the recorder works well on day one, but once it runs every day it breaks often. Window titles change, buttons on a web page move, some files will not open, or the flow hangs halfway without anyone noticing. When the organisation…
Many organisations start with Power Automate through small flows built by individual teams. As the number of flows grows and they become part of core work, problems appear. Flows stop when their maker changes jobs, URLs and email addresses are hard-coded into…
The PivotTable is one of the most powerful summarising tools in Excel, yet many users only drag fields into place and total them. When they need to compare with last year, show shares, rank items or combine several tables, they fall back on long formulas or…
Many organisations have already switched on Copilot in Microsoft 365, yet plenty of staff ask it a few questions, get a vague answer and go back to working the old way. The problem is rarely the tool. It is not knowing what Copilot can do in each app, how to…
When an organisation turns on Microsoft 365 Copilot and agents, one thing changes immediately: every file a user is allowed to open becomes material Copilot can draw on in its answers. If SharePoint and Teams permissions are shared too widely, if there are no…
A lot of office work is still repeated by hand every day: copying data from emails into Excel, sending forms to a manager for approval, chasing documents that have not arrived or letting the team know in Teams when a new item comes in. Organisations that use…
Data teams in many organisations still work across scattered tools: raw data lives in one place, ETL jobs in another, the data warehouse in a third system, and Power BI reports pull the same data again and again. The result is conflicting copies of data,…
Microsoft Excel remains the primary data tool in almost every organization, but how it is used has changed completely. Users no longer need to memorize complex formulas or write M code or VBA entirely themselves - just describe what you want in natural…
Microsoft Excel Advanced is designed for people who already use Excel regularly but want to move up to more complex formulas and apply Excel's tools to real organizational work - HR, inventory, sales and marketing, or accounting and finance. Learners come to…
Modern organizations must communicate complex matters and reach a shared understanding in a very short time - whether it is a cross-functional process, a network topology, an organization chart or a factory floor plan. Relying on text alone often leads to…
Everyday communication needs more and more images, from social posts, notices, invitations and document covers to banners on company systems, yet many people have no graphic design background or no time for complex design software. Microsoft has therefore…
Many organisations still run work on paper, on Excel files passed through several hands, or on forms whose data has to be retyped into another system. Writing a new program in a programming language takes time and depends on a development team. Microsoft…
Once you are made a Microsoft 365 administrator for your organisation, the work ranges from adding users and licences, syncing accounts from Active Directory and configuring email, Teams and SharePoint, to handling the calls when users cannot send email,…
A good diagram helps a team understand a process, an organisation structure, a database or a network at a glance. Yet many people still draw diagrams line by line in PowerPoint or Excel, so changing one step means redrawing the lines, the symbols are not…
Executives have limited time and must decide from a great deal of data. A good report states its conclusion from the first slide and uses figures and charts as evidence that can be understood in a few seconds. Yet many reports are still full-page tables of…
Many organisations already have SharePoint as part of Microsoft 365, and every team created in Microsoft Teams comes with its own SharePoint site. Yet most sites are still just a place to keep files, with no home page that speaks to the team, no central lists…
Preparing data in Excel often takes longer than the analysis itself: copying sales files from several branches together, trimming spaces and fixing dates column by column, or turning a report exported from another system into a proper table, and then doing it…
Many organisations still have documents scattered across staff laptops, email attachments and folders where nobody knows which copy is the latest. After moving to Microsoft 365, many teams are still unsure which files belong in OneDrive and which belong in…
Many teams still track work in Excel files passed around by email or chat groups, so nobody knows who holds which task, what is nearly due or what has been stuck for weeks. Organisations on Microsoft 365 already have Microsoft Planner, and Planner now brings…
Collecting feedback, registrations or test results on paper, or in files emailed back and forth, wastes time gathering and retyping data. Microsoft Forms lets you build surveys, quizzes and polls in minutes. People can answer on a computer or a phone, results…
Numbers in Excel are only valuable when readers can understand them and make decisions from them. Many people calculate correctly but still cannot answer the key questions: what happens to profit if sales rise by 10 per cent, what next quarter is likely to…
Many organisations keep sales, budget and register data in Excel, but when they try to report on it in Power BI they find several subjects crammed into one sheet, merged cells, numbers stored as text, dates mixing Buddhist and Gregorian years, and fixes that…
