Why Data Analysts Hate Using Excel

This week I say what everyone is thinking...
To be clear, I still think Excel is actually really good for a lot of things, but the more I use it the more limitations and thing I find wrong with it. Absolutely necessary to learn!
Shoutout to Nvidia for sponsoring this video!
Try cuDF Library here: nvda.ws/3rTXguZ
Rapids Website: rapids.ai/
AI and Data Science Virtual Summit: nvda.ws/3ROGYOL
____________________________________________
RESOURCES:
Analyst Builder - www.analystbuilder.com/
Take my Full MySQL Course Here: bit.ly/3tqOipr
Take my Full Python Course Here: bit.ly/48O581R
Practice Technical Interview Questions: bit.ly/46pDqqL
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
0:38 Reason #1
1:37 Reason #2
2:46 Sponsorship Shoutout
3:35 Reason #3
4:30 Reason #4
5:13 Reason #5
5:56 Outro
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@pon00050]

1. Cannot handle large data 2. Cannot do version control 3. Does not allow for collaborative work 4. The limit to which can be automated 5. Basic visualizations

[@exhaustive_the_sixth]

6. Tableau and PowerBI do better work with visualizations than Excel does

[@stevehenry9826]

I'm just learning Excel and I've been getting into all the different things it can do. Now I am interested in becoming a data analysts, and from what other data analysts have said from other videos I have seen, say Excel is a good place to start for a foundation and then move on from there like learning Sql and other data base languages. Saw one of your videos on Sql. Very interesting!

[@parkermonroe6599]

Size limits - I agree with for the most part but you can connect to your data with power query and load it to your data model to get around the limitation here most the of the time. Version control - you can set up power automate with an automated cloud flow to save a copy of the file in another location at various time intervals and grab the current date when the flow runs. Collaborating with people - this one I haven't really understood with nearly all of my files being stored either in OneDrive or SharePoint they are cloud files that multiple people can work in at the same time. Only issue I've had with it is some things like pivot tables or power pivot don't like to have auto save enabled but those are typically only features I am using in a file for just me. Automation - this one is fair. VBA is great and all but definitely not perfect and the random code I've received is really hard to understand what it's doing. I am excited that the Automate tab is in desktop version though because if you can write some typescript or record macros there you can also use power automate to run your macros in the cloud without the workbook being open.

[@chasbjoes]

Collaborating with other people has been fixed if you use Microsoft Teams. You can upload an Excel spreadsheet that you need to collaborate on and multiple people can update it in real time. It also gives each person a tag so that you can see what they are manipulating and as soon as they are done in the cell, it updates on your side immediately. We use it all the time at work when we are working on a project the whole team needs to have a say in. It's so much easier than emailing back and forth or one person trying to make the changes everyone is suggesting in the "room" as we're discussing it. As far as a backup - If I have downloaded the raw data, I copy it to the folder I will be working in, leaving the original in the downloads folder. I rarely forget to save the raw data that way.

[@Myer5Hertz]

If you upload to Teams, the file is also saved on Sharepoint. Sharepoint saves a version everytime you save the file to the version in is excellent and roll backs are incredibly simple.

[@jahanas22]

Those are all good points. I haven’t had the version problem luckily. Most people I know love it because they don’t do anything highly complicated.

[@giftoffaeries]

to your second point about the lack of version control, if you add a data connection to all the data tables in your excel file and do the data transformations in power query, you actually have pretty good version control in the power query module inside of excel.

[@slyobinna9885]

Hi Alex please I just came across your videos not long ago and I love it, thank you so much for doing this, I’m new to this career, just about starting. Please do you have an introduction to Excel? Cos I just saw Conditional formatting, Charts, Cleaning data and full project in Excel in your channel

[@dixonstroi]

I still love Excel, but since acquiring more tools my baseline is to do as much outside of Excel (using SQL, Python, Jupiter, cloud tools etc) as possible. I get the notion that Excel is not designed for those heavy duty ETL and aggregation tasks and it's geared towards the end of the analysis process; for working mostly presentation ready tabular data into tables, PivotTables, charts, etc. for quick consumption. It really struggles when you need to do anything relational of any significant size. Also it always bugs out at the least opportune time. Holla if you've had to re-enable PowerPivot multiple times in one day before.

[@abnersangalang3849]

thank you for your thoughts in this matter, can you make a followup video on as to how you would do the workaround on the nuances that you stated here using other programs or software? it would be very helpful, thanks

