Excel

Conditional Formatting in Excel | Free Dashboard Course – Lesson 01

We present a mini course on Dashboards, and in this first lesson, we focus on conditional formatting. You will learn how to highlight the percentage variation of data between different periods using colors and symbols, a fundamental technique to facilitate information visualization. This content is ideal for those looking to enhance their skills in data analysis and report building. - Importance of conditional formatting in reports - How to apply colors to indicate positive and negative variations - Creating a chart that shows data movements - Using symbols to represent fluctuations (up and down arrows) - Practical tips using a fictional dataset Stay with us until the end of the video and discover how these techniques can optimize your analyses and reports! ⬇️ Download the spreadsheet: https://zeplanilha.com/dashboards/aulas/formatacao-condicional/ 🌐 For more spreadsheets, visit our website: https://zeplanilha.com/

Day 1 | Excel Financial Modeling | Best Practices & Pro Tips

https://docs.google.com/spreadsheets/d/1joQhiqeT2ar2eJi3lKy80Sme8vD2Cv41/edit?usp=drive_link&ouid=107142657140793364455&rtpof=true&sd=true https://docs.google.com/spreadsheets/d/1HDU8pg_AqH3Gqjzk5kcL2NsdKGFjN8lB/edit?usp=drive_link&ouid=107142657140793364455&rtpof=true&sd=true https://docs.google.com/spreadsheets/d/1wxnuhvJoMN2-r7hAGAd7UBJ0FAGxnajO/edit?usp=drive_link&ouid=107142657140793364455&rtpof=true&sd=true https://docs.google.com/spreadsheets/d/1TSRhQG-nHJ-fuBIZ831IR79Dy8kfgDHO/edit?usp=drive_link&ouid=107142657140793364455&rtpof=true&sd=true https://docs.google.com/spreadsheets/d/1b6K8Lg_YXipXayS4VTUo4iBuR1bxHBlZ/edit?usp=drive_link&ouid=107142657140793364455&rtpof=true&sd=true --------------------------------- 📈Master Financial Modeling Like a Pro In the world of finance and business, the secret is to build a financial model efficiently and quickly using the best practices employed by major companies. 📊 In this lecture, we share a set of the most important practical tips in Financial Modeling, along with Excel shortcuts that save hours of work, in addition to the best practices gained over years of experience in finance and financial planning. You will learn: ✅ How to use Excel professionally ✅ Best practices in building financial models ✅ Ways to increase your speed and productivity while working ✅ Common mistakes to avoid as a financial analyst or specialist And don't forget to like, subscribe to the channel, and turn on the notification bell to receive all the latest updates. #FinancialModeling #Excel #FinancialModeling #FinancialAnalysis #Finance #FPandA #Accounting #FutureOfFinance #LearnExcel

Build This Excel Dashboard from Scratch in 30 MINUTES

Download the Excel file used in the video: https://www.excelcampus.com/charts/excel-dahsboard-tutorial-full-buildout/ Building an Excel dashboard from scratch can feel overwhelming, but this step-by-step tutorial shows you how to create a professional interactive dashboard using pivot tables and pivot charts with no complex formulas required. You will learn how to build KPI cards, a sales trend line chart, a customer mix bar chart, and a top five items column chart, then connect them all with a slicer for dynamic filtering. Along the way you will pick up practical tips on working with shapes, icons, chart formatting, and how to refresh your dashboard when new data arrives. Additional Resources: 📰Subscribe to our free Excel Pro Tips Newsletter: https://www.excelcampus.com/free 🧠Latest Free Masterclass on Excel & AI: https://www.excelcampus.com/blueprint-masterclass/ ▶️Related Videos: How to Design Dashboards with AI: https://youtu.be/IWeJwQxgZMo Introduction to Pivot Tables and Dashboards: https://youtu.be/9NUjHBNWe9M Pivot Tables: Automatically Update & Refresh When Source Data Changes: https://youtu.be/NI1UQcYtl1A 0:00 Creating an Interactive Dashboard 0:41 Understanding the Source Data 1:24 Starting with Sales by Team Member 1:55 Building the First Pivot Table 3:26 Creating a Pivot Bar Chart 4:33 Analyzing Top Rental Items 8:07 Visualizing Sales Trends Over Time 10:21 Examining Customer Type Mix 12:41 Setting up KPI Card Data 15:16 Dashboard Design and AI Tools 16:40 Building Dashboard KPI Cards 17:47 Linking Shapes to Data 18:30 Efficient Object Selection 19:46 Adding Icons to Cards 22:21 Advanced Chart Formatting 24:33 Customizing Data Labels and Bars 25:35 Organizing Dashboard Layout 27:36 Adding and Linking Slicers 29:00 Creating a Slicer Styling Hack 29:53 Designing Custom Shapes for Headers 32:23 Applying Branding and Theme Colors 33:46 Updating the Dashboard with New Data 35:17 Data to Dashboard Workflow 35:34 Resources and Conclusion

Create Professional Excel Dashboard in Just 10 Minutes | Dynamic & Interactive | No Coding!

📲 Join Our Community: 💬 WhatsApp: https://whatsapp.com/channel/0029VbCIu9XHVvTSpnBDWr0e 📢 Telegram: https://t.me/+aBQXL9Kwg_FhM2Jl 📊 Download the Data File: https://drive.google.com/uc?export=download&id=18ymJIasEKR3QLDo45vrxIozPONB7Izev 📈 Upgrade your Power BI & Dashboard skills today! 👍 Like | 🔔 Subscribe | 📤 Share with your team Create a Professional Excel Dashboard in Just 10 Minutes ⚡ (Step-by-Step Tutorial) Want to turn raw data into a fully interactive Excel dashboard in minutes? In this video, I’ll show you exactly how to build a professional, dynamic dashboard using only Excel — no coding, no tools, no experience needed. Why This Dashboard is Powerful One-click filtering (instant updates) Clean & professional design Fully interactive visuals Easy to build (beginner friendly) No Power BI or Tableau needed 📲 Follow Us on Social Media: 📸 Instagram: https://www.instagram.com/vedakarna_/ 💼 LinkedIn: https://l1nk.dev/776m1 👍 Facebook: https://www.facebook.com/profile.php?id=61584493776530 #ExcelDashboard #ExcelTutorial #DataAnalysis #ExcelTips #DashboardDesign #ExcelForBeginners #DataVisualization #ExcelTricks #BusinessAnalytics #LearnExcel #Dashboard #KPI #ExcelAutomation #Productivity #10Minutes #Trending

Create a Interactive Dashboard with ONE Prompt using Claude AI. (In Just 3 Minutes)

✅ Get the FREE Master Prompt Here: https://drive.google.com/uc?export=download&id=1Sz-9ock5mqQxOeE2G19rGxlzZFdtr1FJ 📊 Download the Excel Dataset File: https://drive.google.com/uc?export=download&id=1WdvR6CUnqerAzyaTECJ28sExDUKI2kI2 📲 Join Our Community: 💬 WhatsApp: https://whatsapp.com/channel/0029VbCIu9XHVvTSpnBDWr0e 📢 Telegram: https://t.me/+aBQXL9Kwg_FhM2Jl 📈 Upgrade your Excel skills from Beginner to Advanced today! 👍 Like | 🔔 Subscribe | 📤 Share with your team What if you could turn a messy raw Excel dataset into a fully interactive Expenses Dashboard… with just ONE click? 🤯 In this video, we’ll show you how to use Claude AI + VBA Automation to automatically generate a professional Excel dashboard in minutes — no manual dashboard building required. 🔥 Features Included: ✅ Dynamic KPI Cards ✅ Interactive Slicers ✅ Automated Pivot Tables ✅ Dynamic Charts & Visuals ✅ One-Click Dashboard Creation ✅ Live Dashboard Building Process ✅ Beginner Friendly VBA Automation 📌 Excel 📌 Claude AI 📌 VBA Automation 📌 One Prompt Watch till the end and learn how to build a fully automated Excel Expenses Dashboard in just minutes. • How to generate VBA code using Claude AI • How to automate Excel dashboard creation • How to create PivotTables automatically • How to build KPI cards dynamically • How to create interactive slicers and charts • How to automate Excel reporting workflows 📲 Follow Us on Social Media: 📸 Instagram: https://www.instagram.com/vedakarna_/ 💼 LinkedIn: https://www.linkedin.com/company/110228139/admin/page-posts/published/ 👍 Facebook: https://www.facebook.com/profile.php?id=61584493776530 #claudeai #aitools2026 #aitools2026 #nocodingjobs #datavisualization #claudeaitutorial #1 #claudecowork #claude #claudecode #excelvba #vbamacros #dashboarddesign #dataanalytics #excelautomation #exceltutorial #exceltips #exceldashboard #excel #aitools #claude #aiforfinance #claudecowork #claudecode #coding #aitools #claudecoworktutorial #howtouseclaudecowork #learnexcel #excelforbeginners #aiautomation #vba

Complete Power Query Excel Tutorial for Beginners to Advanced

🔗 https://espritacademique.com/ A complete Power Query Excel tutorial to learn how to import, clean, transform, and automate your data like a pro. 📚 Access the full training catalog: https://espritacademique.com/catalogue-de-formations/ 📚 Free quizzes and various resources: https://espritacademique.com/qcm-gratuits-sur-les-outils-informatiques-pour-evaluer-vos-competences/ #tutorial #training #course #onlinelearning

