Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Have you ever tried to bring about a change/stood up for something at home/office etc. Did it succeed/fail? How was the experience?

Any good stories from 2008-2010?

For those in private, how was bonus this year?

Hi i got a mail from IFS team about my adverse response in the FY22 ACC regarding EBP's. I am not able to understand this. Please help me understanding this mail.

Base salary for KPMG S3 in audit for MCOL, like orlando?

Is another recession coming?

Is Bosch offering wfh for new joinees or they have to report immediately to office (hybrid)

Although the market is open and lot of lateral hiring is going on.. Can see that 10+ years experience professionals in SAP FICO domian are not getting much calls & invites from the companies..

iPad Pro 1st Gen (refurb) or Latest iPad brand new?

Alvarez & Marsal. How does one get a job there?

Can anyone share their thoughts/experiences with Capital One?

Hello Team, Could you please let me know, how much salary will be sufficient to live in malaysia with family.

How much salary can we expect for 10yrs of experience.

Are people who joined in January not receiving any hikes this year at ac kolkata?

Can someone create a bowl for afghan politics please?

What is up?

Hi All,

Please give me ur answer!!

Does PWC AC banglore offers permanent wfh?

Will that be mentioned in offer letter?

I have HR discussion tomorrow.

I have an offer from EY GDS bangalore, I am looking for WFH. Which one should I prefer?? Please provide your inputs😊Pwc AC @EY

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

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

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

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

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

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

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

How long did it take you to become good at excel? Like fast?

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?

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’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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 🙏

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

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 😭