![Finex Skills Hub](/img/default-banner.jpg)
- 220
- 594 611
Finex Skills Hub
Ghana
เข้าร่วมเมื่อ 8 พ.ย. 2020
Work smart and improve productivity with skills in Microsoft Office tools, Data Analytics with Power BI, Low-Code App Development and Financial Modeling.
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
📊 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
Hello, when i use the same period last year dax, iam getting previous year values / please help?
I am from India. Really Informative Video.. Well Explained.
Thank you
Very insightful!
Thank you
thanks for your share,great video!!
THANK YOU TO SHOW THIS WOULD BE A WAY TO SOLV PROBLEM
It doesn't work. The embed option is not there.
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.
Thank you soo much!
I'm trying to get the link from Onedrive Personal. It rather has a encrypted URL. Do you suggest a work around?
tnx! just what I needed
Thank you so much😍
What if we dont know exactly the number of options innthe enumlist or if they are too many?
Clean solution. Thanks
Wonderful
Thank you
really useful video so easy to follow
fórmula para category 30:32
this just scored me points with the boss - thanks
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!!😄
Yes. That was a decomposition tree. Video coming soon😊
Thank you so much
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
It will sum up the payments in smaller quantities against the person's name
Thank you so much for this.
I WANT ONE FOR FUNERAL CONTRIBUTIONS
This is good, just finding this out Thanks a lot.
Thank you for this ❤🎉
hello, I hope my question is answered.. how to print/make a pdf from separate rows from enum list? thank you.
This saved me WEEKS! Thank you!!!
Your are the awesome
Thank you so much
thank you fir your video. one thing i want to ask if how about i edit the enumlists? how can it be deleted also?
I love this🙏🏼🙏🏼👍🏼👍🏼
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🙏
Yes.... I'll recommend you create another view ( dashboard view) to combine 2 other views ie summary view and MOP view on one page.
The best school for data analysis ❤
I love your videos. keep up the good work.
how can i do this on google sheets ?
Thank you so much sir
How can I make payments from the UK?
Some of our students from outside Ghana used LemFi. You can reach out here on WhatsApp if you have challenges: +233244782356
I hope am not too late to join. Before next week session if I make payment is it good to join?
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
Hello Sir, if one want to learn Data Analytics does need to Master excel before or the Course is from biginer to advance?
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.
This is awesome - thank you, solved this problem for me in 5 minutes
Not working correctly on every page it is showing last pages second record
Good job, but the map is unlabeled
Thank you
Solid!!!
Amazing - I loved your Presentation & Layouts
which map visual is this ?
Shape Map
Thanks Please can you share the material
The download link has been shared under the video description. Reposting here: 1drv.ms/f/s!AsVgPBp9qkOChLoPC0uIObmYhaKt2g?e=6bwKOW
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])))
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 .
@@jaspritsingh6745 Thanks for the feedback. Good question. Will look into this and get back
Another Excel digest 😋 Thank you so much Finex Skills Hub for sharing this. Love it
Useful