I Built 4 BEAUTIFUL Dashboards with Excel's Copilot скачать в хорошем качестве

I Built 4 BEAUTIFUL Dashboards with Excel's Copilot

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/ev... --------------------------------------------------------------------------- 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