MS Excel for most people is an untapped tool. I want to change that and show the ways you can be creative and incredibly productive and efficient at the same time. So let's create a community of like minded people who use MS Excel on a daily basis in any work function, whether it be investment banking, private equity, finance, accounting, or frankly any role you use Excel for to help with creativity, efficiency, and a general ability to increase the level of your skills!
So if you want to take your skills to the next level, I would encourage you to watch some of my content and apply it to your lives, whether for work purposes or otherwise, and increase your Excel abilities! I'm sure it will be a great skill learned, and a good way to stand out from others and impress your bosses!
If you have any suggestions or ideas you would like covered on this channel please get in touch or post a comment on my videos.
Пікірлер
Would you ever consider making a video showing how to build something similar starting form a bare workbook?
Thank you! you got my attention and now a follower. Appreciate you!
Hello sir. Namaste sir ji. Sir your this video is just superb. Full of values. I want to practice it and I need it. Pls could you provide that file that you use in that video. Thank you so much. Be more powerful n successful. Always be happy n healthy. God is with you. Thank you.stay blessed.
Please send me an email and I can forward to you 😊
Sir I can writedown mail id here. It is against you Tube rules. You pls send your mail . I respond you. Thank you so much. Stay blessed.
I can not writedown mail id here.
@@mithupal4921 my email [email protected] 😊
Thank you so much Sir. Just I send you. Pls check it. Thank you. Stay blessed.
I thought I was good at Excel until I came across your video. Amazing dashboard. Thanks for making the template file free! You deserve more subscribers.
Thank you so much for the kind words 😊 hope you enjoy it!
With mint being discontinued, this networth tracker is gold my man!
Thank you man, glad you like it 😊 I’m almost 5 years strong with my tracking now!
@@everydayexcel9278 wow! What intervals is your net worth value over __ showing? I suspect quarterly?
@@everydayexcel9278have you added more things since this video to your own version or had thoughts of how to improve the model?
Great job. Thank you
I sent you an email requesting this dashboard excel file with no response, would you please send me this file & thanks in advance
Tell me how to protect objects from accidental changes in the dashboard?
Thank you for the detailed step-by-step tutorial. You explain everything very well.
Thank you so much for this, looks beautiful and works beautifully!
how can one get the csv files?
Great tool man!!
Great Dashboard! Can I get the template via email?
Link plz to download it
Please send me an email and I can send to you :) [email protected]
Really nice spreadsheet! Thanks for sharing
Thank you! glad you like it
How do I remove the "blank" row from the pivot table? I was able to filter it out, but it is preventing me from formatting the dates properly.
Hi Matthew! Sorry this was only an issue I realised after making the template. The best thing to do is delete all the blank table rows in your data section and each time you add a new record it will make a new row, so there will be no blank rows :)
How did you do the vertical menu bar on the left of your dashboard? Do you have a video? Thank You.
Hi John. You can download the template file from the link in the description and see, but basically it is just shapes with text over top, then the text boxes / menu items are hyperlinks to other tabs in the workbook, so you just have to set up each tab identical on that side. Hope that helps.
This is a great detail description of the spreadsheet, thank you for putting it together. and while I completely understand why you would want to include the video of yourself working on it. The placement of that feels like 25% or more of what you are trying to show is hidden. It makes it very hard to follow what you are doing and to be able to replicate it myself.
Thanks Kaitlin! Sorry about that, when I record the video I sometimes forget where the small window of myself is. From about 4mins on I do ensure the window is made smaller, but you are right I could put this in a better spot or even remove it. Glad you enjoyed anyway!
Great stuff mate 👌👍👏
Great video, thank you!
do you have the raw data that i can use as dump file? Thanks
Nice spreadsheet, how did you create the tabs within the sheet? I would be interested in learning how to do that.
Hi there! It is actually really easy, each label is just a text box object, and once you have created them you can right click and hyperlink it to e.g. cell A1 on another tab. Then it’s just about aligning everything on each tab so it looks seamless. You can download the excel template from Dropbox, link in description
Awesome video. But I need the files so that i can work on them. Will You please send them?
Hi Ankit, please send me an email on [email protected] and i can send it to you :)
@@everydayexcel9278 Please check the mail
@@ankitmishra7076 hi Ankit! Email has been sent to you
investment tab not available of downloaded file
Hi Rushi, the investment tab is not needed, I split them out for my own personal version but you can keep track of everything in the Net Worth Data tab :)
How does the refresh button function?
Hi there! It is just a macro, really easy to record using the refresh button on the data tab, then assign the macro to the object using right click! Hope that helps
@@everydayexcel9278 Awesome. That's what I thought
Thank you for the templates and explaining everything in detail so well. Definitely gonna follow this channel. Too bad my excel doesn't support xlookup but I managed to get by with Vlookup instead. Would you consider teaching macros?
Bro do you bring any personal orientation? How can I contact you?
Hey bro, you can contact me on [email protected]
What a great dashboard. Downloaded template- absolute legend. Explained so well!
Thanks Marcus! :) really appreciate the comment
Just found a beautiful Chanel!
Thanks Mo :)
Can you send the file please
Great video!! I plan on using this moving forward
Looking for a good spreadsheet stumbled upon this and wala. Love it!
Thanks Ken! Glad you like it
Hello thank you very much for this! this is so far the best. looking forward to more of your creation~
Thanks Lee Shien! Appreciate the comment :)
hi , is it possible to receive the document ? Thanks !
Hi Stefan! Of course. Please send me an email at [email protected] and I can send it to you
Amazing video, for some reason the total net worth isn't on top in my graph even tho I copied exactly what you did? Can you help me with this?
Hi there! Yes of course i can help. Send me an email at [email protected] :)
Awesome content bro
Thanks Michel.can u share the file [email protected]
Hi Razaul, you can download the file from the link here :) www.dropbox.com/sh/3dnp5p7yq3lci21/AACfCRKOrktocoUiF3UUk7jDa?dl=0
Very nice. Thanks for sharing!
Thanks Michael! :)
Nice.
👍
Amazing work 👏 Please can I have the underling dataset ? thank you [email protected]
Top video!
Hi, great work. Can you share this dashboard on my email id? I just want to check the hex codes, VBA codes & slicer formatting.
Hi Akash! Sure thing. Please email me at [email protected] and I will send it over
@@everydayexcel9278 I have dropped you a mail. Thank you in advance for sharing the file.
nice video, thanks
This video may be "old" in the internet terms, but it is one of the most useful one for Excel and other office products. It indeed eliminates a lot of frustrations of Excel users. Thanks.
Thank you so much for your comment! Appreciate it and glad it has helped you :)
Dude. You are the Bruce Lee of dashboards.
Thank you Lance!
Hey, Nice idea! I plan to make a dashboard with this concept! Thank You!
Awesome, an you share the dataset ?
Hi Arif! Sure, please send me an email at [email protected] and I will send it to you :)
Is this normal excel ( version ???) Or power BI ???
Hi Nitesh! This is all normal Excel :) you can do this! Be sure to watch along and you will see all the steps
Thanks very useful. 😊👏👏👏[email protected]