richpax.blogg.se

How to do data analysis in excel on mac
How to do data analysis in excel on mac







The tables are easily edited, formatted, colourized, and shared. Probably that’s why Excel has had the same layout over the years. There’s simply no better editor for 2-dimensional data (i.e. These are my own thoughts and experience - I may be wrong so please correct me! Best editor for 2D data But before starting, let’s just clarify: I don’t have any professional relationship with Microsoft and never have had.

how to do data analysis in excel on mac

There are probably plenty of arguments for this (and against). Now, I would like to share my experience with you.Įxcel is a powerful tool for data science. Ranging from self-driving cars in the automotive industries, to risk management in insurance and predictive maintenance in MedTech, Excel has always followed along. Well, hang on…Īfter achieving my Master’s degree in Physics I’ve spent over ten years applying “data science” to solve problems. Data Science? In Excel? Isn’t data science about hyped Jupyter Notebooks in the web browser, Big Data and Hadoop in the Cloud, Deep Learning on the GPU and advanced interactive plots and visualizations, and …? This may sound far from Excel as you know it. They probably got something right in that design?īut wait. After all, it has been around since 1987 and still looks fairly similar with its grids and sheets. The word “Excel” has even become a synonym to “table” or set of tables, as in: “hey, can I send you an Excel?” Even your grandmother has used it.

how to do data analysis in excel on mac

We do our monthly business spreadsheets, calculate vacation costs and even work with contact lists in Excel. Almost everyone knows it, we have our own hate or love relationship to tables, pivots, VBA-scripts and charts. Microsoft Excel is probably the most well-known tool for working with data.









How to do data analysis in excel on mac