Teaching analytics with modern Excel
As a Python enthusiast for a few years and an Excel aficionado for even longer, it's been exciting to see Python become officially supported in Excel. Yet, I still receive a lot of questions from …
Continue Reading about Python in Excel: How to make an open-high-low-close (OHLC) chart →
I'm not sure about your experience, but personally find Excel's charting features antiquated at times. They can be quite finicky to use, particularly when it comes to customization. Iterating between …
Continue Reading about How to resize Python plots in Excel →
This post accompanies my segment on MyExcelOnline's "Best Excel Tips of 2017 Podcast." The first commandment of data analysis: KNOW THY DATA! It's always smart to get a feel for your data's …
Continue Reading about Making Easy, Flexible Histograms with PivotTables →
They say a picture is worth a thousand words... so how many does an animated graph get us? This morning I was working on a research proposal presentation. Essentially, the research aims to develop a …
Continue Reading about Visualizing Movements Along a Line in Excel →
(Note: This guest post is from Puneet Gogia at ExcelChamps.com. Puneet is a good friend of the blog, and today he shares how to build a panel chart in Excel. As I mentioned in my segment on the …
Continue Reading about Guest Post: A Step-by-Step Guide to Creating a Panel Chart in Excel →
