How to Extract Text or Numbers from Character Delimited Cell Content in MS Excel
© Ugur Akinci Character-delimited data is fairly common. Here is an example: 100&4657&23&495&103 or Apple$Pear$Orange$Cherry$Grapes Imagine having a MS Excel table with cells populated with such content. How would you separate the text or the numeric values and post them under their own separate columns? Here is an example of some imaginary data about SEASONAL…
Read MoreHow to Use Excel NESTED IF Function
To reward the customer with quantity discounts for bulk purchases is a common practice in business. Consider the below situation: There are FOUR different IF statements here illustrated by the above table: (1) Here the seller is charging $10 per item if the customer purchases 100 or less items. (2) If the customer buys more…
Read MoreHow to Enhance Your MS PowerPoint Presentations with Visual Bee
© Ugur Akinci You can now enhance your presentations easily with the “skins”, graphics and templates inserted at the click of a button by Visual Bee. Visual Bee is a Microsoft add-on for Power Point which creates a new tab on the PPT ribbon after you download the free version: This is how Visual Bee works: 1)…
Read MoreTCC Selected "Top 100 Influencer" in Technical Communications for 2013 by MindTouch
© Ugur Akinci Folks, I’m happy to announce that this web site was selected one of the “Top 100 Influencers” in the technical communications field (the 56th, to be exact) in an annual survey conducted by MindTouch.com. We toil long hours every day both to keep up with the latest in our dynamic field and to bring…
Read More