Related Posts
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

If you're using Excel as a database, I would question your intelligence anyway, especially because SQL Server Express is free.
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.
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
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
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?