Description
✅Download the free course files and follow along here:
➡️ https://www.simonsezit.com/copilot-chat-and-agent-mode-in-excel-demo-files
Master Copilot in Excel by learning how to harness both Copilot chat and the groundbreaking new Agent Mode to transform raw, messy spreadsheets into stunning, interactive dashboards. We break down the fundamental differences between the two modes, showing you how to use Copilot for quick formulas, conditional formatting, and data cleaning, while deploying Agent Mode to autonomously execute complex, multi-step analysis and build full-scale data models.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 – Course Introduction
00:04:28 – Create and Modify Columns
00:05:13 – Prepare Data and KPI Metrics with Copilot
00:11:13 – Suggest Conditional Formatting
00:17:30 – Generate Summaries from Dataset
00:20:48 – Summarize Using PivotTable
00:27:47 – Data Modelling and Financial Metrics
00:29:47 – Clean Data in a New Column
00:31:07 –Visualize Data Using Copilot-generated Charts
00:40:46 – Prepare Data and KPI Metrics with Copilot
00:47:13 – Build Dashboard Elements and Measure Growth Performance
00:52:12 – Trend Analysis and Advanced Insights
01:00:08 – Advanced Analysis using Copilot in Excel for Web
01:03:09 – Data Modelling and Financial Metrics
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 https://www.youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)