SALE LIVE
SAVE 59% BLACK FRIDAY

Excel Training with Gantt Charts Black Friday Offers

Excel Training with Gantt Charts is part of our Black Friday sale. Lock in 59% off now, choose online, classroom or onsite training, and schedule your course any time through 2027. Group bookings save up to 60%.

FROM NZD1,395 NZD3,395 SAVE NZD2,000

Offer ends 27 November 2026

Excel Training with Gantt Charts Overview

Course syllabus

Who it’s for

What’s included

FAQs

Excel Training with Gantt Charts Course Outline

Module 1: MS Excel Basics

  • Getting Started
  • Explore Window
  • Backstage
  • Entering Values
  • Move Around
  • Save Workbook
  • Worksheet
    • Create Worksheet
    • Copy Worksheet
    • Hiding Worksheet
    • Delete Worksheet

Module 2: Editing Worksheet

  • Data
    • Insert Data
    • Select Data
    • Delete Data
    • Move Data
  • Rows and Columns
  • Copy and Paste
  • Find and Replace
  • Spell Check
  • Zoom In-Out
  • Special Symbols
  • Insert Comments
  • Add Text Box

Module 3: Working with Formula

  • Creating Formulas
  • Copying Formulas
  • Formula Reference
  • Using Functions

Module 4: Excel Charts

  • Types of Advanced Charts
  • Advanced Charts in Brief
    • Waterfall Chart
    • Band Chart
    • Gantt Chart
    • Thermometer Chart
    • Bullet Chart
    • Funnel Chart
    • Waffle Chart
    • Step Chart
    • Box and Whisker Chart
    • Histogram
    • Pareto Chart
    • Organisation Chart
  • Methodology for Creating Advanced Excel Charts

Module 5: Advanced Excel - Gantt Chart

  • What is a Gantt Chart?
  • Advantages of Gantt Charts
  • Preparation of Data
  • Creating a Gantt Chart

Module 6: Make a Gantt Chart

  • Add Duration Data to the Chart
  • Add Task Description to the Gantt Chart in Excel
  • Transform the Bar Chart into an Excel Gantt Chart in Excel
  • Adjust the Number of Dates on Your Gantt Chart in Excel
Show more blue-arrow
Show more blue-arrow

Who should attend this Excel Training with Gantt Charts Course?

The Excel Training with Gantt Charts Course is designed for professionals aiming to master the use of Microsoft Excel for Project Management, specifically focusing on creating and managing Gantt charts. This course will benefit the following professionals:

  • Project Managers
  • Team Leaders
  • Planners and Schedulers
  • Operations Managers
  • Business Analysts
  • Engineers
  • Entrepreneurs
  • Operations Coordinators

Prerequisites of the Excel Training with Gantt Charts Course

There are no formal prerequisites to attend the Excel Training with Gantt Charts Course. However, a basic knowledge of Microsoft Excel would be beneficial.

Excel Training with Gantt Charts Course Overview 

Excel Training with Gantt Charts introduces delegates to Microsoft Excel tools for project planning, scheduling, and reporting. It covers formulas, advanced charts, Gantt charts, worksheet management, and data visualisation techniques. 

Delegates develop skills in creating advanced charts and Gantt charts to organise project data and visualise timelines. They learn to track project progress, improve scheduling, and produce effective reports. 

This 1-Day course by The Knowledge Academy enables delegates to apply Excel and Gantt chart techniques in workplace scenarios. Delegates learn to plan projects, track progress, and manage schedules effectively. These skills support efficient project planning and reporting.

Excel Training with Gantt Charts Course Objectives

  • To understand the Microsoft Excel features used for project planning
  • To create and manage worksheets, formulas, and project data
  • To develop advanced charts using Microsoft Excel
  • To create and customise Gantt charts for project scheduling
  • To organise and present project timelines effectively
  • To support project planning and reporting using Microsoft Excel

Upon completing this Excel Training with Gantt Charts Course, delegates will be able to create Gantt charts, manage project data, and apply Excel tools confidently. They will also use Excel to support project planning, scheduling, and reporting activities.

Show more blue-arrow

What’s included in this Excel Training with Gantt Charts Course?

  • World-Class Training Sessions from Experienced Instructors
  • Excel Training with Gantt Charts Certificate
  • Digital Delegate Pack
Show more blue-arrow

Train Your Workforce

Looking for Excel Training with Gantt Charts in-house or onsite training Hamilton City. We specialise in corporate group training and bulk bookings for organisations of all sizes. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling.

Approved supplier to 53,659 organisations

The Knowledge Academy is an approved training supplier to 53,659 organisations across the UK, Europe, North America and Australia, so most buyers can book through their existing purchasing process with no new supplier setup.

