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

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

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

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

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

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

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

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

In the world of Excel, both ChatGPT and Copilot for Excel have sparked considerable discussion about how AI might transform the product. And although both tools share a common lineage, they each possess distinct advantages and disadvantages regarding ease of use, adaptability, versatility, and more. This post delves into the relationship between ChatGPT and Copilot for Excel, examining their individual and combined impacts on Excel users. Both roads lead to GPT Before delving into the differences between ChatGPT and Copilot for Excel, let’s delve into the considerable commonalities. ChatGPT an ..read more

Among the numerous exciting features that Copilot is set to introduce for Excel, one significant requirement is that Excel data must be organized in tables. This is crucial because Copilot will not function unless the data is formatted in this manner. Excel tables provide numerous advantages, including their aesthetic appeal. With just a few clicks, you can transform your dataset into a beautifully formatted table featuring banded rows, filter buttons, and more. Copilot enhances this experience, making it remarkably simple to modify your table’s appearance after creation. Let’s practice with a ..read more