ONLINE - SAO - Using an Excel Gantt Chart to Manage Projects 10/1/2020

Register for class here.

Length/CPE Hours

5 hours (1 day)

Class Time

8:00 a.m. – 1:30 p.m.

Method of Delivery

This class will be held online using GoTo Metting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoTo Metting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Metting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Metting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

Course Description

Project Management software can be expensive and time-consuming to learn. This class will use the Microsoft Agile Gantt chart template to manage basic projects. In the first half of the class, students will learn the Excel functions and features necessary to understand the template. Then we will exam the Gantt chart template and understand how it works and how it can be modified.  Finally, we will work with conditional formatting and see how the template uses conditional formatting. You will have access to a Gantt chart template you can begin using immediately to manage simple projects.

Course Objectives

Upon completion of this course, participants will be able to use an Excel Gantt chart template to manage their projects and acquire the knowledge and skills necessary to modify the template if necessary.

FORMULAS USED IN THE GANTT CHART

  • Overview of Project Terms
  • Recall Simple Formulas and Comparison Operators
  • Discuss Common Functions like MIN used in the template
  • Examine the IF Function
  • Describe how Dates are stored and calculated in Excel
  • Work with the TODAY, NOW, MONTH, DAY, YEAR and NETWORKING DAYS Functions.

ABSOLUTE ADDRESSES AND RANGE NAMES

  • Differentiate Relative Addresses vs Absolute Addresses
  • Work with an Absolute Address
  • Create a Named Range
  • Discuss Guidelines for Named Ranges

LOCATE, REVIEW AND USE THE GANTT CHART TEMPLATE

  • Review and Explain the Formulas in the Template
  • Work with Range Names in the Template
  • Examine Excel Tables and How they are Used in the Template
  • Show the Excel Developer tab and look at Controls in the Template
  • Work with Data Validation and the Drop-down Boxes in the Template

CONDITIONAL FORMATTING

  • Examine the Data Bars Conditional Formatting
  • Review the Conditional Formatting Used in the Template

BONUS APPENDIX INFORMATION

  • Protecting the file
  • Keystroke Navigations

Prerequisites

The prerequisites for this course are an introductory Excel course, or equivalent working knowledge of the software. Intermediate knowledge of Excel is helpful.

Event Properties

Event Date 10-01-2020 8:00 am
Event End Date 10-01-2020 1:30 pm
Capacity 14
Available place 14
Cut off date 10-01-2020 8:00 am
Individual Price $259.00
Location ONLINE

Group Rate

#Registrants Rate/Person($)
3 269.00