Our Hamilton City venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Hamilton is the most populous city situated in the North Island of New Zealand. Hamilton homes around 154,000 people making it the fourth most populous country in New Zealand. Education and Research play a huge part in Hamilton’s economy. The city is home to around 40,000 higher education students and 1,000 PhD qualified scientists. There are three main universities in Hamilton, the University of Waikato, Waikato Institute of Technology and Te Wananga o Aotearoa. As well as the higher education, Hamilton is also home to a number of Kura Kaupapa Maori schools which offer education in the Maori language. The University of Waikato is a comprehensive university in Hamilton. The University was established in 1964 and was the first university in New Zealand be designed from scratch. The university houses around 10,000 students who can study a variety of subjects, such as Arts, Social Sciences, Computing and Mathematical Science, Education, Law and Engineering. The University of Waikato produced many notable alumni such as Nathan Cohen who is a two time world champion and Olympic champion in rowing. The Waikato Institute of Technology has around 20,000 students. The institute offers students 10 degree programs, 35 diplomas and 12 postgraduate qualifications. The Waikato Institute of Technology has three campuses in Hamilton, which all specialise in various areas, such as engineering, science, technology, sport, health and tourism. The institute works closely with employers to ensure students are work ready when they leave the institution. Te Wananga o Aoteraroa is a specialised university that focus of giving a positive learning experience to students who have previously had negative experiences with the education system. The University if a Maori led institute and focus strongly on Maori traditions and values. Te Wananga o Aotearoa is currently one of the largest tertiary education providers in New Zealand. The Institute caters to around 35,000 students each year and has more than 100 sites. Te Wananga o Aotearoa was established in 1983 to provide education for students whose needs are not being met in mainstream education. 

Show moredown

Ways to take Excel Training with Gantt Charts in Hamilton City

Live Online

The same live course from home, with a live instructor and other delegates. Mirrors the classroom schedule.

Best for: starting soon, without travel.

1 day · next Fri 12 Feb 2027

See live online dates

Online Self-Paced

Study 24/7 on your own schedule through our learning platform, with progress tracking.

Best for: fitting study around work.

90 days of access

See self-paced options

Onsite

We bring the course to your team, at your premises, online or hybrid, on dates that suit you.

Best for: groups and bulk bookings.

Tailored to your team

Get a team quote

Loading ....

Package deals for Excel Training with Gantt Charts in Hamilton City

Our training experts have compiled a range of course packages on a variety of categories in Excel Training with Gantt Charts, to boost your career. The packages consist of the best possible qualifications with Excel Training with Gantt Charts, and allows you to purchase multiple courses at a discounted rate.

Microsoft Excel Training & Certification Course | Excel Training With Gantt Charts in Hamilton City FAQs

What is Gantt Chart?

A Gantt chart is a bar graph that may help direct project management activities such as defining deadlines and timelines, allocating tasks, and scheduling meetings, appointments, and presentations.

What are the pre-requisites?

In this Excel Training with Gantt Charts, there are no formal prerequisites. However, it will be great for the delegates to have some basic knowledge of Microsoft Excel.

Who should attend this course?

This Excel Training with Gantt Charts Training course is ideal for anyone who handles personal or professional assignments and manages projects and various aspects of the project.

What are the advantages of using Gantt Charts?

Great for project planning, resource planning, monitoring and controlling project schedules, helping in identifying risks, and task relationships are the advantages of using Gantt charts.

How Gantt Chart is useful for Project Managers?

To improve clarity, keep your team up to date, simplify complicated jobs, assist stakeholders and team members, identify duties, and reduce the need for status reports and meetings.

What is the duration of this course?

The duration of our Excel Training with Gantt Charts Course is designed to be comprehensive yet concise, lasting for 1 day.

What is pivot table?

Pivot table functions as a summary table for the dataset, you may make reports and spot patterns. They come in handy when you need to track values in extended rows or columns.

What will I learn in this Excel Training with Gantt Charts Training course?

In this Excel Training with Gantt Charts Training course, you will learn about how to add task descriptions to the Gantt chart in Excel, copy and create a worksheet, the advantages of Gantt charts, how to adjust the number of dates on your Gantt charts, formula reference, and other interesting topics related to this.

What is the cost/training fees for Excel Training with Gantt Charts in Hamilton City?

The training fees for Excel Training with Gantt Charts in Hamilton City starts from NZD3395

Which is the best training institute/provider of Excel Training with Gantt Charts in Hamilton City?

The Knowledge Academy is one of the Leading global training provider for Excel Training with Gantt Charts.

What are the best Microsoft Excel Courses courses in Hamilton City?

Please see our Microsoft Excel Courses courses available in Hamilton City

Show more blue-arrow

Customers Reviews

Request For Pricing

WHO WILL FUNDING THE COURSE?
+44

Corporate Training

Unlock tailored pricing and customised training solutions for your team’s needs.

Request your quote today!

Why choose The Knowledge Academy

price

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

learning

Many delivery methods

Flexible delivery methods are available depending on your learning style.

resources

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water
santander barclays bmw google thames-water deloitte bupa tesla

Excel Training With Gantt Charts in New Zealand

cross

Exclusive Deals For Future Leaders!

friday-sale UP TO 60% OFF!

* WHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.