Finex Skills Hub
Finex Skills Hub
  • 220
  • 594 611
Stage Multiple Charts in an Excel Dashboard with Slicers | Dynamic Arrays & Cube Functions Tutorial
In this tutorial, you'll learn how to stage multiple charts in your Excel dashboard and switch between charts using slicers-without any complex formulas! We’ll walk you through the step-by-step process of using dynamic array functions, Cube Functions, and Slicers to make your dashboard interactive and user-friendly.
📊 What You’ll Learn:
How to create and manage multiple charts in a single Excel dashboard.
Use dynamic array functions to automate your data presentation.
Leverage Cube Functions to efficiently handle your data models.
Set up Slicers that allow you to switch between charts with a single click.
Download start workbook here: 1drv.ms/x/s!AsVgPBp9qkOChNJObp-kTSRZtmA5nQ?download=1&em=2
🔍 Why This Video? Excel dashboards are essential for analyzing and visualizing data effectively. With this tutorial, you’ll unlock the potential of creating dynamic, interactive reports that update based on user input.
🖥️ Whether you’re working in finance, project management, HR, or any data-driven field, this guide will help you create professional dashboards that impress your team and clients.
Chapters:
0:00 - Introduction
2:15 - Creating the Doughnut Chart
12:50 - Staging Multiple Charts
30:23 - Dynamic Caption for All Selection
35:37 - Conclusion
Don't forget to like, subscribe, and hit the notification bell so you don't miss out on our future Excel tutorials!
#ExcelDashboard #DynamicArrays #CubeFunctions #ExcelSlicers #DataVisualization #ExcelTips #InteractiveDashboards
มุมมอง: 587

วีดีโอ

