How to use NEW Microsoft Copilot in Excel

Scott Brant
Scott Brant
9,586
0
Published 2024-02-29
Unlock the full potential of Excel data analysis with Copilot in our latest comprehensive tutorial. Dive into the future of data management as we explore how Copilot can transform your approach to Excel, turning complex data sets into insightful, actionable information with ease and efficiency. Whether you're presenting to your peers or reporting to your boss, this tutorial equips you with the skills to interpret and manage data like never before, revolutionising the way you work!

From importing and reviewing data to creating dynamic reports and engaging with your data through Microsoft 365 Chat, this tutorial is your all-access pass to Copilot in Excel!

πŸŽ“ What You'll Learn:

Importing Data: Master the first step of any data analysis process by efficiently importing your data into Excel.
Reviewing and Highlighting Data: Learn techniques to review your data thoroughly and highlight critical insights.
Modifying Data: Gain the confidence to modify your dataset, adding or removing data as needed with precision.
Building Reports: Transform your data into compelling reports, utilising PivotTables and charts to visualise your findings.
Microsoft 365 Chat Integration: Explore how to use Microsoft 365 Chat with Excel to analyse your data through natural language queries, making your data work for you.

⭐️ Additional Resources:

πŸ“š Grab our Free Microsoft 365 eBook: www.your365coach.co.uk/ebook
πŸ”— Enhance your Microsoft 365 skills: www.your365coach.co.uk/courses
πŸ”Ž Find out More about Your 365 Coach: www.your365coach.co.uk


πŸ“° Stay updated: Follow us on Instagram: @your365coach / TikTok: @your365coach

Video Timings:

00:00 Introduction
02:09 Accessing Copilot in Excel
04:05 Analysing Data with Copilot in Excel
08:33 Reporting Data with Automated Charts using Copilot in Excel
10:36 Changing and Creating Data in Excel with Copilot
13:04 Use Microsoft 365 Chat and Gain Insights into Excel Data
16:12 Thoughts on Copilot in Excel

#Excel #Microsoft365 #Copilot #Your365Coach
All Comments (4)
  • @marcteleki2801
    I am the first one to leave a comment. Thanks for the great content. 😊
  • @zhaobb
    Co-pilot in Excel is still very very primitive. It is more a chatbot-based assistance. It doesn't possess more human-like intelligence. A simple example, there is a column of city name. Try to ask how a summary of total sales by continent -- it can't handle this. M365 Co-pilot is still a half-baked product not worth USD $20/$30 per month per user.