1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It's the most exciting Excel development in a generation... but you'd be forgiven for not knowing about it! Overview This one-hour …
How to unpivot a dataset in Excel Power Query vs R vs Python
What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we'll look at a frequent offender: unpivoted data. You'll learn …
Continue Reading about How to unpivot a dataset in Excel Power Query vs R vs Python →
Python was not designed for data analysis (and why that’s OK)
A major reason I think it’s easier for Excel users to pick up R versus Python is that these tools tend to "think" more similarly than Python. See what I mean here: let's take a range of numbers and …
Continue Reading about Python was not designed for data analysis (and why that’s OK) →
Free checklist: 30 days to Python programmer
Python has become in many ways the lingua franca of computing, with the open source language being used in everything from web development to artificial intelligence to... why, yes... data analytics. …
Continue Reading about Free checklist: 30 days to Python programmer →
How to launch Jupyter notebooks from Windows
To be honest, Python is not the easiest program to manage on your PC. I suggest newcomers download it from Anaconda because it does most of the behind-the-scenes lifting for you. Completely new to …
Continue Reading about How to launch Jupyter notebooks from Windows →
Consider learning Python: MyExcelOnline Podcast Top Excel Tips of 2021
John Michaloudis reserves an annual edition of his MyExcelOnline podcast to a roundup of the top Excel tips and tricks of the year from community leaders. I was happy to again be invited to …
Continue Reading about Consider learning Python: MyExcelOnline Podcast Top Excel Tips of 2021 →