Move from Excel to Python with Pandas Transcripts
Chapter: Welcome to the course
Lecture: Where do Excel errors come from?

Login or purchase this course to watch this video and the rest of the course contents.
0:00 Excel is widely used for many tasks. Why does it lead to big and small errors and complaints from users?
0:07 I think part of the reason is that Excel is the only tool. Many analysts know. And they tried to use it for all their tasks.
0:14 The quote, If your only tool is a hammer then every problem looks like a nail is very appropriate in this context. If you are an Excel user,
0:22 you probably used it for many things. A simple database, a task tracker,
0:27 Project planner, Quick calculations complex modeling data cleaning you name it. Some of these tasks are great for Excel,
0:34 others not so much because Excel can only do so much. People try to use it for everything data related. Instead of alternative options like Python,
0:42 that might be more appropriate for the task. The next problem with excel is that all the flexibility makes it difficult to trace the flow
0:50 of a spreadsheet Excel. You can have formulas that reference other spreadsheets or have complex nested functions and visual basic behind the scenes.
0:58 The simple representation of a spreadsheet hides a lot of complexity that goes on behind the
1:03 scenes. Another related problem is that Excel formulas make it very easy to make subtle mistakes. They're difficult to detect.
1:11 We already mentioned data formatting is one example. I can almost guarantee you have had issues where you forgot to include the correct range,
1:17 no formula, Or maybe your data included zeros or blank values that gave you erroneous results. Buying these types of errors can be very challenging.
1:27 The final issue with excels performance, especially on large data sets. In addition to managing Data,
1:33 Excel stores information about formatting formulas and logic to analyze the data. This overhead makes opening a large spreadsheet,
1:40 a slow process with modern computers. We have gigabytes of memory available, so this shouldn't be a limitation.

Talk Python's Mastodon Michael Kennedy's Mastodon