Convinced my non-accountant-but-still-works-@-B4 wife that Excel doesn't use the letter O at all because it's too similar to 0. And that most accounting systems don't use O either.

Score one for Excel nerds!

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

Lks like fishbwl did the same. Smart.

funnylikehelpful

Bummer for Liver Wyman and Bstn Cnsulting Grup

likefunny

Explain pls, excel doesn't use the letter O? In what context? Or am I being punk'd too....

likefunny

Well yeah, it's a good reason too. You wouldn't want something to confuse 4O with 40 (forty). So Excel, starting with 2003 version, removed the O from the character database to prevent confusion in the post SOX financial world. There's also a line in the Dodd-Frank Act recommending companies remove O from financial software to prevent issues. Think of it as like the next generation Y2K prevention.

funnylikesmart

4O

Related Posts

Anyone tired of their firm and wanting to join big 4, dm me for KPMG. I help applicants reach out to the right practice and right people

likefunny

Want to leave current job…looking for either audit/consulting roles at a firm or internal audit/risk management position internally. I have 11+ years of IT audit/SOX/risk/control experience and have worked in Big 4 and Fortune 500 companies…and in all three levels of defense (currently I’m a level 1 IT Risk Director in my company’s IT group.). Looking for any advice, feedback, or leads. Thank you!!

like

How long does a candidate normally get a response from the firm for experience hire (after 3 rounds of interviews)? Do big 4 tell people if they are rejected?

like

What is general perception of EY and other Big 4 when compared to WITCH companies? Will you leave EY and join say someone like TCS or Infosys?

like

What does compensation look like for Big 4 Salesforce Manager? Previously SC at Deloitte commercial and wondering if federal is the way to go. Me: 10 yrs Salesforce consulting exp mostly in commercial

like

6 months in audit at B4. Looking to pivot into entry level Consulting (Tech/Data Analytics). Anyone open to network / give referrals?

like

Realistically, can someone from the B4 ever get hired into any of the MBB firms?

like

Hello, does someone with hardcore banking experience have a chance in getting into Big 4? If so, which is the ideal role to look for?

like

I got couple of offers from big 4. One has provided package of 120k( I already accepted offer before and h1 transfer is approved and gc will be initiated after 4 months) and other is Deloitte which have provided 140k and will file gc after 1 year. I am thinking to stay with first since Deloitte has offered project specialist which seems to be as glorified contractors. By the way I am 8 years experience full stack Java developer.
Deloitte

like

Looking to move from West coast Big 4 to Toronto Big 4; M2 position. Assuming that the salary ranges between $120-130k, what’s the typical rental and daily expense that one can expect?

As far as accounting advisory (CMAAS, FAAS, Etc) anyone have opinions on big 4 vs a more niche firm like Houlihan lokey or A&M? Currently at big 4 and thinking of moving out of audit, but not sure what the best next move is. As I understand it the smaller firms are more middle market, but can pay better and have better WLB? Anybody have any ideas on exit opps/other pro's and cons to consider? Thanks for your help!

like

Hi I’m currently an audit senior at a big 4 and I’ve interviewed a few times for a job at CFGI. I’m curious about the pay structure and how overtime works. Can anyone that works there elaborate on that?

like

When did the B4 get rid of OT? Talked with an MD of Tax at a client and he talked about how at Arther Andersen they were paid OT. My mom worked PA back then too and was paid OT.

like

Currently from mainland Europe. Offer from capco at senior, also offer from big 4 as a manager. Both within data n analytics - and in London. I’m interested in strategy (want to branch out into digital strategy in the future) based work and haven’t heard the best things about capco. Can u guys pls give some opinions. Salaries quite similar. Im 35 and the next move needs to be the right one.

Hey, anyone got leads for Dubai Big 4 Advisory Senior Manager compensation for candidates with EU/US experience? Thanks!

like

Hello! Looking for guidance on SALT senior manager salary in the Boston market. I’ve been a senior manager for 3 years in NYC. I know it will be less, but I’m not sure how much less. I know it can be a wide range, looking for ball park estimates as I start my search since I do not plan on moving within my current firm. Specifically wondering what Big 4, RSM, Grant Thornton, etc. would pay. Thanks!

like

Recently I left a Big 4 which was paying for my MT. So far, 3/12 courses down. Now that I'm paying, is it worth it to cont my MT? Or instead a tech degree (i.e., BS in CS or IT)? Or neither?...

Does anyone want a referral to The Siegfried Group? Required 3+ years Big 4 experience.

