Microsoft Office Training in Christchurch

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

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.

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

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 Christchurch (online or onsite) is designed for anyone wishing to learn and use the software and services available in the MS Office suite to boost their work productivity.

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

• Learn to use the various software applications in the MS Office suite.
• Improve work productivity and collaborate effectively using MS Office tools and services.

This instructor-led, live training in Christchurch (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 Christchurch (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 Christchurch (online or on-site) is designed for MS Office users who wish to master the various tools and techniques within MS Office software and services.

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

• Learn and master a range of shortcut techniques in MS Office.
• Master macros and other Excel functions to manipulate worksheets more efficiently.
• Use PowerPoint controls and advanced features to create dynamic presentations.
• Navigate and search through Outlook quickly and effectively.

This instructor-led, live training in Christchurch (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 Christchurch (online or onsite) is aimed at anyone who wishes to master the fundamentals and features of Microsoft Word to become more productive at work.

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

• Learn the basics of Microsoft Word to best support daily work responsibilities, such as taking meeting notes and drafting memos.
• Work with a range of formatting features.
• Manage document collaboration effectively.

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 Christchurch (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 Christchurch (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 Christchurch (available online or on-site) is designed for data analysts who wish to leverage VBA in Excel to automate tasks.

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

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

Audience

Analysts, researchers, scientists, graduates, students, and anyone keen to learn how to streamline statistical analysis using Microsoft Excel.

Course Objectives

This course will enhance your proficiency in both Excel and statistics, thereby boosting the effectiveness and efficiency of your work or research.

The course covers how to utilise the Analysis ToolPak in Microsoft Excel, apply statistical functions, and carry out fundamental statistical procedures. It also explains Excel's limitations and provides strategies to overcome them.

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

The objective of the course is to enable participants to gain a mastery of the fundamentals and practical applications of VBA for Access and Excel.

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.

During the training, participants will explore financial analysis issues using the advanced features of Excel.

This course is designed for financial analysts, accountants, and anyone looking to expand their spreadsheet skills in the context of financial analysis.

Audience

Financial or market analysts, managers, accountants

Course Objectives

Facilitate and automate all kinds of financial analysis with Microsoft Excel

This instructor-led, live training in Christchurch (online or on-site) is designed for data analysts who wish to program in R for Excel.

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

• Toggle and transfer data between Excel and R.
• Apply R Tidyverse and other R features to develop data analytics solutions in Excel.
• Extend their data analytics skills by learning R.

In this instructor-led, live training in Christchurch (delivered either on-site or remotely), participants will learn how to harness the combined capabilities of Python and Excel.

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

• Install and configure packages to integrate Python and Excel.
• Read, write, and manipulate Excel files using Python.
• Call Python functions directly from Excel.

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.

Course participants will learn how to automate workflows to create complex documents, retrieve data from databases, and prepare forms.

This course is designed for those already familiar with the basics of VBA who wish to deepen their knowledge and make more effective use of the language's capabilities.

Training for individuals using Microsoft Excel spreadsheets who wish to enhance their productivity and skills.

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

Please consider the following questions:

• Is your daily work in Excel a never-ending cycle of copy-and-paste commands?
• Are you spending valuable time repeating similar tasks to prepare data for analysis?
• Do you know all the Excel keyboard shortcuts, yet still feel dissatisfied with the results?
• Would you prefer to focus on data analysis rather than waste time on data preparation?
• Do you have to manually verify the accuracy of data pulled from different systems?
• Do you find yourself working late or taking Excel work home because tasks weren't completed during the day?
• Is your role centred on generating reports from large datasets?
• Do you feel that using Excel often leads you down an unnecessarily roundabout path to achieve results?

If you answered YES to any of these questions, it's time to put an end to this frustrating routine. This training is designed for you.

Discover how you can accelerate your daily operations and get the most out of Microsoft Excel.

WARNING

After this training, your work life will change dramatically. Tasks that once consumed an entire day will be completed in just a few moments. Are you ready for that transformation?

This course aims to enhance trainees' PowerPoint skills through practical exercises underpinned by relevant theory. It is designed for a broad audience, particularly presentation designers, as well as conference speakers and those leading team meetings.

This course is designed for anyone looking to work more efficiently in PowerPoint when creating slides and to learn the fundamentals of delivering presentations.

This course is designed specifically for sales teams. It focuses on harnessing PowerPoint's capabilities to support the sales process—covering how to present data effectively, avoid over-cluttering slides, and identify what truly matters in a sales presentation.

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 Christchurch (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

This instructor-led, live training in Christchurch (online or on-site) is aimed at IT administrators who wish to use Office 365 in an administrative capacity.

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

• Address the most common end-user support requests.
• Troubleshoot startup and version compatibility issues.
• Back up and repair damaged files.

This instructor-led, live training in Christchurch (available online or on-site) is tailored for financial analysts and staff who wish to use Adaptive OfficeConnect to create financial reports using Microsoft Office Excel, Word, and PowerPoint.

By the end of this training, participants will be able to build, create, and update financial reports using the Microsoft Office Suite.

This instructor-led, live training in Christchurch (online or on-site) is designed for marketeers who wish to create video content and presentations using Camtasia and PowerPoint.

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

• Create video content and share it on a video hosting platform.
• Use assets within Camtasia, such as music and icons, to build interactive content.
• Save on costs by producing high-quality videos with Camtasia and PowerPoint.

This course will equip you with the knowledge to present financial information (numbers) in PowerPoint, going beyond mere presentation skills. You'll learn how to convey financial data in a more professional manner.

This instructor-led, live training (available online or on-site) is designed for beginner to intermediate-level developers who wish to utilise VSTO to create tailored solutions for Microsoft Office applications.

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

• Create add-ins and document-level customisations for Office applications.
• Access and manipulate the Office object model and its events.
• Design custom ribbons, task panes, and dialog boxes for Office applications.
• Integrate Windows Forms controls and .NET components into Office documents.
• Connect Office applications with web services and databases.
• Deploy and secure Office solutions.