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 MoreHow to Insert a Manual TOC to a MS Word Technical Document
How to Insert a Manual TOC is a skill that may come in handy with some documentation projects. Did you know that your heading text in a MS Word document and the TOC text (that points at that heading) do not need to be identical? There’ll be times when you may not want MS Word…
Read MoreHow to Color a Continuum of Values in a MS Excel Data Range
© Ugur Akinci Imagine you have a continuum of values in a MS Excel range, like the student grades in a class. Here is how you can color each cell automatically so that at one look you can tell which grades are HOT and which are not. (1) Select the data (cell) range. In this…
Read MoreMS Excel Short Cut for Changing the width of an Excel column
Changing the width of an Excel column to accommodate all text in a single line is something I do frequently while working with MS Excel worksheets. After a while it gets tiresome to select Format > AutoFit Column Width from the ribbon all the time. So here is a wonderful Windows short cut that will…
Read MoreHow to Display the Contents Tab (TOC) in a Compiled Robohelp HTML Help File
Follow the directions in this post to display the Contents Tab (TOC) in a compiled Robohelp HTML Help File. If you compile a Robohelp .CHM (pronounced “chum”) HTML help file and do NOT see your CONTENTS tab (TOC) anywhere, don’t panic. There is actually a very simple reason why the CONTENTS tab does not display: you have…
Read MoreHow to Find the Workday a Specific Number of Days Before of After a “Start Date” in MS Excel by using WORKDAY.INTL Function
Let’s say you have a reference START DATE like “February 2, 2005″. You would like to calculate the exact WORKDAY 100 days BEFORE or AFTER that date. How would you do it? What’s more, how would you do it if the “weekend” definition varied, like “Sunday only” or “Saturday and Sunday”, or even just “Monday”?…
Read MoreHow to Add Running Headers or Footers to a MS Word Technical Document
© Ugur Akinci You can add running headers (also called “running headings”) or running footers to a MS Word technical document so that the text of the selected heading style is automatically printed as a “header” or “footer” either at the top or bottom of every page. Such running headers are useful in identifying the section or chapter that…
Read More