How 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 MoreHow to Calculate Average Number of Items Sold and Average Revenue Generated by a Salesperson in a Transaction by Using MS Excel’s AVERAGEIF Function
How to Calculate Average Number of Items Sold is an important task to perform in many MS Excel projects. Imagine you have the following sales data: How can we find the average number of items sold by a salesperson in an average sales transaction? The formula is: AVERAGEIF = ([RANGE_NAME],”Name”,[AVERAGE_RANGE]) This formula will find the…
Read More