[@rickswineberg]

You are absolutely correct. Excel's small learning curve makes it a favorite, but by no means is Excel a one size fits all tool. I have seen billion-dollar companies being run on Excel, and the accounting dept drowning in spreadsheets, crazy.

[@andrews9719]

I started my data analysis journey learning R. I never used excel in the degree I am in now. I did the google data analysis cert, and used sheets and excel (both I was excited to learn due to most jobs saying they want you to know it). However, I just went back to using R for almost everything because it’s just so much better.

[@emmanuelakinlawon7054]

😊😊😊😊😊😊😊😊

[@alanr745]

Excel is certainly the model of a love-hate relationship. It's super useful for very basic reporting or making PivotTable, but the minute you start using Power Query or importing data, the loading/refresh times can get out of hand, and then people who want "that report" do not understand how to use it. Seems like there should be a merger between PBI and Excel that brings the best of both together for those reports that require drill down and some visualizations when specifying certain metrics or criteria need to be specified. I deal with operations and logistics, so maybe my use cases are unique, but those are my gripes. LOL

[@ferithedataguy]

As we say in England, horses for courses. Excel is great for some tasks, not so great for others. I've been working with companies ranging from 5 employees right up to 30,000 employees. The only thing common between them was that every single person had access to Excel. It's everywhere, and that alone makes it invaluable. If you only work in a tech/data department, great! Use python, Sql, wahtever you want and whatever is available. As soon as you have to work with "non-data" people, you're screwed. Chances are, they are still going to be somewhat familiar with Excel. If they need more than a simple dashboard, that's the way to go.

[@sandydsa]

My son feels the same. He handles gigabytes of data in his job in telecoms and he gets super stressed with its data limitations. While he can do queries from Redshift clients still want excel.

[@Jules-69lol]

I love Excel so much, I was stunned by how versatile it is when I was learning it at first. Haven't used it for a while though, I just use SQL and Python more

[@cradleofrelaxation6473]

Python-pandas I guess. I know Python-pandas can do many powerful stuff which excel can’t. But when it comes to quick analysis and visualization, I find excel to be easier. Partly because I am from excel background. SQL and Python have no real dashboards unless you take the data to power BI or Google data studio

[@Jules-69lol]

