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

(Not frm Accenture)
If you are on notice period and not doing work properly or on time then what can be the consequence ?
They cant put me on performance defaulters as I voluntarily resigned and also got good feedback from client.
The reason I resigned was the sh^^head manager and project.
He said I would be released from project soon and then on bench but after resigning he is saying you have to serve the NP n we cant release early.
This is only option left to get released from this sh^t place

like

Hi Fishes anyone here working in ADDA project

I am currently working as a delivery manager for a data science project where I manage both ML and DE teams. I am not sure what career path should I follow.

Should I move into either a core technical data science/data engineering role or move into a techno-managerial role like a program or project manager? What role would be best in terms of money, growth, and job security?

like

What’s the most unprofessional thing you’ve seen in a deposition recently?

like

Hi all, I am new to cognizant with 3 yoe. Got selected in Verizon account. If anyone knows about this account can u pls comment how the work life balance will be? and the pressure in the project and working Timings

I prepared a presentation for an interview with a sales leader, it went well and I was offered a final interview with regional manager. The sales leader I interviewed with gave me a bunch of feedback, but said to find out information about tech stack, which I for some reason, didn’t consider. I come to find out that deep, hidden within the website of the hypothetical client, they use the service already. Do I roll into the final interview and play dumb or do i present and then come clean?

like

Hello,

How is Kotak Mahindra Bank project of Wipro.......is work life balance maintained?

Please let me know...

Wipro

Kotak Mahindra Bank

like
like

Hi I am currently working with TCS and very soon I will be on bench as my current project has expired. Hence, looking for an opportunity outside for better prospects. Please let me know if any.

like

Things are apparently going to get better after a client will be leaving, I’ll get to work on different brands but I am feeling pretty burnt out from the agency I’m at. Will new clients help? Or should I look elsewhere. Been at the agency almost 3 years, I feel like I need to switch things up for my sanity.

like

Hi Guys,

I have an OL from LTI with a CTC-20 Lpa..As my mother had brain surgery, i need to be with her. i have asked HR to provide WFH. Does LTI support in these kinds of cases?? I have also asked HR to set up a call with the Project Manager.

Comments pls ..

like

Hi everyone!
I currently work for Graybar Electric as a Project Specialist. Over the past few months, I’ve been training some of the new employees and it’s really inspired me to want to move into a operations training and development or a leadership position. Unfortunately, there isn’t a lot of room for growth where I’m at. I’m hoping to make new connections and see where this new endeavor takes me, if anyone would be so kind as to refer me. Here’s a picture of our family dog for some likes ❤️

Post Photo
like

Is Atos have any bench policy,I joined atos in month of April but still I didn't get any project.
They give me 2 or 3 inteview calls but I said no to them beacuse it's not matching my skills set.
Can you please help me will they fire me if I'm on bench for longer time.Atos

Any SAP EWM fish in here? I am new to SAP and just finishing my first project in EWM. Would like to continue building Expertise in this Module.
I am therefore looking for advice on how to go about this?
Which areas within EWM to focus on or start with to build a good foundation.
I have not had formal training so just learning on the HUB and by doing as I go.
But I feel like I need to focus on one area. I cannot decide how/ what though.
Happy Holidays!
Thank you.

like

Recent career-switcher here. While I’m a veteran with the ad process, I am new to the UX agile process. Is it normal to not use briefs whatsoever? Is it normal for the UX research lead to have a stakeholder workshop (sans designers) to think of concept “thought starters,” then have a separate meeting with the UX design lead to vote on which 1 of 3 concepts to proceed with? In advertising, this is analogous to the client and researchers doing the campaign idea then telling the CD to execute it.

like

I am a Staff and was giving the task of organize audit conclusion lunch with client. So I am looking for restaurant recommendations in Newark,NJ to take client for lunch. Anybody?

like

Once we are on bench in Morgan Stanley client, Will they assign any other project in synechron?or we will be on bench for longer days?in syenchron.....Is there anyone working on Morgan Stanley client and got released once project got over?

Advice on pivoting into Sales from Accounting? I know I have the skills and it’s a better fit, personality-wise. I am not a super technical accountant, but my background is still a super strong skill set I bring to the table with me (the ability to process and translate the technical to layman’s terms, and the anticipation of client needs and wants). Are there Sales recruiters similar to those for Public Accounting? Do I go for Inside/Outside 1st? What are your recommendations and wisdom?

like

I have cleared all my interviews for Visa for the role of Sr Project Analyst which band I6 can someone help me with the seniority level of I6 is it entry or mid level?

like

More Posts

TCS has given the BGV check to some vendor and today I got the message from that vendor to verify my Permanent address by clicking a link and then by enabling my location and taking selfie in front of house. I am not staying at my permanent address but I am at my present address. How can I take selfie and enable my mobile location and submit the form. Please someone suggest. @Tcs

Any body got retention offer from LTI?

like

Friday Wordle 314 2/6

🟨🟨🟩🟨⬛
🟩🟩🟩🟩🟩

like

Hi Infosys / Ex Infosys employees, could you please share your experiences.

Post Photo
like

Hello fellow members of the Fishbowl community,

I am thrilled to have joined this vibrant and supportive group of professionals. As a new member, I am looking forward to learning from and connecting with others who share my interests and expertise.

I have been in the freelance web development industry for two years and have build a solid foundation of skills and knowledge. However, I know that there is always more to learn, and I am excited to tap into the collective wisdom of this community.

like

Do you find that you speak figuratively or in analogies more than non-copywriters?

like

Anyone tried roasting their own coffee? Curious about if you found it worth it or not, and any tips you might have for someone looking to get started. Thanks!

like

Is it possible to have video ads that drives clicks? Can you please share some links as well? Trying to figure out what videos are good for DR, thanks!

Hi - Are have all productions halted during this time or do you know of anyone still shooting?

like

I’m interviewing for a job and am in the third and final round. I have to develop a strategy based off of a case study and then do a 30 minute presentation to a panel of people. I haven’t ever done this before. Does anyone have any advice or best practices for this?

like

Is anyone working with OpenText Bangalore. How is the WLB, job security and general culture. Is it a good organization to join for a 9 YOE guy?

like

Hey guys
I wanted to know how much Salesforce support Engineer gets paid in India

like

Did you/would you get booster during pregnancy?

like

Hi Folks,
Once the medical checkup is done, in how many days will I get my visa for Australia?

like

Help! Need an intervention - what are your proven secrets for managing receipts when travelling? I'm in paper hell...

like

Hello fishes,
Anyone has a clue when will Form-16 be available?
My LWD is near, so just wanted all these docs before I loose access.

like

Hi Fishes,

I am thinking to diverting my career towards freelancing in accounting.
For that I have to resign from my current job in Pwc. I am thinking of starting a job as accountant and work as a freelancer as part-time.

Any thoughts or advice?

Hi everyone,
Looking for a M&A HR checklist that includes due diligence through integration. I have one but would like to see what else is out there and compare. Happy to share my email directly.

likehelpful

A jr team working on social part of a campaign, which I oversaw as well, just claimed credits on their social channels for my spots, which they didn’t concept, write, or produce... 🤷‍♀️🤷‍♀️🤷‍♀️

funny

Any PwC manufacturing folks here (Reliability/Maintenance or Prod Development). Looking for referral and also some advise on level (Mgr v Sr Mgr).

like

Additional Posts in Excel Genius

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Anyone know what these badges are?

Post Photo
likefunny

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any 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

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?

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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

like

Still don't have xlookup. #fomo

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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.

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)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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

like

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

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

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

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