Explore Courses

PL-300: Microsoft Power BI Data Analyst

Master Power BI for data analysis. Learn to get data, transform it, build semantic models, create DAX calculations, design reports, and build dashboards. This course covers all topics for the PL-300 certification exam.

Windows Intune Management (MD-102)

Cyberattacks rarely start with a hacker breaking down the door — they start with a lost laptop, a phishing email, or a device that missed its security update. This hands-on MD-102 course puts you in the endpoint administrator's seat and shows how Microsoft Intune stops those attacks before they spread. You'll work in a provisioned Contoso Healthcare Microsoft 365 tenant with Microsoft 365 E5 (no Teams) licensing for approximately 33 users and a free 90-day Microsoft Intune Suite trial covering 250 licenses. Four ready-to-use lab VMs are included: three Windows 11 devices (SEA-DEV1, SEA-DEV2, SEA-DEV3) with the read-only AllFiles (F:) drive, and an Ubuntu 22.04 server (LIN-SRV1). You'll Entra-join and enroll the Windows devices, run Graph PowerShell from SEA-DEV1, register SEA-DEV3 with Autopilot, and deploy Microsoft Tunnel Gateway on LIN-SRV1. Along the way you'll secure devices with compliance policies, BitLocker encryption, attack surface reduction and Defender for Endpoint; block risky apps and data leaks on BYOD phones; deploy new laptops zero-touch with Autopilot and patch thousands of endpoints remotely; and wipe a stolen laptop in minutes — all from the cloud. Through realistic scenarios such as a lost sales laptop, a ransomware outbreak, and an employee accessing company data on a personal phone, you'll build job-ready skills across Windows, macOS, iOS and Android. By the end, you'll be able to plan, deploy, manage and defend a modern workplace — and walk into the MD-102 exam with confidence.

Microsoft Basic Excel (Based on AdventureWorks)

You are the analyst at AdventureWorks, a bicycle manufacturer selling through stores all over the world. Every week the sales team logs thousands of orders, and the raw numbers are piling up across seven worksheets - Customer, Date, Product, Reseller, Sales, SalesOrder and SalesTerritory. Your mission is to turn those 121,000+ rows of raw sales data into clear, decision-ready information: format it as a proper table, sort and filter it, add up the sales, classify every sale, chart the results and summarise everything in a PivotTable. This beginner Excel course covers the Excel screen, worksheet structure, formatting, sorting and filtering, formulas and functions, the IF function, charts, and an introduction to PivotTables.

Mastering Microsoft Project

5-day instructor-led course covering project management foundations, scheduling, resources, costs, tracking, reporting, and advanced features in Microsoft Project 2024/365. Your consulting firm has been engaged by KBC Holdings Ltd. to plan the construction of a two-storey business centre in Kafue, Zambia. The client wants a fully-detailed, resource-loaded project plan that can be priced and tracked in Zambian Kwacha. The deliverable is Project2.mpp — a single Microsoft Project file built from the specification below. Workbooks follow a standard calendar (Mon-Fri, 8:00 - 17:00) and every cost is displayed in Kwacha (K).

Microsoft Word - Basic

Learn essential Microsoft Word skills by formatting a professional job application letter. Covers inserting dates, capitalization, fonts, alignment, and document setup.

Excel Advanced

You are a newly hired data analyst at the United Nations Population Division. Your first assignment is to turn a real, world-bank sourced population dataset into a clean, analysed and professionally formatted workbook. This advanced Excel course takes you through the whole workflow: importing real-world data, cleaning and structuring it, building lookups and logic, summarising millions of rows with PivotTables, creating charts and a dashboard, and finally validating, protecting and exporting your work. Each lesson is a step in the assignment, and the course ends with a final quiz.

PowerPoint Advanced Demo

You are a policy analyst at the United Nations Climate Policy Division. The Secretary-General has asked you to prepare a 12-slide, four-section briefing that turns real climate data into a clear, professional presentation for world leaders. This advanced PowerPoint course takes you through the whole workflow: planning the deck, applying a consistent theme, building charts and tables from real NASA, NOAA and World Bank data, adding tasteful motion, and finally rehearsing, presenting and exporting your work as a video. Each lesson is a step in the assignment, and the course ends with a final quiz.

Microsoft Word - Advanced

You work in the Human Resources department of Essence IT Consulting. A vacancy for an IT Support Technician has just closed, and you must handle the applications like a professional: format a real application letter, build the shortlist of the strongest candidates, and mail merge interview letters to only the shortlisted applicants. This advanced Word course covers business letter formatting, styles and templates, data sources, and a complete mail merge workflow, ending with a final quiz.

Microsoft Excel - Intermediate(With Labs and Exam)

You are the clerk at Lucky Wholesalers Ltd, a wholesale distributor in Lusaka. Every Friday you and the supervisor count the stock, and this week the till does not seem to balance. Your mission is to turn the raw stock-count data into a professional Sales sheet with formulas, currency formatting, a cash-up check, a chart, and a print-ready PDF. This intermediate Excel course covers structuring worksheets, formulas and functions, number formatting, the IF function, charts, and preparing output for print and PDF.

Microsoft PowerPoint - Intermediate

Project-based PowerPoint training built around one real deliverable: a 15-slide executive briefing on the AI economy. Using real investment, GDP and jobs figures from PwC, Stanford HAI, the IMF and the World Economic Forum, you will design a themed deck, build charts and tables that tell a clear story, add a process diagram, animate it professionally, then rehearse and export it as a video - the exact workflow used for board and investor presentations.