Create a Dynamic Commentary in your Power BI Reports with Smart Narrative
มุมมอง 671หลายเดือนก่อน
Unlock the full potential of your Power BI reports by adding dynamic commentary with the Smart Narrative visual! In this tutorial, you'll learn how to create automated, insightful narratives that update in real-time based on user interactions with slicers. Whether you're a Power BI beginner or an experienced user, this video will show you how to turn your data into compelling stories that highl...
Create a Text Analytics Dashboard in Excel using Cartesian Join and Bubble Charts
มุมมอง 465หลายเดือนก่อน
ow to Use Excel's Power Query for Text Analytics with Bubble Charts Learn how to master text analytics in Excel using Power Query! In this tutorial, we'll guide you through the process of comparing feedback responses against a list of keywords using a Cartesian Product or Join. We'll extract key phrases, analyze data with Power Pivot, and visualize insights using PivotTables, dynamic array func...
Live Orientation Session: Training in Data Analytics with Excel and Power BI - Finex School 15
มุมมอง 578หลายเดือนก่อน
Welcome to the recording of our live orientation for new students enrolled in the "Data Analytics with Excel and Power BI" course! In this comprehensive session, we provide an in-depth overview of what you can expect from your journey into the world of data analytics. 📊 What You'll Learn: Overview of Data Analytics: Understand the fundamentals of data analytics and how it applies to real-world ...
Create an Interactive Power BI with Waffle Chart and Global Shape Map | World Bank Data
มุมมอง 996หลายเดือนก่อน
Welcome to our latest tutorial where we explore how to create an interactive Power BI report featuring a Waffle Chart and a Global Shape Map! In this video, we'll use real data from the World Bank on the proportion of seats held by women in national parliaments (%). This step-by-step guide will help you shape your data with Power Query, build a robust Data Model, and visualize insights with Waf...
Create an interactive HR Dashboard in Excel using Power Query, Power Pivot and PivotTables.
มุมมอง 991หลายเดือนก่อน
Unlock the full potential of Excel to create a powerful and interactive HR Dashboard! In this tutorial, I'll guide you through the step-by-step process of transforming raw Register and Payroll tables into a dynamic and visually appealing HR Dashboard using Power Query, Power Pivot, DAX, and PivotTables. 🔍 What You'll Learn: How to use Power Query to clean and transform HR data. Creating data mo...
Create a Personal Actual vs Budget Dashboard in Excel | Power Query, PivotTables, Power Pivot
มุมมอง 1.2K2 หลายเดือนก่อน
Unlock the full potential of Excel in our latest tutorial! Learn how to create a dynamic and interactive Personal Actual vs Budget Dashboard using Power Query, PivotTables, and Power Pivot. Perfect for managing your finances or any budgeting needs, this step-by-step guide will show you how to: Shape and Modify Data: Use Power Query to clean and transform your data effortlessly. Create a Data Mo...
Create an Inventory Management Dashboard in Excel: No Functions, Just PivotTables and Power Pivot
มุมมอง 2.6K2 หลายเดือนก่อน
Unlock the power of Excel with our step-by-step tutorial on creating a comprehensive Inventory Management Dashboard using only PivotTables and Power Pivot! In this video, you will learn how to: Connect multiple tables using Power Pivot Create dynamic summaries with PivotTables Visualize your inventory data effectively Track key metrics like total received, total dispatched, quantity available, ...
How to Analyze Google Form Responses with Power BI | Step-by-Step Tutorial
มุมมอง 6542 หลายเดือนก่อน
Unlock the power of your survey data with our comprehensive tutorial on analyzing Google Form responses using Power BI! In this video, you'll learn how to seamlessly connect Power Query to your Google Forms, shape and transform qualitative data, and create stunning visualizations to gain actionable insights. 🔍 What You'll Learn: How to connect Google Forms to Power BI using Power Query Steps to...
Create Interactive Visuals in Power BI with Bookmarks
มุมมอง 8882 หลายเดือนก่อน
Welcome to our comprehensive tutorial on using Power BI Bookmarks to create dynamic and interactive visuals! In this video, you'll learn how to enhance your Power BI reports by connecting slicers to images and using the Bookmark feature to display various images when a slicer is selected. 🔍 What You'll Learn: Introduction to Power BI Bookmarks Step-by-step guide to creating and managing bookmar...
Create Custom Shape Maps in Power BI | Visualize Map Data with Native Shape Visual
มุมมอง 5K3 หลายเดือนก่อน
Unlock the power of custom shape maps in Power BI with our step-by-step tutorial! In this video, you'll learn how to use the native shape visual to create dynamic and interactive map visualizations. Whether you're a data analyst, business intelligence professional, or Power BI enthusiast, this guide will help you enhance your reports and dashboards with customized geographical insights. 🔍 What ...
Create a Dynamic Actual v Budget Dashboard in Excel using Power Query, Power Pivot, DAX, and Cubes
มุมมอง 2.5K3 หลายเดือนก่อน
This is a complete dashboard lesson on how to create a dynamic Actual vs Budget Dashboard in Excel using Power Query, Power Pivot, DAX, and Cube Functions. In this video, we'll guide you through the entire process, from transforming raw data to building an interactive and visually appealing dashboard. What You'll Learn: Power Query: Transform and clean your raw Actual vs Budget data with ease. ...
Online Lookup with Power Query and Power Pivot
มุมมอง 3093 หลายเดือนก่อน
Unlock the power of Excel with our comprehensive tutorial on how to fetch and utilize online data using Power Query and Power Pivot. In this video, we guide you through a practical case study of retrieving daily FX rates from a web portal and integrating them into your Excel spreadsheet. Learn step-by-step how to use Power Query to fetch and update data automatically, and discover how Power Piv...
Unlock the Power of Forecasting with Power BI and Excel | Step-by-Step Tutorial
มุมมอง 1.1K4 หลายเดือนก่อน
Discover the seamless integration of Power BI and Excel in this comprehensive tutorial! Whether you're a business analyst, data scientist, or finance professional, mastering the art of forecasting is crucial. This video will guide you through the entire process of using Power BI's advanced Forecast feature to generate accurate predictions. Learn how to: Set Up Your Data: Get tips on preparing a...
Create a Waterfall Calculation Using Excel's Dynamic Arrays: Capital Allowance Case Study
มุมมอง 5544 หลายเดือนก่อน
Unlock the power of Excel's dynamic arrays for waterfall calculations in this comprehensive tutorial! Learn how to create a dynamic waterfall calculation for a capital allowance schedule using Excel's Dynamic Arrays. Avoid complex cell referencing and streamline your workflow with dynamic arrays that spill automatically, saving you time and reducing errors. In this video, you'll discover: How t...
A CONTAINS FUNCTION IN MICROSOFT EXCEL? | Workaround with MATCH, OR, EXACT & More
มุมมอง 6354 หลายเดือนก่อน
A CONTAINS FUNCTION IN MICROSOFT EXCEL? | Workaround with MATCH, OR, EXACT & More
Unlock the Full Potential of Excel for Data Analysis with Power Pivot | Learn How!
มุมมอง 5214 หลายเดือนก่อน
Unlock the Full Potential of Excel for Data Analysis with Power Pivot | Learn How!
Combine Trial Balance Data with Power Query for Month on Month Analysis in Excel.
มุมมอง 1.1K5 หลายเดือนก่อน
Combine Trial Balance Data with Power Query for Month on Month Analysis in Excel.
New Ways to Summarize Data with New Dynamic Array Functions GROUPBY and PIVOTBY: Actual v Budget 1
มุมมอง 5385 หลายเดือนก่อน
New Ways to Summarize Data with New Dynamic Array Functions GROUPBY and PIVOTBY: Actual v Budget 1
Finex School Training in Data Analytics with Power BI and Excel for Work - Season 14 Orientation
มุมมอง 4276 หลายเดือนก่อน
Finex School Training in Data Analytics with Power BI and Excel for Work - Season 14 Orientation
Getting Started with Power BI: Complete Power BI beginners Case Study - Full Course
มุมมอง 2.3K6 หลายเดือนก่อน
Getting Started with Power BI: Complete Power BI beginners Case Study - Full Course
Topic 10 - Analysing Data with PivotTable - Part 2
มุมมอง 5106 หลายเดือนก่อน
Topic 10 - Analysing Data with PivotTable - Part 2
Separate Text from Number with Dynamic Array functions TEXTAFTER, TEXTBEFORE.
มุมมอง 3277 หลายเดือนก่อน
Separate Text from Number with Dynamic Array functions TEXTAFTER, TEXTBEFORE.
Topic 10 - Master PivotTables in Excel: A Comprehensive Guide for Beginners: Part 1
มุมมอง 7357 หลายเดือนก่อน
Topic 10 - Master PivotTables in Excel: A Comprehensive Guide for Beginners: Part 1
Free Payroll Template with new Income Tax (PAYE 2024)
มุมมอง 1K7 หลายเดือนก่อน
Free Payroll Template with new Income Tax (PAYE 2024)
Demystifying Excel Icon Sets for Conditional Formatting: A Guide on when to use Number / Percentage.
มุมมอง 6467 หลายเดือนก่อน
Demystifying Excel Icon Sets for Conditional Formatting: A Guide on when to use Number / Percentage.
Reset or Clear all Slicers in your Excel Dashboard with One Click
มุมมอง 2.8K8 หลายเดือนก่อน
Reset or Clear all Slicers in your Excel Dashboard with One Click
Calculate Year to Date Values with the TOTALYTD DAX Function
มุมมอง 1.5K8 หลายเดือนก่อน
Calculate Year to Date Values with the TOTALYTD DAX Function
Topic 9 - Master Cell Referencing and Named Ranges to create effective formulas
มุมมอง 3648 หลายเดือนก่อน
Topic 9 - Master Cell Referencing and Named Ranges to create effective formulas
Unlock the Power of Excel Online! Learn a Simple Trick to Publish Data Model Excel Dashboards online
มุมมอง 5928 หลายเดือนก่อน
Unlock the Power of Excel Online! Learn a Simple Trick to Publish Data Model Excel Dashboards online

