This is exactly what I was looking for. Thank you so much for creating this. Your steps were so easy to follow I'm well on my way to making a menu driven dashboard! Thank YOU!!
@Pinexl3 жыл бұрын
Glad it helped!
@syedashfaq72453 жыл бұрын
Same here
@lynasoua92092 жыл бұрын
Just because you used Game of Thrones character as team member names, you got my like!!!
@84rinne_moo4 жыл бұрын
A way to alter this is to create the dashboard on one tab, and then place a link in every other tab that links back to the dashboard tab. This might help some ppl with the kind of sheets/data you may have. I also would place this just above my headers and then freeze the two top rows to make it able to scroll through my data easily and filter easily with no problems whilst keeping the link back to the main dashboard handy at all times .
@recipehacker97523 жыл бұрын
Thanks ! Please share how you’d freeze those rows, as you had suggested (I.e., to keep them at the top of the window even during scrolling). I was not aware freezing rows was possible . Thank you.
@noblestride4 жыл бұрын
THANKS A BILLION!!! MADE MY SHEET CLUTTER FREE AND AMAZING!
@Pinexl4 жыл бұрын
Happy you found it so useful!
@suhaimiabdazais2 жыл бұрын
Just found and subscribed .. This is what I'm looking for.. Tqvm
@Pinexl2 жыл бұрын
Thanks! Happy you find the content useful!
@shaniwafa4 жыл бұрын
Awesome 👍👍👍 Very simple Technic Result is fantastic!! Thanks for idea Expecting more tricks and animation Technic in future
@Pinexl4 жыл бұрын
More to come! Thank you for your comment!
@manjunathk27674 жыл бұрын
Simple but very rich. Thanks
@Pinexl4 жыл бұрын
Thank you very much!
@Mamounhefni3 жыл бұрын
This smart, simple and elegant !!
@Pinexl3 жыл бұрын
Thank you very much!
@luisenc789 Жыл бұрын
You're a genius man! I love you!
@Pinexl Жыл бұрын
Thanks a lot! We love you too!
@diassetefle97754 жыл бұрын
Thanks for this Amazing tutorial, it looks like a web page
@Pinexl4 жыл бұрын
Glad it was helpful!
@anthonibritto54094 жыл бұрын
Your videos are so amazing and has inspired a lot. Please keep up the spirit.
@Pinexl4 жыл бұрын
Thank you very much! Really appreciate it!
@Jennk-lb5no4 жыл бұрын
Nice! Thanks for sharing! can't wait to try this for my next report
@Pinexl4 жыл бұрын
Happy to help! It should look amazing!
@NixelPresentation3 жыл бұрын
Yes. I could learn something new.
@Pinexl3 жыл бұрын
Hope it helps!
@alonsozuniga1013 жыл бұрын
Thanks a lot mate, excellent explanation!
@Pinexl3 жыл бұрын
Glad you liked it!
@DarA-by4fl3 жыл бұрын
Thank you for this tutorial. This is really impressive!
@Pinexl3 жыл бұрын
Thank you for watching!
@hamedsougue98183 жыл бұрын
Nice lesson thank so much
@Pinexl3 жыл бұрын
Glad you liked it!
@helendemore22259 ай бұрын
Excellent presentation 🙂
@ganeshshetepatil98294 жыл бұрын
Thanks for such nice demonstration...
@Pinexl4 жыл бұрын
And thank you very much for your comment!
@darkoldrocknroller4 жыл бұрын
WOW, very impressive. Thank you.
@Pinexl4 жыл бұрын
Thank you very much! We're happy you like it!
@belalzaqaibeh5072 Жыл бұрын
Perfect
@arijturner8419 Жыл бұрын
WOW I NEED TO DO IT NOW
@allen60314 жыл бұрын
This video made me to subscribe.... 👍
@Pinexl4 жыл бұрын
Thank you subscribing! More videos are coming soon!
@user-ou2wu7iy7k Жыл бұрын
Then how to take Print out, because when i tried, the print is coming with Dashboard, kindly advice
@Pinexl10 ай бұрын
Hello! You can hide the navigation panel by hiding the columns it is in. This way you can print the spreadsheet without it.
@AbuTalha-eo7pr4 жыл бұрын
Very Helpful. Thank you
@Pinexl4 жыл бұрын
Thank you for watching!
@MsBoolo2 жыл бұрын
Very impressive 👏 👌 👍
@Pinexl2 жыл бұрын
Thank you! Cheers!
@mnsoyan4 жыл бұрын
Amazing idea!!
@Pinexl4 жыл бұрын
Thank you very much!
@myrtle4113 жыл бұрын
This is a huge help, however, is there a way to prevent the menu pane from being distorted page-to-page because of row height changes in the datasets (e.g. lots of wrapped text creating a larger row height)?
@Pinexl2 жыл бұрын
Good question! Unfortunately, except for locking the sheet, so that the height of the rows is not changed, there really isn't a way using this method. As an alternative, you could use containers, objects or text boxes with hyperlinks, which you can adjust, so that they are not sized with cells.
@mansiagarwal37153 жыл бұрын
Hi, The tutorial is simple and easy to understand. I wanted to ask that how to hide the sub menus of "Data Input" from the other two menus.
@Pinexl3 жыл бұрын
Hello and thanks for the comment! The submenus are only shown in the Data Input sheet. If you don't add them in the others, they won't be visible!
@pv0315 Жыл бұрын
Beautiful work
@clarissaconvertino47424 жыл бұрын
Hi, thank you for the nice tip. In my case, each tab contains table, whose rows I want to filter eventually. Unfortunately the filtering function will hide certain rows, messing up the navigation pane. Any idea on how to fix this?
@Pinexl4 жыл бұрын
Good question! Unfortunately, this is the disadvantage of using this method. You have two alternatives: 1. Build the navigation menu horizontal in the first rows, not columns. This way you could filter data without breaking the navigation menu. However, if you hide columns, you'd have similar issues as in the beginning. 2. Instead of using cell values to write the sheet names, you can insert buttons - some simple square shape for example, and add a link in it to the other sheets. Hope this helps!
@dorzhimunkuev39594 жыл бұрын
Hello there, I just inserted a text box and attached the link. Then I changed the parameter of object positioning: move and size with cells to don't move or size with cells. Afterward while filtering it does not disappear or move. Generally, it looks the same as shown in this tutorial and you can apply some additional effects in shape tool. I hope it helps you.
@shimonkephaonwuneme33262 жыл бұрын
@@dorzhimunkuev3959 sure I did same using text box for everything. Then modify textbox size and properties to not move with the cells
@yobrunogabriel2 жыл бұрын
Very creative! Thanks
@Blue4736.3 жыл бұрын
That was beautiful
@Pinexl3 жыл бұрын
Thank you!
@ehsansepahsalari617 Жыл бұрын
So helpful, Thank you so much
@Pinexl Жыл бұрын
Glad it was helpful!
@mydigitalquill89453 жыл бұрын
very well done!!
@Pinexl2 жыл бұрын
Thanks a lot!
@dorsoolms4684 Жыл бұрын
Does this work on excel for ios? Cause it looks like it doesn't (at least not with shape buttons) and vba doesn't work either there. I would like to have buttons on my excel sheets on the ipad but so far no luck. They behave differently than on windows and when protecting a sheet they don't work/react at all.
@inglesfuncional3 жыл бұрын
Is there a way to freeze the navigation menu, so it would stay visible when we scroll vertically? Thanks
@Pinexl3 жыл бұрын
Hi and thanks for the question! You could build the navigation menu in the top rows horizontally, instead of vertically, and then freeze the rows. This way it will stay in place when scrolling down.
@millet29633 жыл бұрын
How to lock your template and only use the slicer and the navigation panel?
@Pinexl3 жыл бұрын
Hi and thanks for the comment! You can explore the Protect Sheet option in the Review tab. You can for example lock everything apart from selecting a cell.
@mazhariqbal36544 жыл бұрын
Its Ok, but problem is that when we scroll down the sheet, navigation cells navigate too, any solution?
@Pinexl4 жыл бұрын
Hi and thank you for your comment! You could make the menu horizontal, not vertical and freeze the top rows. This will make sure the menu is always visible when scrolling down.
@Hermetic_ Жыл бұрын
Nice thanks
@futuresuperstar4life2 жыл бұрын
I NEED HELP! PLZZ im trying to do something similar but more specific i guess. im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months. i'm trying to recreate an app that i was using but doesn't track enough details. in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all" and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow. i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be PLEASE TELL ME if you think that is at all possible on excel
@reinforcedmacky92702 жыл бұрын
Thanks
@arulpriyacreations3 жыл бұрын
How to give different datas based on the dates in one row in data entry form
@kuldeepsinghbhati11564 жыл бұрын
Why you hide column A
@Pinexl4 жыл бұрын
Hello and thanks for asking! When you go to a new worksheet by clicking a hyperlink, cell A1 is automatically selected. By hiding column A, this way it appears that no cells are selected when you jump to the new worksheet. Of course, this is totally up to you if you want to implement or not.
@kuldeepsinghbhati11564 жыл бұрын
@@Pinexl Nice trick bro 👍 i want your help.. I am working on a dashboard of employees monthly salary... I have one sheet contain employees name and gross salary. Other 12 sheets for monthly attendance. I want that i just select employee name and month in dashboard and it gives me that month earned salary according to total working days on that month. i did this for one month salary. I changed employee name from drop down and i get selected month salary but this happen only for month. How i link employees name to different months..... Please give some idea
@Pinexl4 жыл бұрын
@@kuldeepsinghbhati1156 You can use an index-match formula based on two conditions, in your case on employee name and month. We have used such formula in our Dynamic Controls tutorial. A free download with examples is also available. You can find the tutorial here: www.pinexl.com/excel-dashboard-controls-tutorial
@kuldeepsinghbhati11564 жыл бұрын
@@Pinexl thanks bro... You are so helpful... God bless you
@Pinexl4 жыл бұрын
@@kuldeepsinghbhati1156 You're welcome!
@eminimamoglu30724 жыл бұрын
Thanks a lot!
@Pinexl4 жыл бұрын
Thank you very much! Glad you are finding it useful!
@AD-qb2kr3 жыл бұрын
I have also this annoying white flash between the sheets are loaded, maybe its because of tons of hyperlinks. Any solution?
@Pinexl3 жыл бұрын
Maybe this depends on the Excel version you're using. If you try it in a new blank document, this will show if it is because of the version of something else.
@TheLionOfJudahTheLambOfYHWH3 жыл бұрын
I appreciate your knowledge and effort to teach--- but for the rest of us who have never experienced this, please slow down, bud--way too fast and you did not explain what you did here 2:06-2:21 this section is not seen anymore--where did it go ?
@Pinexl3 жыл бұрын
Hello and thank you for your comment! We'll keep the pace in mind for future videos. Regarding your question - the selected cells where simply merged, in order to have enough space for the title.
@kadirbasar15474 жыл бұрын
Thank you
@Pinexl4 жыл бұрын
You're welcome!
@hugyourdata1549 Жыл бұрын
Thank you so much!!!
@Pinexl Жыл бұрын
Glad it helped!
@emtyas5 жыл бұрын
Just amazing.
@Pinexl5 жыл бұрын
Thank you very much!
@chanchaldas62294 жыл бұрын
Nice bro
@Pinexl4 жыл бұрын
Happy you like it!
@victormerino44394 жыл бұрын
Thanks bro
@Pinexl4 жыл бұрын
Happy to help!
@kkm53843 жыл бұрын
when we copy the sheets 1:39 then subsequently, whatever changes made in first sheet same is being appear in the all sheets. we need to remove the link of the cell copy. how to do that?
@Pinexl3 жыл бұрын
Hello, it seems like you've selected more than one sheets at the same time. This is why the changes are applied to all of them! Make sure a single sheet is selected after copy/pasting them.
@kkm53843 жыл бұрын
@@Pinexl Thank you. i think its working now. but i dont remember how did. i think i selected first sheet and copied same in all sheets. But what are saying is not not clear to me by saying "...you have selected more than one sheet...". Anyway, that part is OK. i am trying to use this excel book as a template for my write-ups for drafting. Is there a word limit option for the merged cell? i mean i want to select say 20x30 cells and merge them like a text box. then use it like a text box, with word limit. that helps me.
@rajnishbedi74704 жыл бұрын
Very Good
@Pinexl4 жыл бұрын
Thank you!
@OrdinaryCritic2 жыл бұрын
I’m just wondering. What if I scrolled down? Won’t the pane also scroll down? Thanks in advance. :)
@Pinexl2 жыл бұрын
Hi, the pane will stay there, but only the colored part. The menu links won't scroll down. Depending on your needs, you can create the navigation in a similar way at the top rows, instead of having it vertically on the left. This way it will be hidden when you scroll down, unless you freeze the top rows.
@OrdinaryCritic2 жыл бұрын
@@Pinexl, thanks. I’ve managed to use only five main “buttons” that “collapses and expands.” I froze them so they’d stay. It may just be an illusion, but it looks great. This idea of yours is was an eye-opening game changer.
@Pinexl2 жыл бұрын
Thanks, I'm happy you you're finding this useful!
@tomite20012 жыл бұрын
How do you call your forms or dashboards from those menu items?
@eclippse2 жыл бұрын
Hi and thanks for the question! The menu items are actually text cells, which have a hyperlink leading to different sheets in the workbook.
@ITCE20184 жыл бұрын
Nice
@Pinexl4 жыл бұрын
Thank You!
@julie921144 жыл бұрын
Do you have this written out step by step ?
@Pinexl4 жыл бұрын
Hello and thanks for the comment! At the moment this information is available only on KZbin.
@panagiotistheodorou49593 жыл бұрын
Very Interesting but way too fast for learning from it... That is for slow people like myself....
@Pinexl3 жыл бұрын
Thank you for your comment and suggestion. We'll keep it in mind!
@harriscastro5355 жыл бұрын
What if the excel tabs are not hidden in another pc. Would it still hide the tabs?
@eclippse5 жыл бұрын
Hi Mark, thanks for asking! This is a workbook-level setting, so yes - the sheets will stay hidden on all PCs.
@allabout11355 жыл бұрын
I think is time for Pwer BI ;)
@Pinexl5 жыл бұрын
Power BI is indeed an amazing tool! However, there are sill many organizations, where Excel is still the main data analysis, reporting and visualizations tool. This is why we want to help people make the best of it!
@harshitgupta88444 жыл бұрын
Sir I already made my project and now I have to do this thing... Please help me sir
@Pinexl4 жыл бұрын
Hi and thank you for your comment! Check out our brand new Excel add-in Pine BI, which allows you to create the navigation menu from the video in seconds: www.pinexl.com/pine-bi-excel-add-in