![101 Excel Hacks](/img/default-banner.jpg)
- 43
- 32 848
101 Excel Hacks
Приєднався 14 сер 2018
Recreate this Contact Channel Dashboard in Microsoft Excel
Can this cool contact channel performance dashboard be recreated using Microsoft Excel? There's only one way to find out :-) !
Don't forget to like, comment and subscribe!
Don't forget to like, comment and subscribe!
Переглядів: 194
Відео
Create a Pivot Table Competency Dashboard in Microsoft Excel
Переглядів 46Місяць тому
Let's build a Excel-based Competency Dashboard together! In this tutorial, I create a interactive dashboard that summarizes over 100 competencies across categories filtered using a pivot table and slicer. Don't forget to like, comment and subscribe for more 101 Excel Hacks videos.
Build a dynamic rollover dashboard in Microsoft Excel
Переглядів 1212 місяці тому
Walk with me as I create an interactive rollover chart that visualizes annual sales performance for fifteen customers in one dynamic orange dashboard. This took less than thirty minutes to set up, and is a great data visualization technique for maximizing dashboard space. Don't forget to comment, like and subscribe!
Recreate this portfolio dashboard UI in Microsoft Excel
Переглядів 472 місяці тому
A cool portfolio risk dashboard UI, in Microsoft Excel? Why not! Watch me as I give it a try. Remember to like, share and subscribe!
Build this AFCON Football Tournament Dashboard in Microsoft Excel
Переглядів 4143 місяці тому
It's Africa Day 2024, and the perfect day to release the walkthrough of this AFCON Tournament Dashboard built in Microsoft Excel. Link to the dashboard is available here: selar.co/133671
Recreate this customer growth performance dashboard in Microsoft Excel
Переглядів 373 місяці тому
I take on another pre-built dashboard and recreate it in Microsoft Excel. Remember to like, share and subscribe!
Create an interactive KPI Catalog in Microsoft Excel (no VBA)
Переглядів 913 місяці тому
Walk with me as I create an interactive catalog for viewing 8,000 KPIs across 31 KPI categories in a single one-page dashboard, in Microsoft Excel. No VBA macros were required - the magic is all from Excel Form Controls. Don't forget to like, share, subscribe!
Recreate this ecommerce dashboard in Microsoft Excel
Переглядів 894 місяці тому
Here's a video showing my attempt to recreate this ecommerce dashboard in Microsoft Excel. Watch and enjoy! Remember to like, share, comment and subscribe.
Build a dynamic battery bar chart in Microsoft Excel
Переглядів 694 місяці тому
Here's a quick tutorial showing how to build a battery bar chart in Microsoft Excel.
Create an Investment Planning Model in Microsoft Excel
Переглядів 494 місяці тому
This tutorial, I walk through how I created this simple investment planning model in Microsoft Excel. The model answers the question "How much do I need to earn and invest over the next 15 years?" The Excel file used in this tutorial is available for download here - selar.co/hd3o1v
Build a dynamic Nigeria map template in Microsoft Excel
Переглядів 24110 місяців тому
Here's a tutorial demonstrating how to set up a dynamic map in Excel that updates map data points, categories and colors with just a click of a button. Map template available for download here - selar.co/dynamicmap
Build an interactive employee attendance calendar in Microsoft Excel
Переглядів 3,9 тис.Рік тому
Here's the tutorial for how I built an automated employee absence calendar template in Microsoft Excel. Remember to like, share and subscribe!
Build dynamic hover pricing table in Microsoft Excel (with animated voice over)
Переглядів 255Рік тому
This week, I'm recreating the hover-style pricing tables popular in web design. Can li'l old Excel handle this dynamic web UI design element? Watch to find out! (Get ready for a bit of off-key singing: I recorded this very early in the morning and was trying to keep myself awake 😃) Remember to comment, like, share and subscribe!
Create a KPI dashboard in Microsoft Excel
Переглядів 406Рік тому
Join me as I attempt to recreate this KPI dashboard in Microsoft Excel. Remember to like, comment and subscribe! Music credit: Music from Uppbeat (free for Creators!): uppbeat.io/t/soundroll/feeling-home License code: DVHVHADNMJVQJLFK
Build a training performance report in Microsoft Excel
Переглядів 106Рік тому
Here's a step-by-step video showing how to build a training performance report in Microsoft Excel. Music credit: Music from Uppbeat (free for Creators!): uppbeat.io/t/soundroll/feeling-home License code: DVHVHADNMJVQJLFK
Create a VLOOKUP dashboard from an Excel database in minutes!
Переглядів 7812 роки тому
Create a VLOOKUP dashboard from an Excel database in minutes!
Create an emoticon drop-down field in Microsoft Excel
Переглядів 5682 роки тому
Create an emoticon drop-down field in Microsoft Excel
Build an interactive plant database in MS Excel
Переглядів 1,8 тис.2 роки тому
Build an interactive plant database in MS Excel
Interactive botanical repository built in Microsoft Excel
Переглядів 1262 роки тому
Interactive botanical repository built in Microsoft Excel
Can we recreate this KPI dashboard in MS Excel
Переглядів 3413 роки тому
Can we recreate this KPI dashboard in MS Excel
Can we recreate this Avocado performance dashboard in MS Excel?
Переглядів 1613 роки тому
Can we recreate this Avocado performance dashboard in MS Excel?
Build a car expense model in MS Excel (Part III: Link the visual layer to the back end and test)
Переглядів 753 роки тому
Build a car expense model in MS Excel (Part III: Link the visual layer to the back end and test)
Build a car expense model in MS Excel (Part II - Building the scenario layer)
Переглядів 423 роки тому
Build a car expense model in MS Excel (Part II - Building the scenario layer)
CAN WE RECREATE THIS PROGRAMME STATUS DASHBOARD IN EXCEL (THE EXTREME EXCEL SERIES)
Переглядів 2033 роки тому
CAN WE RECREATE THIS PROGRAMME STATUS DASHBOARD IN EXCEL (THE EXTREME EXCEL SERIES)
Can we recreate this performance dashboard in MS Excel (THE EXTREME EXCEL SERIES)
Переглядів 6694 роки тому
Can we recreate this performance dashboard in MS Excel (THE EXTREME EXCEL SERIES)
Can we recreate this salesperson scorecard in MS Excel (THE EXTREME EXCEL SERIES)
Переглядів 1,3 тис.4 роки тому
Can we recreate this salesperson scorecard in MS Excel (THE EXTREME EXCEL SERIES)
The Extreme Excel Challenge Series - Starts August 2020!
Переглядів 2764 роки тому
The Extreme Excel Challenge Series - Starts August 2020!
Can we recreate this customer support dashboard in Excel (THE EXTREME EXCEL SERIES)
Переглядів 7 тис.4 роки тому
Can we recreate this customer support dashboard in Excel (THE EXTREME EXCEL SERIES)
Where will we get the map???
i’m wondering the same thing
i CAN'T GET THE PART ON SUMMARIZING THE PIVOT TABLE IT STOPS ME THERE
Apt 👌
Didn’t quite understand 😢the highlight part
Oh, which section on particular? Could you confirm the timestamp of the area? Thanks
Can i get this for free template. I am building up an archiving of edible plants in our country. Thank you so much
It's available at this link: 101excelhacks.co/downloads/
Thank you for the reply. But, i couldnt find it your shop list . @@101excelhacks8
@@101excelhacks8 hi, I just checked your link and there's no link for the download. it only takes you back here to the tutorial, if you can fix that I'll be very grateful, thanks in advance
@@MarcosCappa I've updated it, you can check it out now. Thanks for bringing my attention to this.
@@101excelhacks8 thanks a lot ❤
How do you configure the country borders in the map? When you click on a country, the name comes up, but now does Excel know what the country borders look like?
Thanks - I explained this in another video in the series, link is here: ua-cam.com/video/bZkNr8KHfgs/v-deo.htmlsi=9v-cN3XQoHedmcLL
Congratulations, very beautiful show, file available for download...
Thank you very much for sharing Would be great to leave a template for practice
Sure thing - will keep that in mind for the subsequent videos. Thanks!
قصرتي
Great tutorial!!!! It's unfortunate that it wasn't a bit slower for us beginners!
Thanks! Sorry about the speed. You can adjust the speed of the video from the control settings. I had video length limitations so had to keep it within 25 minutes.
is it possible to do it in spreadsheet?
Thank you for the tutorial! It was an immense help for a calendar I had to put together for work
The last part of conditional formatting is not working for me . The colors don't show up for some reason. Would appreciate it if help is extended.
This may sometimes be because of your referencing. Check that your vlookup formula uses a relative reference (i.e. R7) and not an absolute ($R$7) or a mixed ($R7 or R$7) reference. Also confirm the table array in the vlookup uses an absolute reference in all scenarios. Another reason it may not work is spelling errors in the vlookup formula vis-a-vis the table, confirm "Off work", etc is spelled and has exactly the same type of spacing as the data in your tables. Please confirm if it works after checking these
you are great miss thanks for making the tutorial on this topic. Its really helpful
Hi there, I hope all is well with you. Can you please give a more in-depth breakdown of how you built the combo box? I am trying to follow the steps but I'm having a hard time. Thanks in advance, this tutorial is helping me to create a whole new database for my department.
How to get an image like that?
Hey I checked and checked but you did not continue and ur video is helping a lot if you don't mind can you pls help with the rest of the videos
Great work. Keep it up
does the video play fully for others? its glitchy and freezes half way
Ah, must have been an upload error. Will correct. Thanks for pointing this out 🙏
I love this. I wish the video is not too fast so I can follow along.
How?
😔 ρ尺oΜ𝐎ᔕᗰ
Awesome!
When is the next video pls
This is impressive WOW!
How if i want to use my own map...
Ohhhh :)!
the MAP you use is a PNG or Shape File format?
It is a bitmap file (.bmp). It was originally a .shp file I believe but it got converted.
@@101excelhacks8 after convert your map as (.bmp) how do you insert in excel as a shape?
@@jorenbugarin1784 you just copy the shape and paste it in excel
Full tutorial please
Thanks 🙂
What’s up?! Liked the video, good job! Have you ever thought about using PromoSM to help grow your channel?!
Really amazing way to explain and create everything. However, there are some downsides of what was created... For example, the Avg First Contact Resolution rate bar colours depend on the top/bottom value... E.G, in example, Sales enquiry is highest and gets blue, however, if Bug would be highest, then it would be blue (at least this is my assumption coming from the colours and the values for each category)... I also think that the star colour can be made dependent on the score, and hence, you would not need to order 1-2-3 based on the score, but it would actually be like in the dashboard... Especially since the ordering is not done based on "satisfaction" but number of solved... So, some improvements can be done, but is is a great start...
is it interactive?
What version of excel we should use for these kind of dashboard?
Any version from 2010 works
Very nice 👍 keep it up ma'am
You are so good in excel. Keep it up 🤩
Thank you! 😃
this is amazing. please upload this kind of videos frequently.
faster please lol
very happy to see this......but can I download the files to see it "Under the Hood"?
Really great! You actually inspired me to build my first model in excel for my work. Thank you.
Love your videos! Keep up with your excelent work! Thank you and regards from Portugal
It's awesome! But i have a question - how long does it take to do it? It look for me to much anoying and arduous work, however the results is very nice.
amazing could u please make this tutorial more detailled thanks a lot
Really great video. Thank you.
Very clear and concise
Great video, but I can't download the map from the link provided
I've fixed it now. Thanks for the heads up!
good work !!! kindly create this in power bi
Good thinking
you have no contact on your about me section, would have needed to talk to you.
Hi. You can contact me on my website - 101excelhacks.com. Apologies for the late response.