ความคิดเห็น

  • @syedjeelani1136
    @syedjeelani1136 2 วันที่ผ่านมา

    Hello, when i use the same period last year dax, iam getting previous year values / please help?

  • @deepakjaju1549
    @deepakjaju1549 2 วันที่ผ่านมา

    I am from India. Really Informative Video.. Well Explained.

  • @lorenzoladejobi8701
    @lorenzoladejobi8701 3 วันที่ผ่านมา

    Very insightful!

  • @teigenxayden
    @teigenxayden 6 วันที่ผ่านมา

    thanks for your share,great video!!

  • @MdIrshadVideo
    @MdIrshadVideo 9 วันที่ผ่านมา

    THANK YOU TO SHOW THIS WOULD BE A WAY TO SOLV PROBLEM

  • @etienneezio342
    @etienneezio342 11 วันที่ผ่านมา

    It doesn't work. The embed option is not there.

  • @ifoodieTV
    @ifoodieTV 12 วันที่ผ่านมา

    Can I use my own the DATA? It will be a SINGLE EXCEL file with areas of GHANA. Simply a detail of SYNOPTIC PANEL. Please advise.

  • @diyamary2561
    @diyamary2561 12 วันที่ผ่านมา

    Thank you soo much!

  • @keerthy.shunmugarajan
    @keerthy.shunmugarajan 13 วันที่ผ่านมา

    I'm trying to get the link from Onedrive Personal. It rather has a encrypted URL. Do you suggest a work around?

  • @eaola2005
    @eaola2005 14 วันที่ผ่านมา

    tnx! just what I needed

  • @monekeosengkhamyong7427
    @monekeosengkhamyong7427 14 วันที่ผ่านมา

    Thank you so much😍

  • @agustinsantiagocosentino1061
    @agustinsantiagocosentino1061 17 วันที่ผ่านมา

    What if we dont know exactly the number of options innthe enumlist or if they are too many?

  • @agustinsantiagocosentino1061
    @agustinsantiagocosentino1061 17 วันที่ผ่านมา

    Clean solution. Thanks

  • @oluwaplentya8808
    @oluwaplentya8808 19 วันที่ผ่านมา

    Wonderful

  • @AMP78490
    @AMP78490 19 วันที่ผ่านมา

    really useful video so easy to follow

  • @hoyyosoy
    @hoyyosoy 20 วันที่ผ่านมา

    fórmula para category 30:32

  • @AcidHouseKid
    @AcidHouseKid 21 วันที่ผ่านมา

    this just scored me points with the boss - thanks

  • @andrewdutch4843
    @andrewdutch4843 22 วันที่ผ่านมา

    Thanks for a great video! 👍 Is that a decomposition tree that you used to show the votes cast? Do you have you got a video on how you did that? Thanks!!😄

    • @FinexSkillsHub
      @FinexSkillsHub 22 วันที่ผ่านมา

      Yes. That was a decomposition tree. Video coming soon😊

  • @ChinenyeJessica-b7j
    @ChinenyeJessica-b7j 27 วันที่ผ่านมา

    Thank you so much

  • @naanakumi
    @naanakumi 28 วันที่ผ่านมา

    The example you gave for member 3 was about a person who paid the dues in a lump sum. If one person were to pay the dues in smaller quantities, how would it reflect in the first excel sheet

    • @FinexSkillsHub
      @FinexSkillsHub 28 วันที่ผ่านมา

      It will sum up the payments in smaller quantities against the person's name

  • @olalekanoyeniyi9619
    @olalekanoyeniyi9619 29 วันที่ผ่านมา

    Thank you so much for this.

  • @paulkwabenaobeng9796
    @paulkwabenaobeng9796 29 วันที่ผ่านมา

    I WANT ONE FOR FUNERAL CONTRIBUTIONS

  • @JunexWonder
    @JunexWonder หลายเดือนก่อน

    This is good, just finding this out Thanks a lot.

  • @alair_data6944
    @alair_data6944 หลายเดือนก่อน

    Thank you for this ❤🎉

  • @rizkimaylisaputri9475
    @rizkimaylisaputri9475 หลายเดือนก่อน

    hello, I hope my question is answered.. how to print/make a pdf from separate rows from enum list? thank you.

  • @crystalzeyer4273
    @crystalzeyer4273 หลายเดือนก่อน

    This saved me WEEKS! Thank you!!!

  • @asiashaik2816
    @asiashaik2816 หลายเดือนก่อน

    Your are the awesome

  • @mostafatawfeik534
    @mostafatawfeik534 หลายเดือนก่อน

    Thank you so much

  • @ronelarinal1865
    @ronelarinal1865 หลายเดือนก่อน

    thank you fir your video. one thing i want to ask if how about i edit the enumlists? how can it be deleted also?

  • @jamesarthur2360
    @jamesarthur2360 หลายเดือนก่อน

    I love this🙏🏼🙏🏼👍🏼👍🏼

  • @kevinbool8014
    @kevinbool8014 หลายเดือนก่อน

    Is it possible to have the current balance for cash and bank etc. On the summary page. We use the app for our house hold. En we have 4 bank accounts. We just want to see the overvieuw off the current balance in our first page. I hope so you can help me🙏

    • @danoy2310
      @danoy2310 หลายเดือนก่อน

      Yes.... I'll recommend you create another view ( dashboard view) to combine 2 other views ie summary view and MOP view on one page.

  • @owusuaavictoria9873
    @owusuaavictoria9873 หลายเดือนก่อน

    The best school for data analysis ❤

  • @gademordonatus6574
    @gademordonatus6574 หลายเดือนก่อน

    I love your videos. keep up the good work.

  • @kryzylrosido6549
    @kryzylrosido6549 หลายเดือนก่อน

    how can i do this on google sheets ?

  • @user-uj5nx4cc5e
    @user-uj5nx4cc5e หลายเดือนก่อน

    Thank you so much sir

  • @OpeyemiAdewuyi-jy9io
    @OpeyemiAdewuyi-jy9io หลายเดือนก่อน

    How can I make payments from the UK?

    • @FinexSkillsHub
      @FinexSkillsHub หลายเดือนก่อน

      Some of our students from outside Ghana used LemFi. You can reach out here on WhatsApp if you have challenges: +233244782356

  • @amehodavidetse4414
    @amehodavidetse4414 หลายเดือนก่อน

    I hope am not too late to join. Before next week session if I make payment is it good to join?

    • @FinexSkillsHub
      @FinexSkillsHub หลายเดือนก่อน

      No. You are still in good time. First class starts on Aug 3, 2024 and we end Aug 31, 2024. You can register here: www.finexskillshub.com/apply

  • @amehodavidetse4414
    @amehodavidetse4414 หลายเดือนก่อน

    Hello Sir, if one want to learn Data Analytics does need to Master excel before or the Course is from biginer to advance?

    • @FinexSkillsHub
      @FinexSkillsHub หลายเดือนก่อน

      You can start as a beginner in Excel. The program will walk you through basics like Tables, Structuring and Cleaning Data all the way to how to analyze and interpret data for insights.

  • @TheRiskTakersPodcast
    @TheRiskTakersPodcast หลายเดือนก่อน

    This is awesome - thank you, solved this problem for me in 5 minutes

  • @vijaymeena1211
    @vijaymeena1211 หลายเดือนก่อน

    Not working correctly on every page it is showing last pages second record

  • @GloriaTnz
    @GloriaTnz หลายเดือนก่อน

    Good job, but the map is unlabeled

  • @muhammedazharudheen2276
    @muhammedazharudheen2276 หลายเดือนก่อน

    Thank you

  • @MkingJaCari
    @MkingJaCari หลายเดือนก่อน

    Solid!!!

  • @qadeerhussain5351
    @qadeerhussain5351 หลายเดือนก่อน

    Amazing - I loved your Presentation & Layouts

  • @user-jh2yv2jz5s
    @user-jh2yv2jz5s หลายเดือนก่อน

    which map visual is this ?

  • @BringDownTheGloryOfGodMi-ms1jc
    @BringDownTheGloryOfGodMi-ms1jc หลายเดือนก่อน

    Thanks Please can you share the material

    • @FinexSkillsHub
      @FinexSkillsHub หลายเดือนก่อน

      The download link has been shared under the video description. Reposting here: 1drv.ms/f/s!AsVgPBp9qkOChLoPC0uIObmYhaKt2g?e=6bwKOW

  • @FinexSkillsHub
    @FinexSkillsHub หลายเดือนก่อน

    At 31:15 If you encounter an error with the DAX formula for Active Staff, please use this alternative formula: =CALCULATE(COUNTROWS(Tracker),Tracker[Event]="Hired",FILTER('Calendar','Calendar'[Date]<=MAX('Calendar'[Date])))- CALCULATE(COUNTROWS(Tracker),Tracker[Event]="Exit",FILTER('Calendar','Calendar'[Date]<=MAX('Calendar'[Date])))

  • @jaspritsingh6745
    @jaspritsingh6745 หลายเดือนก่อน

    Great Video ,Thanks for the excellent information .I have one query regarding shape maps ,where we can selectively fill color for eg (different districts of state ) . Let us consider one country which has multiple States ,when we hover our mouse pointer ,tooltips option helps us and gives various information like name of state ,population etc as per the column name entered in tooltips but is there a way that we can get at least some information (eg name ) for every state displayed automatically without us hovering over the pointer to get information . Please let me know if something could be done in this case ,and if i am able to explain properly .

    • @FinexSkillsHub
      @FinexSkillsHub หลายเดือนก่อน

      @@jaspritsingh6745 Thanks for the feedback. Good question. Will look into this and get back

  • @ulrichaho
    @ulrichaho 2 หลายเดือนก่อน

    Another Excel digest 😋 Thank you so much Finex Skills Hub for sharing this. Love it

  • @muhammadimtiazimtiaz3210
    @muhammadimtiazimtiaz3210 2 หลายเดือนก่อน

    Useful