Excel Tip - Formulas without Formulas

Did you know that you don’t always need to build a formula when adding, subtracting multiplying and dividing values? Watch this video to see how it can be achieved using Paste Special…

Excel Tip - Recommended Charts

Next time you are hard-pushed to decide which chart type best suits your data, select ‘Recommended Charts’. Follow this video to see how Excel can create a chart that’s a perfect match for your data…

Excel Tip - Leading Zeros

Have you tried entering data in Excel with a leading zero; say a part number or a telephone number? Then you’ll have noticed that Excel removes the zero; here’s the solution…

Excel Tip - Rounding and Integer Function

Excel has quite a few different rounding functions, but did you know about the INT (integer) function? It’s so simple to use and will always round a value down to the nearest whole number…

Excel Tip - Compare Files

Have you ever had two different versions of the same Excel workbook, and you need to know the differences?  Here’s the answer…