Use the TRIM function

Sometime we get worksheets that have mysterious characters in cells. This makes it hard to compare cells to each other, especially when using lookup functions. It also could cause you to print out strange phantom pages that seem to have nothing on them. Lets learn how to use the TRIM function to get rid of this extra characters in our cells.

Calculate Subtotals in Excel

Have you ever shopped online and mindlessly put items into your shopping cart? Then you go to check out and look at the Subtotal. Then you laugh. Then you close the window. That kind of sticker shock may happen once a while in our shopping lives and it come from the magic of the mathematical concept of addition. This magic is also available in Excel! In addition, you can conjure up sophisticated numbers across different categories with the Subtotal feature in Excel. Learn all this is less than ten minutes (that’s less time it takes to do a full load of laundry!).

Generate Random Numbers in Excel

Do you like randomness? If so this is the video for you cause it will cover how to generate random numbers in Excel. There are three examples: One using the RAND function, another using the RANDBETWEEN and one more using the Data Analysis Toolpak Random Number Generator option.