I've felt this way for most of my career but I know when the dataset becomes too large, Excel is unfeasible. So that's where I'd draw the line. What about you?

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

If you're using Excel as a database, I would question your intelligence anyway, especially because SQL Server Express is free.

like

Excel was easier for me at first because it was the program I was most comfortable with. Excel only goes so far though and other programs make up a lot of where Excel fails. New things are hard, but the more you do them the faster you’ll get with it.

like

Excel is using the machines memory not only for storage but also calculations, so the bigger the data the slower excel and yes it becomes infeasible.
But there are other limitations of excel such as transforming data several times: you need either to use VBA or make temporary data representing steps of transformation. Note that power query can be a solution also).
Another limitation is the one développer - one user. It’s almost impossible to share and work together on a spreadsheet and it’s also hardly deployable …
I don’t mention instability, complication of certain formulas.

That said it’s a fantastic tool for design thinking, experimenting, or visualizing very fast

like

Excel is so prone to data errors - it is just not a repeatable/auditable process
Once you write your code it should the same every time
Yes you need to get it right but so much better imo

like

I’m not sure that creating pivot tables and charts qualifies as data science (the sub where this was posted)

The whole aspect of data science is large datasets. R & Python are the only ways to go, especially with modeling. You honestly can’t even model in Excel - how would you?

Related Posts

Any trial prep tips and tricks for an associate second-chairing a medical malpractice case for the first time?

like

On Amazon, a role’s title is Sr. Manager but when reading the job description it says Senior Program Manager. Does that mean the salary will be that of a Senior Program Manager (L6)?
Amazon

like

Have a start date coming up and need to give notice ASAP to make my start date. Just got a call from HR saying I passed my background check but nothing officially in writing. Do I wait or can I give notice tomorrow?

like

Hello fishes, need some help. Can anyone share how it is to work for tesco bangalore? Is it a good place to work in terms of learning, tech stack and job security? I am considering accepting a tesco offer. Here are my current options: 1. Tesco - SDE2, 50L full fixed. 2. Walmart - IN4, total around 50L(per year) -35 fixed, RSU 8L, variable 8L(4 year vest). 3. Paypal - SE3, total around 50L(per year) - 32 fixed, 3.2 variable, 34 RSU (3 year vest). Cctc - 23L, YOE - 6. Walmart ,Paypal ,Tesco

Manufactruing process improvements tips - for interview prep what all points one should say ?

like

First year review: I have to become a better legal writer/ writer in general. Writing was never a strong suit and this has to change.

Please drop book recommendations!!

Thoughts on: 1) the winning brief; 2) point made; 3) legal writing in plain English

like

I have to admit that I wasn't terribly impressed by the virtual Co-Lo for Digital. The exception to that, though, was David's insightful comment that leadership knows and expects that many of us are struggling to come back from the pandemic, and it's okay to ask for help and or take a leave. Digital culture, and how we are real and take care of each other, is just AMAZING. That speech alone made me so proud to be here and turned around a lot of my negative thoughts.

like

Hi fishes,

I'm currently into analytics domain, want to get into front desk/quant role in investment banking/markets domain. Can FRM, CFA or CQF help me land there? Since I don't have any workex related to finance, any CTC ranges I can expect?
Or full masters is the way ? Anyone on that

like

Hi, what salary can I expect for 2 year full stack developer experience at a product firm. It would be great if someone can give an insight.

like

How to get on-site opportunities in European countries along with visa sponsorship .can someone who individually applied and got on-site and moved by themselves to different country,pour your suggestions.looking for change management roles.

like

Hey guys ,
I was a fresher when i joined wipro
My manager has given me rating 1 in confirmatory appraisal on may 18 may which happened after completion of 1 year at wipro.
I raised the issue of rating with my manager immediately , he convinced me not to worry , ratings are already submitted , I asked him to resubmit cause i don't deserve rating 1
So he said he will look if that is possible but didn't changed .Now after 3 months they are pressurizing me to put a resignation,what should i do?

like

Terrifying scope of Capitol attack becoming clearer as Washington locks down for Biden's inauguration

like

Being from Minnesota, I think it's so funny when people act as if we are some far-left State just because we hadn't voted Republican in a presidential election since Nixon. Never mind that many of our elections are close or that we have elected Republican Senators and governors.

I have voted for both the GOP and the DFL, and I feel like they are both far more normal than their national counterparts

like

Hi, just wondering how the staffing situation has been in strategy consulting in general? My sibling started a job in strategy in Silicon Valley 2 months ago after MBA. She has been on the bench for 2 months and was informed that there has been a shortage of jobs (within the job) and the amount of people on the bench is getting high. She has been under a lot of stress although she had many great networking calls with people. I wanted to help but can't identify what she can improve on.

like

Anyone work for GoDaddy and would like to recommend me for an accounting or analyst role?

like

Does anyone know about what it’s like to work for Amgen as a sales consultant?

like
like

Having trouble landing a decent job, I am 4 years post bachelors, environmental science. I can not seem to land a job above minimum wage. My last position (horticultural assistant) found myself taking on a good amount of projects that were being left unfulfilled, due to coworker politics (a few co worker’s wanted to see the supervisor fall short of expectations) in addition I had difficulty with my manager( sexual harassment) I rejected their advances, and I was laid off in December

likesmart

Is anyone concerned the push for sexual equality in pay without accordant leveling of parental leave is gonna backfire?

Here’s a hypothetical:

A company has 2 candidates, aged 25-30, equal in every respect save one’s a man the other’s a woman. Maybe the woman is a slightly better candidate overall. They’d have equal comp.

Company considers the woman a riskier bet due to possibility she’ll take maternity leave — and considers the man less risky for his ineligibility to take as much leave. 🤷

likefunny

Is taking the bus to work as convenient as taking the tube? Thinking of getting a place that by bus has a lesser commute than train but worried about traffic, frequency, etc. of the bus. Basically 20 mins bus vs 27 mins tube? Thanks!

like

Additional Posts in Excel Genius

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

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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!

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

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

Post Photo
likehelpful

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

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

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

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

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

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

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

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

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

likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

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

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
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