Articles by George Mount

What is the role of Python in modern Excel?

February 21, 2023 | George Mount

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 overwhelmed. One “Excel-adjacent” tool that can be particularly intimidating for prospective learners is ...
[...Read more...]

How to install the xlwings add-in for Excel

January 24, 2023 | George Mount

Many packages exist for working with Python and Excel, but xlwings may be the most powerful all-around due to its many reading and writing features. This versatility, however, comes at the cost of being relatively more difficult to set up. For example, one of the most useful features of xlwings ...
[...Read more...]

Free workshop: Excel Power Query PDQ!

August 11, 2022 | George Mount

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 free one-hour workshop will serve as an introduction to Power Query in Excel: How tables serve as the “...
[...Read more...]

Free checklist: 30 days to Python programmer

May 8, 2022 | George Mount

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. If you’re a heavy Excel or Power BI user, Python is a great tool to add to your ...
[...Read more...]

How to launch Jupyter notebooks from Windows

March 27, 2022 | George Mount

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 Python? Check out my Python launch checklist Among other benefits, Anaconda comes with many of the ...
[...Read more...]
1 2 3 7