Tag Archives: Excel

5 Brilliant Excel Functions

Posted on May 24, 2010 by Eileen

LARGE The LARGE function is used to return a value dependent upon its ranking within a range of values. For example, the LARGE function can return the 3rd largest number from a range of values. The syntax for the LARGE … Continue reading →

Posted in Computer Software Training | Tagged , , | Leave a comment

Using Excel Dynamic Named Ranges in Pivot Tables

Posted on January 28, 2010 by Eileen

On of the best techniques to reference data in excel is to use named ranges. This can be extended if you want dynamic named ranges which adjust with new data. Normally we hard code the source range for a chart … Continue reading →

Posted in Computer Software Training | Tagged , , , | Leave a comment

MS Excel – Examples of ‘What If’ Scenarios

Posted on January 19, 2010 by Eileen

Microsoft Excel is a powerful piece of software, and most people underestimate the complexity and sophistication in the types of calculations that it can handle. One fine example of Excel’s power is its ability to “predict the future” (sort of!) … Continue reading →

Tagged , , , | Leave a comment