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.

Hello everyone, can you please suggest.
Which one to choose: Accenture or a product based organisation*?

Compensation:
Accenture: X LPA
Product based organisation*: X+2 LPA

Tech stack in Accenture: Azure
Tech stack in Product company: .net, AWS

Aim: to learn, and to get into FAANG like companies in next few years.

Hi, I need some advice
How to crack Google or Microsoft data engineer interviews, what are the rounds and what will be the key skills I should focus on
My current skills are
Azure cloud and gcp cloud data platform services
Pypsark
Python
SQL
Data modelling

How am I expected to bill 1900 hours when I only have 8 cases and when I ask for work no one responds. I even asked the partner in person for work and he said he was slow and didn’t have anything for me.This month I’ve only billed 80 hrs. Its making me anxious because I don’t want to get fired for low hours but also I’m a first year so will they have some mercy on me? Lol

Anyone stay at the Ritz-Carleton in D.C.? I’ve never stayed at a Ritz location so I’m curious to hear what to expect. Will be in D.C. for a conference so my firm is covering the trip.

Recently joined the firm as a project delivery specialist. During recruiting, the team harped on how great my background was and how much a good fit I would be for the firm/project...

Well, I was on an onboarding call and they were talking about staffing and projects. The presenter said to reach out to them if you don’t think your project is a good fit. In his words “you were hired into the firm, not a specific project. We see you here long term... With the exception of PDM model” 😅
Cont.

I am looking for a summer internship in consulting. Currently, I'm a 3rd year Economics and Stats student at U of T.
My target companies are KPMG and Accenture, and I really want to work in one of these two as they have the best workplace culture.
I'd appreciate if anyone could help me out with applications or share tips on how to get to the interview round, thanks!

What's the band of Manager Salary in CITI ?

Do citi bank risk team send their colleagues to US for projects? What is the criteria for going to US ??

I’m concerned that my latest job have been less than a year each on my resume but I’m at my wits end and need to start looking. Do you think I will be overlooked because of the length of time at each company?

Anyone looking for an AAE or Asst Media Planner? Have a friend w a Cornell degree looking to change careers and join our crazy industry

Need a referral for this PWC job...https://jobs.us.pwc.com/job/new-york/financial-services-digital-solutions-architect-manager/932/15959386

Any SAP analytics cloud developer here? Quick query, client wants a column root causes ..now this column is not available in S/4..now the S/4 team is not cooperative enough.

My leads suggested SAC has comments option. However comments are not going to help users either. Because it will not show graphically which root causes contribute the most.

So my question is now, does SAC have an in built excel option which would allow users to enter root causes across materials and then SAC refresh this

Any marketing strategists on here?

What impact has the prestige of your school had on your career?

Just want to drop by to say that The Sylvester is the best bar in Miami.

Hey everyone,

US Military Officer looking to move to Aus with SO at the beginning of next year. Planning my exit from the military as we speak. Anyone willing to connect to talk about their move?

Anyone go FAANG from big law litigation (specifically entertainment)? If so, what year did you make the switch?

Looking for Goregaon/Malad location PGs, flats. 1BHK/2bhk.

Please share details.

Thanks

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.

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

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).

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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 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. 😂🤯

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

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

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)

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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.

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 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?

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.