Advanced Planning Analytics
  • Home
    • About Us >
      • Services
      • Careers
      • ORACLE in Las Vegas P6 Advanced
      • Contact Us
      • Call for Speakers
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Power BI in EPC
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
    • $100 TIC Estimating
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • Free Tools
    • Free Tools
    • FREE Online Tests >
      • Assessment PLANNING & SCHEDULING
      • Assessment EARNED VALUE
      • Assessment EPC
      • Assessment Procurement
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER Analytics BETA TESTERS
  • XER P6 Templates

ADVANCED EXCEL GANTT USING CONDITIONAL FORMATTING

If you would prefer not to create the basic Gantt file in Excel yourself or if you would like some automatic formatting to happen I have created a fully functional file here. I want to post a quick video on creating an Advanced Gantt in Excel using Conditional Formatting. As an example, professionals , managers or project controls may not have access to a scheduling software. However, their could be a need to create an executive Level 1 or Level 2 schedule. This method allows for the Gantt to be somewhat dynamic for purposes of updating.

Snapshot of the Excel Gantt with Conditional Formatting

Picture
Picture

Follow my instructions on the video.

In case you were not able to build the Gantt file in Excel on your own, I've provided an advanced file already completed. Just click the button below to access the file.

Buy Now
Picture
Privacy Policy

Terms of Use

Excel Gantt Tool
Copyright © 2019 - Advanced Planning Analytics,  All Rights Reserved.  CRamos Management LLC.
  • Home
    • About Us >
      • Services
      • Careers
      • ORACLE in Las Vegas P6 Advanced
      • Contact Us
      • Call for Speakers
  • SME TRAINING
    • Engineering, Procurement, & Construction Planning [EPC]
    • Earned Value in P6
    • Power BI in EPC
    • Advance Work Packaging
    • Schedule Analytics
    • EVM in P6 Online Course
    • $100 TIC Estimating
  • ONLINE P6
  • ORACLE P6 TRAINING
    • P6 Fundamentals
    • P6 Advanced
    • Primavera Risk
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • Free Tools
    • Free Tools
    • FREE Online Tests >
      • Assessment PLANNING & SCHEDULING
      • Assessment EARNED VALUE
      • Assessment EPC
      • Assessment Procurement
  • APA Store
  • Engineering Deliverables in P6
  • Project Analytics APP
  • XER Analytics BETA TESTERS
  • XER P6 Templates