Master Claude for Excel in 10 Minutes: Financial Modeling

🎥 Master Claude for Excel in 10 Minutes: Financial Modeling Claude now has an Excel add-in, and it is surprisingly strong for financial modeling, Excel automation, and upgrading messy spreadsheets without writing formulas from scratch. In this video, I show you how to use Claude in Excel step by step. We cover: - how to install the Claude Excel add-in - how to build a financial model from scratch - how to upgrade an existing Excel model - best practices, limits, and when to use Opus vs Sonnet If you have been searching for Claude in Excel, Claude AI in Excel, how to add Claude in Excel, or Excel automation for finance, this video is for you. What you will learn 1. Install & Navigation - how to download and enable the Claude add-in for Excel - where to access Claude inside Excel - when to use Sonnet for quick tasks and Opus for advanced work 2. Build financial models from scratch - describe the business, not the spreadsheet - let Claude create assumptions tabs, formulas, linked model logic, and charts - generate a usable 24-month financial model without manually building every formula 3. Upgrade existing Excel models - add new assumptions to a current model - preserve existing formula dependencies - extend charts and outputs automatically - highlight specific cell ranges and ask Claude to explain or update them 4. Tips, limits, and best practices - prompt tips for Excel-specific tasks - how to ask for validation checks, like balance sheet controls - current limitations, including lack of VBA support and no saved session history Why this matters A lot of people gave up on AI inside Office because earlier tools did not deliver enough value. Claude is different. It is fast, practical, and genuinely useful for finance use cases, especially if you work with assumptions, scenarios, models, and spreadsheet analysis all day. Chapters 00:00 Introduction 00:40 Installation & Navigation 01:51 Build Models 05:03 Enhance Existing Models 07:01 Best Practices and Limitations Related topics - Claude Excel - Claude in Excel - Claude AI in Excel - Excel automation - Financial modeling - Excel tips - Anthropic Claude Excel If you want to go deeper after this, I recommend my video on Claude Skills, since the Excel add-in supports skills and they are one of the best ways to reuse strong workflows across your team. #ClaudeExcel #ClaudeInExcel #FinancialModeling #ExcelAutomation #ExcelTips #ClaudeAI #AnthropicClaude

What is Power Query and What is it For? | Save HOURS of Work 🤯 | Excel | Class 137

Power Query is one of the most powerful tools in Excel for transforming, cleaning, and automating your data without using macros or complicated formulas. In this video, you will learn what Power Query is, how it works, and what it really does when working with large volumes of information. 🔍 You will see in detail: How to import data from external files How to clean, transform, and combine tables Why Power Query is essential in an ETL (Extract, Transform, Load) workflow If you use Excel, Power Query will save you hours of work and allow you to work like a data analysis professional. Check out the Excel course online: 🌐https://eltiotech.com/curso-de-excel/ View the course in the Playlist https://www.youtube.com/playlist?list=PL1yslgETgkYHWZnyk9w5JyUTY6xkyKrov Power BI Course: https://eltiotech.com/curso-completo-de-power-bi/ VISIT OUR WEBSITES: 🔵 https://www.eltiotech.com 🔵 https://www.tiotech.net 📩 Join us on Telegram: https://t.me/eltiotech 📒 Join us on WhatsApp: https://whatsapp.com/channel/0029VaEaioE3mFYCM6e7jR33 FOLLOW US ON OUR SOCIAL MEDIA 🔴 TikTok: https://www.tiktok.com/@eltiotech_ 🔴 Instagram: https://www.instagram.com/luismiguelvelavela/ 🔴 https://www.facebook.com/eltiotechoficial

Professional Excel Dashboard Just in 10 Minutes (No VBA) #excel #dashboard

How I Build a Professional Excel Dashboard in 10 Minutes (Beginner Friendly) 🎯 Want to create excel dashboard from pivot table in just 10 minutes—even if you’re a complete beginner? In this step-by-step Excel tutorial, I’ll show you exactly how to create a professional dynamic interactive excel dashboard from scratch using Pivot Tables, slicers, and charts—no advanced formulas required. This video uses a realistic USA-based online course enrollment dataset, making it perfect for office workers, students, analysts, and anyone learning Excel for business. 📊 What you’ll learn in this Excel dashboard tutorial: ✔ How to organize raw data for dashboards ✔ Convert data into Pivot Tables the right way ✔ Design a clean, modern Excel dashboard layout ✔ Add interactive slicers and timelines ✔ Connect slicers to multiple pivot tables ✔ Create dynamic KPI cards (Total Revenue, Enrollments, Courses) ✔ Build professional Excel charts that update instantly ✔ Format dashboards for a polished, business-ready look By the end of this video, you’ll have a fully interactive Excel dashboard that responds instantly when you filter by course, state, category, or date—just like dashboards used in real companies. 👨‍💼 Who this video is for: ✔Excel beginners ✔Office workers & students (USA-based examples) ✔Business analysts & data analysts ✔Anyone preparing dashboards for reports or presentations 🧠 Excel skills covered: ✔Excel Dashboard Tutorial ✔Excel Pivot Tables ✔Excel Slicers & Timelines ✔Excel KPI Cards ✔Excel Data Visualization ✔Excel Charts & Formatting ✔Interactive Excel Reports ⏱ Time required: Just 10 minutes 🛠 Tools used: Microsoft Excel (No VBA, No Macros) 👍 If this video helped you, like the video, subscribe for more Excel tutorials, and comment “Part 2” if you want advanced Excel dashboards next. Thanks for watching—and keep improving your Excel skills! 🚀 Excel dashboard Playlist: https://www.youtube.com/playlist?list=PLOzcgkFA1mZ1WIYlYiK4ANvlau5p-Rh-v 🔔 Subscribe for more Excel Tips: https://www.youtube.com/@easyclicklearning?sub_confirmation=1 🔗 Connect with me: Facebook: https://www.facebook.com/profile.php?id=61567182173475&mibextid=ZbWKwL X (Twitter): https://x.com/JB5453 LinkedIn: https://www.linkedin.com/in/easy-click-learning-590945336 #exceltips #exceltricks #exceltutorial #microsoftexcel #excelforbeginners #easyclicklearning #exceldashboardstutorial #pivottable #excelformula #slicer

Interactive Modern Excel Dashboard Tutorial in 3 Steps - The 2026 Way!

Modern Excel Dashboard Most Excel dashboards rely heavily on Pivot Tables and slicers. What if you could build a clean, fully interactive dashboard without using either of them? In this video, you’ll see a modern approach to dashboard design that gives you more flexibility, better performance, and complete control over how your data behaves. I’ll walk you through how to structure your data, apply dynamic formulas, and use charts that respond instantly to user input. You’ll learn how to create interactivity using simple lists, making your dashboards feel more like a custom solution than a spreadsheet. This method is useful if you want lighter files, custom layouts, or dashboards that are easier to maintain and customize. You’ll have a repeatable framework you can use to build professional, modern Excel dashboards with confidence. 🕙 You can use these timestamps in case you are looking for something specific 00:00 - Introduction 00:09 - Sneak Peak at the Dashboard 01:18 - Creating self growing lists or dropdowns 04:16 - Creating a simple list 05:18 - Filtering data based on Category and Region 07:55 - Choosing the data based on metric 10:35 - Creating the dashboard summary data 12:15 - Creating charts for the dashboard 13:57 - Creating KPIs ▶️ Other videos that may interest you SORT Function in Excel https://www.youtube.com/watch?v=g_SWqu8uALc&list=PLv8u559jZTwCs9j3oK34EgC8K_88idOpm FILTER Function in Excel https://www.youtube.com/watch?v=csNtvctKJJQ&list=PLv8u559jZTwCyRCSOr23JtmLGsW4uIGdn&index=17 UNIQUE Function in Excel https://www.youtube.com/watch?v=qjz3p5l-erk&list=PLv8u559jZTwCyRCSOr23JtmLGsW4uIGdn&index=14&pp=iAQB INDEX & MATCH Functions in Excel https://www.youtube.com/watch?v=1-1QsR0_1Xw&list=PLv8u559jZTwA757sTE00J3VvzugpnSuII&index=11&pp=gAQBiAQB The # Symbol in Excel https://www.youtube.com/watch?v=n4nynITXCnA&list=PLv8u559jZTwCyRCSOr23JtmLGsW4uIGdn&index=27&pp=iAQB GROUPBY Function in Excel https://www.youtube.com/watch?v=4mFhlLbopmg&list=PLv8u559jZTwCs9j3oK34EgC8K_88idOpm&index=3&pp=iAQB0gcJCb4JAYcqIYzv VSTACK Function in Excel https://www.youtube.com/watch?v=HLL5u7k4ags&list=PLv8u559jZTwCs9j3oK34EgC8K_88idOpm Creating Names in Excel https://www.youtube.com/watch?v=pa8g1MV_rOU&list=PLv8u559jZTwCGdjaUmHf9u4iyfS6Mn7-N CHOOSE Function in Excel https://www.youtube.com/watch?v=BsaMcCr_Tok&list=PLv8u559jZTwCs9j3oK34EgC8K_88idOpm Tables or Structured References in Excel https://www.youtube.com/watch?v=teKGYz1PHVY&list=PLv8u559jZTwD8opjsLdLZ_caz0CBYF1Ld Dashboard in Excel using Pivot Tables and Slicers https://www.youtube.com/watch?v=5SOdGplty6I&list=PLv8u559jZTwCrogeKH0z9qCl8TLHuSilL ✅ Subscribe to our Channel to level up your Excel and Power BI skills faster https://www.youtube.com/@analyticssuccess?sub_confirmation=1 ⬇️ Download the file used in the video https://www.qling.net/11174/files/6953a81eaf120_1767090206_modern-excel-dashboard-xlsx.zip 💻 Courses offered by us Learn more about our Excel Masterclass course https://yt.qling.net/excel-masterclass Explore all courses https://yt.qling.net/courses 📘 Download our E-Book on Excel Shortcuts (Windows and Mac) https://yt.qling.net/excel-shortcuts 🗂️ Access all our templates and E-Books https://yt.qling.net/templates-and-ebooks 🤝 Connect with us LinkedIn: http://www.linkedin.com/company/qling1 Facebook: http://www.facebook.com/learnatqling Instagram: http://www.instagram.com/learnwithqling Pinterest: http://www.pinterest.com/learnatqling/ Get in touch: https://quiz.qling.net/get-in-touch/ #analyticssuccess #dashboard #excel #ExcelDashboard #excelhacks #exceltips #msexcel #sheets

