Microsoft Excel Training & Certification Course | Excel Training With Gantt Charts in Virtual

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

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.

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