I have been asking *so many questions* this week and for that I am sorry lol.

Now, regarding power query in Excel, does anybody know what specific situation would entail XML mapping?

I am asking because I need to open an existing document in SharePoint for web to view the change log. It does use power queries that involve XML but idk which XML query is the issue. I have other workbooks that use XML weblinks which do not give me this "XML mapping" error.

I did my time and got out and was thrilled but now I am insanely bored and don’t have much motivation. Am considering getting back in or applying to become a police officer / fed...cont

How to switch from Accenture technology to Accenture strategy?

Currently interviewing for a role at Amazon that is listed as a CW position, but I have direct experience in the product and capabilities this role is seeking, and the hiring manager is moving me forward. What is the likelihood that if I tried to negotiate from a CW to FTE, I would get the position?

I have client round on friday.. So anyone please help what kind of questions they can ask in client round..? Automation testing using selenium and 6 yoe

Hey, I am looking for an Angel investor to invest in our idea. Can someone help me to connect with the person.

When picking up a J2, how much should you include about J1 on a background check?

Random question since I learned about this watch recently: does anybody in the bowl have the salmon dial Seiko Sarb037? And if so, how/where did you get it?

Can anyone working for DT’s ARA or PwC’s CMAAS tell me what does their job specifically include, hours and exit opportunities?

Can anyone recommend a great rep? Weighing my options.

Do your executives and ownership teams care about culture? Do they care about innovating?

My top executive is very “stuck in their ways” and refuses to accept that he is creating disconnects with his team.

What is the actual transaction work like at a growth equity firm like Norwest, TCV, Capital G, etc. I’m interested in learning more about minority investments in the $10-$100m range. What is the diligence like, timeline, etc basically, I am curious if this is something only bankers can do/have experience with

For advice/fee based platforms: SEI Private Trust or Envestnet as your preferred?

What is typical salary range for Sr. Consultant at Deloitte India Consulting. YoE - 3. MBA Tier 1 college.

Has anyone had crochet Senegalese Twists? If so do you know what brand of hair you bought?

Sink or swim. I applied for a position as a “STEM Coach” that I don’t qualify for via university degree, but do qualify for on experience and self initiative. Got nothing to lose:).

Has anyone here done a google case interview and can share their experience?

Worth trying to jump from Clearview to MBB for the biopharma exit opps? Or would the exits be similar.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

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

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.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

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.

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)

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

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!

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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 😭

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.

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?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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