Anyone else feeling like their excel skills are becoming irrelevant? Seems like powerBI, power automate and the likes are taking over and I’m having a difficult time keeping up

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

I think the main advantage of having "excel skills" is not the overall formulas you know, but the logic skill/ability to Breakdown a problem. It's the same as engineering (for me) - I don't use it, but I benefit from the problem-solving/busting-my-ass skills acquired

Knowing that =SUMIFS() sum a group of cells based on a given criteria is kinda worthless - but knowing how to structure the analysis, that is worth something. You can translate that go "knowing what questions to ask about" in the AI context, although personally, I think people are overestimating its impact in the short-run

Personally, I think excel will stay here for a while, so the "hard skills" of knowing excel will have some use/value - but it is up to you to decide how much you need to know/can benefit from knowing

likesmart

Some companies are still using AS400 from 40 years ago. It will be fine. Excel is not going anywhere lol

like

Is that Lotus 🪷?

We use excel for complex modeling every day. It’s still my teams go to choice for taking output from systems and translating into business metrics and costs/savings.

like

Being good with Excel has pretty much been demoted to super quick data analysis over like 30 minutes and just being able to get a hand on data.

But as far as building large models and visualizations I agree it's basically become a legacy skillset

like

Legacy skill set 👍🏼

like

Yes, constant changes… definitely learn AI as well!

like

@CH Robinson
Right? I'm currently job hunting now and I would love to take the time to get more exposure to AI and other analytics tools, but not sure where to go for them

AI will take over this skillet. Humans will just have to tell AI what we want to see.

likehelpful

Excel is a generic tool, hence very versatile.

Of course, if you compare its data visualization capabilities to a * specialized* software for that such as PowerBI ... Excel isn't good enough by construction.

But Excel enables much more than dashboarding:
- implement calculations for their result (accounting) or for performing what-ifs (risk scenarios)
- (few steps) analysis of (small) datasets
- run parametric and non-parametric statistics
- experiment models of any kind: in portfolio management, business, ...
- Find complex function optimal (with the solver)
- etc ...

Excel has a very flat learning curve which makes it the tool of choice for all non-tech people to think about an issue with numbers ...
This won't be replaced any time soon

like

The beauty of EXCEL is it runs the world. I have not meet a client that blocked the use of EXCEL, but many clients have other BI tools and other automation tools. While I can make a more appealing solution using PowerBi I still find myself using excel knowing that I can leverage that solution on any other client as well.

like

Nope. Was running circles around ais the other day using just excel. Software/hardware always breaks. I never quit.

like

My excel skills have helped me get a better grasp on the full power platform; my honest belief is excel will soon be used to train children in programming things. It will be a fundamental and common skill but not a “valuable” one.

You’d be surprised how many companies are using excel assessments to screen potential candidates, at least in my field of finance.

Excel will definitely be around for a while, but it is good practice to broaden your skills. It’s just the nature of the world. Technology is evolving more rapidly than ever and we constantly have to reassess how are skills are applicable today and how they may or may not be applicable tomorrow.

Related Posts

Any needs a great cfa tutor dm me.

like

Partner: Can you get this turned around by 10p?

Me, hands on my ankles: Yes! No problem! ☺️

Post Photo
likefunny

Let’s be honest, what % of the entering class from consulting to m7 schools do we think used an admissions consultant? I think it’s upwards of 40%

like

Hello Fishes,
I got an opportunity from NTT Data BPO.
I am currently being hired for nightshift. Are there any chances for getting day shift or mid shift?
Or are there any chances to get a change in shift after getting on boarded?
Will it be okay to discuss this with HR?
Because during interview I said yes to Night Shifts.

Which one would you prefer b/w local lender v/s establish financial institution when buying a home?
What are the pros and cons of each?

like

Anyone looking for an AAE or Asst Media Planner? Have a friend w a Cornell degree looking to change careers and join our crazy industry

Has anyone been successful negotiating a “breach notification costs” provision in contracts with vendors? What are some good args to include it? I feel like vendors generally flat out say “no”, but I have seen some contracts where vendors were willing to include it and I’m wondering how that happened 😁

like

What is your preferred HRIS Platform and why? Here are the options:

-Workday
-Oracle
-SAP
-ADP
-Ultimate
-Ceridian
-Other (if other, please name the system)

like

Exec consisting Slalom for more creative work and more diverse and inclusive culture. Any insight into partner and above admissions/roles/past experiences. Based east coast but not looking for local

Hey everyone, Withum is still hiring entry-level staff accountants (audit and tax) with the start date of November 2023, experienced associates, senior associates, and more!
The firm is currently number 22 in the nation based on INSIDE Public Accounting. AMAZING culture, good wlb, and really nice people (at least in the nyc office). Please message me directly if you’re interested!

likefunny

Does anyone know what busy season is like at SAX LLP? The role is permanently remote except when needed to go to clients. That seems very broad to me, will I have to commute to clients often?

like

Hi all, I’m trying to transition to the insurance industry and begin as a claim adjuster. I have a virtual interview for progressive and a phone call interview with AAA coming up soon. Do you have any tips for me?

like
like

Why People Are Quitting Their Jobs

Post Photo
like

Any moms on here that absolutely love their company and feel 100% supported?

like

New joiner. What should I get with my $250 wfh stipend? I already have standing desk, dual monitor, portable monitor, and good headset, not too sure what else I need, but it’s free money. Thanks.

like

Additional Posts in Excel Genius

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

like

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

like

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

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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

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

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?

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

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

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

Post Photo
likehelpful

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

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?

likehelpful

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

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

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