Pivot Table Concepts by Derek Mortensen via @TDataScience

Report, Analyze, Tell Stories.

This was really interesting. Pivot tables tell us so many things and can be a great tool and so to be able to do them outside of Excel is great.

5 Common Excel Tasks Simplified with Python by Frank Andrade via @TDataScience

Using Pandas, OS, and the DateTime module to simplify Excel tasks with Python.

I really like this which can be used to make yourself easier as well as a great learning experience.

Do You Read Excel Files with Python? There is a 1000x Faster Way by Nicolas Vandeput via @TDataScience

In this article, Nicholas shows you five ways to load data in Python. Achieving a speedup of 3 orders of magnitude. 

This is really useful as I knew there had to be a way to do it faster but this clearly gave me to the right ways to do it faster,

Excel Automation Using Python Xlwings by Sandeep Burnwal via @Medium

Automation has been the buzzword for a long time and will continue to be one in the times to come. It can take many forms and this great article by Sandeep explains how you can automate Excel using Python XIwings.

A very clear and very useful thing to learn. Useful code snippets to help you get your own code right.

The New XLOOKUP Function for Excel + Video Tutorial by/via @excelcampus

Microsoft’s new XLOOKUP feature is getting a lot of attention from Excel users. Here is a great tutorial on how to use it.

I like the look of this function which I think over time could save time and be much easier.

WEBINAR: Top 4 Excel Functions Done Better with Data Wrangling - 21 March 2018

Overview

Title: Top 4 Excel Functions Done Better with Data Wrangling

Date: Wednesday, March 21, 2018

Time: 09:00 AM Pacific Daylight Time

Duration: 1 hour

Summary

Top 4 Excel Functions Done Better with Data Wrangling 

Analysts have relied on Excel for decades, but as the size, variety, and pace of data accelerates, certain Excel functionality has begun to feel archaic. Today's data wrangling platforms offer analysts new approaches to preparing data that alleviate Excel bottlenecks. In this webinar, we’ll demonstrate how to leverage data wrangling techniques to execute common Excel functions more effectively, and what features to look for in a leading data wrangling platform. 

In this latest Data Science Central webinar, we will demonstrate how to leverage data wrangling techniques to execute common Excel functions more effectively, including:

• A side-by-side comparison of Excel vs. data wrangling platform 
• Examples of real-world applications for data wrangling techniques 
• Key functionality of a modern data wrangling platform

Speakers:

David McNamara, Customer Service Executive -- Trifacta

Tanya Cashorali, Founding Partner -- TCB Analytics

Hosted by:

Bill Vorhies, Editorial Director -- Data Science Central

  

Register here

5 Excel Add Ins Every Data Scientist Should Install by Megter via @DataScienceCtrl

No matter what you do, you can’t avoid excel. So, may as well dive into it & tame the beast. Here are 5 excel Add Ins that every data scientist should install.

These are really interesting and I think anyone who is serious about data and analysing it should consider adding these too.