Financial Modeling

This EXCEL FUNCTION is usually BETTER than =VLOOKUP & =XLOOKUP

With this function, you are no longer dependent on references in Excel in many situations and can build your spreadsheets more efficiently and intelligently. Sections: 00:00 Introduction 00:22 Data source 01:28 Solution with references 03:45 Transforming tables 04:39 Building a data model 06:01 Linking tables 07:40 Generating reports 10:49 Outro

The Ultimate Excel Dashboard: Visualize Data Like a Pro

💥 $50 OFF My Dashboards Course (code: SAVE50) 👉 https://chandoo.org/wp/excel-school-program/ ~ Become an Excel Dashboard PRO with this hands-on tutorial. Learn how to think like a business analyst, create KPIs, set up calculations, use pivot tables, slicers and build interactive charts + maps to create this dynamic business dashboard in just 30 minutes. This is the perfect end to end Excel project for a data analyst. ⭐ What you will learn: 1) How to set up the data for your dashboard in Excel? 2) What KPIs and business questions to address with the dashboard? 3) How to use Pivot Tables to build the "calculation engine" for your Excel dashboard 4) Storytelling with "summary" & "detail" approach 5) Building dashboard canvas with shapes and formatting in Excel 6) Creating various kinds of charts with Excel 7) Formatting charts so they look professional and slick! 8) Setting up Map Charts in Excel 9) Using Picture Links to create grids in dashboard 10) Interactive dashboards with slicers 11) Dashboard theming with Page Layout options 12) Storytelling with strong & insightful titles for your charts 🕐 Topic-wise timestamps: 0:00 - Master Excel Dashboards in 26 Minutes (intro) 1:36 - Data for our dashboard 2:34 - KPIs and business questions for our dashboard 3:32 - Analysing data with Excel - Formulas vs. Pivots 4:00 - Calculated columns in our data 4:42 - Creating Pivot Tables for our dashboard 5:55 - Display format for the pivot values 6:18 - Dashboard Sheet Setup 8:24 - Building the Dashboard Side-panel (for summaries) 10:46 - 13 Week Sales Trend Graph 12:15 - Purchase Patterns Grid Chart (Picture Links) 14:49 - Quantity Distribution Chart (Pivot Grouping!) 16:23 - Most Popular Products Chart 18:02 - Map chart to see Geographic Trends 20:02 - Days to Delivery Chart 20:20 - Customer Satisfaction Chart 21:46 - Slicers for Dashboard Interactions! 26:18 - Adding Chart Titles 27:01 - Dashboard Theming (colors) with Page Layout options 28:44 - Closing Remarks (where to go from here) 📂 Download Sample Data: Grab the sample file from here and build your own dashboard: https://chandoo.org/wp/wp-content/uploads/2025/11/ecommerce-blank.xlsx 🧑‍💻 Learn more Join my Excel School program and learn how to build world-class dashboards with Microsoft Excel. Use the coupon code SAVE50 to get $50 discount on the course. Visit https://chandoo.org/wp/excel-school-program to enrol. ~ #excel #exceldashboard #dashboard

You Don't Need VLOOKUP & XLOOKUP, You Need This | Excel

Start using a better alternative to the XLOOKUP and VLOOKUP functions in Excel. 👩‍🏫 Learn more about the Power Pivot and DAX in my course: https://bit.ly/lookups25course ⬇️ Download the example file here and follow along: https://bit.ly/lookups25file VLOOKUP or XLOOKUP are probably the first formulas you reach for when you need to pull data from one sheet to another in Excel. They work great on small tables, but the moment your file grows, they can slow everything down because they duplicate data. I'm going to show you exactly why the pros have moved beyond lookup formulas, and the alternative that will change how you work with data forever. LEARN MORE =========== 📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum #Excel #ExcelFormulas #ExcelFunctions

Financial Modeling from Scratch

📊 FINANCIAL MODELING FROM SCRATCH — STEP BY STEP FOR FINANCE PROFESSIONALS If you want to learn financial modeling from scratch and master one of the most important skills for those working (or wanting to work) in FP&A, Controllership, Valuation, M&A, Private Equity, and Financial Analysis, this class is for you! In this video, we will show you, in practice: ✅ The ideal structure of a professional financial model ✅ How to set assumptions and drivers ✅ How to project Income Statement, Cash Flow, and Balance Sheet ✅ Logical connections between the statements ✅ Scenario building Everything explained clearly, objectively, and with real examples for you to apply in your professional day-to-day. 📌 By the end of this class, you will be able to start your own modeling and understand the key concepts behind companies' financial decisions. Download the spreadsheet for this class by clicking the link below: https://bit.ly/4qESKdl Visit our website and gain access to the most comprehensive training in the market ➡ https://fpanapratica.com.br/ 🚀 Our Instagram profile: https://www.instagram.com/fpanapratica/ 🔥 Our LinkedIn profile: https://www.linkedin.com/in/fpanapratica/ 🎈 Chat with us on WhatsApp: https://bit.ly/47O0gcn

Excel Agent Mode: Build Dashboards Automatically (Step-by-Step Tutorial)

Tired of struggling with PivotTables, charts, and slicers to build dashboards in Excel? Thanks to Excel’s brand-new Agent Mode (aka Excel’s “AI Beast Mode”), creating an interactive dashboard has never been easier. In this step-by-step tutorial, I’ll show you how to use Agent Mode inside Excel Labs to automatically build a dashboard from raw data — no advanced skills required. You’ll see how to: - Turn your data into an interactive, refreshable dashboard - Add charts, KPIs, and slicers with just a prompt - Refine your dashboard with natural language requests - Understand how Agent Mode compares to Copilot By the end, you’ll know how to transform a wall of numbers into clear insights with just a few clicks. Host: Kevin Stratvert 📚 RESOURCES - All you need is a Microsoft 365 subscription and a Copilot license. - Try it today in Excel on the web at https://www.excel.new - Sample data: https://kevstrat-my.sharepoint.com/:x:/g/personal/admin_kevstrat_onmicrosoft_com/EeHsBt_uSKtAqtzyaxQ7HC8BBkOdFF0Qe51b3bK2z_4kVw?e=y36W00 ⌚ TIMESTAMPS 00:00 - Introduction 00:38 - Turn data into a table for easy handling 01:26 - Enable Agent Mode with Excel Labs add-in 02:01 - Write a prompt to build a dashboard 03:19 - Review formulas, steps, and insights from Agent Mode 04:25 - Explore KPI summary and product breakdown 04:56 - Update source data and watch dashboard refresh 05:45 - Add a slicer to filter dashboard by cookie type 06:50 - Format dashboard: hide gridlines, headings, sheets 07:34 - Share your dashboard with others 07:42 - Closing thoughts 📺 RELATED VIDEOS - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://newsletter.kevinstratvert.com 🔽 CONNECT WITH ME - Official website: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr ✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline ✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb ✅ 📈 Semrush | https://bit.ly/semrush14dayfreetrial ✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert #agentmode #excel

Create Professional Excel Dashboard in just 10 Minutes || Interactive & Dynamic #excel #dashboard

We're bringing you the best Excel tips and tricks to help you become a spreadsheet expert! Don't forget to hit that like button to show your support for our content! #msexcel #exceltips #exceltricks #excelhacks #spreadsheets #msexceltutorials #exceltutorials #sheets

Power Query was HARD until I learned these 7 Tips

Power Query is an amazing feature of Excel that can save us a ton of time with our jobs. But for most people, it's not very approachable and can be a bit overwhelming when you get started. So in this video, I share 7 tips that I wish I had known sooner when learning Power Query. This includes an overview of what Power Query is and when to use it in your workflows. Along with tips for preventing errors and getting the most out of this fantastic Excel feature. 🔗LINKS 🎓 Power Query Jumpstart Course: https://www.excelcampus.com/power-query-jumpstart-course/ 🎓 Power Query Pro Course: https://www.excelcampus.com/the-power-query-pro-course-fb DOWNLOAD the Excel File ► https://www.excelcampus.com/powerquery/power-query-made-easy/ 🔎 Get free weekly Excel tips: https://www.excelcampus.com/newsletter/ 💡 Free 60-minute Excel training session: https://www.excelcampus.com/blueprint-masterclass/ 00:00 Introduction 00:18 Excel's Best Kept Secret 03:16 Your Personal Time Machine 04:48 The Biggest Cause of Errors 06:43 Choosing the Correct Ribbon Tab 07:35 I'm not sure which Button to Click?? 08:47 The Secret Language Behind Your Clicks 09:54 The Most Powerful Button in Power Query?

XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)

Want to learn XLOOKUP? You have come to the right place. "XLOOKUP is probably the most powerful XL function" - my grandma How to use XLOOKUP? =XLOOKUP( value you want to find, in the column where your data is, specify the column you want as a result) XLOOKUP Example 1: =XLOOKUP( "Richard", B8:B42, H8:H42) XLOOKUP Example 2: =XLOOKUP( "EMP1012", C8:C42, B8:B42, "Person not found") Why use XLOOKUP? XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions. In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel. The video explains: ✅ How to use XLOOKUP? ✅What happens when XLOOKUP can't find the value? ✅XLOOKUP and returning the entire row ✅XLOOKUP with two sheets More Excel XLOOKUP examples and explanation: Read my detailed XLOOKUP article for full information - https://chandoo.org/wp/xlookup-examples/ XLOOKUP Sample file - https://chandoo.org/wp/wp-content/uploads/2025/07/xlookup-howto.xlsx XLOOKUP Advanced Techniques (10 powerful examples) - https://youtu.be/YyhJe5tMq58 I stopped using VLOOKUP, here is why - https://youtu.be/DDlZXXEI1bU ~ =XLOOKUP("best day ever", days, you) #xlookup #excel

How to Create the Perfect Dashboard in Excel – The Most Detailed Guide

Learn how to create a professional, efficient, and visually appealing dashboard in Excel from scratch! This step-by-step tutorial will guide you through every stage: data preparation, visualization setup, and final touches. Perfect for beginners and advanced users alike! DOWNLOAD Free Excel file for this video: https://goo.su/NUIbC 00:00 - Intro 01:20 - Preparing the Foundation for the Dashboard 11:44 - Sales Chart by Month 21:03 - Sales Chart by Region 24:32 - Sales Chart by Quarters 29:55 - Pie Chart of Sales by Product Subcategories 38:26 - Sales Charts by Product Categories 47:49 - Sales Charts by Segments 54:35 - Sales Ranking by Cities 01:08:43 - Setting Up Relationships Between Different Tables 01:17:18 - Setting Up Conditional Formatting 01:19:57 - Nuance of Interaction Between Objects and Cells 01:20:52 - Excel Chart in the Form of a Speedometer 01:28:20 - Displaying Key Metrics 01:38:54 - Formatting Slicers 01:42:56 - Setting Up City Rating Toggles 01:47:55 - Final Dashboard Setup #excel #dashboard #dashboardinexcel #exceltutorial #exceldashboard

Top 20 Most Important Functions in Excel | Practical Examples Essential Formulas 🏆🥇

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcelente 🔵FREE EXCEL SPREADSHEET DOWNLOAD: https://excelentejoao.com.br/wp-content/uploads/2025/03/20-FORMULAS-Pas4D2tiE9c.xlsx In this Excel tutorial, we will learn how to use the 10 most important functions in Excel. Or rather, the most important formulas in Excel with 10 practical examples from everyday life that can help you in the job market and save time. There are many functions in Excel that help us automate tasks and processes. In this free Excel tutorial, we will see several of these formulas and functions in the Excel spreadsheet. 00:00 SUBSCRIBE TO THE CHANNEL 00:25 LIKE THE VIDEO 00:55 SUM 07:40 SUMIF 10:55 VLOOKUP 15:45 XLOOKUP 18:03 DATEDIF 22:07 IF 24:31 AND 28:51 OR 33:03 AVERAGE 34:22 AVERAGEIF 36:23 LEN 39:33 COUNTA 41:29 COUNTBLANK 43:17 COUNTIF 44:31 TODAY 46:46 TEXT 50:29 EOMONTH 53:08 MAX 55:24 MIN 56:39 TRIM The SUM function adds up the values in a range of cells. The COUNTA function counts the number of non-empty cells in a range of cells. The COUNTBLANK function counts the number of empty cells in a range of cells. The AVERAGE function calculates the average of the values in a range of cells. The MIN function finds the smallest value in a range of cells. The MAX function finds the largest value in a range of cells. The VLOOKUP function looks for a value in an array and returns the corresponding value from another array. The IF function returns one value if a condition is true and another value if the condition is false. The SUMIF function adds up the values in a range of cells that meet a specific condition. The COUNTIF function counts the number of cells in a range that meet a specific condition. XLOOKUP searches for a value in an array or table and returns a corresponding result from another column or row, functioning more flexibly than VLOOKUP and HLOOKUP. DATEDIF calculates the difference between two dates in years, months, or days, useful for determining age or the time between dates. AVERAGEIF returns the average of values in a range that meet a specific criterion. LEN counts the number of characters (including spaces) in a cell. TEXT formats a numeric value or date as text, allowing for format customization. EOMONTH returns the date of the last day of the month, allowing you to add or subtract months from a starting date. TODAY returns the current system date and is automatically updated. OR checks if at least one of the conditions is true and returns TRUE or FALSE. AND checks if all specified conditions are true, returning TRUE only if all are met. TRIM removes extra spaces in a text, leaving only one space between words. #ExcellentJoão #Excel #Dashboard

How to use XLOOKUP Function in MS Excel | XLOOKUP Formula in Excel

In this video we will learn to use XLOOKUP Function with multiple examples in Microsoft Excel step by step #xlookup #xlookupfunction #xlookupformula #excelxlookup #excelxlookupformula #excelxlookupfunction #xlookupinexcel #xlookupformulainexcel #xlookupfunctioninexcel #advanced_excel #excelformulas #excelfunctions #exceltips #exceltricks #exceltipsandtricks #microsoftexcel #exceltutorials #microsoft_excel_tutorial #studyspan Music: Outside Musician: @iksonmusic Thank you

How To Apply VLOOKUP and XLOOKUP formula on Big Data in Excel in Bangla

How To Apply VLOOKUP and XLOOKUP formula on Large / Big Data in Excel ✅ আমার কোর্স সম্পর্কে জানতে Whatsapp করুনঃ +8801515-629158 ✅আমার সকল কোর্সের বিস্তারিত এখানেইঃ https://rayhantanjimtech.com/ In this video, you will learn how to use VLOOKUP and XLOOKUP formulas in Excel to search for data in large datasets. These formulas help you find information quickly and easily. 🔹 What you will learn: ✅ How to use VLOOKUP in Excel ✅ How to use XLOOKUP in Excel ✅ Best method for searching big data ✅ Easy tips to avoid errors This tutorial is perfect for beginners and advanced users who work with large Excel files. Watch the full video and improve your Excel skills! 📌 Don't forget to LIKE, SHARE, and SUBSCRIBE for more Excel tips! #Excel #VLOOKUP #XLOOKUP #ExcelTips #BigData #microsoftexcel 00:00 What is Vlookup? 01:20 How to apply Vlookup with Match Function in Excel 06:16 How to Use Xlookup in Excel Demo File: https://docs.google.com/spreadsheets/d/1WlnVq35Zxhao4ab-eqVUZiAXCw-4NO4o/edit?usp=sharing&ouid=108709163563404706634&rtpof=true&sd=true

Turn Raw Data into a Clear, Interactive Dashboard in Excel

Ready to transform your spreadsheets from ordinary to extraordinary? In this tutorial, you’ll learn how to take raw, unorganized data and turn it into a dynamic Excel dashboard—complete with PivotTables, interactive charts, and slicers for real-time filtering. Follow along step by step and discover how to structure your data, apply must-know Excel features, and design a dashboard that’s both informative and visually striking. Whether you’re a beginner or an Excel enthusiast, this guide will help you unlock the power of data storytelling—no coding required. Practice Data 2023-2024: https://go.teachers.tech/Dashboard_Data Practice Data January 2025: https://go.teachers.tech/Dashboard_2025 What You’ll Learn: PivotTables – Effortlessly summarize sales, expenses, or any metric with flexible groupings. Charts & Graphs – Choose the right visualizations to convey your story at a glance. Slicers – Create clickable filters so anyone can drill into details in seconds. Layout & Design Tips – Make your dashboard easy on the eyes while spotlighting key insights. By the end, you’ll have a professional-looking Excel dashboard that can impress clients, managers, and colleagues alike. Learn more about PivotTables in Excel: https://youtu.be/Jx89DRlKe7E Learn more about Charts in Excel: https://youtu.be/64DSXejsYbo New to Excel? Start here: https://youtu.be/p_NvzCJ31D0 0:00 Intro 0:39 Get practice data 1:04 Create table 1:51 Create1st Pivot Table 4:09 Create Chart 5:07 Add Slicer 5:57 Create 2nd PivotTable, Chart and Slicers 8:57 Create 3rd PivotTable, Chart and Slicers 11:04 Create dashboard sheet and move charts and slicers 12:46 Slicer formatting 15:26 Layout and design 21:55 Adding new data and refreshing dashboard

How to Use XLOOKUP in Excel – Step-by-Step Tutorial for Beginners

