HomeОбразованиеRelated VideosMore From: bradedgardotcom

How to Create a Product Review Data Chart in Excel

49 ratings | 7763 views
How to Create a Product Review Data Chart in Excel For more Excel tips and tricks visit me at http://www.bradedgar.com. This is a technique you can use on other charts but in this video I'll show you how to create a product review data chart in Excel using the repeat / rept formula. This rept formula (repeat formula) allows you to consecutively display a character by the number of times provided to the formula. In this video I use the Wingding font to display a star and use the repeat formula with Excel data validation to force the user to put in the number of stars that they feel is valid for the review of the product / product review. More Resources and Links on the Repeat Formula and Wingdings Fonts How to Use Wingdings As Icon Sets In Your Excel Dashboard https://youtu.be/mOY9Wxg2fGI Wingding Character Mapping from Spreadsheet Guru http://www.thespreadsheetguru.com/blog/wingdings-webdings-font-icon-cheat-sheet-printable Wingdings and Other Symbolic Fonts in Slicers! http://www.powerpivotpro.com/2012/07/wingdings-and-other-symbolic-fonts-in-slicers/ Wingdings 2 character set and equivalent Unicode characters www.alanwood.net/demos/wingdings-2.htm Use WingDings to display special check box controls in an Access report http://www.techrepublic.com/blog/microsoft-office/use-wingdings-to-display-special-check-box-controls-in-an-access-report/ How to insert symbols and special characters in Excel https://exceljet.net/lessons/how-to-insert-symbols-and-special-characters-in-excel Conditional Formatting Icons in Excel 2003 http://blog.contextures.com/archives/2009/04/14/conditional-formatting-icons-in-excel-2003/ The Ultimate Guide to Bullet Points in Excel http://www.launchexcel.com/bullet-in-excel/ Excel REPT Function https://exceljet.net/excel-functions/excel-rept-function The Excel REPT Function http://www.excelfunctions.net/Excel-Rept-Function.html http://chandoo.org/excel-formulas/rept.shtml 30 Excel Functions in 30 Days: 15 – REPT http://blog.contextures.com/archives/2011/01/16/30-excel-functions-in-30-days-15-rept/ Excel REPT Function Tutorial http://spreadsheetsuperstar.com/excel-rept-function-tutorial/ Use Excel's REPT function to visually display data comparisons http://www.techrepublic.com/blog/microsoft-office/-use-excels-rept-function-to-visually-display-data-comparisons/ -~-~~-~~~-~~-~- Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard" https://www.youtube.com/watch?v=MCBmPnaKf_g -~-~~-~~~-~~-~-
Html code for embedding videos on your blog
Text Comments (11)
tamilan gamers (1 month ago)
How to give an half star in excel
Pradeep Rastogi (1 year ago)
Sir, Good Evening. It is really such a nice video.I have a question i.e. if rating is not in "Whole Number" then what will be solution? Please share the solution. We are waiting. I am Pradeep from India. Thanks.
Google User (1 year ago)
Fuck off. Fucking thing
James Lewis (2 years ago)
I love this video,unauthorized kicks for me is the way to go whenever I need a new sneaker, I find them very affordable and damn high quality as well, https://goo.gl/oYJWJe
Cynthia Ponce (2 years ago)
Thank you, this is great.
James Lewis (2 years ago)
I love this video,if you want UA sneakers, dope UA sneakers,visit LLBkicks and grab your pair,, https://goo.gl/TYhJr9
bradedgardotcom (2 years ago)
+Cynthia Ponce glad you enjoyed it! Thanks for checking it out!
Bi-Naya# Tube (3 years ago)
Brad u are guru!!!!!! Salute il learn more through you thanks highly appreciated
bradedgardotcom (3 years ago)
+Faruk Naya thank you!! I'm glad to hear that you're picking things up and learning Excel through here!
Julio C. Rendon (3 years ago)
Excelent. Very Good. God Bless You.
bradedgardotcom (3 years ago)
I'm glad you enjoyed it! Hopefully you can use it in your day to day work.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.