Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like
Posting as :
works at
You are currently posting as works at

Agree. You can also build the Gantt in SharePoint or in a PowerBi dashboard. Thats a lot more efficient than excel drag.

like

I have done it using conditional formatting.. it will be a pain to create and maintain, but is doable

In excel I can see two options:
- Conditional formatting
- VBA

Both a bit of a pain to create and maintain, also, depending on how big the project is, it will make the file lose a lot of performance.

Plus, you won’t get most of MS project functionalities, and will loose a lot of time recreating some of them.

I’d suggest to look for PM tools. Nowdays it’s easy to find good apps on the budget. The biggest problem is to sell the idea to the client.

Related Posts

Hi BIA fish! I’d like to connect with a designer for custom logo creation (paid job) on a personal passion project of mine. If that’s you or someone you know I’d love to reach out!

like

Hi,
Can there be a case when you are hired for a specific role and later on you are aligned to a different project ?
Thanks

like

Hello all, need an advice and opinion on below:
Offer from
Coforge (20+1) as a project manager and Indegene, Inc. (20+3) as delivery leader

like

I’ve noticed an increase in clients discussing breeding their pets. Animals that, IMO, definitely should not be bred. What do you say to encourage the client to reconsider?

like
like

Looking to do a fall shoot for a client before the leaves have changed and fallen. I need prop leaves. Anyone have any ideas about how where to contact for a massive amount of fake fall leaves?

Hi folks,