Discover how to master XLOOKUP in Excel with this beginner-friendly tutorial! If you’ve been searching for a modern alternative to VLOOKUP, XLOOKUP is here to simplify your workflows. This video breaks it down step-by-step, making it easy to follow along and upgrade your Excel skills. First, we’ll introduce the XLOOKUP function by showing how it can replace manual entry for filling in order amounts. Next, you’ll learn how to enter the formula, including the lookup value, lookup array, return array, and optional parameters like "if_not_found" and match modes. Then, we’ll explore the formula help tool, using the Fx icon to get insights into function parameters and preview results. After that, we’ll show you how to fill the formula down across rows, using absolute references to lock key cells. Next, we’ll tackle the issue of adding rows by converting data to table references, ensuring your formula remains dynamic. Finally, we’ll demonstrate how to use XLOOKUP for horizontal lookups, perfect for transposed data like monthly reports. By the end of this Excel tutorial, you’ll have the skills to confidently use XLOOKUP. Ready to dive into the Excel app and see why it’s the big brother of VLOOKUP? Hit play and follow along! Host: David DeWinter 📚 RESOURCES - Download the practice workbook to follow along ➜ https://kevstrat-my.sharepoint.com/:x:/g/personal/david_kevstrat_onmicrosoft_com/EWtYn3QY2U9BsKPYzOLpghcB1vmNQD-nWc70MxhJ64fJyw?rtime=ffCXuX063Ug ⌚ TIMESTAMPS 0:00 - Intro: Master XLOOKUP in Excel 0:53 - #1: Entering the XLOOKUP Formula 1:38 - #2: Understanding lookup_array and return_array 2:30 - #3: Tackling if_not_found, match_mode, search_mode 4:24 - #4: Using Formula Help for Parameters 4:50 - #5: Copying XLOOKUP Across Rows 6:15 - #6: Horizontal Lookup with XLOOKUP 7:57 - A Final Question for You 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ 🔽 CONNECT WITH ME - Official website: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎁 TOOLS AND DISCOUNTS ✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY ✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM ✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL ✅ 📹 CapCut | https://bit.ly/installcapcut ✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa ✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax ✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry ✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr ✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline ✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb ✅ 📈 Semrush PRO | https://bit.ly/semrush14dayfreetrial ✅ 📈 Semrush GURU | https://bit.ly/semrushguru14daytrial ✅ 📈 Semrush ContentShake AI | https://bit.ly/contentshakeaisemrush ✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx ✅ 🏓 Smartsheet | https://bit.ly/trysmartsheet 🎒 MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert #xlookup #excel

✅Top 15 Formulas of Excel | Advance Excel 2025

Master These 15 Essential Excel Formulas Today Advanced formulas in Excel are more complex functions used to perform in-depth calculations, analyze data, and automate tasks. They go beyond basic functions like SUM or AVERAGE and include formulas like VLOOKUP, INDEX-MATCH, IFERROR, and nested functions. These formulas allow you to look up data across sheets, apply conditional logic, manipulate text, perform date calculations, and handle large datasets more efficiently. Mastering advanced Excel formulas helps streamline workflows, uncover trends, and make smarter, data-driven decisions. ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖ 👉Download the Practice file - https://t.me/accounts_experts/49 ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖ Time Stamps: 02:30- Vlookup 14:19- Xlookup 18:29- index + match 26:46- Filter 30:15- Dget 32:09- Dsum 34:33-Large and small 36:10- Sequence 38:23- Sumifs 41:51- Flashfilll 44:51- Workdays and workdays.intl 47:19- Networkdays and Networkdays.intl ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖ Course Details: 🌐 Checkout Our Website: https://accountsexpertapp.com/ ⬇️Install our App : https://play.google.com/store/apps/details?id=co.tarly.wugze ⏰ Course Start Date: 10th February 2025 ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖ 🌐Website Link : accountsexpertapp.com 📞What's App - @8804949888 📧Email: learnonline.expert@gmail.com ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖ Check out my previous videos Playlist : • Live Excel Basic Classes: https://www.youtube.com/playlist?list=PLQbpZef8wZYGexvMPog6ATui6qFkE1arO • Advanced Excel Techniques Playlist: https://www.youtube.com/playlist?list=PLQbpZef8wZYFg4398S7TMqa_Vbt_H_BEg • Tally Live Course Playlist: https://www.youtube.com/playlist?list=PLQbpZef8wZYGCQXbQZZA-B4vnZl-8QIDa • SAP Live Course Playlist: https://www.youtube.com/playlist?list=PLQbpZef8wZYEo3VlmBVk4KxDw5vJyP3_r ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖ 📣Want to connect with me? Check out these links:📣 ⭐Telegram Link - https://t.me/+Udg6wWtErrhkMTU1 ⭐Instagram Link - https://www.instagram.com/accounts_expertt/profilecard/?igsh=MXU2aXY4czZib3dpaA== ⭐Facebook - https://www.facebook.com/accountsexperrt ⭐LinkedIn - https://www.linkedin.com/in/accounts-expert-017478348/ ⭐What's App - https://wa.me/8804949888?text= ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖ #powerbi_training #powerbi #powerbishorts #excel #msoffice #motivation #dashboard #motivation #youtube #accounting #tally #sap #advancedexcel #automobile #autoexcel #exam #dashboard creation #advance #new #powerbi #powerbi_training #powerbishorts

Part 1/9 - Learn Financial Modeling in Excel - Step by Step (By Ex-JP Morgan Analyst)

📥 DOWNLOAD THE FILE TO FOLLOW ALONG: Free Financial Modeling Excel Template & Case Study: https://tinyurl.com/wsm-fm-template Welcome to the 9 part video series on Financial Modeling in Excel. Here, you will learn to create Financial Models in 9 Easy Steps with ex-JPMorgan and CLSA equity analyst. As the first step, you will learn how to create the initial structure for a Financial model in Excel. Timestamps: 00:00-00:52 Introduction 00:52-05:10 Steps Overview 05:10-06:50 Apex Solutions 06:50-07:28 Your role as an Equity Research Analyst 07:28-10:44 Step 1 - Creating the Structure 10:44-13:06 Industry practice for color-coding the data 📥 DOWNLOAD THE FILE TO FOLLOW ALONG: Free Financial Modeling Excel Template & Case Study: https://tinyurl.com/wsm-fm-template

Automatically Color Entire Row Based on Status | Conditional Formatting Excel

🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcelente In this Excel tutorial, we will learn how to automatically color an entire row in an Excel spreadsheet. Automatically Color Entire Row Based on Status. Change the color of the entire row, change the color of the whole row in the Excel table. To do this, we will use one of the most important features of Excel, which is conditional formatting. Conditional formatting, as the name suggests, formats a cell or a range based on a condition. So, for example, let's say you have a sales spreadsheet in Excel, and you want to automatically color all sales greater than R$100, highlighting the cells in green, for instance. Conditional formatting can automate this task for you. You can automatically color the entire row whenever a criterion is true. You can also use conditional formatting to color either just one cell or multiple cells at once. Whether it's an entire row in the Excel spreadsheet or an entire column in the Excel spreadsheet or other specific ranges of cells. Conditional formatting is an excellent tool and a great feature in Excel that can help us a lot in our daily tasks and also to automate repetitive tasks and processes. #ExcellentJoão #Excel #Dashboard

The NEW Point in Excel Changes Everything (Update 2025)

► Subscribe to the channel: https://bit.ly/jakobnbr ► Excel Academy: https://neugewinn.de/excel In this video, I show you the new update of Excel 2024 to limit references to "filled" cells. Absolutely brilliant, and currently only available as a Beta Insider. ▬ More Videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Create a Database in Excel https://youtu.be/XG9nU2N-oqk ► Professional Dashboards in Excel https://youtu.be/Eddh6ffIQBw ► The Most Important Excel Functions https://youtu.be/KfMUdw0XBbw ▬ About This Channel ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Excel Course: https://neugewinn.de/excel ► Subscribe to my channel: https://bit.ly/jakobnbr ▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 Intro 00:23 New Feature 03:18 Dropdown Improvement 04:55 Get the Update 05:32 More Examples 07:07 Summary of the Feature

Introduction to Power Query in Excel | Malayalam Tutorial | Part 1

എക്സലിന്റേയും, പവർ ബി.ഐ യുടെയും ഭാഗമായ പവർ ക്വറി പഠിക്കാം, ഡേറ്റ അനലിസ്റ്റ് ആകാം. Power Query Tutorial for Beginners, explained in Malayalam - Part 1 🎯 എക്സലിൽ Beginner ആണോ? Step-by-Step ആയി Professional ലെവലിലേക്ക് എത്താൻ സഹായിക്കുന്ന എന്റെ Microsoft Excel Course (മലയാളം): https://www.udemy.com/course/microsoft-excel-beginner-to-professional-malayalam/?referralCode=592DD7352D466992D4CB Subscribe to @AjayAnandXLnCAD for more. http://www.youtube.com/c/AjayAnandXLnCAD 📘 Microsoft Word Online Course (മലയാളം) 👉 കോഴ്സിന്റെ വിശദാംശങ്ങളും നിലവിലെ ഓഫർ വിലയും അറിയാൻ ഇവിടെ ക്ലിക്ക് ചെയ്യൂ: https://www.udemy.com/course/learn-microsoft-word-in-malayalam/?referralCode=7C4B9E5DA75070465BD0 #powerquery #malayalamtutorial #powerbimalayalam

[1/4] Power Query Training — The Basics You Need to Know!

