Excel Magic 9: Building a Project Tracking “Gantt” Chart

Continuing Education Credits
Click or touch a Credit for more information

Certified Public Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
cpe/qas logo
Illumeo is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State Boards of Accountancy have the final authority on the acceptance of individual course for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

NASBA Sponsor Number: 109504
State of New York Sponsor Number: 002746
State of Texas Sponsor Number: 009890
In accordance with the standards of the National Registry of CPE Sponsors, CPE credits have been granted based on a 50-minute hour.

Chartered Accountant (IES8 CPD)

Continuing Education Credit:
1.5 Hour
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Your specific provider of Continuing Professional Development accreditation has final authority on the acceptance of individual courses for CPD-IES8 credit.

Certified Management Accountant

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Fraud Examiner

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer Software & Applications
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Internal Auditor

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Computer science
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal


Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Internal Auditor (CIA) CPE program.

Certification in Risk Management Assurance

Continuing Education Credit:
1.5 CPE Credit
Field of Study:
Other activities contributing to professional competence
CPE Delivery Method:
Self-Study
Program Location:
Online
Program Level:
Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.
Registry of CPE Providers Seal

Recognized CPE provider, authorized by the Institute of Internal Auditors for use in the Certified Risk Management Assurance (CRMA) CPE program.
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Excel Magic 9: Building a Project Tracking “Gantt” Chart0:38
  Why do We Use Gantt Chart to Track Projects1::20
  Instructor Introduction1:11
  Comparison with Other Similar Courses1:24
  What you will get from this course?0:37
Gantt Chart
  Gantt Chart: The History0:32
  How to Build a Gantt Chart in Excel4:05
  Build a Customized Gantt Chart 1:00
  Three Types of Gantt Chart to Cover in this Course1:36
Refresher
  Refresher 1: Math Formulas6:44
  Refresher 2: Conditional Formatting (Part 1)3:18
  Refresher 3: Conditional Formatting (Part 2)4:32
  Refresher 4: Dropdown List2:32
  Refresher 5: Calendar Formulas2:28
No. 1: Basic Gantt Chart
  Basic Gantt Chart - Part 15:06
  Basic Gantt Chart - Part 23:24
No. 2: Advanced Gantt Chart
  Advanced Gantt Chart - Part 12:11
  Advanced Gantt Chart - Part 26:33
  Advanced Gantt Chart - Part 38:30
  Advanced Gantt Chart - Part 44:37
  Advanced Gantt Chart - Part 51:48
No. 3: “Pure” Gantt Chart
  “Pure” Gantt Chart - Part 15:01
  “Pure” Gantt Chart - Part 26:09
  “Pure” Gantt Chart - Part 34:53
Bonus: Two Cool Functions for Data Entry in Gantt
  Office 365 “Form3:55
  Calendar Date Picker1:39
CONCLUSION
  Takeaways1:20
  Next Course & Q&A0:29
CONTINUOUS PLAY
  Excel Magic 9: Building a Project Tracking “Gantt” Chart1:27:32
SUPPORTING MATERIAL
  Slides: Excel Magic 9: Building a Project Tracking “Gantt” ChartPDF
  Excel Magic 9: Building a Project Tracking “Gantt” Chart Glossary/ IndexPDF
  Workbook: Excel Magic 9: Building a Project Tracking “Gantt” ChartXLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam