George J. Mount
263 FOLLOWERS
This blog is meant as a resource for recent grads and others who want to advance their career through Microsoft Excel, data analytics, and business economics.
George J. Mount
6d ago
I’m genuinely excited about the suite of AI tools Microsoft has been introducing for Microsoft 365, particularly Excel. However, I do wish the naming conventions were sometimes easier to understand. Specifically, it’s quite confusing to follow along with the various products since they are all named “Copilot:”
Microsoft: "What should we call this new product?"
Microsoft marketing: pic.twitter.com/MQbVJFX9HL
— George Mount (@gjmount) March 20, 2024
This post aims to distinguish between Microsoft Copilot and Copilot for Excel in terms of access, pricing, features, and more.
Access
To start ..read more
George J. Mount
6d ago
Copilot in Excel can help with a variety of everyday tasks for working with your data, such as adding conditional formatting or creating basic calculated columns. But did you know that you can also use Copilot in Excel for some non-Excel tasks? Let’s explore how this works and see how it could actually help in your day-to-day activities as an analyst. To follow along, you can download the exercise here, or open up any dataset in Copilot in Excel:
Download the exercise file here
Excel for Copilot vs ChatGPT
Let’s take a moment to understand why Copilot in Excel is knowledgeable about top ..read more
George J. Mount
1w ago
One of the greatest wins for Excel users learning Python is access to a comprehensive suite of data visualization tools. However, compared to Excel, the default plots produced with Python in Excel can seem somewhat static. For example, there’s no straightforward way to add tooltips or interactive elements that allow users to click on parts of the chart to understand the data’s origins.
Nonetheless, it is possible to make Python plots created in Excel feel more interactive and user-friendly. This post expands on a previous article where I explored using moving averages with Python in Excel. We ..read more
George J. Mount
1M ago
Just like in biology, where cells are the building blocks of life, in your Excel workbook, cells serve as the foundational elements. In this post, you’ll discover how to interact with individual cells and then extend your knowledge to managing entire rows and columns using openpyxl.
For this demo, I’ll assume you’re familiar with installing and working with Python packages, along with basic operations such as creating variables, indexing, and so on. If you need assistance with these topics before proceeding, consider checking out my book Advancing into Analytics:
Advancing into Analytic ..read more
George J. Mount
1M ago
Working with Python code becomes significantly more manageable when objects are assigned clear, sensible names, and Excel is no different. This blog post covers how to create named ranges and tables in Excel using openpyxl.
To begin this demonstration, we will import several modules from openpyxl, along with a sample of rows from the penguins dataset available in the seaborn package.
import openpyxl
from openpyxl.worksheet.table import Table, TableStyleInfo
from openpyxl.utils import get_column_letter
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl import Workbook
wb = Wo ..read more
George J. Mount
1M ago
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 this lesson, I’ll assume you’re familiar with installing and working with Python packages, along with basic operations such as creating variables, indexing, and so on. If you need assistance with these topics before proceeding, consider checking out my book Advancing into Analyti ..read more
George J. Mount
1M ago
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, I’m excited about how Copilot can Python more accessible to everyday Excel users. With Python’s integration into Excel and with the help of Copilot, even those new to coding can easily tap into its powerful data analysis, visualization, automation, and AI c ..read more
George J. Mount
1M ago
Excel continues to be an essential tool for many business professionals, often utilized for swift ad hoc analyses, reporting, or data entry tasks. However, Excel’s true potential over time frequently resides in automation, where it minimizes repetitive tasks and maximizes efficiency.
Microsoft’s Power Automate and Office Scripts play a crucial role in this evolution, presenting inventive methods to streamline workflows within Excel Online. Grasping the distinct advantages and applications of each tool can greatly boost your productivity. Let’s explore the details of when and how to employ thes ..read more
George J. Mount
1M ago
Excel users are increasingly tasked with accomplishing more with fewer resources. The volume of data to manage is constantly expanding, yet there are fewer individuals available to help manage it. Adding to this challenge is the looming presence of AI, which has instilled a fear of future job security in many. The concern is that failing to automate tasks that computers can handle may render their roles obsolete due to advancements in AI. So, what is the solution?
One tool I recommend for Excel automation is Python. Another noteworthy option is Power Automate, and by extension, Office Scripts ..read more
George J. Mount
1M ago
Microsoft’s introduction of Copilot for Excel promises to revolutionize our interaction with data through unprecedented analytical assistance and decision-making support. However, this innovative tool, while brimming with potential, is currently shrouded in a veil of confusion and misunderstanding. Many users eager to explore its capabilities find themselves stalled, uncertain of how to navigate the complexities and leverage Copilot effectively.
This post aims to shed light on Copilot, dispelling common misconceptions and equipping you with the necessary insights to begin utilizing this powerf ..read more