What is the worst feature of Excel?

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

Excel needs way better data visualization capabilities. I hate having to switch to python for relatively simple charts that just aren't possible in Excel. Love it to death but catch up!

like

Agree.
But excel is more like a multitask app, so it can’t be good at everything.

It attempting to “help” by converting things to date. I’ll import things like “3.1.3” and “3.14.1” and it decides I mean January 3rd 2003 and 3.14.1. Then you can’t convert back because it will convert the date to a datetime string

like

Not having a function to tell when a cell was last modified and by who without vba or scrolling through the version history.

I'll open up worksheets and I know someone has fucked up something up, just tell me who did it.

like

The default being light mode, so opening a new sheet later in the day or at night means that I get flash-banged by my screen. Dark mode Excel is superior by all metrics imo

like

When you can’t open two files with the same name. Makes me so mad lol

like

Going to boring training to learn more about it

You can learn by yourself what you really need.
And this cannot be boring: you will automate most of your work and do something more interesting.

How?
First of, use excel help.
Then use chatGPT for simple questions about formulas, etc …
Then look at some tutos (there are good ones on YouTube)
Then get something more structured with Coursera, linkedin courses, …
That will cover the basics in a useful way

like

New window not using same grid line and freeze settings

I wish it could handle bigger datasets

Related Posts

What are some of the more common exit jobs that audit managers take?

like

Anybody else struggling with the fact that nearly all their friends are coupled up?
Not in an envious way. Just... Damn, this sh*t can leave you very alone.

like

Hello all,
Looking for a consultant position in healthcare consulting. I have an MBA with 5 years in the healthcare industry, 7+ years of strategic program/project management and I’m am lean six sigma green belt certified. Know of any companies currently hiring? (I am willing to travel. )

Feel free to PM me to further discuss.

like

Hello fishes,
I am currently working as project manager / scrum master in one of leading Indian MNC. Can someone please refer me in your company. Would share the profile in case you can. Please let me know the company name as well.

like

Anyone travelled internationally and returned in Advance Parole recently? I need my h1b visa stamped but due to delays in india I am not getting an earlier date for Dropbox. Due to family reasons, I need to travel now and traveling on AP is the only option. Wanted to check if anyone here any advice on my situation?

like

I am looking for ideas on how to teach spelling in the classroom.

like

Hello all, just joined. I use a lot of ed tech in my classroom and would love to connect and exchange ideas with others.

like

1st year SPED teacher here, If you had $700 to spend on your classroom what would you get?? I don't know what I am missing out on. :)

like

Can anyone refer me to Deloitte usi for tax consultant or Audit please 😊

like
like

I started a few new business ( with debt) this year, and because the way my taxes looked with other losses it looks like I didn't make a ton of money. Now my credit dropped from 800 to 720 and I'm having trouble getting credit. Despite having a perfect payment history and fully able to cover all liabilities. Any way to get the credit up. If I pay off my liabilities then my credit history gets shot with young accounts. What's the best way to handle this?

like

I feel like I can’t redeem my career. I’ve been out of paying work since I graduated. My bar was delayed due to a medical problem and since then I’ve only been able to find volunteering. I’ve been working for free for 2 years now. My network is tapped, my mentors are confused why I can’t find anything, my law school’s career services actually gave up on me, I don’t have the money to move to a new place, I have no other support and I can’t even go back to retail because nobody’s hiring out here.

like

I am tagged to resources pool in Coforge from last 2 months i.e. I am in bench.
Any idea what's the notice period on bench?

I am looking to get into consulting firms in the Netherlands preferably in M&A space.
Does anyone have a recommendation for a recruiter or recruitment firm who could help me?
I have close to 3 years of experience in Financial due diligence and valuation. I am also a newly qualified ACCA accountant.
Open to share more details

like

Which is best to join between PWC AC Bangalore with permanent wfh and NTT Data business solutions with hybrid work. Salary is almost same : NTT data - 24 LPA fixed and no variable. Where as PWC 21 LPA fixed with upto 20% variable. YOE is 7 years in SAP SD functional consultant.

Boyfriend and I have been dating for ~1.5 years and we still only spend weekends together. I want to move in together at the 2 year mark but bf thinks it’s too soon... just feels our relationship is stagnant and not going anywhere. Any thoughts from ppl who’ve gone through similar situations?

like
like

just got a full time graphic design job. is there any reason why using the work-provided adobe creative cloud account for personal use is a bad idea? like privacy or something? i’m thinking of canceling my personal subscription and saving some money.

like

Hi male here , any one interested msg me

like

Let’s discuss “acting managers” that never get promoted because they can’t pass their CPA. Do you think at a certain point they should be pushed out?

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?

Anyone know what these badges are?

Post Photo
likefunny

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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

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

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

Would anyone be willing to teach me vlookup?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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

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

like

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

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