Are there certain functions and tools that most companies want you to be an expert at?

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

Lookups, sum/sumifs, concat, embedding multiple functions, count, average, subtotal, Len, left, right, mid, substitute,if/ifs, And are some that come to mind. But it depends on the expectations of the role.

like

Knowing the difference between similar functions and when they should be used would be considered “expertise.” For example, despite performing similar tasks, there are differences between VLOOKUP and INDEX/MATCH in terms of speed and specificity. Understanding the limitations of nested IF statements would be considered “expertise” as another example.

like

Converting data into pivot tables and visualizations is probably at the top of the list. Short of that, knowing how and when to apply functions to appropriately aggregate information.

Simplifying complex / unorganized data into valuable insights

Related Posts

Tomorrow is my first day at my new job after being layoff... I enjoyed seen this post with stats so here is mine:)

2 months (pluss 2 weeks after accepting a offer, just waiting for paperwork etc)

273 application

10-20 recruiting condos (some pass on me, some I passed on because they were not fully remote, salary or long hiring process)

3 companies I when thrue the whole interviewing process

From the 3, 1 company just declined no feedback the other 2 send offer letters

170k base, tech.

likeuplifting

Beside toastmasters, what are other ways to improve communication and public speaking skills? Books, podcasts...?

like

Best consulting firms to work for that will allow 100% remote work indefinitely regardless of what clients do?

like

Did anyone hate wedding planning? I’m constantly considering cancelling the wedding cuz I honestly can’t believe how much drama it’s causing with all family members.......

like

I drunk texted. It was bad. I wasn’t an asshole, I just said my feelings because I was frustrated about them being avoided. And then I got hardcore ghosted, which is expected but still harsh. Do as I say, not as I do. 💔

like

What is the number one tactic/strategy/channel to test in 2020

What types of non-profit organizations do you think could use SCM skills? All I can really think of is food banks.

like

How to get into Human Resources with a Master Degree in Psychological Organization Leadership

like

If i am a fresher in cognizant and worked for 2 months and have got better opportunity can I abscond from same as the other company is asking to join immediately

like

Is April (easter time) a good time to visit Norway? If yes, what are some of the places you would recommend? I’m looking for hikes/ national parks experience and don’t want to spend much time in city.

For those interviewing in Bay Area/NYC- has there been any general skills that have been coming up during interviews which companies have especially been seeking?

like

I have an interview for an AR Specialist position wish me luck Fishbowl Family!!! And any pointers would be accepted.

like

Thoughts on buying into Wells Fargo now, at their 52 week low basically.. Bank too big to fail of course and their imposed caps on grown expire in a year or 2 I believe with regards to how much $$$ they can lend out or take in...

like

Thoughts on XT?

like

Is there an app/software to consolidate and track your investments across different asset classes? (ETFs, stocks, bonds, crypto)

like

Which 529 account every one using and how do you like it. Invested in any specific funds or index funds? For me, no state tax, so looking for any good fund that doesn’t have state residency requirements

like

I have a coworker who keeps spouting comparative odds and situations in regards to the safety of the vaccine. Such as: you're twice as likely to get hit by lightening than have blod clots from JJ. It's very annoying and I find it to be really inapprorpriate, maybe because it's pushy or just I find these comparative things to be a bit irrelevant. How does one handle something like that? Can you shut the person down without starting a spat?

like

What is the most effective way to handle reputation management online? I've been hired by a company that doesn't have the best track record but they are rebranding themselves in a big way

like

I got into marketing because I thought it would be an opportunity to make good money in a field where I could still exercise my creativity, but I’ve found it to be extremely stifling and bogged down by bureaucracy. Does it ever get better?

like

Additional Posts in Excel Genius

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?

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

Would anyone be willing to teach me vlookup?

like

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

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

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

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

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

like

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

like

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

like

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

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

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

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

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

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?

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