101 Excel Hacks
101 Excel Hacks
  • 43
  • 32 848
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!
Переглядів: 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
Convert a JPG into Microsoft Excel
Переглядів 176Рік тому
Convert a JPG into Microsoft Excel
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)
Build a car expense model in MS Excel
Переглядів 1133 роки тому
Build a car expense model in MS Excel
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)

КОМЕНТАРІ

  • @AbúbàkàrSadiqaliyu-u4x
    @AbúbàkàrSadiqaliyu-u4x Місяць тому

    Where will we get the map???

  • @troycleofe5967
    @troycleofe5967 Місяць тому

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

  • @tunjigeorge5666
    @tunjigeorge5666 Місяць тому

    Apt 👌

  • @ShivaSingh-vs4yv
    @ShivaSingh-vs4yv 2 місяці тому

    Didn’t quite understand 😢the highlight part

    • @101excelhacks8
      @101excelhacks8 2 місяці тому

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

  • @sheenaorihuela8264
    @sheenaorihuela8264 2 місяці тому

    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 2 місяці тому

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

    • @sheenaorihuela8264
      @sheenaorihuela8264 2 місяці тому

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

    • @MarcosCappa
      @MarcosCappa 7 днів тому

      @@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 7 днів тому

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

    • @MarcosCappa
      @MarcosCappa 7 днів тому

      @@101excelhacks8 thanks a lot ❤

  • @DavidGreer-nk3yj
    @DavidGreer-nk3yj 2 місяці тому

    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 2 місяці тому

      Thanks - I explained this in another video in the series, link is here: ua-cam.com/video/bZkNr8KHfgs/v-deo.htmlsi=9v-cN3XQoHedmcLL

  • @FranciscoJose-fh6fn
    @FranciscoJose-fh6fn 2 місяці тому

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

  • @Favenez
    @Favenez 3 місяці тому

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

    • @101excelhacks8
      @101excelhacks8 3 місяці тому

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

  • @Berrybooo
    @Berrybooo 4 місяці тому

    قصرتي

  • @estebanleguizamon3130
    @estebanleguizamon3130 4 місяці тому

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

    • @101excelhacks8
      @101excelhacks8 4 місяці тому

      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.

  • @user-vj3us4xo1f
    @user-vj3us4xo1f 5 місяців тому

    is it possible to do it in spreadsheet?

  • @SoKatyLeigh
    @SoKatyLeigh 6 місяців тому

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

  • @srikanthpullela
    @srikanthpullela 7 місяців тому

    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 7 місяців тому

      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 10 місяців тому

    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 Рік тому

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

    • @101excelhacks8
      @101excelhacks8 Рік тому

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

  • @abg.create
    @abg.create Рік тому

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

  • @chadmolligan5418
    @chadmolligan5418 Рік тому

    How?

  • @arnoldday5412
    @arnoldday5412 Рік тому

    😔 ρ尺oΜ𝐎ᔕᗰ

  • @deepk82
    @deepk82 Рік тому

    Awesome!

  • @oladayobello720
    @oladayobello720 Рік тому

    When is the next video pls

  • @anapatino4782
    @anapatino4782 2 роки тому

    This is impressive WOW!

  • @dezeindra2190
    @dezeindra2190 2 роки тому

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

  • @jorgepau3099
    @jorgepau3099 2 роки тому

    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 2 роки тому

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

  • @khalidmounir3475
    @khalidmounir3475 3 роки тому

    amazing could u please make this tutorial more detailled thanks a lot

  • @surferol10
    @surferol10 3 роки тому

    Really great video. Thank you.

  • @Everyday_ploughman
    @Everyday_ploughman 3 роки тому

    Very clear and concise

  • @mtmichael_
    @mtmichael_ 3 роки тому

    Great video, but I can't download the map from the link provided

    • @101excelhacks8
      @101excelhacks8 3 роки тому

      I've fixed it now. Thanks for the heads up!

  • @aas2943
    @aas2943 3 роки тому

    good work !!! kindly create this in power bi

  • @Everyday_ploughman
    @Everyday_ploughman 3 роки тому

    Good thinking

  • @datalab365
    @datalab365 3 роки тому

    you have no contact on your about me section, would have needed to talk to you.

    • @101excelhacks8
      @101excelhacks8 3 роки тому

      Hi. You can contact me on my website - 101excelhacks.com. Apologies for the late response.