Author Archive

How to Make Validation Case Sensitive?

(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) {return;} js = d.createElement(s); js.id = id; js.src = “//connect.facebook.net/en_US/all.js#xfbml=1″; fjs.parentNode.insertBefore(js, fjs); }(document, ‘script’, ‘facebook-jssdk’)); Chaitanya is CEO of p2w2, a Spreadsheet Solutions company. p2w2 has expertise in Excel Modeling, Excel Dashboards, Profitability Analysis, Excel Invoices and Excel Bid sheets. You can contact us [...]

How to Create Dropdowns in Excel

(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) {return;} js = d.createElement(s); js.id = id; js.src = “//connect.facebook.net/en_US/all.js#xfbml=1″; fjs.parentNode.insertBefore(js, fjs); }(document, ‘script’, ‘facebook-jssdk’)); You can learn how to create drop downs in excel. In addition, you can also learn how to allow unlisted entry into the drop down field. —————————————————————————————————————————————————- Chaitanya is [...]

How to Change Text Like YYYYMMDD into YYYY/MM/DD format?

Often, you get text like 19950607 and you want to be able to convert it into text like 1995/06/07.  Here’s a formula you can use to convert the text into a formula. (this assumes the text is in A1) =DATE(MID(A1,1,4), MID(A1,5,2), MID(A1,7,2)) What this does is this: Date formula has the following parameters – DATE [...]

Don’t Undercut Prices: Javier Unzueta

Javier Unzueta shares his secret to success and tells you why you should not undercut prices.    

Did You Take a Shower Today? Manage Your Business’ Identity

Did you take a shower today? If you want to present yourself to the world well, same thing applies to your business as well. It has to look good. Deborah Laux talks about the importance of logo in your business. Deborah is an identity consultant and graphic designer in Los Angeles, CA. I had an [...]