@@cradleofrelaxation6473 I agree. I'm currently doing a python project and I want to kill myself. I'm a PBI/SQL enjoyer mainly (aside from excel but that's a given) and it's been really difficult to make even the most basic visualizations work The visualization is the hardest part

[@Hitchon]

Hey Alex! I definitely don’t hate excel, I understand your points but I disagree. (1) large data size, yes this is a fair point above 1 million rows + it becomes pretty unusable. There are potential workarounds though with tools like powerquery but yes I agree at this point it makes sense to use a different tool or excel combined with some other tools like Python dataframes. (2) Version control so this is part of google sheets. For excel files if saved in share point or onedrive you can do that. (3) again collaboration is possible if you use excel online with share point or onedrive (4) VBA I agree their are limitations but it still is a powerful tool I have made UI, games, Monte Carlo simulations, and many powerful automations with VBA. (5) I think excels data visualization is great for what is needed. What you mentioned is basically a big part of why power bi exists. Anyway imo excel is amazing people should get better at Excel and it should be part of any data analysts skillset. Like anything it’s a tool that works best combined with Python, power query, SQL, and powerbi knowledge.

[@pedrocastro2789]

100% agree

[@themolestones]

Completely agree

[@themolestones]

Also, now Excel supports Phyton

[@Info-God]

100% agree

[@Shadowoftheoldones]

I get fairly large data pulls at my work, and for some reason (security?) they will only write them in encrypted xlsx files that end up being several GB in size. This leads to my question - do you do much with xlwings for Python? I've used this library to write macros and extract data from excel, and I very much prefer it to VBA.

[@mattmatt245]

Ever heard of excel add-ins like power pivot and power query ? Use those if you need to work with big data also if you need more visualizations you now have python in excel.

[@ar8abdul]

Sql is better than excel when working with more data

[@Ultrajamz]

Sadly the issue is too many people still don’t know SQL well. I guess it keeps us well employed though.

[@fareed_adam]

Why does Microsoft Excel be compared to SQL other than Microsoft Access?

[@Info-God]

​@@fareed_adam If you know how to use arrays, find, dictionaries you are really fast in VBA-Excel. However you can run SQL in VBA-Excel.

[@fredericnicholson80]

A couple of the downfalls you describe are due to the fact that Microsoft wants you to use their infrastructure. for example: online collaboration is possible via Sharepoint. This gives you a (very simple) version control as well. Automation should become better with the intruction of Python.

[@johnwong2595]

Excel with sharepoint seems to work for version control and real-time usage.

[@Chrisbit1]

For Junior data Analyst, which would be better to use Excel or Google Sheets ?

[@bms4654]

Thank you for saying it. No more cleaning spreadsheets and connecting vlookup....I also roll my eyes when I click a cell and it's a page and a half of logic functions. I hate SharePoint and SharePoint List more than Excel.

[@EuanM20X]

thats really interesting you struggled with the processes you can complete to automate with VBA, i was tasked to do a lot of VBA automation in my first role and the only time i ran into issues was when external/internal data changed formatting etc

[@sr-xd8jb]

I usually slice the datasets into multiple csv files and then load them to Excel.

[@luisprieto6391]

I used Excel when is already filtered in Sql and used tableau or power bi for visualization

[@ebamybass19]

Alex can you help give us tutorials on Azure Data Studio

[@SamiullahEhsan997]

You are right. Excel is no less than an anxiety and stress in such contexts. In your opinion what is the alternative if we are dealing with big data sets and that we need to avoid the stress and frustration from excel in such scenarios(the reasons you have mentioned in the video), should we use Python or any other tool?

[@chasbjoes]

I jump over to Microsoft Access and SQL for larger data sets (both are based in SQL but Access allows you to build your queries and also your dashboard all in the same program, but it does take some learning). I'm not skilled with Power Query yet but I know you can play with larger data sets that way in Excel. I've worked with Access for over 20 years, so I've learned how to create queries that pull from the SQL database the raw data is in, clean the data (based on reoccurring bad data habits) and put it in the tables then build a really nice dashboard that the customers could check daily. I've even built ones that created and publish my slide decks and/or update Excel spreadsheets.

[@SamiullahEhsan997]

@@chasbjoes Thank you for the detailed answer, and it did help me. Since your experience and working in Microsoft Access, can you recommend any resource that can help with learning Microsoft Access, any KZbin channel or playlist?

[@malcorub]

Excel hell is still alive and well.

[@CJ-fh5xq]

I work at a major Bank where I am the sole DA for a non technical team. Our monthly transaction details contains almost 1 million lines of data. Doing any filtering, pivot, or lookups will crash the damn thing. Now imagine doing it for a 12-24 month ask.

[@djnaadowanyakumulator3526]

Reason #3 - it does allow for collaborative work if you save it on a Teams channel. Works relatively OK

[@risingradiance9142]

UNRELATED QUESTION... but still within the boundaries of Data Analyst. Would the HP PAVILION PLUS LAPTOP 14Z-EY000,14" good as a Data Analyst laptop? If purchased with the maximum Operating System, Processor, graphic and memory, Display, and Storage (1 TB)? From HP's website. It's pretty impressive and budget friendly (Well budget for me).

[@stefantodorovikj6165]

Excel is still the best tool to quick check something , or to write a complex query download the data and send a Pivot as a quick and dirty solution to ad-hoc request. No matter how big the company is or tools it uses there will always be 1 board member or colleague that will ask you "can i get it in xlxl format please ". So yes it does have a limitation however this tool wont be going anywhere and what i would even suggest is learn excel to be at least intermediate user your life as a Data Analyst or w.e Data position you will have will be easier.

[@Mister_Garibaldi]

I hate what Excel does to data files. So many times someone sends me a data file to load into a database and leading zeroes are dropped from zip codes, columns are misaligned, or other odd issues...this happens especially when people open a csv directly into Excel, save it, then pass it along to be loaded into a database.

[@datastop400]

Must always transform data from a database to excel or csv, and back again. Been working with R(though some might prefer Python), and it does this very well. And there is also Power Query, though I find R much less verbose. Of course there is a learning curve with all these options.

[@markleonard4635]

Most of the excel standards you are referring to sound really dated, for most small to mid-size companies they would still be fine utilizing power query and Excel's data model features, subsequently there is also a built-in tool to excel to compare two separate versions of a file to audit any changes that have been made, but it also supports coauthoring now. They even support python now. While i agree excel is used as a band aid to other tools and services it's nowhere near as insufficient as you are making it out to be.

[@dennislam1501]

Any comments on PowerBI software? Does Data Analysts love them?

[@slyobinna9885]

Found it already 😁 thank youuu

[@keylanoslokj1806]

What if you open this excel file with pandas in Jupiter notebook?

[@kanchanachristopher5465]

Alex kindly make a video on how sql is benefited for HR's, it will be big help.

[@eimienwanlanibhagui4859]

When Indid not know about the existenxe of other tools, I did an analysis on Excel with a fine temporal resolution data (15 mins) and the data is for 5 years. Excel crashed severally! It boggles my mind that Microsoft is interoperating with Python, yet this limitation of Excel has not been improved upon. Is it a policy thing or what? Anyway, are putting this on LinkedIn, @Alex? I would love to see David Langet's reaction to this video. In any event, enpirically, Excel is still valued in the Data Industry. I am even going to use it now, including its data visualization 😁. Thanks for sharing your thoughts.

[@user-cy1eo9jh3v]

However, most companies are still looking for Excel skills for data analytics.

[@kanchanachristopher5465]

Hey alex let me know how sql benefits HR Mng.

[@mohamedmushaima1641]

While I agree with your statements on general, i still love excel as it was the start of my passion with data😊. Excel will do all the jobs when your data is relatively small AND your using power query and data models. (Less than 1 million rows easily and up to 2 millions with some difficulty). If your data is more use other solutions The other point is that all business world are still depending on it, so it's basic skill that you need

[@LizGamerGirl]

I do like the ease of use with excel.. with small data sets!

[@Info-God]

Like hundreds of thousands?

[@preetshah3793]

Hello sir make a video on realtime change in data automatically change in dashboard

[@MegaTimPim]

Ppl who really know excel well have wonderful solutions for all of your problems. Except for large data exceeding the Power Query capacity.

[@AlexTheAnalyst]

I've also found solutions to a lot of these... but that's the thing. I have to go out of my way to find workarounds.

[@marcink6879]

I love it when it just randomly crashes and closes a few xlsx files at once without any notice. Well, not that randomly, as it happens under heavy use.

[@nadiasharnelle]

IKR! So much fun when it happens right at EOD which is also your deadline 😃

[@Info-God]

I can extract 2.5k records out of 1 million records in 2.5 seconds using VBA. Just wonder if is slow. Also extract hundreds of files' names, build an array from tens of thousands based on multiple key words searches in fractions of a second. Is this slow?

[@chahineatallah2636]

Hi Alex cool video, but for collaboration u can upload ur files to one drive and share file with others

[@afrominded]

I just feel like things go so much quicker with SQL or Python. With Excel, I feel like I have so many small steps that I have to get in order to get things done. However, on the flip side, I LOVE the visual aspect of Excel.

[@MogsterKupo]

"Death to spreadsheets" was part of my work email signature at some point. I got told off a bit, so in retaliation I upgraded it to "Death to Excel". 😝 (Fortunately, I get away with a lot of stuff)

[@fardinahmed612]

Hello Alex. Can you make a video on entry level remote data analyst jobs? It would help a lot

[@jumpropemonk7703]

I still consider Power Query in excel one of the best ETL tools for data transformation

[@paulstork2866]

In all fairness to Excel: it was never designed for this level of data or type of activity. If you could start from scratch, how would you redesign it? Here's what I'd do: 1. Integrate local python / R usage as well as allowing it to execute the code remotely in the cloud. 2. Version control. 3. Online colab instead of purely local (Google Sheets) 4. Better visualization builder. 5. Better handling of Big Data (all hail the Big Data) 6. Kill VBA. Just let it die. 7. Better automation.

[@markleonard4635]

Almost all these things have already been addressed this video is kind of misleading viewers based off someone that due to using other tools has not kept up to date with all the newest features of excel.

[@SetYourBarTo10]

I find myself making a sheet called raw data, with all of the cleaning and wrangling being done with a copy of the data in a different sheet.

[@dakshbhatnagar]

Now that I have been using Google Sheets as a data analyst I think I don’t want to go back to excel ever again

[@izmi2938]

Wait, is excel cannot shared data real time? Because I did use it before..

[@moxie1189]

Didn’t even mention Python in Excel, especially around improving data viz capabilities. In terms of automation, whilst you can’t access your local machine currently , I’m sure it won’t be long before Python in Excel allows for this.

[@bgyw]

This is interesting. I'm starting in data analytics and I've had this idea that I should use Excel since it's an industry standard. I used it back in the days (when Google Sheets didn't exist) but eventually switched over Google Sheets because it's free, the interface is much nicer and has plenty to offer for analytics. Trying out Excel now feels like a step back, especially in terms of UI. Maybe you should do a head to head Google Sheets vs Excel video.