🚨 Test your level on Power Query (with answers) and receive exclusive resources 🎯 ➜ https://www.morpheus-formation.fr/blog/test/power-query/ 🎁 Follow our free training on Power Query → https://www.morpheus-formation.fr/power-query/ 🏆 Power Query training eligible for CPF – Up to 100% funded, all levels, 100% personalized → https://www.morpheus-formation.fr/formation/excel/power-query/ Discover the 3 other chapters of our free Power Query training: 👉🏻 Part 2/4: https://youtu.be/-BGJ3NVa7HI 👉🏻 Part 3/4: https://youtu.be/gF1u7CKhS-8 👉🏻 Part 4/4: https://youtu.be/sc9S0SlP8ZQ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🎓 TRAINING: ⇢ Free Power Query Training: https://www.morpheus-formation.fr/power-query/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ✅ Welcome to the first part of our free training on Power Query! You will discover and learn to use this tool that transforms the way we work with data. If you want to go further in the training, feel free to inquire at this link where everything will be explained: https://www.morpheus-formation.fr/formation/excel/power-query/ 💡 Summary 00:00 : Intro 01:59 : What is Power Query for? 02:33 : Why use Power Query? 03:59 : Getting to know the interface 06:36 : Connecting to a data source 10:38 : Basic features of Power Query 25:35 : Closing and Loading data 28:42 : Outro #powerquery #excel #training

Try The DGET Function Instead of INDEXMATCH & XLOOKUP

DGET function Excel tutorial and why it's a great alternative to lookup functions! 👉 Take our Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free DGET Excel file for this video: https://careerprinciples.myflodesk.com/drpsgpln5a DGET Function: You've probably never heard of the DGET function, yet it's just as useful as the VLOOKUP, XLOOKUP or INDEX MATCH. So we'll compare the DGET function to these 3 super popular lookup functions and also look at how it's better than each of them in specific scenarios. The DGET function also has a built-in wildcard feature, and OR condition, which you'll learn more about in this DGET formula tutorial. LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ DGET vs VLOOKUP 2:17​ - DGET vs INDEX MATCH 4:22​ - DGET vs XLOOKUP 7:15​ - DGET Wildcard Feature 8:59​ - DGET OR condition 10:06​ - DGET Limitations

How to create an excel dashboard? Excel dashboards and reports!

How to create an excel dashboard? Excel dashboards and reports! ✅ Live Courses: https://www.tanviracademy.com/live-courses ✅ Video Courses: https://www.tanviracademy.com/recorded-courses 📧 For Business Inquiries: tanvirrahamanbd@gmail.com 🔗 For any help: https://www.facebook.com/groups/tanviracademybd/ 🔗 Like our Page: https://www.facebook.com/tanviracademybd 🔗 LinkedIn ID: https://www.linkedin.com/in/tanvirrahaman/ 🔗 My Others Channel: www.youtube.com/@TanvirRahamanbd 🔗 Visit our Website: https://www.tanviracademy.com/ Practice File: https://docs.google.com/spreadsheets/d/1iA92YnnOnpyjMjsNnWbuVvDrUMj9sAzV/edit?usp=sharing&ouid=108820028326812696043&rtpof=true&sd=true #exceldashboard #exceltutorial #tanviracademy #excelbangla #excelbanglatutorial

How to create a Dashboard in Excel in Tamil

In this step-by-step tutorial, we'll guide you through building a dynamic and interactive sales dashboard in Excel. Learn how to effectively organize and analyze your sales data with pivot tables, visualize key metrics with charts and graphs, and add interactivity with slicers. Perfect for beginners and advanced users alike, this video will help you transform your raw data into insightful and actionable business intelligence. Watch now and take your Excel skills to the next level! Stay Connected: https://www.instagram.com/end_less_knowledge https://www.facebook.com/enlessknowledge https://whatsapp.com/channel/0029Va5iya9Lo4hbtSeVie3Z https://twitter.com/EndlessKnowled1 https://www.threads.net/@end_less_knowledge #dashboard #exceldashboard #excel #exceltutorial #endlessknowledge

Make a Stunning Excel Dashboard in 5 Simple Steps!

In this video, you will learn how to create a dashboard in Excel in just 5 simple steps. First, we will learn how to create charts for your dashboard in seconds using the Analyze Data tool. Once we've inserted the charts we want to include in our dashboard, we will show you how to build a stunning dashboard in Excel to visualize insights and make data-driven decisions. 📖FREE RESOURCES - FREE EXCEL SHORTCUT GUIDE (PC): https://excel-dictionary.com/pages/free-mini-excel-shortcut-guide-website -FREE EXCEL SHORTCUT GUIDE (MAC): https://excel-dictionary.com/pages/mini-mac-excel-shortcut-guide -FREE EXCEL FUNCTION GUIDE: https://excel-dictionary.com/pages/free-excel-function-guide 🤓SHOP EXCEL DICTIONARY - COURSES: https://excel-dictionary.com/collections/courses -GUIDES: https://excel-dictionary.com/collections/e-books -MERCH: https://excel-dictionary.com/collections/merch -TEMPLATES: https://excel-dictionary.com/collections/templates 📩NEWSLETTER -Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subscribe 📺SUBSCRIBE -Subscribe to never miss a video: https://www.youtube.com/c/ExcelDictionary 🕰️TIMESTAMPS '0:00 Intro '0:29 Insert Charts For The Dashboard '1:22 Step 1: Select Background Color '1:47 Step 2: Insert A Shape '2:20 Step 3: Format The Shape '2:53 Step 4: Send Shape To Back '3:02 Step 5: Format The Chart '3:35 Wrap up #excel #exceltips #tutorial

How to Use VLOOKUP, HLOOKUP, XLOOKUP || Detailed Explaination with examples || Advance Excel Formula

#ExcelWithAI #Excel #AIExcelSkills #ExcelTips #ExcelMastery #AI #AIExcelHacks #Excel #30DayChallenge #ExcelWithAIChallenge #youtube #youtubeshorts #basic #excel #microsoftoffice #trendingshorts #trendingshorts #trendingvideo #artificialintelligence #computer #vlookup #hlookup #xlookup #lookup #advanceexcel

Basic Power Query Course - Lesson 1 - Introduction to Power Query

CLICK HERE TO LEARN MORE ABOUT THE COMPLETE POWER BI IMPRESSIONADOR COURSE: https://lp.hashtagtreinamentos.com/esperapbiimpressionador?origemurl=hashtag_yt_org_saibamaispbi_2FT7MDDREwg TO DOWNLOAD THE FREE POWER BI MINI COURSE: https://pages.hashtagtreinamentos.com/inscricao-minicurso-power-bi?origemurl=hashtag_yt_org_minicursopbi_2FT7MDDREwg Tutorial to INSTALL POWER BI FOR FREE: https://youtu.be/YO1Tn1z2grE ----------------------------------------------------------------------- ► To Download the Files Used, Access: https://pages.hashtagtreinamentos.com/arquivo-pbi-1yiqX1VNiZO7u6hjjmuU6UimDiLm0OktZ?origemurl=hashtag_yt_org_planilhapbi_2FT7MDDREwg ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/curso-basico-de-power-query-power-bi ----------------------------------------------------------------------- TO HIRE HASHTAG FOR YOUR COMPANY: https://www.hashtagtreinamentos.com/treinamentos-corporativos?fonte=yt ----------------------------------------------------------------------- Hello Impressionadores! Today we will start the Basic Power Query Course! This is a course for you to understand the importance and how to use Power Query in Power BI to create your projects. In this first lesson, we will have a brief introduction to Power Query so that you know how to import the database, how to process data in Power Query. This part of processing the database is very important, as it ensures that your information is all correct when presenting your dashboard, making it an essential step in any project. I will show you some important tools and steps within Power Query so that you have a minimally adjusted database. We will see how to delete a column in Power Query (remove unnecessary information), how to delete rows in Power Query (empty rows that may hinder analysis). I will show you how to adjust the column headers, how to split a column in Power Query (to separate information and perform more detailed analyses), I will talk about applied steps in Power Query (which is a history of your actions within the program). To finish, I will teach you how to use the example column tool in Power Query (to separate information automatically using some examples). ----------------------------------------------------------------------- Recommended Videos: ► How to Start from ZERO in POWER BI in just ONE LESSON https://www.youtube.com/watch?v=UFGe25gydxo ► Power BI Course - Lesson 01 - First Steps in Power BI https://youtu.be/wtpstMZwozs ► Power BI Course - Lesson 0 - First Steps in Power BI https://www.youtube.com/watch?v=YO1Tn1z2grE ► Power BI Course - Lesson 02 - Manipulating Texts and Values in the Database https://youtu.be/bUqWTfqBJIs ► ANIMATED BAR CHART RACE in Power BI https://www.youtube.com/watch?v=UbM5SlMIcJo ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click the bell)! ► Like our video! ----------------------------------------------------------------------- Social Media ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-tVurdUw ► Tik Tok: https://bit.ly/3dUpwkW To receive daily content on Excel, VBA, and Microsoft Power BI for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-tVurdUw In our videos, we teach various Power BI tips and tricks so that you can impress using this tool in the job market! ----------------------------------------------------------------------- Lesson Content 00:00 Introduction 01:02 What is the purpose of Power Query? (BI Process) 04:58 Understanding the Database 07:28 Importing the Database (Transform Data) 10:10 Opening the Database in Power Query 10:47 What is Power BI and what is Power Query? 11:50 What do we need to edit in Power Query? (Data Processing) 12:38 Deleting Columns in Power Query 13:17 Deleting Rows in Power Query 16:01 Adjusting the Column Headers 17:41 Splitting a Column in Power Query 22:08 Replacing Values in Power Query 23:55 Applied Steps in Power Query (history) 26:26 Example Column in Power Query 29:34 Example Column (more complex cases) 31:18 Saving the file (sending to Power BI) 32:25 Conclusion #powerbi #pbi #hashtagtreinamentos

