Excel’s CHOOSE function is not much use on its own, but when you nest it with other functions it can make quite a difference to their capabilities. First let’s look at the basics of the CHOOSE function. CHOOSE syntax: =CHOOSE(index_num, value1, value2, value3…..up to 254 values) With an example: =CHOOSE(3,“ Blue”,”Green”,“Orange”) Translated the formula reads: [...]
April 2011
The MIN, MAX, SMALL and LARGE functions in Excel are fairly straight forward, but I’d like to show you a couple of tricks that won’t be obvious from reading the Excel help files. First of all the syntax for MIN and MAX functions: =MIN(number1, [number2],….) =MAX(number1, [number2],….) The ‘number’ can be keyed directly into the [...]
If you’re reading this you probably already know that the standard deviation is a measurement of confidence, variability or diversity in the average (be it the mean or another expected value) used in statistics and probability theory. I’m not going to go into any more detail on what the standard deviation is, but I will [...]
In Excel 2007 the graphics features are vastly improved. Not only have you got some instant designer quality flow charts (see image below), with the new and improved Shapes you can now apply effects like you find in Photoshop. Excel SmartArt I’m not going to go into a lot of detail with SmartArt. Other than [...]
Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a simple function that returns a random number between 0 and 1. It is entered =RAND() That’s it…simple. RANDBETWEEN Function RANDBETWEEN is slightly more complicated. =RANDBETWEEN(bottom,top) Where ‘bottom’ is the lowest number you want returned and [...]
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would be worth at the end of 2 years at an interest rate of 6% compounded monthly. It’s not as simple as =$10,000 x (1+.06 x 2)…although this will get you close. But if you’re a [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
