Microsoft Training in Auckland

Microsoft 365 is a suite of cloud-based productivity and collaboration tools that includes Teams, OneDrive, Planner, and Copilot to support modern workplace workflows.

This instructor-led, live training (online or onsite) is aimed at intermediate-level professionals who wish to adopt Microsoft 365 capabilities to improve productivity, governance, and cross-team collaboration.

Upon completion of this training, participants will be able to:

• Configure and manage Teams for effective team collaboration and meeting practices.
• Use OneDrive for secure file storage, sharing, and version control.
• Plan and track work using Planner and integrate tasks into team workflows.
• Leverage Copilot to accelerate document drafting, meeting summaries, and data insights.

Format of the Course

• Interactive demonstrations combined with guided, hands-on labs.
• Scenario-driven exercises reflecting real organisational workflows.
• Practical sessions on configuration, governance, and user adoption best practices.

Course Customisation Options

• We can tailor examples, governance checklists, and hands-on labs to match your organisation's policies and environment.

This instructor-led, live training in Auckland (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.

Microsoft 365 offers a powerful suite of tools for building enterprise-grade knowledge management systems, bringing together SharePoint, Teams, Power Automate, and Power BI to effectively organise, integrate, and visualise information. This course explores how to design dynamic intranet dashboards, connect data sources, and implement structured workflows to boost collaboration and knowledge sharing across teams.

This instructor-led, live training (available online or on-site) is designed for advanced-level professionals who want to develop and manage sophisticated knowledge management frameworks using Microsoft 365 tools.

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

• Design advanced knowledge management systems using Microsoft 365 tools.
• Build interconnected SharePoint sites and Teams channels to support seamless information flow.
• Automate content workflows using Power Automate.
• Develop Power BI dashboards for knowledge visualisation and reporting.
• Optimise governance, access controls, and version management across shared repositories.

Course Format

• Interactive lectures and group discussions.
• Extensive exercises and hands-on implementation.
• Practical configuration in a live Microsoft 365 environment.

Course Customisation Options

• To request a customised version of this course, please contact us to make arrangements.

Microsoft Intune is a cloud-based endpoint management solution that enables organisations to securely manage users, devices, and applications. It provides comprehensive tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android environments.

This instructor-led, live training (online or on-site) is aimed at intermediate-level to advanced-level IT professionals who wish to deploy, configure, and manage enterprise devices using Microsoft Intune and related Microsoft 365 technologies.

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

• Implement and manage Microsoft Intune for endpoint management.
• Configure device enrolment, compliance, and security policies.
• Deploy and protect enterprise applications using Intune.
• Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint for unified management.

Format of the Course

• Interactive lecture and discussion.
• Plenty of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training for this course, please contact us to arrange.

Microsoft 365 is a suite of integrated productivity tools that enable collaboration, data-driven insights, and workflow automation through applications such as Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led, live training (available online or on-site) is designed for intermediate-level professionals who aim to master Microsoft 365 tools and AI-powered capabilities to enhance decision-making, communication, and organisational efficiency.

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

• Apply advanced Excel techniques and automation tools to support business and leadership decisions.
• Design impactful PowerPoint presentations using storytelling and data visualisation techniques.
• Create, format, and collaborate on professional documents in Word with the assistance of Copilot.
• Enhance productivity and time management using Outlook and AI-driven features across Microsoft 365.

Course Format

• Interactive lectures and discussions.
• Hands-on exercises and scenario-based practice.
• Practical application using Microsoft 365 tools in a live-lab environment.

Course Customisation Options

• To request a customised version of this course, please contact us to make arrangements.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is aimed at beginner to intermediate-level professionals who wish to leverage Microsoft To Do not only for personal productivity but also as a powerful collaborative tool integrated with Microsoft 365 applications.

Learning Objectives

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

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365.
• Create, organize, and prioritize tasks and lists for both personal and team use.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress.
• Enhance workflows by using Microsoft To Do alongside Outlook, Teams, and Planner.
• Apply productivity best practices and advanced techniques for long-term adoption.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and guided labs.
• Practical team collaboration simulations.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organise, prioritise, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to use Microsoft To Do to manage tasks effectively, boost productivity, and collaborate better with teams.

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

• Set up and configure Microsoft To Do for personal and team use.
• Create, organise, and prioritise tasks efficiently.
• Integrate To Do with Outlook, Teams, and other Microsoft 365 tools.
• Apply productivity best practices using To Do features.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft System Center Data Protection Manager (DPM) is Microsoft's enterprise backup and recovery solution for protecting workloads such as file servers, databases, and virtual machines.

This instructor-led, live training (online or onsite) is designed for intermediate-level IT professionals who wish to deploy, configure, and manage DPM to safeguard data and ensure business continuity.

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

• Install and configure DPM servers and agents.
• Create and manage protection groups.
• Perform backup and recovery operations.
• Integrate DPM with other disaster recovery solutions.

Course Format

• Interactive lectures and discussions.
• Abundant exercises and practical sessions.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training session for this course, please contact us to arrange.

This instructor-led, live training in Auckland (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 Auckland (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.

Microsoft Exchange Server is a messaging platform that delivers email, calendar, contacts, and task management capabilities.

This instructor-led, live training (available online or on-site) is designed for intermediate-level IT professionals seeking to install, configure, manage, and troubleshoot Microsoft Exchange Server environments.

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

• Install and configure Microsoft Exchange Server.
• Implement disaster recovery and anti-malware safeguards.
• Configure message transport and migrate to Exchange Online.
• Troubleshoot issues and maintain server availability.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation within a live lab environment.

Course Customisation Options

• To request a customised training session for this course, please contact us to make arrangements.

Microsoft OneNote is a digital notebook application used for organising, sharing, and collaborating on information across teams and devices.

This instructor-led, live training (online or onsite) is aimed at professionals with limited or emerging experience in OneNote who manage or coordinate digital information and wish to use Microsoft OneNote effectively to organise notes, coordinate team knowledge, and enhance collaborative workflows.

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

• Organise personal and team notes using notebooks, sections, and pages.
• Share and collaborate in real-time on OneNote content.
• Embed and link files, emails, and meeting notes into a unified workspace.
• Integrate OneNote with Microsoft 365 apps like Teams, Outlook, and Planner.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Microsoft OneNote in sample collaboration scenarios.
• Guided exercises focused on note-taking, content organisation, and teamwork.

Course Customisation Options

• To request a customised training for this course based on your department's workflows or internal tools, please contact us to arrange.

This instructor-led, live training in Auckland (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 Auckland (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.

Excel is a spreadsheet application used for data entry, analysis, reporting, and automation.

This instructor-led, live training (online or onsite) is aimed at beginner-level to advanced-level users who wish to build confidence and proficiency across Excel's essential, intermediate, and advanced capabilities.

Upon completion of this training, participants will be prepared to:

• Work confidently with spreadsheets, formulas, and formatting.
• Use intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Create professional worksheets that support business decision-making.

Format of the Course

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customisation Options

• For tailored coverage based on your department's workflows, please contact us to arrange a customised version of this course.

Microsoft System Center Operations Manager (SCOM) is a monitoring solution designed to ensure the availability, performance, and reliability of IT services across datacentres and applications.

This instructor-led, live training (delivered online or on-site) is aimed at intermediate-level IT professionals who wish to deploy, configure, and manage SCOM for enterprise monitoring and alerting.

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

• Install and configure System Center Operations Manager.
• Set up monitoring rules, alerts, and reports.
• Integrate SCOM with other System Center components.
• Troubleshoot and optimise performance in monitored environments.

Format of the Course

• Interactive lecture and discussion.
• Extensive exercises and practical practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training session for this course, please contact us to make arrangements.

Excel is a widely used spreadsheet application for data organisation, analysis, and automation.

This instructor-led, live training (available online or on-site) is designed for intermediate-level Excel users who wish to apply Excel skills to inventory control, budgeting, reporting, and automation using real-world datasets.

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

• Apply formulas such as SUMIF, IF, VLOOKUP, and SUMIFS to support inventory and purchasing scenarios.
• Efficiently manage and analyse large datasets containing 5,000+ rows.
• Create and interpret pivot tables for monthly and cumulative tracking.
• Automate repetitive reporting tasks using macros.
• Track material purchases against consumption using structured templates.

Course Format

• Interactive lectures and group discussion.
• Abundant exercises and hands-on practice.
• Live implementation in a real-time lab environment.

Course Customisation Options

• To request a customised version of this course, please contact us to arrange.

This instructor-led, live training in Auckland (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 Auckland (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 Auckland (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 Auckland (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 Auckland (available online or on-site) is designed for data analysts and anyone wishing to learn how to use Excel to create data models for analytical purposes.

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

• Learn to analyse and solve any business problems using structured problem-solving tools.
• Navigate Excel tools with confidence.
• Set up, format, and present data effectively.
• Understand the logical structure and apply the correct functions to Excel models.

Microsoft Word is a powerful word-processing application used to create, format, and manage professional documents.

This instructor-led, live training (available online or on-site) is designed for users ranging from beginner to advanced levels who wish to develop comprehensive skills in creating, editing, formatting, and automating documents using Microsoft Word.

Upon completing this course, participants will be able to:

• Create professional documents with consistent formatting.
• Utilise intermediate features such as styles, templates, and collaboration tools.
• Apply advanced tools including mail merge, references, and automation.
• Boost productivity by leveraging Word's advanced layout and document management capabilities.

Course Format

• Engaging demonstrations and guided instruction.
• Extensive practical exercises and skill-building tasks.
• Real-time document creation and refinement in a live environment.

Course Customisation Options

• If you require a tailored version of this training, please contact us to discuss customisation options.

This instructor-led, live training in Auckland (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.

Participants will gain the ability to efficiently utilise key data analysis tools such as scenarios and pivot tables, apply features for date-based calculations and text-processing functions, and create and customise macros to automate spreadsheet workflows.

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 Auckland (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 Auckland (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 Auckland (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.

Data analytics is a vital tool in today's business landscape. Throughout this course, we focus on building practical, hands-on skills for data analysis. The goal is to empower participants to provide evidence-based answers to key questions: 

What has happened?

• processing and analysing data
• creating insightful data visualisations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimising processes

Automate workflows and develop robust desktop applications using VBA across Microsoft Excel and Access. This comprehensive training programme covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

Microsoft Excel is a powerful spreadsheet application used for organising, analysing, and visualising data.

This instructor-led, live training (online or on-site) is aimed at beginner-level data analysts who wish to use Excel for data analysis and reporting.

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

• Create and manage spreadsheets in Excel.
• Format and organise data for clarity and efficiency.
• Use formulas and functions to automate calculations.
• Visualise data using charts, tables, and conditional formatting.
• Collaborate and share workbooks securely in Microsoft 365.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• To request a customised training for this course, please contact us to arrange.

This Excel training for financial analysis equips finance professionals with advanced spreadsheet techniques, including lookup functions, search formulas, and Pivot Charts, alongside conditional formatting, external data workflows, and securities analysis. The course explores practical approaches to evaluating time value of money concepts, identifying market trends, constructing financial forecasting models, and utilising Excel's comprehensive analytical toolkit for complex financial computations and reporting.

Analysing Financial Data in Excel empowers financial analysts and accountants with advanced techniques for automating complex calculations and reports. It covers core principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. The course dives into Goal Seek, Solver, Analysis ToolPak, and VBA macros for automating recurring workflows. It helps professionals transform raw figures into actionable financial insights and accurate forecasts for strategic planning.

Course participants will learn to efficiently carry out a wide range of calculations in a clear and organised manner, present their results effectively, utilise multiple tools to streamline and accelerate spreadsheet creation, and safeguard both calculations and outcomes against unauthorised access.

Participants will be empowered to excel in the most efficient way possible, creating, consolidating, and managing data. A range of tools designed to streamline workflows will significantly reduce the time spent on tasks and enable you to design applications capable of performing new functions.

Course participants will learn how to create clean, professional-looking documents (including official correspondence of all kinds – both formal and internal), as well as fully utilise the fundamental features that enable clear and efficient information flow in both short and long documents.

Achieve mastery over advanced document workflows by leveraging the full capabilities of Microsoft Word. This course covers custom styles, mail merge from external databases, macro recording, and template creation. Participants will gain control over section-level layout, dynamic tables of contents, indexes, hyperlinks, content controls, document comparison, and version tracking. The training equips professionals to develop automated reporting systems, standardized enterprise templates, cross-referenced documents, and workflows integrated with SharePoint.

Elevate your VBA proficiency to an intermediate level by exploring custom interfaces, complex data types, conditional logic, looping constructs, and professional debugging techniques. This practical Excel VBA training covers robust error handling, performance optimisation, VBA UserForms, and workflow automation through real-world exercises, bridging the gap from basic macros to advanced automation solutions for data analysts, reporting professionals, and business users seeking enterprise spreadsheet capabilities.

Master Microsoft Excel through this professional training course designed to enhance your spreadsheet efficiency and productivity. Gain essential skills including editing worksheets, managing workbooks, constructing complex formulas with powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. Ideal for business analysts, accountants, data handlers, and office professionals seeking to advance their Excel proficiency from an intermediate to an expert level. Boost your data analysis capabilities, streamline reporting workflows, and unlock the full power of Microsoft Excel for better decision-making and workplace productivity.

This instructor-led, live training in Auckland (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.

Gaining mastery of PowerPoint extends well beyond the fundamentals, enabling you to craft polished, scalable presentations that truly capture attention. This course explores customising slide and handout masters, building templates, leveraging SmartArt for visual process mapping, and integrating deeply with Excel for live-linked data dashboards and charts. It equips professionals with power-user workflows using add-ins such as Office Timeline and Poll Everywhere, streamlining review cycles and accelerating the production of complex decks to deliver impactful business presentations.

Objective:

Enhancing the ability to craft compelling presentations using PowerPoint and other tools.

Target Audience:

Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs, and public institutions for whom the challenge is to stand before a group, engage them, and spark genuine interest.

This instructor-led, live training in Auckland (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 one-day training session is tailored for power users who act as SharePoint site owners and/or site collection administrators.

Course objectives:

• Configure site navigation
• View site activity reports
• Customise lists and libraries
• Work with site columns and site content types
• Set up check-out/check-in, content approval and versioning
• Create and modify pages and web part pages

This one-day training session is designed for individuals who use SharePoint as end users and wish to gain a deeper understanding of some of its advanced features. Attendees should enrol in this course if they need to grasp functions such as team collaboration, document management, and the social capabilities of Microsoft SharePoint 2013.

This course is tailored for:

• SharePoint Site Owners and general users

Course objectives:

• Manage sites and site collections
• Add users and groups, and administer security at the site, list, folder, and item levels
• Add and configure web parts
• Customise site settings, including theme, title, description, and icon

Designing impactful financial presentations bridges the gap between complex numerical data and executive-level communication via PowerPoint. This course explores design strategies encompassing slide structuring, treemap and sunburst visualizations, budget chart layouts, and simplified reporting tables that highlight key financial metrics. It guides participants to master Excel integration for dynamic data, selective number emphasis, and confident financial storytelling that secures stakeholder buy-in.

This instructor-led, live training (available online or on-site) is designed for system administrators who wish to install, configure, deploy, and manage SharePoint Server 2019.

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

• Configure SharePoint components and options.
• Plan the hardware and software architecture for a SharePoint deployment.
• Build a taxonomy structure.
• Troubleshoot a SharePoint environment.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation in a live-lab environment.

Course Customisation Options

• This training is based on the on-premises version of SharePoint 2019 (also known as SharePoint Server 2019).
• To request a customised version of this course, please contact us to arrange.

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.