101 Excel Hacks
101 Excel Hacks
  • Видео 45
  • Просмотров 37 675
Recreate a Knowledge Management Dashboard in Excel
Learn how to create a professional Knowledge Management Dashboard in Excel from scratch! 🚀 This tutorial will guide you through each step of building the UI for a dynamic and visually appealing dashboard that organizes and tracks knowledge resources effectively.
📊 What you'll learn in this video:
- Designing a clean, user-friendly layout for your dashboard
- Creating interactive charts, KPI panels for easy navigation
Whether you're a knowledge manager, team leader, or Excel enthusiast, this video will help you build a dashboard that centralizes critical information and supports better decision-making. 💡
💻 Don’t forget to like, comment, and subscribe for more Excel tutorials and productivity ti...
Просмотров: 18

Видео

How to build a Supplier Health Tracker in Microsoft Excel
Просмотров 1532 месяца назад
Here's a walkthrough on how I recreated the Supplier Health Tracker performance dashboard in Microsoft Excel.
Recreate this Contact Channel Dashboard in Microsoft Excel
Просмотров 2096 месяцев назад
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!
Create a Pivot Table Competency Dashboard in Microsoft Excel
Просмотров 666 месяцев назад
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
Просмотров 1647 месяцев назад
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
Просмотров 577 месяцев назад
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
Просмотров 4918 месяцев назад
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
Просмотров 458 месяцев назад
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)
Просмотров 1138 месяцев назад
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
Просмотров 1339 месяцев назад
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
Просмотров 1059 месяцев назад
Here's a quick tutorial showing how to build a battery bar chart in Microsoft Excel.
Create an Investment Planning Model in Microsoft Excel
Просмотров 849 месяцев назад
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
Просмотров 361Год назад
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
Просмотров 6 тыс.Год назад
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)
Просмотров 3592 года назад
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
Просмотров 4182 года назад
Create a KPI dashboard in Microsoft Excel
Build a training performance report in Microsoft Excel
Просмотров 1102 года назад
Build a training performance report in Microsoft Excel
Convert a JPG into Microsoft Excel
Просмотров 1842 года назад
Convert a JPG into Microsoft Excel
Create a VLOOKUP dashboard from an Excel database in minutes!
Просмотров 9242 года назад
Create a VLOOKUP dashboard from an Excel database in minutes!
Create an emoticon drop-down field in Microsoft Excel
Просмотров 7562 года назад
Create an emoticon drop-down field in Microsoft Excel
Build an interactive plant database in MS Excel
Просмотров 2,2 тыс.3 года назад
Build an interactive plant database in MS Excel
Interactive botanical repository built in Microsoft Excel
Просмотров 1803 года назад
Interactive botanical repository built in Microsoft Excel
Can we recreate this KPI dashboard in MS Excel
Просмотров 3473 года назад
Can we recreate this KPI dashboard in MS Excel
Can we recreate this Avocado performance dashboard in MS Excel?
Просмотров 1743 года назад
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)
Просмотров 783 года назад
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)
Просмотров 453 года назад
Build a car expense model in MS Excel (Part II - Building the scenario layer)
Build a car expense model in MS Excel
Просмотров 1453 года назад
Build a car expense model in MS Excel
CAN WE RECREATE THIS PROGRAMME STATUS DASHBOARD IN EXCEL (THE EXTREME EXCEL SERIES)
Просмотров 2114 года назад
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)
Просмотров 6954 года назад
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,4 тыс.4 года назад
Can we recreate this salesperson scorecard in MS Excel (THE EXTREME EXCEL SERIES)

