Excel - Learn Data Science with Travis

Travis chat

WORKING WITH EXCEL SPREADSHEETS

Automate the Boring Stuff with Python

13 WORKING WITH EXCEL SPREADSHEETS Although we don’t often think of spreadsheets as programming tools, almost everyone uses them to organize information into two-dimensional data structures, perform ...

Don’t Worry, Excel is Surprisingly Effective

Towards Data Science

It is common for data scientists to look down on Microsoft Excel. Compared to a programming language like Python, it seems like a tool from the stone age. It doesn’t scale well, it's hard to…

Bye-bye Excel, hello Mito

The Pythoneers

You can now write Python code if you can edit an Excel file. Continue reading on The Pythoneers

Stop Wasting Time in Excel: Let Python Do the Work

Python in Plain English

Not a paying member? Click here to read for free One of the things that surprised me the most when I started in Analytics is how dominant Excel still is. Whenever an analysis is presented or insights ...

Looking for the Best Excel Add-ins

Analytics Vidhya

Excel provides convenient methods, including easy to use functions and intuitive buttons and menus, for performing simple computations. But it’s hard for it alone to accomplish complicated…

Using Python to automate your boring and tedious excel tasks!

Analytics Vidhya

Are you tired of doing tedious and repetitive excel tasks daily in your work? If yes then this article will help you get through and save you some time. You will need python’s pandas library for…

Excel for Data Science?

Towards Data Science

Microsoft Excel is probably the most well-known tool for working with data. Almost everyone knows it, we have our own hate or love relationship to tables, pivots, VBA-scripts and charts. We do our…

Getting Started with Microsoft Excel

Towards Data Science

Learn the basics of Excel functions, including Pivots, Text to Columns, Removing Duplicates, Concatenating fields and using conditional logic.

10 Best Excel Courses for Beginners to Take in Udemy [2023]

Javarevisited

Hello guys, in my 20+ years of software development career if I have seen one tool so ubiquiterous as Microsoft Excel . While you will find all the office products like Microsoft Word, PowerPoint, and...

I Use Excel To Write Code. Sue Me.

Level Up Coding

I have done some weird things in my day, some of them I would not admit to freely — but using Excel for coding tasks is one of my guilty pleasures that I will not hide from anyone. Forget the turing…

Excel Functions, Tips, and Shortcuts for Everyone

Analytics Vidhya

Learn how to use the VLOOKUP, INDEX & MATCH, CLEAN & TRIM, Text to Columns functions, and explore the Pivot Table including its numerous data reporting functions. Also, tips on error detection, cell…

Life After Spreadsheets: Python for Productive People

Analytics Vidhya

For most people, most of the time, spreadsheets are the right choice for the job. They are the most accessible, the easiest to use, and offer the best set of tools for organizing, manipulating, and…