How to change a date field from 2002/01/15 to YYYY-MM-DD. The right click and date selection is not converting it for some reason. Even tried to do a custom field but it’s not changing :(

Anyone familiar with Yamamoto (mdc partners / brand labs)

I have joined nagarro in Jan and till now my journey has been very good ,but listening to recession news I am getting tensed is nagarro secure in recession if u are in a project and performing gud,should I look for another company or here job is secure .please old nagarrians reply

How was your 1st day (onboarding etc..) at NielsenIQ?

Is esquire CLE legit? They have cheap CLE’s for Florida

How long did you guys study for The new cissp exam , and how are the questions like on the exam

@ those who have gotten their H1 stamped - Can we use the auto generated employment verification letter from ToD for H1B stamping Interview? Or do we have to get a separate letter signed by a Manager?

Anyone here cringe or shudder when they see someone with loads of Botox and face work done? I find it hard to look at people like that.

Has anyone used the “Happify” app in conjunction with an employee “Be Well” challenge? If so, can you let me know how the app was used? Thank you!

Is there any room to negotiate pay rates with state hospitals that have set rates based on level of experience? Also what are the pros and cons of working for state teaching hospitals?

Recommendations for tailors on the west side? Considering using nordstrom if all else fails… can anyone vouch for nordstrom?

Incoming new joiner here- starting at Monitor Deloitte in a few weeks. Wondering if D/MD Australia give EOY bonuses or anything of the sort?

Hi fellow Fishes,
I came across an interesting opportunity at Tavisca.
Can anyone refer me for the position?
Thanks in advance!

Anyone here work @ Novo Nordisk? I have a sales interview tomorrow morning for diabetes care specialist

I am plat exec on AA and wife wants to purchase ticket to Europe (traveling alone). Any benefits of booking it through my account (and assigning her FF#) or none?

Anyone use the Apple Card to buy iPhone on monthly installments and submit Apple statements for the cell reimbursement? Or do we have to buy phone through cell carrier?

Hi, Can someone please connect me to the recruiter/HR?
There is a Test Engineer (Automation) opening in Google which I see on LinkedIn. It seems relevant. Applied a few times already but I don't think submitting resume is helping here.
Also, I hear HR at Google helps candidate prepare for the interview as well.
Any help would be appreciated. TIA 😊

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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

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.

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

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

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.

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

I have 6 months left until I start my first consulting job, I want to use (and improve) my Excel skills via volunteering, where should I look to find such opportunities? (UK)

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”

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Hi all,
I bought access to Wall Street Prep’s modeling courses to enhance my modeling skills. I find that the material is a few years old and the guy in the video explaining everything is super monotone and boring. I just don’t feel like I’m learning much.

Would anyone have any good recommendations for other modeling course providers? Should I stick with WSP? Any and all advice/responses would be helpful - Thank you in advance !

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

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

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

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?

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?

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.