Teaching analytics with modern Excel
Analysts frequently sort and filter their data to enhance manageability and to spot patterns, trends, and anomalies. While Excel already facilitates this task, Copilot further streamlines the …
Continue Reading about How to sort and filter data with Copilot for Excel →
Data profiling is used to examine a dataset to understand its structure and quality, identifying data types, inconsistencies, and outliers. This process ensures data accuracy and integrity, essential …
Continue Reading about Copilot for Excel: How to profile your data →
Formulas and functions form the core of Excel, and if you believed AI would eliminate the need for you to ever craft them personally – you're only partially correct. Let's delve into how Copilot can …
Continue Reading about Copilot for Excel: How to create formulas and functions →
As someone who has created LinkedIn Learning courses on AI for Excel and written extensively about the topic on my blog, I am frequently asked about how AI will influence the future of Excel. One of …
Continue Reading about How to understand what “AI-Powered Excel” is all about →
One of my all-time favorite quotes about data visualization comes from legend Edward Tufte: At the heart of quantitative reasoning lies a single question: 'Compared to what?' In Excel, …
Continue Reading about Copilot for Excel: How to add conditional formatting to your workbook →
Data visualization plays a crucial role in simplifying complex data, uncovering patterns, and effectively conveying findings to others. However, starting a new chart can be daunting. With a plethora …
Continue Reading about How to visualize data with Copilot in Excel →