How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel

How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel #excelinterviewquestions #vlookup #xlookup Welcome to our channel, Practice File : https://docs.google.com/spreadsheets/d/1juSrfEzIaKepPWE_B1KcEYe-ZmQvM_4I/edit?usp=sharing&ouid=111649791678669535997&rtpof=true&sd=true _______________________________________________________________________________________ 😊👇⏬ Products I Use and recommend you ⏬👇😊 ____________________________________________________________ 1) Excel Interview Question and Answers https://amzn.to/4cc3tDV 2) ASUS Vivobook 15 Laptop: https://amzn.to/46wez5i 3) Sony Alpha camera for Video and Photo Shoot https://amzn.to/3LMyWSa 4) Keyboard Mat for Keyboard Shortcuts https://amzn.to/3yd3fhX 5) Boya wireless Mic https://amzn.to/3SwkXUc 6) Boya Wired Mic https://amzn.to/3yqvrhg _____________________________________________________________________ ____________________________________________________________________ vlookup in excel : vlookup is one of the powerful function of excel, use used lookup large data in excel. in this video we will understand vlookup properly. xlookup in excel: xlookup is an advance lookup function of excel. in this video we will learn that how can you apply xlookup on large data. watch this video and learn it easily. Thank You. Related Searches : vlookup in excel, vlookup formula, vlookup in hindi, how to use vlookup in excel, vlookup function, vlookup in excel in hindi,excel formulas and functions, vlookup formula in excel, vlookup formula in excel in hindi, xlookup, xlookup formula, xlookup formula in excel, xlookup in excel, vlookup, excel, excel vlookup, ms excel, excel for beginners, xlookup function, xlookup in excel in hindi, vlookup on large data, xlookup on large data #vlookupinexcel #vlookup_in_excel #how_to_apply_vlookup_in_excel #vlookupandxlookup

Mastering XLOOKUP in Excel (With 10 Examples) | XLOOKUP Tutorial | XLOOKUP Function in Excel

Unlock the full potential of the XLOOKUP function in Excel with this comprehensive tutorial! Whether you're new to XLOOKUP or looking to enhance your skills, this video covers everything you need to know to master this powerful function. Learn how to use XLOOKUP to search for data, perform exact and approximate matches, handle errors, and much more. With 10 practical examples, you'll learn how to apply XLOOKUP in various scenarios, from simple lookups to more complex tasks. Watch now and become an XLOOKUP expert! #xlookup #xlookupfunction #excel Advanced Excel Mastery Course With A. I. - Premium Beginner To Advanced Course detail https://deepakeduworld.com/advanced-excel-mastery-course/ 📱 Download the Deepak EduWorld App *IOS App Link ( Org Code : UMNRRJ ) :* https://apps.apple.com/in/app/myinstitute/id1472483563 *Android App :* https://play.google.com/store/apps/details?id=co.barney.mczad 🎁 Launch Offer Available Download Training File : https://drive.google.com/uc?export=download&id=1gaASoB62GWjNtesxZAlW8CAsB5LiuBdJ My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: POWERPOINT COURSE ► https://youtu.be/OekrBhNybP0 ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP TUTORIALS ► http://bit.ly/3kJyIBv Thanks for Watching Deepak EduWorld

How to Build an Interactive Excel Dashboard (Step-by-Step Tutorial)

In this step-by-step tutorial, learn how to use Microsoft Excel pivot tables and charts to create an interactive dashboard that tracks financial consumer complaints. In under 10 minutes, you'll learn how to build: - Dynamic KPI cards - Pie charts - Bar & column charts (with drilldowns!) - Filled maps And it’s all controlled with user-friendly filters and timelines! 🔗 If you want to follow along with a similar dataset, check out our "Financial Consumer Complaints" dataset in our FREE Data Playground! https://mavenanalytics.io/data-playground?search=Financial%20Consumer%20Complaints ▶️ Want more Excel tips? Check out our Data Analysis in Minutes playlist: https://www.youtube.com/playlist?list=PLGAnLqlBhx1EAZAKX5UNhkQw3uIJ8bOE6 🗣️ Follow us on LinkedIn for daily data analysis tips and career guidance: https://www.linkedin.com/company/maven-analytics 💡 Interested in other courses? Join over 1,000,000 students who have taken our Maven Analytics courses in Excel, SQL, PowerBI, Tableau, Python and more: https://www.mavenanalytics.io/online-data-analysis-courses

How to use INDEX + MATCH vs VLOOKUP vs XLOOKUP in Excel Telugu || Computersadda.com

Hi .. viewers .. If you find the videos on this YouTube channel useful, valuable content, and if they save you time & money, then consider taking a membership on this channel. Get additional benefits. Support this channel. To become a member, click the JOIN button next to the Subscribe button. Check the information. Click here Below Link & JOIN:- ======================== https://www.youtube.com/channel/UCBVo5w4Cvm3_AEEBqsHjXow/join =========================================================== Each Course Topic wise Playlist Links :- ================================ Ms-Word 👉https://www.youtube.com/playlist?list=PLL3zPWMHgpV2WbnxU9L_TyN5bc0f13p5H Ms-Excel 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV0AWL3fW7TNgXm5TD-CTP1a Ms-PPT 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV0-AOOyMPexGag5UcDZyD66 Photoshop CC 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV3I9BPZ6MwBw4mXiEL9aeh9 PageMaker 👉https://www.youtube.com/playlist?list=PLL3zPWMHgpV1WI21BEnLbzMKY3MVqZdaY CorelDraw 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV3pNdWiqzr1XxA2IlY6CO8C Indesign 👉https://www.youtube.com/playlist?list=PLL3zPWMHgpV2euWbFnP6bw3ZH-pGDkeuX AutoCAD 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV1uyroPIYfLj8QHAcVi6EAz Html 👉 https://www.youtube.com/playlist?list=PLL3zPWMHgpV0ZpmYMkqejFjKKnIgww-jQ ============================================ Facebook fan page ------------------------------- https://www.facebook.com/Computersadda-1958850927674191/ Youtube Channel page ------------------------------------ https://www.youtube.com/channel/UCBVo5w4Cvm3_AEEBqsHjXow ------------------------------------------------------------------------------------------------------------ Hi Friends. Welcome to our Adda. Complete Telugu Video Tutorials. Ms-office, Tally ERP 9, Accounts, Photoshop, Pagemaker, CorelDRAW, AutoCAD (2D & 3D), C Lang, Basics of Computers, Html, Tips & Tricks, Weekly QUIZ. All Courses Shortcuts keys, Theories, Abbreviations, What & Who is This ?

Financial Modeling: Building the model from scratch in Excel and integrating Income Statement, Balance Sheet, and Cash Flow Statement indirect!

In this class, we will build a Financial Modeling project from scratch in Excel together with you and perform the integration of the Income Statement, Balance Sheet, and Cash Flow Statement indirect from the ground up! **************************************************************************************************** Learn to make strategic financial decisions and boost your career growth with our Super Simulator + Financial Modeling training! ✔ Gain exclusive access to the Super Scenario Simulator that will streamline your financial analyses! ✔ Discover what FP&A is and how to become an expert in this strategic area! ✔ Learn the secrets of financial modeling and how to securely and automatically integrate the main financial statements: Income Statement, Cash Flow Statement, and Balance Sheet! ✔ Find out how to integrate financial modeling with Valuation and business feasibility analysis! ✔ Master the analysis of financial indicators and make assertive decisions! ✔ Automate the integrations between the main financial statements! ✔ Learn how to develop the assumptions of a corporate budget and how to make forecast projections! ✔ Learn to do corporate planning and budgeting practically! ✔ Uncover the powerful PVM (Price, Volume, and Mix) analysis and leverage your results! And much more exclusive content for you to boost and elevate your financial career! Learn more through the link in our BIO on Instagram and on our website: geracaofpa.com.br

Create an AMAZING interactive Excel dashboard in under 45 minutes (COMPLETE TUTORIAL)

