Teaching analytics with modern Excel
Between Power Query and Power Pivot alone, "modern" Excel boasts so many features that it's impossible to learn them all. Add to that Office Scripts, Power BI, LAMBDA() and more and it's easy to get …
Continue Reading about What is the role of Python in modern Excel? →
I love Excel. It's a bedrock of my blog and largely my "claim to fame" as an authority. That said, early on I intended this not to just be an Excel blog, because I saw the benefits of cross-training …
Continue Reading about The dangers of being a one-platform data analyst →
I remember when I first got into Python and heard about Anaconda. It wasn't really clear to me if Anaconda was a "dialect" of Python code, a really awesome suite of tools for working with Python, or …
Continue Reading about What is an open source software distribution? →
First time using R? Check out my free mini-course, "5 Things Excel Users Should Know About R." R is a free statistical programming language that is very popular and powerful. I like to use it with …
One of my courses this year is a seminar on information systems. Before each class, we each write a "conversation starter" incorporating our thoughts on the papers.A topic that has greatly interested …
Oz du Soleil has a new daily vlog series in August, "Excel Ignited." He'll start from the basics, diving into what Excel is for and how to think about data. In the last lesson, he discussed "What is …
