AdvancedPlanningAnalytics.com
  • Home
  • About Us
    • ORACLE in Las Vegas P6 Advanced
    • ORACLE Primavera Training
    • Contact Us
    • Services
    • Careers
  • TRAINING
    • ORACLE Primavera P6 Professional Fundamentals
    • ORACLE Primavera P6 Professional Advanced
    • ORACLE Primavera Risk Analysis
    • SPECIALIZED TRAINING >
      • ORACLE Primavera Risk Analysis
      • PLANNING & SCHEDULING WITH HANDS-ON SOFTWARE TRAINING
      • EARNED VALUE MANAGEMENT
      • SCHEDULING ANALYSIS [QUALITY, DIAGNOSTICS & FORENSICS INCLUDED]
      • PROJECT CONTROLS PROCEDURES & GUIDELINES
      • ENGINEERING, PROCUREMENT, & CONSTRUCTION PLANNING [EPC]
  • Free Tools
  • FREE Online Tests
    • Assessment PLANNING & SCHEDULING
    • Assessment EARNED VALUE
    • Assessment EPC
    • Assessment Procurement
  • Schedule Blog
  • APA Store
  • Engineering Deliverables in P6
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • TAKE THIS SURVEY [FREE GIFT]
  • Project Analytics APP
  • Privacy Policy
  • Terms of Use

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
Copyright © 2017 - Advanced Planning Analytics,  All Rights Reserved.  CRamos Management LLC.
  • Home
  • About Us
    • ORACLE in Las Vegas P6 Advanced
    • ORACLE Primavera Training
    • Contact Us
    • Services
    • Careers
  • TRAINING
    • ORACLE Primavera P6 Professional Fundamentals
    • ORACLE Primavera P6 Professional Advanced
    • ORACLE Primavera Risk Analysis
    • SPECIALIZED TRAINING >
      • ORACLE Primavera Risk Analysis
      • PLANNING & SCHEDULING WITH HANDS-ON SOFTWARE TRAINING
      • EARNED VALUE MANAGEMENT
      • SCHEDULING ANALYSIS [QUALITY, DIAGNOSTICS & FORENSICS INCLUDED]
      • PROJECT CONTROLS PROCEDURES & GUIDELINES
      • ENGINEERING, PROCUREMENT, & CONSTRUCTION PLANNING [EPC]
  • Free Tools
  • FREE Online Tests
    • Assessment PLANNING & SCHEDULING
    • Assessment EARNED VALUE
    • Assessment EPC
    • Assessment Procurement
  • Schedule Blog
  • APA Store
  • Engineering Deliverables in P6
  • EXCEL GANTT
    • EXCEL GANTT ADVANCED
    • EXCEL GANTT BASIC W-PROGRESS
    • EXCEL GANTT USING VBA
  • TAKE THIS SURVEY [FREE GIFT]
  • Project Analytics APP
  • Privacy Policy
  • Terms of Use