SALE LIVE
SAVE 60% BLACK FRIDAY

Excel Training with Gantt Charts Black Friday Offers

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

FROM £595 £1,495 SAVE £900

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 Birmingham. 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,573 organisations

The Knowledge Academy is an approved training supplier to 53,573 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 Birmingham 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.

Birmingham is a large city in the West Midlands of England. It is the second largest and second most populous city in the UK behind London. It has an estimated population of nearly 1.2 million people. It is the ninth largest metropolitan area in Europe. The city is a major international commercial centre and an important transport, retail, events and conference hub for England. Education in the UK is a devolved matter, meaning each of the countries that constitute Great Britain each have separate systems operating under separate governments.  For example: the UK government is responsible for England, whilst the Scottish government, Welsh government and the Northern Ireland Executive are in charge of their own country.

Popular searched areas in and around Birmingham include:-

  • Aston
  • Birmingham International Airport
  • Bournville
  • Castle Bromwich
  • Coleshill
  • Edgbaston
  • Erdington
  • Handsworth
  • Harborne
  • Hockley
  • Hollywood
  • Kings Norton
  • Maypole
  • Moseley
  • Northfield
  • Selly Oak
  • Sheldon
  • Vauxhall
  • Yardley

Birmingham City Council is England's largest local education authority. It is responsible for around 450 schools including nurseries, primary schools, secondary schools and special schools. Most schools are 11-16/18 comprehensive schools while students have the choice of college or sixth form after they have sat their GCSE’s. Bishop Vesey's Grammar School, founded in 1527, is the one of the oldest and perhaps the most prestigious school in the city. Birmingham is a densely populated city for universities with five in the city. These universities are: Aston University, University of Birmingham, Birmingham City University, University College Birmingham and Newman University. There also campuses for the university of law, the BPP University and the Open University West Midlands. There are an estimated 79,000 full time students in the Birmingham area. This is more than any city outside of London in the UK. The University of Birmingham is a highly respected university and is ranked inside the top 100 universities in the world and is a top 15 university in the UK. The motto of this university is “persuasive, persistent and bold.” They claim to encourage and empower to turn their ideas into a reality in order to make things happen. The university has a tradition of innovative research and is always striving to push the boundaries. The Knowledge Academy, we offer over 50,000 classroom based training courses in the UK, including popular locations such as Birmingham.

Show moredown

Ways to take Excel Training with Gantt Charts in Birmingham

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 20 Nov 2026

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 Birmingham

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 Birmingham 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 Birmingham?

The training fees for Excel Training with Gantt Charts in Birmingham starts from £1495

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

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 Birmingham?

Please see our Microsoft Excel Courses courses available in Birmingham

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