Tag Archives: Excel Hints & Tips
5 Brilliant Excel Functions
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 Computer Tips, Excel, Excel Hints & Tips
Leave a comment
Using Excel Dynamic Named Ranges in Pivot Tables
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
MS Excel – Examples of ‘What If’ Scenarios
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
Excel Tips
Excel is a brilliant tool, used properly it can perform statistical and mathematical calculations easily. Excel can be used for all kinds of things from a simple household budget spreadsheet to business accounting and lots more. We found this article … Continue reading