[@gusboy20]

I would say if you're a long time excel user who can be very efficient with keyboard shortcuts, Google sheets is extremely frustrating for simple things like inserting a row. Now, I'm not a data analyst, I do a lot of financial modelling and for that purpose, obviously, excel is king. I would just say that from what I hear from friends in tech, it's not about the tool, it's about the task. Why create an algorithm in python or a database in SQL to give some simple numbers to the Board? I think common sense is key, and knowing when to use which is the way to go. Just my 2 cents...

[@markleonard4635]

Where for enterprise is google free? Every actual business I know of pays for their licenses to use the G-suite and the finance departments hate working with it. If you want a free option libre office exists.

[@jeroenvdb1782]

"It's not about the tool, it's about the task."@@gusboy20 - Great spoken, I totaly agree. Today, lots of possible routes/tools exists, multiple ways to come from source data to your distination. And tools are continously evolving. Up to your expert insight which one is the most suitable for the specific case.

[@warrenanderson412]

Ummm...I guess you never heard of Excel Online, Power Automate, Power Query, Power Bi, and Macros,huh?

[@NDE-SDJ]

Your points have merit, but as a Excel/Microsoft fan boy I have to disagree! But that is just me. 😁😁

[@swatmy3]

In comparison, I will be more prefer Google Sheet. first of all it is cloud-based, i do not need to worry about forget to save problem. and the formula i feel that could more functionable than excel. for example =UNIQUE()