like

EY feels kinda...cheap. Are the other B4 like this?!

Is senior manager level in an investment bank(RBC ) lower than manager level in big 4? If yes , which title will be same to manager level in a big 4?

like

More Posts

like
like

How is job security in zs india?
With upcoming recession, will it be wise to join ZS (as it has 6 months probation period)?

ZS Associates

like

I have thoughts on the reasoning but wondering if any MBBers can comment on why their firms use standardized test scores as part of their hiring decisions. Seems a bit narrow minded on its own...

like

Anyone feel like their hair lost a lot of volume since the beginning of covid? And thinning out?
Have you found anything that's helped you?

like

How do you make sure you are keeping the brand voice consistent?

like

What’s TC for a senior director at FTI Consulting in HCOL looking at?

like

Just got a verbal offer this morning from a company. Have other companies waiting for results from final rounds but the recuriter from the first company wants to discuss next steps.. how do I best position myself with highest possible salaries? Do I just give higher number than usual? Fyi all consulting firms and the offer is at Senior level while others may be at Manager level but the former may be paying more due to the size of the company..

like

Never been set up with anyone. how do I make the initial texting less awkward? Once I get to the actual date I'm sure I'll be fine, but hoping to get there without coming off as boring

Anyone in Estate Planning/Private Client?
How does the practice looks like? Any recommendations for someone looking to transition into it from international tax? (have prior summer experience in big law in private client) currently at b4

likehelpful

Who is in this bowl? I feel like it is mostly guys in mid 20s.

Let’s do a survey: Age/Gender/Location/Ethnic Background

like

I see a bunch of people talking about investing in Gold bonds. Would an ETF like GLD or IAU make sense?

like

Is T-systems good company in WLB, promotions and hike?

like

Looking for advice! I’ve been in the banking for approximately 10 years in risk/Compliance. I left my role several months ago and I’m having trouble landing a job in the banking sector. Hiring managers say the interviews went great but then crickets. I am feeling that this is no longer for me. Would a career coach help me pivot to another career. I keep falling back to what I know and it’s no longer working. Thanks!

like

Best ETF to invest in?

like

Any CDs out there manage the social team and social media managers brand side? Would love to swap stories (anonymously) and give/get support. We’re doing great things but lots of guess work and I feel a bit lonely wondering what is normal and not, esp coming from an ad agency background.

like

Has anyone taken a job with great medical benefits but no dental or vision coverage? Did you find coverage on your own?

like

Hey there! I’m hiring!

Looking to find a digital strategist, social media manager and a community manager.

F100 client, global brand, growing team + agency.

Holler for you or someone you know!

Post Photo
like

I am yet to join servicenow as backend developer senior software engineer. Will there be too many expectations from SSE role in company?? Please guide

Can you “safely” share suicidal thoughts with a counselor?? If you have a plan-18 months out-you don’t want to follow through on, can you share that with a counselor without them reporting you to someone or just generally create more of a crisis than you would like to exist?

like

Additional Posts in Excel Genius

Need help with VBA. Have a folder of 40 files, I want to pull the 5th sheet from each file and combine it into one tab of an existing file. Can’t seem to get my code right...any suggestions fish??

Are there any great market sizing and business case spreadsheet templates that you guys have come across? I came across this SaaS valuation template in this bowl which was super helpful, but nothing for sizing or business casing. Appreciate any help.

likehelpful

Does anyone know how to reformat a date from yyyy-mm-day to month-day—yyyy?

like

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

like

Dear auditors, please explain how you pick samples for substantative testing.

like

I’m trying to return a subset of two sheets. There is a list of names by week on one and a list of work assignments on the other. I want to filter out anyone who hasn’t done any of the assignments, but I want to return the full time period data for any employee who has worked on any of the assignments. Any suggestions? I wouldn’t mind being able to put this in PowerBI (answer could use Dax), and I’m a below average alteryx user but is another option. Thanks all!

like

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

I wonder if there is a quick guide for excel ??

like

I have a table in sheet1. Column examples are ID, Initiative, Owner, etc. I’d like to use that table as a growing list of inputs. I’d like for sheet2 to be used by another team for other types of data inputs. But I need sheet2 to automatically populate the IDs from sheet1 as they change. Thoughts?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like
like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

So xlookup? How is it going for you? Still haven’t use it.

like

What’s the keyboard short cut to switch between open apps without using the mousing. It’s something like using alt tab or whatever the combination is