Online Microsoft Training in New Zealand

This instructor-led, live training in New Zealand (online or on-site) is designed for business professionals, educators, and marketers at beginner to intermediate levels who wish to integrate DeepSeek with PowerPoint to automate and optimise their presentation workflows.

By the end of this training, participants will be able to:

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Use AI to summarise lengthy reports and transform them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint to deliver streamlined, dynamic presentations.

This instructor-led course in New Zealand empowers advanced professionals to construct enterprise knowledge management systems using Microsoft 365. Learners will design SharePoint repositories, automate workflows with Power Automate, and utilise Power BI dashboards to visualise data, thereby enhancing collaboration across the organisation.

This instructor-led training in New Zealand focuses on deploying and securing enterprise endpoints using Microsoft Intune. You will learn to configure enrolment, compliance, and application management across Windows, macOS, iOS, and Android. This course is ideal for IT professionals seeking unified security and practical, hands-on skills.

This instructor-led, live training in New Zealand (online or on-site) is tailored for beginner to intermediate-level business users who wish to boost their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

By the end of this training, participants will be able to:

• Effectively create, manage, and utilise teams and channels in Microsoft Teams.
• Leverage tags, mentions, and app integrations in Teams to streamline communication.
• Store, organise, and securely share files in OneDrive using best practices.
• Recover documents using version history and collaborate on files in real time.
• Use Outlook for advanced email management and shared calendar scheduling.

This instructor-led, live training in New Zealand (available online or on-site) is designed for beginner to intermediate-level users who wish to boost team productivity and streamline everyday workflows using Outlook, OneDrive, Teams, Planner, and Forms.

By the end of this training, participants will be able to:

• Organise and manage communication effectively with Outlook.
• Store, share, and collaborate on files using OneDrive.
• Conduct meetings, chats, and team collaboration with Microsoft Teams.
• Plan and track tasks efficiently using Microsoft Planner.
• Create and analyse online surveys and quizzes with Microsoft Forms.

This instructor-led, live training in New Zealand (online or on-site) is aimed at beginner-level leadership teams who wish to effectively manage and coordinate tasks using Microsoft Planner and its related tools, leading to enhanced productivity and collaboration across the organisation.

By the end of this training, participants will be able to:

• Effectively create, manage, and track tasks and projects using Microsoft Planner, thereby improving team coordination and project visibility.
• Organise and prioritise individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Utilise Microsoft Loop components for real-time collaboration, integrating them seamlessly into projects and meetings, and enhancing communication and information sharing among team members.
• Design and manage custom lists tailored to specific project needs, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This instructor-led, live training in New Zealand (delivered online or on-site) is tailored for beginner-level business professionals who wish to develop the skills needed to effectively use Teams, Word, and Excel within a management context.

By the end of this training, participants will be able to:

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilise Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in New Zealand (online or on-site) is designed for beginner to intermediate-level professionals seeking to master Microsoft Word, Excel, and PowerPoint to enhance document creation, data analysis, and presentation skills.

By the end of this training, participants will be able to:

• Create, format, and manage documents effectively using Microsoft Word.
• Leverage Excel for data entry, analysis, and visualisation.
• Design engaging and professional presentations with PowerPoint.
• Make the most of collaboration features across Microsoft Office applications.

This instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organisation's IT environment using Microsoft 365.

By the end of this training, participants will be able to:

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Manage Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implement compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

This instructor-led, live training in New Zealand (online or on-site) is designed for data analysts ranging from beginner to advanced levels who wish to utilise Excel for a variety of tasks, including data entry, formula creation, data analysis, and advanced automation.

By the conclusion of this training, participants will be able to:

• Navigate Excel's interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting to support data analysis.
• Create and manage pivot tables and charts for effective data visualisation.
• Utilise tools such as Power Query and Power Pivot to conduct in-depth data analysis.
• Automate routine tasks using macros and VBA to streamline workflows.

This instructor-led, live training in New Zealand (online or onsite) is designed for beginner to intermediate-level professionals seeking to boost their productivity and efficiency by harnessing the advanced features of Excel and Google Sheets for data organisation, analysis, and teamwork.

By the end of this training, participants will be able to:

• Navigate and make the most of the core features of Excel and Google Sheets.
• Conduct data analysis and derive actionable insights using advanced spreadsheet techniques.
• Collaborate in real time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organisation's IT environment using Microsoft 365.

