- 140
- 253 008
DataDash Pro
Pakistan
เข้าร่วมเมื่อ 28 ก.ค. 2022
Welcome to DataDash Pro, your ultimate resource for mastering Excel, Google Sheets, and diving into the world of Power BI, with a special focus on data tricks, charts, amazing dashboards, and powerful formulas.
📊 Do you want to create stunning visualizations, uncover hidden insights, and become a data wizard in Excel and Google Sheets? Look no further!
📈 Our channel is dedicated to empowering you with the skills and knowledge you need to excel in data analysis. From foundational tips to advanced techniques, we've got you covered.
🧮 Explore the magic of Excel and Google Sheets as we unravel their secrets, share invaluable formula hacks, and teach you how to craft beautiful and informative charts that tell compelling data stories.
👨🏫 Our team of experts is here to answer your questions, provide guidance, and help you become a data superhero. Don't forget to hit that subscribe button to join our community and never miss a moment of data brilliance!
📊 Do you want to create stunning visualizations, uncover hidden insights, and become a data wizard in Excel and Google Sheets? Look no further!
📈 Our channel is dedicated to empowering you with the skills and knowledge you need to excel in data analysis. From foundational tips to advanced techniques, we've got you covered.
🧮 Explore the magic of Excel and Google Sheets as we unravel their secrets, share invaluable formula hacks, and teach you how to craft beautiful and informative charts that tell compelling data stories.
👨🏫 Our team of experts is here to answer your questions, provide guidance, and help you become a data superhero. Don't forget to hit that subscribe button to join our community and never miss a moment of data brilliance!
Recruitment Analysis Dashboard: On/Off Stages | Excel, Sheets, Power BI
Explore the power of data visualization with our Recruitment Analysis Dashboard: On/Off Stages. This dashboard provides a clear and concise representation of your recruitment pipeline using a stacked column chart. Easily track candidates' progression through various stages of the hiring process, distinguish between active and inactive stages, and gain actionable insights.
Whether you're working in Excel, Google Sheets, or Power BI, this dashboard is adaptable to your preferred tool. Perfect for HR teams, recruiters, and data analysts looking to streamline their hiring workflows and make data-driven decisions.
====CHAPTERS=====
0:00 A Breif Overview
1:48 Creating Calculated table behind the chart
6:45 Selecting Stack Column Chart
10:08 Google Sheets Calculated table behind the chart
13:41 Creating Chart from Calculated table
File Links:
Excel: drive.google.com/uc?export=download&id=1LKWJVyvin6HQ5_cBNESobFdymIvUEMnN
Google Sheets: docs.google.com/spreadsheets/d/1hZzMdvbAT15Emv3CzeJWLBB0IfMp_ZFxw4QV3gNCGWo/copy
Power Bi link: drive.google.com/uc?export=download&id=13IARiUZjMz5mPXe9Zf6G_cfOpqaFQ23I
Whether you're working in Excel, Google Sheets, or Power BI, this dashboard is adaptable to your preferred tool. Perfect for HR teams, recruiters, and data analysts looking to streamline their hiring workflows and make data-driven decisions.
====CHAPTERS=====
0:00 A Breif Overview
1:48 Creating Calculated table behind the chart
6:45 Selecting Stack Column Chart
10:08 Google Sheets Calculated table behind the chart
13:41 Creating Chart from Calculated table
File Links:
Excel: drive.google.com/uc?export=download&id=1LKWJVyvin6HQ5_cBNESobFdymIvUEMnN
Google Sheets: docs.google.com/spreadsheets/d/1hZzMdvbAT15Emv3CzeJWLBB0IfMp_ZFxw4QV3gNCGWo/copy
Power Bi link: drive.google.com/uc?export=download&id=13IARiUZjMz5mPXe9Zf6G_cfOpqaFQ23I
มุมมอง: 47
วีดีโอ
Dynamically Calculate Bar (Column) Chart Differences with Slicers in Excel
มุมมอง 431วันที่ผ่านมา
Learn how to dynamically calculate bar differences using slicers in Excel! In this tutorial, we'll explore how to create interactive bar charts combined with slicers and custom formulas to easily compare data between different years or categories. You'll discover step-by-step how to: Set up a Pivot Table with slicers. Design a dynamic bar chart. Use custom formulas to calculate percentage diffe...
Dynamic Date Filtering in Excel & Google Sheets + Multi-Column SUMIF Bonus Tricks
มุมมอง 23314 วันที่ผ่านมา
🎯 Master Dynamic Date Filtering in Excel & Google Sheets! In this tutorial, learn how to filter data dynamically based on a horizontal date range and unlock advanced techniques using SUMIF across multiple columns. Whether you're an Excel enthusiast or a Google Sheets user, this step-by-step guide will simplify your data analysis and save you time. 🚀 🔍 What You’ll Learn: ✅ Filter data dynamicall...
Convert Sample Bar Chart to dynamic Star in Excel
มุมมอง 7814 วันที่ผ่านมา
Learn a simple method to create Star rating chart in Excel. Use this concept to create any shape fill chart in Excel. Like & Subscribe for more. Other Interactive Chart th-cam.com/video/NCcnwQhWQ1I/w-d-xo.html th-cam.com/video/Ai0qgyN4KUU/w-d-xo.html th-cam.com/video/JSkVkJO8jhY/w-d-xo.html th-cam.com/video/iXdDt7EqTSY/w-d-xo.html
Simplify Formula In Excel and Google Sheet with LAMBDA (Named Function)
มุมมอง 41121 วันที่ผ่านมา
Use the LAMBDA function to simplify any formula in Excel and Name Function in Google Sheets. DOWNLOAD Free Excel file for this video: Google Sheets Link: Excel Lambda Function: The LAMBDA function in Excel enables users to create custom functions for recurring calculations, simplifying complex formulas. At a basic level, it converts long formulas into user-friendly functions, standardizing calc...
Build a Custom Dynamic and Interactive Chart in Excel | No Pie Chart!!
มุมมอง 11521 วันที่ผ่านมา
Learn how to create a custom dynamic and interactive chart in Excel to visualize your data effectively. This guide will walk you through step-by-step instructions, using Excel’s powerful tools such as dropdowns, slicers, and formulas, to build a chart that updates automatically based on user input. Whether you're a beginner or an advanced Excel user, this tutorial will help you enhance your dat...
Create Dependent Data Validation dropdown list with XLOOKUP in Excel
มุมมอง 71921 วันที่ผ่านมา
Create fully dynamic Dependent dropdown with simple and easy Xlookup. File link: shorturl.at/TlLI3 CHAPTERS 0:00 Creating the First Level Dropdown 0:29 XLOOKUP Formula for Second Level Dependent Dropdown 1:55 Applying the Formula how to apply the XLOOKUP formula and ensure it works correctly. 2:34 Creating a Third Level Dropdown List Techniques and methods for adding a third level dependent dro...
Step-by-Step: Excel Gantt Chart for Beginners
มุมมอง 36328 วันที่ผ่านมา
Learn How to Create Simple & Effective Gantt Chart for Small Project. File Link: shorturl.at/mXzHg 0:00 Intro 0:31 Formula Creating in Helper Columns 2;20 Inserting Chart 3:55 Inserting & Formuatting Error Bars 5:26 Data Label & Marker formatting Excel Gantt Chart Made Easy for Small Projects How to Create a Simple Gantt Chart in Excel Small Project Gantt Chart: Quick Guide in Excel Step-by-Ste...
Google Sheets: Advanced Multi-TAB Dependent Dropdown Data Validation Tutorial
มุมมอง 457หลายเดือนก่อน
Learn advanced dependent dropdowns using Data Validation across multiple tabs, enabling seamless and dynamic data management. Without developing Name Range and complex indirect method I will show a stright forward and easy way. Sheet Link: Hit a like and Download docs.google.com/spreadsheets/d/1x_99jDFPqASlVOFHa3c8Os81_n3_Ot-W0x3fsj3dnnI/copy Other useful Video: Most Watch Video of Dropdown :th...
Create Multiple Dependent Dropdowns in Google Sheets TABLE
มุมมอง 672หลายเดือนก่อน
Learn how to create dynamic dropdown lists in Google Sheets that update automatically! In this tutorial, we'll show you a step-by-step guide on how to create dependent dropdown lists in Table that dynamically update based on changing data in your Google Sheet. This is a game-changer for anyone who uses Google Sheets for data analysis, reporting, or tracking. With this technique, you'll be able ...
Create Availability Gantt Chart in Excel
มุมมอง 99หลายเดือนก่อน
Learn how to create a weekly availability Gantt chart to effectively manage your team's workload and schedules. This video tutorial will guide you through the process of creating a Gantt chart that showcases your team members' availability on a weekly basis. By the end of this video, you'll be able to create a visually appealing and informative chart that helps you identify availability pattern...
No More Pie Charts! Create Bar Chart Labels Percentage % and Value Excel Google Sheets
มุมมอง 499หลายเดือนก่อน
Learn how to create informative and visually appealing bar charts in Excel and Google Sheets with dual labels that display both percentage and value. Say goodbye to pie charts and hello to a more effective way of presenting data. In this tutorial, we'll show you a step-by-step guide on how to create bar chart labels that display both the percentage and value, making it easy to analyze and under...
Distinct Values in Drop-Down List in Google Sheets
มุมมอง 149หลายเดือนก่อน
In this tutorial, I will explain the steps to obtain only unique values in a drop-down list in Google Sheets. What does it mean? If an item is already selected in one drop-down, it won’t be available for selection in another drop-down. This prevents duplicates in the drop-down selections. Removing Used Items from Data Validation Drop-Down Lists - Understanding the Scenario How to Get Distinct V...
Dual Data Label in Excel Chart & Google Sheets
มุมมอง 419หลายเดือนก่อน
Learn why dual data labels are essential in charts, when to skip pie charts, and how to use dual labels in Excel and Google Sheets Chart, Dashboard. 0:00 Introduction 0:20 Method 1: Simple Data Source 2:09 Method 2: Pivot Table Source Data 4:42 Method 3: Google Sheets Dual Label Chart File Link: drive.google.com/uc?export=download&id=1h5X_KKBAUlQa8H0uPc-jEIWKIIeI-YNd Other Useful Video: th-cam....
Interactive Excel Dashboard with Power BI Cross Filtering
มุมมอง 322หลายเดือนก่อน
Learn, How easy Create Interactive Dashboard in Excel with Cross filtering effect similar to Power BI. This technique is useful if you want to highlight specific month and view the overall summary. File Link: drive.google.com/uc?export=download&id=12x7nngFvY-SNPB7kqwtyalVbmEV_nGFq Other Useful Video to Enjoy: th-cam.com/video/V4L2uFV1svI/w-d-xo.html th-cam.com/video/9wAadpvLrY4h/w-d-xo.htmlttps...
Create Dynamic Excel Column Chart for Climate Averages
มุมมอง 122หลายเดือนก่อน
Create Dynamic Excel Column Chart for Climate Averages
Easy Method: Create Multiple Dependent Dropdowns Across Sheets in Excel
มุมมอง 462หลายเดือนก่อน
Easy Method: Create Multiple Dependent Dropdowns Across Sheets in Excel
Sparkline Clean Dynamic Bar Chart Google Sheets
มุมมอง 124หลายเดือนก่อน
Sparkline Clean Dynamic Bar Chart Google Sheets
Master Excel Timeline Slicer Dynamic Previous Period COMPARISON!
มุมมอง 3282 หลายเดือนก่อน
Master Excel Timeline Slicer Dynamic Previous Period COMPARISON!
Slicer to Anaylze Specific Columns in Excel Chart
มุมมอง 1362 หลายเดือนก่อน
Slicer to Anaylze Specific Columns in Excel Chart
Highlight & Calculate Specific Columns in Excel Charts Like a Power BI Pro
มุมมอง 6082 หลายเดือนก่อน
Highlight & Calculate Specific Columns in Excel Charts Like a Power BI Pro
Unlock NEW Dynamic Slicers with Multi-Selection DROPDOWNS in Google Sheets
มุมมอง 4092 หลายเดือนก่อน
Unlock NEW Dynamic Slicers with Multi-Selection DROPDOWNS in Google Sheets
Convert Text URLs into Clickable Links Google sheets
มุมมอง 1912 หลายเดือนก่อน
Convert Text URLs into Clickable Links Google sheets
Create Custom Waterfall Chart in Excel
มุมมอง 2802 หลายเดือนก่อน
Create Custom Waterfall Chart in Excel
Generate or Create All Combinations Three Column Excel Formula (Two Methods)
มุมมอง 9732 หลายเดือนก่อน
Generate or Create All Combinations Three Column Excel Formula (Two Methods)
How to Change Chart Type with Excel Formula
มุมมอง 1752 หลายเดือนก่อน
How to Change Chart Type with Excel Formula
Generate or Create all Possible Combinations from Two Column, Pair, List, using Excel Formula
มุมมอง 9132 หลายเดือนก่อน
Generate or Create all Possible Combinations from Two Column, Pair, List, using Excel Formula
Display % Percentage, Difference & Value in Excel Column Charts
มุมมอง 4303 หลายเดือนก่อน
Display % Percentage, Difference & Value in Excel Column Charts
I dont know how to make 4th level? 😅
Same as third method
Great 👍 👌
Fantastic ❤
awesome
I cnt find clipboard on mac. Please help
I am sorry. I do not have any clue about the clip board on Mac
What if I need to duplicate the Dropdown List worksheet to get a Daily sheet?
Watch my other video. I developed other video to cover this
Da Data
Sir good you marked two sales and only you show the only one . Another you sent back side sir why
It's better design
@DataDashPro ok sir
how clever you are, the best
nice video
Glad you like it
Perfect, thanks 👍
would you please be able to download the sheet you just shown?
I think it's in description?
Excellent functionality and you explained it so clearly that my grandma could figure this out. Thank you!
Oh that's cool your grandma is sharp.
Super useful 🙏
very useful
I'm glad you found this helpful!
Thank you
Glad you like it
Great video!
Can You Sum Conditional Formatted Colors (Display Colors)?
Some how we can do. Let review work on this
Excellent 👍🏾
Thank you
very useful trick
Awesome, I'm glad you found this helpful!
This really works, thanks..
Hi dash I hope you are well, I need help when I do the transpose I have a lot of categories, and the quantity of columns are not enough for example I have almost 300 categories, How do I do that? theres another way to do this? I just want second level
Is it possible to share a sample sheet link to review it and then suggest best method
@@DataDashPro thanks for the answer I'd found the solution. I just add more columns to the right. like 600 cells, and it works for me, the issue was because i was no able to make transpose because the limits of columns.
@@alvarorodriguez1428 that's greate. if you want to optimize it further i am happy to see your sheet.
Great Bro
Amazing Bro
doesnot work
Did you apply in excel?
Thanks really helpful for the guide 👍
Wow! That's Great.
There i have found another issue that if you do make a another sheet you have to do the same practice for every sheet its a barrier.
Did you watch a new video? I cover the issue
have a look to this video. th-cam.com/video/JMX8UNsHfag/w-d-xo.html
Thanku so much sir ❤
again thanks for your all support really helpful and you got a new sub.
Thank you soo much
thank you very much helpful really appticiated
I have error coming. In formula showing _xlfn. Why this error bro can you help
What is your excel version?
Which excel version you using and your excel format sheet coming error. Please help
Excel 365
Incredible video. Event CHATGPT couldn't help me with this.
I believe Mark Proctor deserves the credit
❤ fantastic ❤
I'm glad you found it helpful!
Very helpful tutorial video!!! Just what I was looking for! Great job!
Awesome, I'm glad you found this useful!
Obrigado! Era isso que eu precisava e com certeza não iria conseguir sozinho!
idk why it's not working for me
watch this new concept its much better to apply. th-cam.com/video/nD3_BbY5BCI/w-d-xo.html
Just Awesome. Very Useful. You saved my labour. Thanks a lot.
Glad you like it
thanks for the video!
Bro god exists.. I'm telling you.... I was trying to do this by using your last video, finished that video and finished the sheet. Experianced the same issue. Came back to your channel and Boom.... New video with a solution 😍😍😍😍
Good News: Using Google Sheets Table we can Easily Create Multi Level dependent dropdown, Insert & Delete rows and it will still work. Don't wait watch my new video : th-cam.com/video/nD3_BbY5BCI/w-d-xo.html
Hi! can you also make dynamic QR codes in word? :D
What mean by dynamic in your case?
@@DataDashPro dynamic in the sense where i can change the URL behind the QR-code. So the. QR code remains the same, but i can change the content it redirects to?:)
@@AnneMariaGamdrup But you only need to change text in edit mode. I think if you watch the video how i switch from text view to QR view
Thanks soo much
Glad you like it
when i applied same formula it didnot work, then i have copied from your sheet started working , hahhaha
You need to pay attention to each and everything. Glad my sheet help you
My comment for the algorythm! Well presented!
Looks like I found a gem of a TH-camr!
Works great!
Good to hear!