Комментарии

  • @paulw8579
    @paulw8579 День назад

    Great great job 👍 How about the sample data behind it to make the infographics dynamic? Look forward to that 👏

  • @AlifianDarmawan
    @AlifianDarmawan 15 дней назад

    can this works with pivot table & pivot chart?

  • @obano456n
    @obano456n 27 дней назад

    Thanks for this video. I have tried it, and it works, but I am stuck when I try to set macros for countries with multiple names, e.g. South Africa and the Central African Republic. It keeps showing me errors when I use the VBA functions. I would appreciate your suggestions on moving forward.

  • @michaelhortle594
    @michaelhortle594 28 дней назад

    I too am very interested in this template for a local plant project in Tasmania, however the link still does not seem to function. Would greatly appreciate if you could review it. Thanks.

  • @obano456n
    @obano456n Месяц назад

    How did you configure the flags to change as well

  • @gojalisitohang7585
    @gojalisitohang7585 Месяц назад

    Hello, do you have the rest of the videos? it's really helpful. Thankyou very much

  • @grahamsmith5240
    @grahamsmith5240 4 месяца назад

    Is there a way to update the table with the employee's using a list. So employees can be added/removed.

  • @grahamsmith5240
    @grahamsmith5240 4 месяца назад

    Great calendar but I have 50+ employee's. do you have one for 50 employee's

  • @AbúbàkàrSadiqaliyu-u4x
    @AbúbàkàrSadiqaliyu-u4x 6 месяцев назад

    Where will we get the map???

    • @alyssamia4689
      @alyssamia4689 5 месяцев назад

      i’m wondering the same thing

  • @troycleofe5967
    @troycleofe5967 7 месяцев назад

    i CAN'T GET THE PART ON SUMMARIZING THE PIVOT TABLE IT STOPS ME THERE

  • @tunjigeorge5666
    @tunjigeorge5666 7 месяцев назад

    Apt 👌

  • @ShivaSingh-vs4yv
    @ShivaSingh-vs4yv 7 месяцев назад

    Didn’t quite understand 😢the highlight part

    • @101excelhacks8
      @101excelhacks8 7 месяцев назад

      Oh, which section on particular? Could you confirm the timestamp of the area? Thanks

  • @sheenaorihuela8264
    @sheenaorihuela8264 7 месяцев назад

    Can i get this for free template. I am building up an archiving of edible plants in our country. Thank you so much

    • @101excelhacks8
      @101excelhacks8 7 месяцев назад

      It's available at this link: 101excelhacks.co/downloads/

    • @sheenaorihuela8264
      @sheenaorihuela8264 7 месяцев назад

      ​Thank you for the reply. But, i couldnt find it your shop list . ​@@101excelhacks8

    • @MarcosCappa
      @MarcosCappa 5 месяцев назад

      @@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

    • @101excelhacks8
      @101excelhacks8 5 месяцев назад

      @@MarcosCappa I've updated it, you can check it out now. Thanks for bringing my attention to this.

    • @MarcosCappa
      @MarcosCappa 5 месяцев назад

      @@101excelhacks8 thanks a lot ❤

  • @DavidGreer-nk3yj
    @DavidGreer-nk3yj 7 месяцев назад

    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?

    • @101excelhacks8
      @101excelhacks8 7 месяцев назад

      Thanks - I explained this in another video in the series, link is here: ruclips.net/video/bZkNr8KHfgs/видео.htmlsi=9v-cN3XQoHedmcLL

  • @FranciscoJose-fh6fn
    @FranciscoJose-fh6fn 7 месяцев назад

    Congratulations, very beautiful show, file available for download...

  • @Favenez
    @Favenez 8 месяцев назад

    Thank you very much for sharing Would be great to leave a template for practice

    • @101excelhacks8
      @101excelhacks8 8 месяцев назад

      Sure thing - will keep that in mind for the subsequent videos. Thanks!

  • @Berrybooo
    @Berrybooo 9 месяцев назад

    قصرتي

  • @estebanleguizamon3130
    @estebanleguizamon3130 10 месяцев назад

    Great tutorial!!!! It's unfortunate that it wasn't a bit slower for us beginners!

    • @101excelhacks8
      @101excelhacks8 9 месяцев назад

      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.

  • @GoldenTouch-l8z
    @GoldenTouch-l8z 11 месяцев назад

    is it possible to do it in spreadsheet?

  • @SoKatyLeigh
    @SoKatyLeigh Год назад

    Thank you for the tutorial! It was an immense help for a calendar I had to put together for work

  • @srikanthpullela
    @srikanthpullela Год назад

    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.

    • @mowunmi7189
      @mowunmi7189 Год назад

      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

  • @usmanakbar8818
    @usmanakbar8818 Год назад

    you are great miss thanks for making the tutorial on this topic. Its really helpful

  • @briannajcoleman
    @briannajcoleman Год назад

    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.

  • @omhoogmetjay
    @omhoogmetjay Год назад

    How to get an image like that?

  • @samchannels7
    @samchannels7 Год назад

    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

  • @gordanstanic8587
    @gordanstanic8587 Год назад

    Great work. Keep it up

  • @garybaitson
    @garybaitson 2 года назад

    does the video play fully for others? its glitchy and freezes half way

    • @101excelhacks8
      @101excelhacks8 2 года назад

      Ah, must have been an upload error. Will correct. Thanks for pointing this out 🙏

  • @abg.create
    @abg.create 2 года назад

    I love this. I wish the video is not too fast so I can follow along.

  • @chadmolligan5418
    @chadmolligan5418 2 года назад

    How?

  • @arnoldday5412
    @arnoldday5412 2 года назад

    😔 ρ尺oΜ𝐎ᔕᗰ

  • @DeepakKhandelwalOfficial
    @DeepakKhandelwalOfficial 2 года назад

    Awesome!

  • @adeloretechsolutions
    @adeloretechsolutions 2 года назад

    When is the next video pls

  • @anapatino4782
    @anapatino4782 3 года назад

    This is impressive WOW!

  • @dezeindra2190
    @dezeindra2190 3 года назад

    How if i want to use my own map...

  • @jorgepau3099
    @jorgepau3099 3 года назад

    Ohhhh :)!

  • @jorenbugarin1784
    @jorenbugarin1784 3 года назад

    the MAP you use is a PNG or Shape File format?

    • @101excelhacks8
      @101excelhacks8 3 года назад

      It is a bitmap file (.bmp). It was originally a .shp file I believe but it got converted.

    • @jorenbugarin1784
      @jorenbugarin1784 3 года назад

      @@101excelhacks8 after convert your map as (.bmp) how do you insert in excel as a shape?

    • @101excelhacks8
      @101excelhacks8 3 года назад

      @@jorenbugarin1784 you just copy the shape and paste it in excel

  • @jorenbugarin1784
    @jorenbugarin1784 3 года назад

    Full tutorial please

  • @radekkuszyk
    @radekkuszyk 3 года назад

    Thanks 🙂

  • @paulrussell8801
    @paulrussell8801 3 года назад

    What’s up?! Liked the video, good job! Have you ever thought about using PromoSM to help grow your channel?!

  • @borispeulic5579
    @borispeulic5579 3 года назад

    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...

  • @sasy1229
    @sasy1229 3 года назад

    is it interactive?

  • @chethikumar9789
    @chethikumar9789 3 года назад

    What version of excel we should use for these kind of dashboard?

  • @cosmicconnections2800
    @cosmicconnections2800 3 года назад

    Very nice 👍 keep it up ma'am

  • @giandenorte
    @giandenorte 3 года назад

    You are so good in excel. Keep it up 🤩

  • @acpioneer
    @acpioneer 3 года назад

    this is amazing. please upload this kind of videos frequently.

  • @hleyjr
    @hleyjr 3 года назад

    faster please lol

  • @markwilhelm1304
    @markwilhelm1304 3 года назад

    very happy to see this......but can I download the files to see it "Under the Hood"?

  • @chineduokerekeocha4710
    @chineduokerekeocha4710 3 года назад

    Really great! You actually inspired me to build my first model in excel for my work. Thank you.

  • @thekunga
    @thekunga 3 года назад

    Love your videos! Keep up with your excelent work! Thank you and regards from Portugal

  • @pumex030
    @pumex030 3 года назад

    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.

    • @101excelhacks8
      @101excelhacks8 3 года назад

      This took about 3 hours - most of the time was spent labelling the African country shapes. They could be fiddly to work with, particularly if there are a lot of smaller shapes, but the goal is to reuse it as a template for map dashboards so the time spent is worth the effort.