TECH-017 - Create a presentation in Excel and navigate through it like a website

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to create a spreadsheet that you can navigate through the same way you do in a website. Prepare your presentation in Excel in case you are going to be modifying data and you do not want to be going back and forth from and to power point. For this exercise we will be using hyperlinks. I highly recommend you check out our previous video TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet • TECH-012 - Create link...
I hope this concept is something you can use in your daily routine so you get more with less effort.
If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task
kzread.info?o=U&vide...
* TECH-015 - Count total days by day of the week in a calendar in Excel • TECH-015 - Count total...
* TECH-014 - Create a progress tracker with check box buttons in Excel
• TECH-014 - Create a pr...
* TECH-013 - Create a bar chart with conditional formatting in Excel
• TECH-013 - Create a ba...

Пікірлер: 58

  • @hankgrimes1806
    @hankgrimes18065 жыл бұрын

    This is, by far, one of the coolest and most useful tips I've come across in a long time. Can't thank you enough for sharing this!!

  • @bbcc2020
    @bbcc20203 жыл бұрын

    Have you stopped your presentations? please come back where you are. You're simply the best in the marketplace, straightforward, and easy to customize. Great job!

  • @jonathanbarrick9690
    @jonathanbarrick96905 жыл бұрын

    Tech the excel challenge. Where did you go? Your videos have been the best by far. I hope you come back with more videos or instructions on how to learn from you.

  • @minimal2224
    @minimal22244 жыл бұрын

    Wow this really really is going to be useful! thank you so much for taking the time to make this

  • @falahalugaily6752
    @falahalugaily67524 жыл бұрын

    Great tool. Thank you!

  • @gorilla4661
    @gorilla46616 жыл бұрын

    I love on how you teach excel. Simple.neat.and complete.

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    LOL, thanks again Norman. T-E-CH

  • @markperdigon
    @markperdigon4 жыл бұрын

    Thank you so much. Liked and Subscribed! :)

  • @andreja1973
    @andreja19733 жыл бұрын

    This is an excellent presentation. you are brilliant communicator who clearly knows his stuff. continue with the great work. I have learnt.

  • @ramgaicai
    @ramgaicai4 жыл бұрын

    Thanks! This helped!

  • @hiamkace171
    @hiamkace171Ай бұрын

    This is amazing bro, thanks a lot.

  • @mehdihammadi6145
    @mehdihammadi61455 жыл бұрын

    Thank you for sharing, this is very useful

  • @lewissigauke1057
    @lewissigauke10574 жыл бұрын

    this is great!

  • @johnklaiber7733
    @johnklaiber77334 жыл бұрын

    Great tutorial. Is there a way to have those four pages automatically rotate without having to use buttons? I would like to show multiple tables as a status board periodically rotating between pages.

  • @benrandom742
    @benrandom7422 жыл бұрын

    well done and thank you for sharing. was very helpful.

  • @RoddyDa
    @RoddyDa4 жыл бұрын

    Straight up awesome

  • @crazyjestor435
    @crazyjestor4352 жыл бұрын

    Omg this is awesome I needed this for work projects

  • @brianlokwawi4030
    @brianlokwawi40303 жыл бұрын

    Thanks for the video it is very informative!

  • @oliveromsberg1976
    @oliveromsberg197611 ай бұрын

    The opportunities given by your tips are only limited by our fantasies. Thank you for helping me level up my, and other students which I will share these tips with, academic life.

  • @paradox3042
    @paradox30428 ай бұрын

    You're a life saver ❤

  • @ReginaldPriceSkillions
    @ReginaldPriceSkillions2 жыл бұрын

    I will use this much thanks you earned a sub

  • @googlopooglo1469
    @googlopooglo14693 жыл бұрын

    I have learnt very well thank t you soooo much.Sir

  • @mihirjichkar683
    @mihirjichkar6833 жыл бұрын

    GREAT one

  • @ReginaldPriceSkillions
    @ReginaldPriceSkillions2 жыл бұрын

    You are awesome great video!

  • @ZOneStore-cy8vv
    @ZOneStore-cy8vv4 жыл бұрын

    It's help for my virtual interview. Thanks!

  • @TheExcelChallenge

    @TheExcelChallenge

    4 жыл бұрын

    Good to hear Zeneration Squad and good luck in your interview. Thanks for watching. T-E-CH

  • @fredicoventures3189
    @fredicoventures31893 жыл бұрын

    Tnx 4 d presentation. I like it

  • @allymigeyo9870
    @allymigeyo98704 жыл бұрын

    Great 👏

  • @bharath8027
    @bharath80273 жыл бұрын

    Thank you so much

  • @venkatachalapathibaskar5927
    @venkatachalapathibaskar59275 жыл бұрын

    Great.

  • @hdeeb4471
    @hdeeb4471 Жыл бұрын

    Thanks a lot dear for your effort

  • @muhammadhassankasmani2241
    @muhammadhassankasmani22416 жыл бұрын

    Thanks for this awesome video. Do u have any website too? And please do upload these types of videos on a regular basis so that we can learn more effectively. Thanks again.

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    Hello Mhassan Kasmani. I'm glad you liked the video. Now, regarding a website, no, I don't have a website yet. My domain www.theexcelchallenge.com takes you to my KZread channel. I would like to eventually create a website where I can post the actual files for people to download for free but I'm not there yet. On the other hand, although I don't have a website yet, these past weeks I have been working on expanding my content into other Social Media websites, and now The Excel Challenge is also in LinkedIn, Twitter, Facebook, Google+ and Pinterest in case the viewers prefer to follow me in one of these websites. Lately, working on these Social Media websites has taken a lot of my time and focus away from producing videos, but I'm planning to get back at that so I can share more tips and tricks with you guys. Thanks for your comment and thanks for watching. T-E-CH

  • @duraigowtham1916
    @duraigowtham19162 жыл бұрын

    Great video 👍👍

  • @bettinarosericarter
    @bettinarosericarter5 жыл бұрын

    Wow I learned something today, Ctrl + drag to copy paste the button, I didn't know that before, thank you for making this video😉

  • @TheExcelChallenge

    @TheExcelChallenge

    5 жыл бұрын

    Hello Bettina. I’m glad to hear you learned something from my video. That’s the whole purpose of sharing it with everyone. Thanks for your feedback. T-E-CH

  • @bettinarosericarter

    @bettinarosericarter

    5 жыл бұрын

    Im one of your subscribers now, hoping to learn more from you.👍

  • @aldu_xtreme2973
    @aldu_xtreme29735 жыл бұрын

    please make a video how to create habit tracker on excel... this also includes maximum streak, current streak..

  • @lehlohonololemphane124
    @lehlohonololemphane124Ай бұрын

    Wow nice

  • @salimpatel745
    @salimpatel7456 жыл бұрын

    I LIKE IT 👏👏

  • @TheExcelChallenge

    @TheExcelChallenge

    6 жыл бұрын

    It's good to hear you liked it Salim. I hope you can create nice presentations with this tip. T-E-CH

  • @CoolHomeTech
    @CoolHomeTech4 жыл бұрын

    Super 👌

  • @biplabgayen5400
    @biplabgayen54004 жыл бұрын

    Hello sir , could you make an Excel file to make school automatic class routine for different subject and different class teachers. Please make a vedio in this regard. Thank you.

  • @hankgrimes1806
    @hankgrimes18065 жыл бұрын

    Last comment, I promise: Will the same technique work if the buttons were aligned vertically? I ask because I have sheets that are MUCH longer horizontally than vertically, and it would be easier to scroll from left to right.

  • @TheExcelChallenge

    @TheExcelChallenge

    5 жыл бұрын

    Yes sir, they will. The position of the button is irrelevant. What matters is the link. Play with it and if you have more questions, just drop them here in the comments. Thanks T-E-CH

  • @nicolaconte3887
    @nicolaconte38872 жыл бұрын

    Thanks

  • @graciousoctavius6375
    @graciousoctavius6375 Жыл бұрын

    Wow! How did you make the screen wave like a page? I wanna learn that too!

  • @Nikolay_Shyshkin_NSAds
    @Nikolay_Shyshkin_NSAds5 жыл бұрын

    where can i download this file ?

  • @hankgrimes1806
    @hankgrimes18065 жыл бұрын

    Are you planning to present any full-length courses in the future? I think it would be very gratifying to study other Excel features under you tutelage.

  • @colekasen9843

    @colekasen9843

    2 жыл бұрын

    Sorry to be so off topic but does anybody know a tool to log back into an Instagram account..? I somehow forgot the password. I would appreciate any tips you can give me.

  • @jaycemarcelo2634

    @jaycemarcelo2634

    2 жыл бұрын

    @Cole Kasen Instablaster =)

  • @colekasen9843

    @colekasen9843

    2 жыл бұрын

    @Jayce Marcelo thanks for your reply. I found the site through google and I'm trying it out atm. Takes a while so I will reply here later with my results.

  • @colekasen9843

    @colekasen9843

    2 жыл бұрын

    @Jayce Marcelo It did the trick and I now got access to my account again. Im so happy! Thanks so much you really help me out!

  • @jaycemarcelo2634

    @jaycemarcelo2634

    2 жыл бұрын

    @Cole Kasen No problem xD

  • @mohsinshafique6018
    @mohsinshafique60184 жыл бұрын

    good

  • @susannduta
    @susannduta4 жыл бұрын

    Hi are you still around? I may need your help, I really appreciate your video's

  • @TheExcelChallenge

    @TheExcelChallenge

    4 жыл бұрын

    Hello Susan. Yes, I am around. How can I help you?

  • @goachingoulding3926
    @goachingoulding39262 жыл бұрын

    สวัสดีครับวันนี้เมื่อวานนี้เค้านิล่ะชื่อคุณฯ((สายันต์เกรียงไกร))