How 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 More