All the updates to Excel and it still struggles with this 😅

Post Photo
likefunny
Posting as :
works at
You are currently posting as works at

Genuinely laughed out loud, thanks for that today

like

Bahhahahahhahaha. I honestly have the issue where it flips all my dates to Julian dates.

Related Posts

To all those who have got or trying to get international assignments. What skills do we need to showcase to our leads/managers and possess.
Also those who are managers what do you expect one should have in order to get this opportunity.
Please don't say bootlicking/politics/favouritism etc. Those might be there but what are real skills.
Please throw some light on this folks !!

like

Hi all,

Have an offer from PWC for 22l (fixed). Yoe-7
For senior product manager role in S&P global Market Intelligence, how much can I ask for with current offer in hand? Does S&P provide entire fixed or there is a variable component?

Also will help, if you can share details about WLB, average yearly appraisals etc..this will help me decide!
Thanks in advance !!

like

ghosted from FIG :(

like
like

Sorry if this question is already asked. Has premium processing resumed for H1B transfer to another employer?

Any Deloitte people trade on robin hood?

like

Where are you all traveling to for work?

Serendipitously meeting people on the road was one of the best parts traveling pre-Covid

likeuplifting

If the layoff is not necessarily to go through performance improvement plan, then is there a standard dashboard look to evaluate ourselves about how close we are at?

likehelpful

Got my bachelors degree in civil engineering in China. Passed all four CPA exams in 2010. I have less than 1 yr exp working in a CPA firm. What do I need to do to get the CPA License in NY?

uplifting

Hi Fishes

What would be the in hand monthly salary of 12lpa?
Thanks in advance.

Curious to know how many are both the EC teacher and the general curriculum teacher for their PReK class. (And are you the IEP case manager for your students.)

like

Anyone here willing to explain their thesis on bitcoin? Thanks!

like

For those of you who got out at 10, do you wish that you rode it out to 20? I’m at a crossroad and I’m not sure what to do. Have some active/reserve time, wrapping up graduate school, and am now considering either a) come back to the business world or b) go active and retire before 50 and live off a nice pension. Obviously there are draws to both. I’m an officer for what it’s worth so I can realistically retire at O-5, MAYBE O-6.

likesmarthelpful

Anyone from Accenture CN here? Need urgent help

like

What are the best consulting firms for digital marketing?

like

Any ideas on a decent salary for a clinical care coordinator, home health setting? *with experience*

like

How do you apply design factors to IT Audits. Just overheard someone explain 'level of aggregation' for IT Security policies by describing how many people have access to it. Why is this a thing???

like

Does oracle has a office at Kolkata ? My current location is banglore , can I change my base location to Kolkata ?

If yes , what's the process ?

like

Does anyone else have issues knowing when to stop working or managing their work-life balance? I get emails and requests at all hours and I always respond but I'm wondering if it is time to set up some boundaries and start ignoring requests after a certain point at night and on the weekends?

like

Can someone refer me in your organization for Wintel domain role.

Experience- 3.3 years
Serving notice period

like

Additional Posts in Excel Genius

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

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

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

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

like

Would anyone be willing to teach me vlookup?

like

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.

likefunny

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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.

like

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

like

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

like

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

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

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

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

Post Photo
like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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 😭

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal