Did you know that MS Excel has a hidden, life altering Easter egg? This is a story of how I found it and discovered joy. Read on.
Almost an year ago, I have quit my job with one of the leading IT companies in the world, to embark on an uncertain but very exciting journey. I have started my own business around MS Excel – creating & selling awesome Excel products & training programs [visit our online store].
This is a continuation of the Chandoo.org Start-up Story posted around the same time last year. Grab a cup of coffee and read it in leisure. Do not expect any Excel tips. 🙂
[PS: if you are new to Chandoo.org, Read this and this before reading this post.]
What is it like to run a small business
When I wanted to leave a stable & well-paying job & start a business several things bothered me. What if my business never picks up? What if I do not generate enough money to sustain my family? What if I grow complacent & make mistakes? What if I get bored or lonely or get demotivated? What if I cannot handle the thousand little things that go in to running a business?
They say, leap and a net will appear. And leap I did. And just as if a switch is turned on, I found answers to all my doubts one by one. I discovered the joy in running a small business around my passion. I made mistakes, but I kept learning. I found help from friends. I made new friendships. I learned how to reduce, automate, outsource areas of work that are not critical. I hired people to help me with customer service & emails. And not one moment, I felt tired, bored or demotivated. In fact, I feel excited every single day about what I am doing.
How is my business doing?
Here is a quick summary of the business:
(April 2010 to March 2011)
- Total paying customers: 2,175 (Repeat customers: 175)
- Revenues: ~$200,000
- Top products – Excel School (743), PM Templates (1148), Dashboard Training (199)
- Consulting clients – Microsoft, Wao Marketing, eNor and more.
- Speaking & Training – Office 2010 Launch Event, International Excel Workshop @ Maldives
- Total Visitors to Chandoo.org – 2.5 Mn
- Visitors who spent more than 15 minutes on site – 787,000
- Number of comments received – 7,790
- Number of articles written – 217
- Press Coverage – MSN, Economic Times etc.
What did I learn in one year of doing this?
Many things. Hardly a week goes by without picking up some new skill or idea. But the most important things have to be,
It is not risky: I had this notion of taking huge risk by leaving a plush job. But then, the risk magically disappeared on day 2. Instead, I see immense opportunity for fun, knowledge, satisfaction and profit. All of which were not possible with my day job beyond certain extent. [Related: Is it scary to start?]
It does not take 80 hours per week: During the first 6 months, I used to work a lot. Most of the time I was inefficient. Then, I analyzed my time (in Excel, what else) and found that I could reduce the number of hours spent on e-mail and other activities to focus on what I love most – Excel, interacting with people and sharing new ideas. Now, I am spending <6 hours per day and I am happy with the results.
You need a supportive family: At least once a day, my son or daughter would walk up to my office-cum-guest-bedroom and knock on the doors, often violently, and scream – “daddy, da.” (meaning, Come out Daddy). Although, my heart would race to go out and hug them, I would say no and continue working.
There were days, when Jo (my wife) would feel lonely as I was locked inside the office room for a product launch or marathon recording session or crafting a dashboard etc.
But, thankfully, I have an understanding wife. So, they would be all smiles when I walk out. Also, I have learned to structure my working hours around my kids sleeping hours. For eg. I would get up at 4AM to do recording.
Saying NO is 100 times tougher than saying YES: While I feel immensely thankful for the growth in my business, it has also bought in a new challenge. There were too many opportunities. So many more than I can handle. I get requests for consulting, training, product development, testing, collaboration and more. Initially I used to say YES to everyone. Soon, I had a pipeline of things to do, with no clear plan on when I will finish everything. Then, I started being picky. I started accepting consulting work for projects which are challenging. I started collaborating with one company at a time. This reduced the workload. But the challenge of saying NO is so much more than YES.
Taking it easy is not so easy: When this blog was my side-business, I used to take it very easily. But during the initial months of making the switch, it was hard for me to take this easily. I would freak-out when my site went down, when a customer dis-liked my product or when I get an email with “Urgent” in the subject.
I learned to slow down things. For eg. I reduced the number of posts per week from 5 to 3. I also roped in more people. Hui, Paramdeep & a few guest authors to write on this blog. Ravindra to help me with emails & customer service. Naturally, this restored my sense of humor and ability to learn new things.
Ask and you shall receive: This is the most important lesson. I used to worry whether anyone would purchase my training or products. But then I realized that by just asking you to purchase, you would consider it. This is how I was able to generate revenues from Excel School, PM Templates and other products.
What next?
I am excited about the way my business has turned out. While I generally avoid from making long-term plans, here are a bunch of things I would continue to do,
- I would like to grow this business slowly and learn new things all along.
- I will continue to share my knowledge, mistakes and ideas with you.
- I will spend a great deal of time with Jo and kids. I love taking long walks with Jo, playing with kids.
- I like connecting with people all around the world and will continue to do so.
- I will continue making awesome products, training programs.
- We (our family) will continue to spend less, live meaningfully and give back a portion of what we make to society.
- I will continue to treat you, my dear reader, as my top-most priority.
Wishing you a happy Easter
I found an Easter egg in Excel. Instead of finding it on Easter day, I find it everyday. And I feel excited, fulfilled, grateful & honored.
I wish you will find your Easter egg. It might be in your profession, hobby, religion or community. I wish you will discover the same joy as I did and continue to spread it.
And if you have already found it, then I feel very happy for you.
Thank you.
Easter Egg photo from tillwe.
35 Responses to “Quick and easy Gantt chart using Excel [templates]”
"Please share your experiences and ideas using comments"
For those willing to go VBA, XL can do far more w/Gantt Charts. Compare to PapaGantt. https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts
While making PapaGantt was neither quick nor easy, using PapaGantt is both, not just for displaying Gantts, but for scheduling tasks as well.
is it possible to get a xls(m) file ?
instead of a zip-file with .xml-files ?
i cannot open it with excel :/
Regards
Stef@n
@Stef@n
Try saving the file and then open from Excel as opposed to opening directly from the post
Also try this link: http://img.chandoo.org/pm/quick-gantt-chart-template.xlsx
Thanks very much for this workbook idea.
To slightly up-scale functionality I added:
1. conditional format for when the cell value =2 to be red which could be used for critical path or other activity highlighting needs (milestones perhaps)
2. conditional format for when the cell value =c to be green which could be used for showing activity progress
3. conditional format for the same range where formula =DATE(YEAR(D$5),MONTH(D$5),DAY(D$5))=TODAY() and set custom to ;;; and cell fill colour to a light blue. This will highlight today down the whole table to allow quick assessment of activity progress to plan. Anything not green upto where the date indicator is shows activity is behind the plan. Opposite for tasks ahead of the plan.
(There is probably a better way to get the same result but this works for now. If there is please post for us to share.)
Hope this made enough sense.
Also, thanks Craig for the link. I'll have a better look soon.
Regards,
Darren
Hey Chandoo,
I actually made one of these for a friend of mine but added an extra level of automation.
Rather than putting in 1 on all the dates the activity occurs, I added a column for start and end date of each project. Then I used formula along the lines of :
=IF(AND(DateAtTop >= Start Date, DateAtTop <= End Date),1,"")
Then used the same conditional formatting where 1 was coloured.
I thought this was a nice touch, especially if a project lasts for many days.
Let me know what you think 😉
Lucas
P.S. First time I've posted here, love your work btw!
Hi Lucas... welcome to the comments and thanks for your first of many comments.
I like the idea. In fact, it was one of the first Excel tricks I ever learned (to use conditional formatting to automate things like this). See this (written almost 6 years ago)
http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
and scroll-down to the tip on gantt charts. 🙂
I liked this approach and tried adding it into the Conditional format via Formula = statement. It workd fine with just the AND statement but then I realised you need the "1"'s to calcluate the duration.
I then put the whole IF statemnt in but it hasnt worked. Any thoughts?
Ta
Hi Lucas and Darren,
I tried the conditional formatting but I really don't succeed in getting the solution. Do you have a template of this?
Thanks in advance
Br
[…] http://chandoo.org/wp/2014/02/18/quick-gantt-chart-excel-template/?utm_source=feedburner&utm_med… […]
[…] via Quick and easy Gantt chart using Excel [templates]. […]
Excellent, thanks for this tip and expample.
I had a monthly reporting template very similar to this, but was done in excel which needed more manual inputs.
I used your exmaple and updated my monthly group reporting plan.
I further devided the day into 4 quarters to make it easy for us to followup on different tasks.
Now, I just have to update the start date, and everything gets udpated by itself in fraction of a second.
Thanks once again. love your daily udpates.
Wow.. glad to hear that.
Hi Prahlad,
Can you share ur template even i am looking for similar kind of template .where i want day duration ,split in hrs and each task effort represented in hr spent by each resource .
Thanks
savi
Hi Chandoo,
Can you guide on preparing an indian version of the captioned sheet. We have saturdays working :-(, and only one day weekly off on sunday.
Regards-Prajay
Hi Chandoo,very useful post.i need gantt chart for inventory module.
[…] Quick and easy Gantt chart using Excel […]
Hi.
Really usefull post. I would like to know if i can also include weekends.
Thank you
Hi Chandoo, thank you for the great job, I was wondering if you can customize this sheet for Inventory planning purposes?!
thank you indeed
This was so helpful. ive been through about 10 different tutorial type things and this has to be the best so far, helped me out a great deal. and now my boss is happy i can make gantt charts!
thanks
This's a great post, thanks for sharing
Hi Chandoo,
Thanks for the excel tutorial. I wanted to make a simple modification, however it will cause issues with the duration part. I created another rule/cell marked 2. For my project I want to show a projected timeline and then an actual timeline. The issue is that the duration is being logged for when I enter 2, which I want to be projected and not actual. Will you please assist in letting me know how I can create a duration for both project and actual on the same line?
Thank you,
Steven
Showing vertical line between every week is very useful for me, I used to do it manually. Thanks so much!!
But how about, my gantt chart included Saturday & Sunday, and I want to show the vertical line after Sunday, could any expert teach me how to fix it. Thanks again.
This was so helpful - thank you! I had a bit of trouble with the end of the week conditional formatting over-writing the filled cells but switching the order of the rules sorted it out. Needed to put together a gantt chart quickly for an important bid at short notice and this was just the job - thanks for taking the time to post it. Much appreciated.
This is the first time I'm reading a tutorial that actually makes sense 🙂 This is absolutely great, with only one minor issue I can't seem to figure out on my own. How do I include weekends in (or instead of) the Workday formula? Thank you!
[…] This template I made myself but I inspired from Chandoo.org. […]
Hi,
Sometimes I must work at weekends - it is possible to modify the dates so that you can include Sat + Sun as well?
Thanks,
H
Nice gantt chart template chandoo, simple but useful
Thank you so much for this excellent guide! I have adapted this to show scheduled activities at multiple project sites weekly over the course of the year, including active and proposed work. With just a tiny bit of tweaking to your tutorial, I was able to create a chart that suited my needs perfectly!
Thank you very much for idea sharing .very innovative workday formula is showing 5 days but i want 6 days , is there any other option plz reply..
i got it friends..
=WORKDAY.INTL(F4,1,11)
hhhhhh
@Somnath
I also like the structure using =WORKDAY.INTL(F4,1,"0000001")
where each day is a 0 or 1
Hi thanks a lot for the tuto!! It helped me a lot!!
But can you tell me how can I add a vertical line representing today on it?
@Cynthia
Open the template
Select D7:DS26
Goto Conditional formatting
New Rule
Use a Formula
=D$5=today()
then set the format as a Red Right Hand Border only
Apply
Do not select stop here for the rule
Hi Chandoo,
I purchased your Project Management templates a month ago and have not had the chance to thank you for the great templates. Thank you!!!!! It has saved me a lot of time creating and re creating templates. Unfortunately, I had to do a lot of customization but it's not that bad. I am now in the process of customizing my GANTT which my boss thinks is too granular. He doesn't want to see a weekly grant. Only the months should be showing. I have researched and researched but to no avail. Do you have any examples I can look at?
Hi Chandoo,
thanks so much for all your tips on Gantt Table.
I'm actually building one at the moment and want to use the conditional formatting. However, I always get into trouble with that when I have to add new lines. I don't know the final size of my table yet and I eventually also want other people to be able to work with it.
Conditional formatting tends to "split up" into various "applies to" ranges when you insert a new row or copy and past values from somewhere.
I'm sure you've come across this issue already... So far I couldn't find a feasible solution to this. I was wondering if you had an idea / suggestion for me?
Thanks so much!!!
Nadine