Hey everyone,

I was looking to see if someone has a template or can assist me in creating an Excel sheet for my startup business to calculate sales, revenue, and expenses.

Anyone willing to refer at deloitte? Happy to chat

Is there a list of agencies and clients that don’t pay on time or at all? If not, can we start one here?

Hey, everyone! Hoping someone may have a lead for a free online database for training approvals and registrations? It doesn’t need to be fancy! I’m in a new role in the public sector and am trying to move them out of Outlook and Excel messiness for training registrations. I’m just looking to streamline and centralize the process. (We don’t have SharePoint or any centralized database.) Thanks in advance!

Why is it so hard to find a remote HR position? I have my SHRM-SCP, my MBA and over 10 years of experience being an HR Manager.

What is the best way to prepare for public sector cases? Is there a specific casebook or cases I could refer to? I am currently doing case prep for recruiting in the ME. Is it correct to assume most case interviews are focused on public sector or energy?

What are your favorite meal delivery services? Looking for healthy, portioned, ready meals for one person. The protein+ options on Fresh n Lean look good but open to suggestions. TIA!

What will be the effect of US recession on KGS?
What should we be ideally prepared for in worst case scenario

How’s the work life balance situation at Amex for data engineers?

Hi Fishes, howz the leave policy at mphasis?? Thanks

Can you see who filled a particular section in smartforms?

If there is a case that we have to quarantine again. Do you all think it is possible for store associates to work remotely? If so, what are some ways this could work? I fear another pandemic or outbreak and so many people being out of work again. I can't even fathom those that had jobs in retail that had little to no choice to not be remote.

Is 650 a target score for NYU Andre Koo tech MBA? They don’t publish avg or median but middle 80% is 580-730

Is R3 even worth the bother? I have a T15 option but thinking about throwing in another M7 app. Thoughts?

Anyone knows of openings or hiring in Operations space for HF/AM/IB/FA or Family offices? Would like to move to FL, NC or TX.
Have 20 yrs experience with Consulting and Operations

I am a Client Executive with 7 years in the industry and 5 years of HR experience prior to that. I make 60k, am I underpaid?

Currently with PwC US and would like to move to PwC Australia for better work life balance. Anyone available to chat?

Anyone pack their lunch and if so what do you pack??

Anyone actually use the Networking feature here on fishbowl? Like yeah I see some of you with it on but do you actually use it besides thirsty dms?

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

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?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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?

Any book recommendations on excel modeling for real world business applications?

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

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)

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.

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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.

Would anyone be willing to teach me vlookup?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).