As an Excel trainer and consultant, I've often encountered skepticism about categorizing skills into beginner, intermediate, and advanced levels. It's understandable—Excel is a vast program, and users …
Here are some memorable quotes from <i>Modern Data Analytics in Excel</i>
Modern Data Analytics in Excel is a technical book primarily focused on delivering dense technical information, which may not be everyone's cup of tea. However, if you delve into a lot of technical …
Continue Reading about Here are some memorable quotes from <i>Modern Data Analytics in Excel</i> →
Copilot for Excel: How to work with multiple tables
I like to say that good data, much like money, doesn't grow on trees. It takes work to obtain. Often, this work involves retrieving and combining data from multiple sources using techniques like …
Continue Reading about Copilot for Excel: How to work with multiple tables →
Spreadsheet Smackdown! Excel Trash Talk to Crunch Your Rivals
I see people crafting all sorts of Excel pickup lines, but what about trash talk? After all, how many dates are Excel nerds getting anyway? (And let the trash talk begin.) Here are some Excel …
Continue Reading about Spreadsheet Smackdown! Excel Trash Talk to Crunch Your Rivals →
How to use Copilot in Excel for non-Excel tasks
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 …
Continue Reading about How to use Copilot in Excel for non-Excel tasks →
Python in Excel: How to create interactive visualizations
Download this post as a PDF: 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 …
Continue Reading about Python in Excel: How to create interactive visualizations →