How to Use Copilot in Excel: Mastering Excel with M365 Copilot – Data Analysis Tutorial

How to Use Copilot in Excel: A screenshot from an Excel Copilot demo showing various charts and graphs analyzing donor data. The interface includes a Copilot preview pane suggesting insights, and a video overlay of a presenter explaining the data. Graphs display information such as winter donations by date, donation amounts by last name, age distribution by gender and membership status, and occupation impact on donation behavior.
How to Use Copilot in Excel: Screenshot of the Excel Copilot video on Youtube analyzing donor data with graphs and insights.

Welcome to our deep dive into donor data with Excel Copilot! We will explore insights from our donor dataset to understand donor behavior, campaign effectiveness, and seasonal trends. Let’s learn how to use Copilot in Excel and dive into the data to see what stories it tells us.

How to Use Copilot in Excel with Copilot Prompts

To begin, look for the Copilot icon in the upper right corner. Copilot suggests actions such as „show data insights“, which we’ll select. Then select „+ Add to new sheet.“

Visual Enhancement

To make our data more engaging, let’s add a colorful icon next to donors whose donation amount exceeds $100. This visual cue will help us quickly identify high-value donors.

Excel Copilot Prompt: Add a colorful icon if Donation_Amount is more than 100.

Days Since Last Donation

Next, we’ll calculate the number of days since each donor’s last donation. This will help us identify recent donors versus those who haven’t donated in a while.

Excel Copilot Prompt: Calculate the number of days since each donor’s last donation and add this as a new column.
Action Step: Insert Column

Campaign Effectiveness

Let’s analyze how different communication methods, such as email and phone, impact donation amounts. We will identify which method is most effective for different donor segments.

Excel Copilot Prompt: Analyze the effectiveness of different communication methods (email, phone) on donation amounts. Identify which method is most effective for different donor segments.

Occupation Impact

Let’s examine the impact of donor occupations on their donation behavior. We’ll look at donation amounts and frequencies across various occupations to see which ones are associated with the highest donations.

Excel Copilot Prompt: Examine how a donor’s occupation affects their donation behavior, including donation amount and frequency. Identify which occupations are associated with the highest donations.

Lifetime Value (LTV)

Next, we will compute the lifetime value of each donor, which is the total amount donated over time. This will give us a sense of each donor’s value to our organization.

Excel Copilot Prompt: Compute the lifetime value (total donations over time) for each donor and add it as a new column.
Action Step: Insert Column

We’ll identify seasonal trends in donations by calculating the total donations for each donor during different seasons: spring, summer, fall, and winter. These insights will help us tailor our campaigns to seasonal patterns.

Excel Copilot Prompt: Identify seasonal trends by calculating the total donations for each donor during different seasons (spring, summer, fall, winter) and add these as new columns.
Action Step: Insert Columns

Conclusion

By analyzing these aspects of our donor data, we gain valuable insights into donor behavior, campaign effectiveness, and seasonal trends. This information will empower us to make informed decisions and enhance our fundraising strategies. Thank you for joining me in this data exploration. Let’s open the floor for any questions or further discussion!

How to Use Copilot in Excel: Watch the Full Video

Watch the full Excel Copilot Tutorial on YouTube:

Download the Dataset

Get the dataset used in this Excel Copilot tutorial: Download Donors.xlsx Dataset

Don’t forget to like, share, and subscribe for more insightful demos and data-driven strategies! If you’re interested in learning more about the impact of AI, check out my book Decisively Digital (Amazon).


Stay tuned for more updates and feel free to leave your questions or comments below. Happy data exploring!

Unlocking the Power of Data Science with Excel: Discover the Book „Data Smart“

Exploring the depths of Data Science with Excel: A glimpse into 'Data Smart' by Jordan Goldmeier, a must-read for data enthusiasts.
Exploring the depths of Data Science with Excel: A glimpse into ‚Data Smart‘ by Jordan Goldmeier, a must-read for data enthusiasts.

Data Smart (Amazon) is an exceptional guide that creatively uses Microsoft Excel to teach data science, making complex concepts accessible to business professionals. This 2nd edition, masterfully updated by Jordan Goldmeier, arrives a decade after John Foreman’s highly acclaimed original version, bringing fresh perspectives and contemporary insights to the renowned first edition.

Whether you’re a novice or a seasoned analyst, this book provides valuable insight and skill enhancement without requiring extensive programming knowledge. The practical, problem-solving approach ensures that you not only understand the theory, but also how to apply it in real-world scenarios. That’s why I’ve chosen Data Smart as our latest pick for the #datamustread book club.

Why „Data Smart“ is a #datamustread

Data Smart stands out in the realm of data science literature. Its approachable and practical methodology is a breath of fresh air for business professionals and data enthusiasts alike. Here’s why this book is an indispensable resource:

1. Excel as Your Data Science Laboratory:
The use of Excel, a tool many of us are familiar with, to unravel data science concepts is nothing short of brilliant. This approach significantly flattens the learning curve, making complex techniques more digestible.

2. Practical Learning through Real Business Problems:
Each chapter of the book introduces a different data science technique via a relatable business scenario. This context-driven approach makes the learning experience tangible and immediately applicable.

3. No Programming, No Problem:
The author’s method of teaching data science without delving into programming languages makes the content accessible to a broader audience.

4. Excel Skills Elevated:
In addition to data science concepts, readers will enhance their Excel prowess with advanced tools like Power Query and Excel Tables.

5. A Spectrum of Techniques:
From cluster analysis to forecasting, the book covers a wide array of methods, making it a comprehensive toolkit for any aspiring data scientist.

6. Fresh Perspectives in the Second Edition:
Goldmeier’s updates are not just cosmetic; they incorporate the latest Excel features, ensuring the content remains relevant in today’s fast-paced tech landscape.

Bridging the Gap with „Teach Yourself VISUALLY Power BI“

While exploring Data Smart, you’ll find parallels with the insights shared in my own book, Teach Yourself VISUALLY Power BI. Both texts aim to make data analytics accessible and actionable, providing a solid foundation for anyone looking to make informed decisions based on data.

Your Journey into Data Science Awaits

Data Smart is a gateway to understanding data science through a familiar and powerful tool: Excel. Whether you’re a beginner or a seasoned analyst, this book will enhance your analytical skills and expand your understanding of data in the business world.

Order Data Smart today and support both the authors and my endeavors in bringing such valuable resources to our community. Let’s dive into this journey of discovery together, transforming data into actionable insights.

Join the Conversation

After delving into Data Smart, I’d love to hear your thoughts and takeaways. Share your insights and join the discussion in our vibrant #datamustread community on LinkedIn and Twitter:

„Unlocking the Power of Data Science with Excel: Discover the Book „Data Smart““ weiterlesen