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...]
1 6 7 8 9 10 14