Articles by George Mount

Python in Excel: How to calculate investment returns

June 19, 2024 | George Mount

Whether you’re a seasoned financial analyst or a data-proficient professional, understanding the calculation of investment returns can help assess the profitability and risks of various assets. This post explores three core methods for calculating investment returns: normalized returns, daily returns, and logarithmic daily returns. The integration of Python within ...
[...Read more...]

Python in Excel: How to work with missing values

May 22, 2024 | George Mount

Data analysts should be proactive about missing values in their data, as these can significantly impact analysis outcomes. First of all, many algorithms such as linear and logistic regression as well as decision trees require complete datasets and cannot inherently process missing data. But beyond statistical modeling and machine learning, ...
[...Read more...]

Python in Excel: How to run a Monte Carlo simulation

April 9, 2024 | George Mount

Monte Carlo simulations leverage probability and randomness to simulate processes multiple times, exploring a wide range of possible outcomes. This approach can illuminate the inherent uncertainty and variability in business processes and outcomes. Integrating Python’s capabilities for Monte Carlo simulations into Excel enables the modeling of complex scenarios, from ...
[...Read more...]

How to create and modify Excel workbooks with openpyxl

March 26, 2024 | George Mount

Several packages facilitate working with Python and Excel, but openpyxl stands out as an excellent choice due to its comprehensive features for reading and writing workbooks. In this blog post, we will explore how to get started with creating Excel workbooks from scratch and modifying existing ones using openpyxl. For ...
[...Read more...]

Copilot for Excel: How to work with Python code

March 25, 2024 | George Mount

One of the key insights Excel users should appreciate about Copilot is its vital role in keeping Excel current in the AI era. It achieves this by innovatively integrating multiple intelligence sources, expanding Excel’s functions beyond traditional spreadsheets. Today’s era is characterized by growing system interoperability. In particular, ...
[...Read more...]
1 2 3 10