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
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!!
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!
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.
Wow this really really is going to be useful! thank you so much for taking the time to make this
Great tool. Thank you!
I love on how you teach excel. Simple.neat.and complete.
@TheExcelChallenge
6 жыл бұрын
LOL, thanks again Norman. T-E-CH
Thank you so much. Liked and Subscribed! :)
This is an excellent presentation. you are brilliant communicator who clearly knows his stuff. continue with the great work. I have learnt.
Thanks! This helped!
This is amazing bro, thanks a lot.
Thank you for sharing, this is very useful
this is great!
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.
well done and thank you for sharing. was very helpful.
Straight up awesome
Omg this is awesome I needed this for work projects
Thanks for the video it is very informative!
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.
You're a life saver ❤
I will use this much thanks you earned a sub
I have learnt very well thank t you soooo much.Sir
GREAT one
You are awesome great video!
It's help for my virtual interview. Thanks!
@TheExcelChallenge
4 жыл бұрын
Good to hear Zeneration Squad and good luck in your interview. Thanks for watching. T-E-CH
Tnx 4 d presentation. I like it
Great 👏
Thank you so much
Great.
Thanks a lot dear for your effort
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
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
Great video 👍👍
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
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
5 жыл бұрын
Im one of your subscribers now, hoping to learn more from you.👍
please make a video how to create habit tracker on excel... this also includes maximum streak, current streak..
Wow nice
I LIKE IT 👏👏
@TheExcelChallenge
6 жыл бұрын
It's good to hear you liked it Salim. I hope you can create nice presentations with this tip. T-E-CH
Super 👌
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.
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
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
Thanks
Wow! How did you make the screen wave like a page? I wanna learn that too!
where can i download this file ?
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
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
2 жыл бұрын
@Cole Kasen Instablaster =)
@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
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
2 жыл бұрын
@Cole Kasen No problem xD
good
Hi are you still around? I may need your help, I really appreciate your video's
@TheExcelChallenge
4 жыл бұрын
Hello Susan. Yes, I am around. How can I help you?
สวัสดีครับวันนี้เมื่อวานนี้เค้านิล่ะชื่อคุณฯ((สายันต์เกรียงไกร))