I have 9 years of experience as a QA out of which last 2-3 is an individual contributor (sole qa owner) plus team lead of a qa team.. I want to pursue masters in the UK so I can have a role like Project Manager/Test Manager/Scrum Master in the future.. what course should I go for:
1. MSc Management
2. Business Analysis and Consulting
3. MBA (not so easy as I don't want to give GMAT, will select certain colleges that do not need GMAT score)

What's the best way to gain visibility by those holding 3-4 positions higher than you? I like learning from them and growing mentorships but can't break the AE-level wall with my responsibilities. Being remote also makes it harder to interact.

I'm on the client/business side but would love to hear anyone's thoughts.

like

Does anyone who works on a DOD project with a clearance know if you can request a phone?

like

This post is an alert message for anyone joining the Johnson & Johnson EMEA account for SAP & had Rakesh Sharma for their Manager round.

He is nothing less than a con man & will promise you a lot to make you join the account. After that he will put you in testing projects. If you ask for a release, he will either not release you or release with a very bad rating and influence other project managers to not take you into their projects.

You will be left with no choice other than leaving TCS.

like
like

Currently get a Master of Science in Project Management and the concentrations are Agile PM, Analytics, Construction Management, Leadership, Leading and managing technical projects, Organizational communication, Project business analysis, which one should I pick and any advice and recommendations?

like

Off topic, Can anyone please suggest me how to prepare for AWS cloud job, my current project is not related to cloud, i have +2 years of production support in linux and currently holding aws practitioner certificate.

McKinsey & Company Any advice to help prepare for data science analyst role at top consulting firms (McKinsey & Company EY Boston Consulting Group etc)? Any materials, open source platform recommended to take on freelance data science project? When should I start actively looking and applying? I am a new grad who is working in tech as a marketing analyst I’m looking to pivot to marketing& sales data science consulting next year. Would like someone with similar backgrounds offer some practical tips.

like

What are some Entry Level jobs at AWS in Project Management/Implementation Consulting?

like

I just learned that I get to argue all of our pre-trial motions and do a direct examination at an upcoming trial. What are your best tips for preparing and setting yourself up for success? I want to hear them all! I’m beyond excited for the opportunity. It’s for our biggest client, so I really want to impress!

like

How many project rejection are normal in nagarro. I have been mapped with different stack due to which have been rejected twice for proposed projects.

like

On a phone call today, my client suggested our project team provide 24/7 coverage for scanning support. My team size is two, including myself.

Post Photo
likefunnysmart

More Posts

Suggestions for MBA aspirant !
Is MBA valued in AUS job market as it is in UK ? Target colleges ?
4 YOE - Big4 TechConsulting

Intention is to stay after graduation - great weather + peaceful life

likefunny

When selling a home have been able to negotiate lower commission with your broker if the buyer is not represented by a realtor (eg, 3% in this situation versus still paying the full 6%)?

My wife is using my credit card too much.
Monthly around 13K.

Everytime I confronted her the ending is always the same, I loose the argument and end up paying everything.

like

Have a 2/15 call on ghiv. Tanking today, drop it?

like

Who are your favorite advertising comedy directors? Who are your favorite comedy directors who are women?

like

Any Knowledge Attorneys or Professional Support Attorneys out there? Or know any? Wondering if it would be a good life choice. (I like the sound of it from the little I’ve found.)

likehelpful

I never get tired of the SLC approach, even doing it every week 😍

Post Photo
like

Dating question:not really an appropriate place to put it but its the only anon forum i have access to.
We’ve only been dating for 4 months and i feel like its gone to shit. We’re constantly fighting and everything is telling me its not worth it or not going to work... but i love her. We’ve tried to talk things out but nothings really changed on her end. I feel like we’re both just dragging eachother down. Should I end things? Maybe just focus on my career? I dont want to cuz i love her but idk

like

Question that could belong here or in the Relationships bowl:

How do women prefer to be turned down if the guy they’re pursuing is not interested. I know men have the capacity to deal with rejection poorly, and I’m not suggesting otherwise. But in my anecdotal experience , women take the gentle “no thanks, not interested” poorly.

likesmartfunny

Anyone looking to buy a Rolex Datejust 126334 fluted bezel, Azzuro Blue on Jubilee? Few weeks old, almost like new. Thinking about selling it for $11k (less than what I paid with taxes) since I don’t like flippers in our hobby.

Super beautiful watch, just thinking it’s a bit flashy for me.

Post Photo
like

Hi Fishes,

Got a call from Trianz Bangalore location for Cloud Migration Solution Architect role. Can I have some insights about the Company.

like
like

1.What are different band levels in LTI?
2.Is senior specialist level above the manager level in terms of payscale/destination?
3.What does working in salesforce vertical looks like & onshore opp. for US visa holders?
4.Avg hike / variable pay per year?
5.What is the notice period in LTI?
6.Any hidden components included in salary that can be avoided or restructed before joining?
7.What can be avg hike for 9 yrs of Exp in senior specialist track?

Thanks in advance,it will cover most of the quer

like

If you asked to be considered for early promotion and didn’t get it (despite being highly rated, exceeding billable goal, etc) would you look elsewhere? Is it right to be angry about it? I don’t want to spin myself up unnecessarily if it’s unjustified

like

Any one know how many round of interview in Wipro .... For selenium Testing
I attended 1st round and selected for 2nd round.. any one help me what type of interview will be expected.. plz help me to get placed

like

Hi friends,

I got offer from a product based firm which offered me 24+2(variable) and joining date is on Monday. They have even sent me the laptop and welcome kit. But today I got one more offer from capgemini offering 30lpa. What should I do?

like

Who here is willing to turn on networking for the next 2 hours?? People want to see their options in this bowl! You can then quietly go back into the shadows.

Was just reached out to by someone from Barton. They say they recruit people for day-by-day contract work for PE firms. Are there any other firms that do this?

like

Just got off the phone with a recruiter who asked me what year I graduated from my MBA program and college and effectively told me I was too old for the role. I do have the 1 year of experience they asked for in the job in question. It's just that I have all this other experience in things unrelated to the role or things I want to deemphasize in my next role. Is there anything I can do? I only list the last 8 years of experience (as it's most relevant) and don't have my graduation years listed.

like

Hi, I have got an offer from Abzooba. Any inputs for wlb, job security would be really helpful.
Role: PM, 10 yrs

I hear that UST acquired this last year. TIA

Additional Posts in Excel Genius

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Would anyone be willing to teach me vlookup?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

How do I compare two sheets to make sure they are identical?

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal