SLW#029: Create Simple and Effective Gantt Chart!

weekly newsletter

I'm thrilled that the Tips and Tricks pack has reached 140+! It comes with my lifetime membership, helping you boost productivity and enhance advanced applications! Click here to know more!

This week, let's talk about using Excel to make a cool thing called a 'Gantt Chart.'

Gantt Chart helps you to plan work around deadlines and properly allocate resources. They show the schedule in a way that's easy to understand.

Making one in Excel is easy, especially if you know about this feature called "New Rule" in formatting.

"New Rule” helps to format your cells by changing values from other cells.

In this guide, we'll use "New Rule" to make a colorful schedule. Plus, we'll add a timeline that automatically points out today's date in the Gantt Chart. Excited to try it? Let's go!

 

If you want to "Master 5 Big icons" in conditional formatting, click below link to check out my course cirriculum. It would speed up your learning and benefit you lifelong.

That's all for this week.

See you next week. 

 

✂️-----------------------------------

Whenever you're ready, here's the best way I can help you:

  1. Excel Analytics OS for business professionals
  • Signature course: Excel Analytics OS  (121 short lessons, 8 modules)
Explore the course with SPECIAL OFFER TODAY!