GET THE DASHBOARDS FROM THE VIDEO:
https://tinyurl.com/2dpzeavd
---------------------------------------------------------------------------
Access 100+ accounting & finance templates: https://www.modelwiz.com
---------------------------------------------------------------------------
Learn every single feature in Excel with my newest course
https://www.yourcfoguy.com/courses/everything-you-can-do-in-excel
---------------------------------------------------------------------------
Microsoft Copilot just rolled out new features that can turn hours of work into minutes, especially if you're not an Excel expert.
After investing more than 20 hours researching Copilot, in this video you'll find out the best use cases and hidden tricks that actually work.
We will build together 4 dashboards from scratch, using only copilot.
You'll learn how to get more things done without having to google stuff every 30 min.
I tested everything myself to show you the most useful features that will make your workflow faster.
⏱️ Timestamps:
00:00 Introduction
00:23 How to Install Copilot in Your Excel File
00:48 Use Copilot to Populate a Dashboard
02:27 How to Prepare Your Data for Copilot
04:49 Using Copilot to Filter Tables
06:06 Data Analysis with Copilot
06:45 Adding a New Column with Copilot
08:00 Updating Your Data with Custom Formatting Using Copilot
08:40 Performing Calculations with Copilot
10:30 Using Copilot to Populate a Table with a Spill Function
12:39 Populating a Budget vs Actual Dashboard
17:38 Using Conditional Formatting with Copilot
18:22 Creating a Payroll Dashboard with Copilot
18:50 Finding Duplicates with Copilot
19:40 Performing a Lookup Based on Another Table
20:23 Dividing First and Last Names
22:05 Making Copilot Act Like an FP&A Assistant
22:31 Create a Dashboard with Insights
25:18 Will AI replace me?
ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.
⚡️ Check out my channel here: / @yourcfoguy
Don’t forget to subscribe!
🔎 FIND ME AT
https://www.yourcfoguy.com
➡️ Subscribe to my Newsletter!
https://www.yourcfoguy.com/newsletter
🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
LinkedIn: / joshaharonoff
Twitter: / yourcfoguy
#excel #copilot #accounting #entrepreneurship #entrepreneur #dashboards #finance #financeandaccounting #Accounting #accountingprofessionals #tutorial #yourcfoguy