[@serddel2168]

Whatever analysis I do my colleagues ask me eventually to send an Excel file.

[@darijozivkovic7931]

You're making this with Excel on personal level. XD

[@diegoariel707]

My love for excel is broken now XD, hope you give us better alternatives to excel in other video

[@Fritz131415]

Why is everyone talking about automation in terms of VBA and not in Power Query/Power Pivot? As far as I know Microsoft themselves stopped supporting VBA. And yeah, I agree about Data Viz part but in terms of data transformations you can literally do the same stuff you can in Pandas. Also, you are saying that Excel freezes with big amounts of data - well, because you are cooking it wrong. Load it into data model and use Power Pivot to display the aggregations you want. You don't view the whole dataframe in Python, do you? :) What will happen with Python if you decide to view the whole dataframe of, let's say, 1M rows and 20-30 columns by removing the limitation of dataframe display? It will either crash your Jupyter notebook or take forever to load. I mean, I don't use Excel much but it can handle a lot more if you know how to use it and sometimes be a faster/more convenient solution than one in Python/R.

[@millertime6]

They’re trying to solve some of this with the python for excel functionality. Add in power query and you might have something cool to work with. If your arm is twisted of course 😩🤣

[@SAKE42able]

I love excel it's straight forward app

[@sergioramos3437]

Maybe it's just a problem I've had but I cannot seem to get excel to do a simple count distinct in a pivot table either 😂

[@topdawg312]