By the end of this training, participants will be able to:

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level supervisors and programming officers who wish to expand their knowledge in administering SharePoint and effectively utilising Microsoft 365 Copilot.

By the end of this training, participants will be able to:

• Understand the fundamentals of SharePoint architecture and administration.
• Configure and manage SharePoint sites and user permissions.
• Implement security and compliance measures within SharePoint.
• Integrate and manage Microsoft 365 Copilot features to enhance organisational productivity.
• Apply best practices for data governance and content management.

Excel is a widely used spreadsheet application developed by Microsoft. It is employed for storing, organising, and analysing data in a tabular format. Below are some of its key features and capabilities: 1. Spreadsheets: Excel consists of sheets, where each sheet is a grid made up of cells arranged in rows and columns. It supports the creation of multiple sheets within a single file, enabling efficient organisation of various data sets. 2. Calculations and Formulas: It allows users to perform a wide range of mathematical, statistical, and logical calculations using formulas. Excel includes a comprehensive set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, and many others. 3. Data Formatting and Presentation: It offers tools for formatting data, including changes to font, colour, and style, as well as the ability to create charts, pivot tables, and diagrams. 4. Sorting, Filtering, and Grouping: Users can sort data according to specific criteria. It enables filtering to display only selected information. Data can be grouped based on user requirements. 5. Data Analysis: Advanced analytical tools are available for scenario analysis, trend identification, forecasting, and macro creation. 6. Data Sharing: Excel facilitates real-time data sharing and collaboration, allowing multiple users to work simultaneously on the same dataset. 7. Task Automation: Users can create macros and automate repetitive tasks using the VBA (Visual Basic for Applications) programming language. Excel is extensively used across various fields, from business and finance to science and education. Its versatile functions support data analysis, report generation, budgeting, scheduling, data management, and many other applications.

This instructor-led, live training in New Zealand (available online or on-site) is designed for data analysts who wish to leverage advanced VBA in Excel to automate tasks.

By the end of this training, participants will be able to:

• Develop advanced object-oriented applications
• Convert text files
• Integrate external data sources
• Leverage external libraries

This instructor-led, live training in New Zealand (available online or on-site) is designed for data analysts who wish to leverage VBA in Excel to automate tasks.

By the end of this training, participants will be able to:

• Record and edit macros as needed.
• Write procedures using data from worksheets.
• Create custom functions.
• Handle events (such as opening a worksheet or updating a cell) using event handlers.
• Design and implement user forms.

This instructor-led, live training in New Zealand (online or on-site) is designed for data analysts who wish to learn techniques for preparing data in Excel and then visualising it in Power BI.

By the end of this training, participants will be able to:

• Understand the principles, objectives, and approaches of data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and utilise visualisations and charts for specific analysis scenarios.
• Import data using Power View to transition from Excel-based Power BI to a standalone Power BI environment.

Develop foundational Microsoft Excel competencies in this entry-level programme located in New Zealand. The curriculum encompasses data input, styling, formulas, functions, tabular structures, and visualisation, enabling learners to establish a solid base for practical data examination and reporting applications.

This instructor-led, live training in New Zealand (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

This instructor-led, live training in New Zealand (available online or on-site) is designed for beginner to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.

By the end of this training, participants will be able to:

• Use Excel formulas and functions to perform calculations and manipulate data.
• Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarise and visualise data.
• Use Excel charts and graphs to create and customise data visualisations.
• Use Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel data import and export features to connect to external data sources and share data with others.

-This advanced-level programme is tailored for IT specialists and SharePoint administrators tasked with overseeing, configuring, and securing SharePoint Online environments within the Microsoft 365 ecosystem. Participants will explore SharePoint Online architecture in depth, covering modern site provisioning, permissions governance, content lifecycle management, and integration with Microsoft 365 applications such as Teams, Power Automate, and Viva. The course blends strategic concepts with practical configuration exercises using the Microsoft 365 admin centre, SharePoint Admin Centre, and PowerShell. Particular emphasis is placed on real-world administrative scenarios, automation, compliance, and optimising user adoption while upholding governance standards.

This hands-on, practical course provides a comprehensive introduction to Microsoft SharePoint Online, focusing on how modern organisations can leverage it for collaboration, document management, process automation, and integration with the Microsoft 365 ecosystem. Participants will explore SharePoint's core capabilities—document libraries, lists, permissions, and site structures—while also gaining introductory experience with automation tools like Power Automate and Power Apps.