In this video, we will build together a dynamic, interactive, and beautiful dashboard on Excel in less than 45 minutes! Starting from the raw sales and profit data of the year 203 for Western Europe. ⬇️ DOWNLOAD my free resources: https://formations.exceler.fr/ressources 🎯 Do you want me to create or optimize your files? Book your call and share your project with me 👉 https://formations.exceler.fr/reserve-ton-appel To go further, check out my video on the dashboard to optimize your personal finances https://youtu.be/FltKMKQ9GrA In this complete tutorial, you will see how to create an interactive dashboard from A to Z. We will cover this tutorial in 6 chapters. - First, we will start by defining the structure of the Excel file and the organization of the raw data. - Next, we create the navigation menu between the different pages of the document. - Then we will look at the design and graphical architecture of the dashboard to achieve a professional look and feel. - After that, we will process all the data to create pivot tables to highlight the important data. - Next, we create the various charts and customize them for perfect integration into the dashboard. - Finally, we will finish by creating segments to filter and display the desired data. Enjoy watching! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 📖 CHAPTERS: 0:00 Intro 0:17 Structure of the Excel file 3:40 Navigation menu 11:32 Visual and aesthetics of the dashboard 15:59 Data processing + PIVOT TABLES 23:55 Chart, customization, and assembly 40:37 Filters, segments, and customization 46:24 Dashboard presentation 47:00 Conclusion ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 🚀 LEARN EXCEL: Hi, I’m Pierre. I help you take your career to new heights: 🎓 Coaching and training available here: https://formations.exceler.fr ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 👍 FOLLOW ME ON SOCIAL MEDIA: - X (Twitter): https://twitter.com/PierreCaill2 - Facebook: https://www.facebook.com/profile.php?id=61553317725954. - LinkedIn: https://www.linkedin.com/company/100351210/admin/feed/posts/ #Excel #Dashboard #dashboard #data_report #Excel_report #dashboard #Excel_dashboard #excel_model #excel_template #dashboard_template #Excel_dashboard #free_templates #excel_template #free_Excel_Template #interactive #interactive_model #interactive_template #Interactive #dynamic #professional #Infographics #charts #Excel_charts #pivot_table #pivot_table_excel #pivot_table #key_performance_indicators #career_pro #Excel_career #freelance #freelance_excel #excel_freelance #powerpoint #Tutorial #how_to_create #tutorial #tuto #complete_tutorial #live_tutorial #live #live_Excel #Excel_tutorial #Excel_Tutorial #Chart #chart_excel

How POWER PIVOT Works in Excel | COMPLETE BASICS

Here you will learn step by step the complete basics to combine datasets into a data model using Power Pivot, expand this data model, and create meaningful reports (with KPIs, graphs, etc.) based on it. Datasets to WORK WITH (in a file): https://docs.google.com/spreadsheets/d/1f12vdRhzS2_oOyrFWTEUcqsMVbey4ByPrYJG291MIls/edit?usp=sharing 00:00 Introduction 00:31 Data Source 01:43 Adding Power Pivot 02:34 Merging Datasets 05:46 Relationships 08:07 Expanding Data Model 12:21 Creating Measures 17:45 Visualization with Pivot Tables 20:34 KPIs 22:27 Graphs 23:30 Slicer 24:15 Timeline 24:55 Outro

Build a 3 Statement Financial Model (FULL Tutorial + Free Template)

Make a 3-statement financial model built from scratch in Excel. Full tutorial with free template! 📈 Take our Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🆓 DOWNLOAD the Free Excel file for this video: https://careerprinciples.myflodesk.com/f64zoavpdx In this video, you'll learn to make a 3 statement financial model from scratch. First, we'll have a set of assumptions to forecast our income statement. Then, we'll work on the fixed assets schedule to forecast depreciation. Third, we'll work on calculating the interest expense to finalize our income statement. Following the income statement, we'll work on the balance sheet forecast. We'll skip the cash and revolver line items for later in the video. Then, we'll calculate the cash flow statement and plug the ending cash balance back into the balance sheet. Finally, we'll set up a revolver (revolving credit facility) to make sure we don't run out of cash when having a negative forecast. We will also solve any circularity (circular reference) errors we might have in the process. LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ 3 Statement Model Intro 0:28 - Forecasting the Income Statement 6:10​ - Fixed Assets Schedule 9:52​ - Interest Expense Forecast 10:53​ - Balance Sheet Assumptions & Forecast 20:40​ - Building the Cash Flow Statement 25:43 - Revolver (Revolving Credit Facility) 30:55 - Fixing Circular Reference Error

The Ultimate XLOOKUP Tutorial (The Best Excel Formula)

Xlookup formula tutorial in Excel using 5 examples. 👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/qib6phoo0p Learn how to use the XLOOKUP function in Excel with 5 examples from easy to hard. First, you'll learn how to use a simple XLOOKUP and replace a VLOOKUP. Then, you'll learn how to use the XLOOKUP with a wildcard for approximate matches. Third, you'll learn how to use the xlookup with multiple conditions to replace the index match. Fourth, we'll look at approximate matches using the match mode for matches that are smaller than a certain number. Finally, we'll look at getting multiple answers with the spill feature in XLOOKUP. Once we understand the xlookup, we'll look at some of the limitations of the formula, especially with summing values. LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ XLOOKUP Example 1 1:57​ - XLOOKUP with Wildcard Chart 3:39​ - XLOOKUP with Multiple Conditions 6:08​ - Match Mode XLOOKUP 8:13​ - XLOOKUP with multiple answers 9:42 - XLOOKUP problems

How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP

How to pull a column of data into an Excel report from another spreadsheet using VLOOKUP and then XLOOKUP functions. Extract data from one workbook to another. You'll learn how to apply the VLOOKUP and XLOOKUP functions to your data extraction tasks. Whether you're a beginner or an advanced Excel user, this video will help you save time and reduce errors in your work. Let's compare VLOOKUP and XLOOKUP. So, which function should you use? It really depends on your specific situation, your level of comfort in Excel, and the complexity of the task you need to accomplish. VLOOKUP is a great function for finding related information in large tables or when you want to add a column of data to a report, which is what we are going to do in this tutorial. Syntax for VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Now, VLOOKUP does have its limitations. For example, it only works to the right of the lookup value, so you can't use it to look up values to the left of the lookup column. Additionally, VLOOKUP can only search for exact matches or approximate matches based on the closest value, which can be problematic if you have duplicate values. XLOOKUP is a more powerful function than VLOOKUP that allows you to search for values in any direction (left, right, up, or down) and also supports fuzzy matches and wildcards. Syntax for XLOOKUP: =XLOOKUP(lookup_value, lookup_array, return_array, [not_found], [match_mode], [search_mode]) TIMESTAMPS ⏰ 00:00 Pull Data into Excel Report with VLOOKUP & XLOOKUP 00:25 How to Insert Functions in Excel 02:17 How to use VLOOKUP in Excel 03:44 How to use XLOOKUP in Excel FREE COURSE 🎓: How To Create Fillable Forms in Microsoft Word - A Step-by-Step Guide Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro! https://youtu.be/438pCPCSuG4 WATCH NEXT 📺 https://youtu.be/z-62JPTqgiw How to Automate Reports in Excel with Office Scripts CHANNEL LINK 📺 https://www.youtube.com/@SharonSmith Visit my Channel page on YouTube to see all my videos, playlists, community posts and more! TEMPLATES 📄 Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv Thank you for supporting my channel! 🌟 FREE DOWNLOADS ⬇️ ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. CONNECT WITH ME 📎 Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR Instagram: https://www.instagram.com/sharonsmithlearning/ Facebook: https://www.facebook.com/SharonSmithLearning GEAR ⚙️ 🎙 Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!) 🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!) 🎥 Screen Recording Software: https://techsmith.z6rjha.net/NZG5b 📗 Green Screen: https://amzn.to/2DnHsY2 📸 Camera: https://amzn.to/39KvpQA 🔌 Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top-notch webcam) RESOURCES 📚 ✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 🖥️ TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel! SUPPORT THIS CHANNEL 🙌 - Hit the "$Thanks" button on any video, or - Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills. You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️ PLAYLISTS 🎥 ➤ Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD ➤Create A Letterhead in Word: https://www.youtube.com/playlist?list=PLb80efKTbWuO0RyeiYB0fEb55601yL4OT ➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv ➤ Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45 #vlookup #xlookup #microsoftexcel #msexcel #dataextraction #dataretrieval

Make Interactive Excel Dashboard in Just 12 Minutes

📂 Get the dataset here: https://payhip.com/b/2b7DW ✨ Want the finished dashboard? Get the complete, fully editable file here: https://payhip.com/b/JUZSl ✨ Ready-to-Use dashboards & templates: https://payhip.com/MarizDigital Build an Interactive Excel Dashboard in just 12 minutes. In this video, we will build an automated excel dashboard from scratch using the sample data provided below. First, we prepare the base of our dashboard by removing the gridlines and adding color on the entire sheet. Then we will outline the overall structure of the dashboard using shapes. Next, we will connect our metrics using text box, the formula bar, and the metric value on our pivot tables. After that, we will create charts as our visualizations – stacked column chart for Sales vs Target per month, smooth line chart for total customers per month, and bar chart for profit per region. Since our charts is based on Pivot Tables, by default, messy Field Buttons appear on our charts. We will also show how to remove these buttons. Then we will customize our dashboard and finally add slicers. The slicers make our dashboard automated by providing buttons that we can click to filter data at once. 📺FREE COURSES: EXCEL: https://youtube.com/playlist?list=PLjHKwibbH7DxtALrABq6tZXcVHU6Y5bw8&si=HiUD_id77DsWQETO TABLEAU: https://youtube.com/playlist?list=PLjHKwibbH7DwPtqRqeHREA6pHWpV7_SLe&si=-kCz2dLcv9JSmGnC POWERPOINT: https://youtube.com/playlist?list=PLjHKwibbH7Dz8_KzBKaCTgBSjUwfESm4g&si=NuHeQ5xyT-MnOEZh STAY CONNECTED: 🔗: https://linktr.ee/marizcaranguian BUSINESS/PARTNERSHIP INQUIRIES: 💌: itsmariz.business@gmail.com