You have to add your data to the Data Model before creating the pivot table (there's a little check box to check when you the pivot table dialogue box pops up where you can select which sheet to create the pivot table on). After you do that, distinct count will become an option)

[@dianadennis7225]

hahahaha, Filters! the first thing that popped into my mind

[@mugomuiruri2313]

sure I use sql in R where initially i used excel

[@mattb8135]

While I agree with your comments on large data handling and visualizations, as someone who has used excel for over 15 years, and attribute my strength in it as the primary contributing factor to the progression in my career, I strongly disagree with your statement and sentiment of "the people who really love Excel are the people who are just getting started in Excel." I still love Excel, and would highly advise anyone getting into data analysis, that you have to learn it. You also have to learn how to summarize data in SQL and other tools first, so you don't have every row in Excel filled in...the tool was not designed to be used this way, no matter how many rows/columns Microsoft put in it. Don't hate it, learn it, and learn it well. You WILL stand out, in a good way, if you do.

[@KopfKino901]

I also hate Excel, but reason 3 and 4 are wrong. There is a collaborative side to it with the subscription, and it now supports Python.

[@iscrewyouall]

I love excel, but for accounting and not with data analysis

[@et.sachin]

Wha about Python in Excel

[@AlexTheAnalyst]

Naaaaah

[@agbontaeneseosa6538]

My supervisor asked me a few minutes ago why I do most of analysis in SQL and I was wondering: “Isn’t it obvious? It’s smoother, faster and less likely to make mistakes”. Then I come on KZbin and I see this video. I’m not alone

[@malcorub]

How do you share your work though? Is the entire company using SQL Server?

[@agbontaeneseosa6538]

@@malcorub Unfortunately, I always export to excel and share.

[@keacoq]

If you are analysing large quantities of data you need a tool that can work with the data in an organised way. MS Access springs to mind, Excel is a problem in that the formulas are too easily changed, one by one. It is hard to check that your spreadsheet works as you intend. With a database you use sql to manipulate data as far as possible. Excel to deal simply with relatively small amounts of data and present it

[@lorensims4846]

Get a Mac. Version control is built right into the OS.

[@tujestem77]

I'm waiting for excel with python - first thing I will install pandas and polars 🥳

[@carlosace3]

That pun was intended

[@scotttheniceguy]

I am forced to use Excel daily because clients don't know how to use other data tools nor can I use OneDrive due to sensitive information.

[@steveduignan7002]

Data analyst here. I feel you are unfair regarding automation. I feel that there are libraries and tools to help you automate with excel. I have found I can automate pretty much everything I need to do with excel VBA. Although it is often easier with python/pandas

[@rudiantoxu2497]

wps better, sometimes we get data from sql and clean it through wps

[@jeroenvdb1782]

Interesting, dindt knew it. Altough, Google search gives this about WPS: "Why was WPS removed? was it removed in Android pie? and why? It was removed for security reasons. WPS has some serious security bugs."

[@ryan_454]

"Data limitation and performance issues" -- hear, hear!

[@Wreckedballs]

I passionately dislike Excel, it is a tool that is often used as a one size fits all solution. It is so engraved into modern business processes that it is only replaced when the tool begins to cost money due to its poor underlying function. Previously working in admin for a large finance company had the culture of 'edit spreadsheet and pass it on, go to this spreadsheet enter values.. I really did refuse to build on Excel and it allowed me to focus on using more appropriate tools and advance I better tools.

[@enigmauniwar9166]

3D stacked pie chart 😂😂 Edit: wait, tell me those don't exist please

[@KwekuBrainy]

I really bust out laughing 😆. I can relate a lot to the first reason 🤣 the excel will take hours to open and will just crash. Power Bi my new lover 😍

[@YashSinghal]

Why doesn't everyone just use Google sheets?

[@chibuikeomenukor7054]

Therapeutic indeed...😂

[@wasiullah7224]

Hy sir i need some help do you have any of your academy of a email to ask a query and a project with you

[@psanders4754]

Power query bro

[@Inc0gnit030]

I was just saying how much I hated Excel the other day. Who needs Excel anyway when you have Python and SQL?

[@YemiFatodu]

Excel freezes when you have to analyse a whole bunch of data set...😢

[@caraziegel7652]

Haha ok. i've probably been using excel longer than you've been doing addition. excel is fantastic for appropriate use cases . . . but its not good for everything. btw, the visuals in excel, back in the day, were about the best you could generally find.

[@rosemaryng7994]

Python is coming to Excel. I think Excel is cool again. 😂

[@mugomuiruri2313]

realy

[@felipepereira3061]

ALSO, i really hate the formula's syntax...M for life! heuehueheu

[@lorensims4846]

Didja consider keeping your source data in a separate file, just in case something went wrong in Excel? That's what we learned in the old days. Do your own damned version control. They like to tell you Excel can do everything, but obviously, it can't. Did they ever fix that rounding error that raised such a stink around the turn of the millennium? You mentioned Google Sheets. There ARE alternate spreadsheet tools out there, some that will do things Excel just can't. But how many different tools do you want to have to learn? Yeah, it's the lingua franca out there, like Python is. But that does NOT mean they're the best available tools, especially for a particular job. Say, I hear you can now script Excel with Python. Do you think that will really help?

[@panic_seller]

I met an "experienced" wannabe making claims that excel is the best tool for analytics, me and my little knowledge literally laughed my ass off, he no longer speaks to me these days🤣🤣

[@chocholates]

Microsoft will not develop Excel more than their other products like Power bi. If u do want larger data set to be analysed for rationality than pay more & go for Power bi 😅

[@onii-chan2811]

I dislike it so much, I can’t get myself to really learn it