#data_validation#auto_price#excel
In this video I'm going to show you how to create a dynamic dropdown list in excel & How to Create an automatic price list in your excel spreadsheet. Also using the data validation options and some excel formulas for creating the daily sales report.
Formulas (office 2003,07,10,13,16 Same)
1. Dynamic Dropdown List : =INDIRECT("TABLE1")
2. Auto price list : =IFERROR(VLOOKUP(D4,'PRODUCT LIST'!A:B,2,FALSE)," ") Keyboard Command (Windows)
1. Past Name : F3
2. Auto Date : Ctrl+;
3. Auto Time : Ctrl+Shift+:

If you have any question, feel free to ask me in the comment section. I will be more than happy to reply you!

" Shohoz Life " is a tech & tutorial base channel.


Thanks for watching.

Like comment and share this video with your friends. Please don't forget to subscribe to my channel :)
Youtube link: https://bit.ly/2VLFyG3

Find Us - Facebook: https://www.facebook.com/shohozlifee

Linkedin https://www.linkedin.com/shohozlifee

Twitter: https://twitter.com/ShohozL

Thank You So Much!

About this Channel: We are a team of people working together as Shohozlife channel. Some of us are working as Digital Marketing trainers, Executives and Strategists, etc. Here we are trying to cover almost every online digital marketing and other exam guidelines.


Disclaimer: The information available on this YouTube channel is for educational and information purposes only. We have shared here Google, Facebook, Twitter, SEMrush, HubSpot, Microsoft, and more exam guidelines with our viewers for free. In the shohozlife, we have made it our mission to transform the skills and knowledge of digital professionals on a global scale for only learning purposes. Feel free to request for any other exam guidelines.

" Shohoz Life " is a tech & tutorial base channel.

Like comment and share this video with your friends.

Please don't forget to subscribe to my channel :) https://bit.ly/2Hvd4cv

Thank You Soooo Much...!

Regards: Shohoz Life Team.


#data_validation#auto_price#excel