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

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

About 4 months as an intern? Our VP had a rule where we had to put a dollar in a jar if he saw someone with their hand on their mouse while Excel was open.

like

Alt + E + M

Should take you about six months if you take it seriously

I was writing VBA code my freshman year of college. Soooooo PA was easy

Lol just cuz you can write VBA doesn't mean public accounting is easy. That is just a dumb comparison. I know VBA code quite well and have used it on many projects. However, some client data sets are so nasty that trying to code exceptions into VBA would take longer than just manually manipulating the data. Additionally, there are times when all that is needed is 30 minutes of calculations that would be a waste of time setting up a macro. Not to mention all the other projects that are outside the realm of excel rendering VBA useless. Nice try at a humble brag, but it fell short.

like

Depends what you consider good. Nobody at PwC is actually good at Excel

Lol there are tons of offices around! Using your bias sample doesn’t give you coverage over your entire population no matter how you try to define this as a “non-stat” sample

Related Posts

Company is offering me either a macbook pro or dell xps for a non engineering role. Which laptop should I choose? I’ve only done professional work on PCs

Long story short I REALLY want to get back into soccer but have not kept up in nearly a decade how the hell do I get caught up to speed?

like

For those who switched from audit to advisory: what are some of your job responsibilities? What kind of advisory service are you in? Did you like the change from audit? What are the disadvantages?

like

How do you explain to a interviewer that you are leaving your job because your new boss doesn't treat you well/fairly?

like

Hey folks I applied for a credit card they were asking for official mailid is it legal to provide bank mailid for credit card processing?

like

What's the salary range for a 9 YOE consulting manager in the UAE?

like

I’ve been married for a while now (5+ years) but feeling completely checked out. My wife has zero conflict resolution skills and can’t control her anxiety, so we constantly bicker if I ever do anything that offends her, and she wants to spend all her time talking about the constantly changing projects she will never start. I can’t ever talk about anything that worries me because she just freaks out. We have kids and she has no ability to earn money so leaving would be impossible financially

like

Anyone know of any work from home pharmacy jobs?

like

Has anyone ever messed up at a company party because of alcohol?

like

Hi Fishes,

I have an offer of around 39 LPA + bonus and my wife is holding an offer of 32 LPA in India. Now I have received another offer from a fintech organization in Berlin, Germany who are providing me 69k Euros as base salary + 5k Euros as RSU and also an on call support of 5k Euros annually + complete relocation assistance package. My wife currently doesn't have any offer for Germany and might need to search for a job after reaching there. Is it worth? Need your suggestions please.

like

Let's have a poll on our current work setup!
It's about your current work setup and not about your preferences.

Post Photo
helpfulfunnylikeupliftingsmart

Can we leave CG a month after joining?

like

Looking for few suggestions for high risk/high return stocks at current level which have potential to double/ triple in next 3-4 years...

likefunny

I've taken all the exams twice and only passed BEC... got a 71 on REG and 66 on FAR. I really feel like giving up. What are some tips to stay motivated?

Anyone waiting for scores today?

like

Hi guys,
I was offered 16.5lpa B2 band senior software engineer
Tech stack: pyspark/SQL/Hadoop
Yoe: 4.5 years
I request you pls share your thoughts on above. Is it good or not okay or should I consider this offer?

Anyone analyze QoEs before? Need to come up with questions for due diligence call and looking for some guidance

like

Hey.. Anyone has Charles Schwab account. Let me know

likefunny

Additional Posts in Excel Genius

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

like

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?

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

My sheet has multiple cells with Notes. Whenever I reorder rows or add new columns, the notes go completely out of whack (get displaced or squeezed). Any quick fixes? Also why does this happen?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Why don't recent grads know how to use excel?

likehelpfulfunny

Any weekend or online excel course recommendations?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

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

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”

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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?

likesmart

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

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.

like

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

How useful are Macros and VBAs for tax prep?

like

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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