Tag Archives: Computer 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
Deleting your Google Search History
You probably use Google to search the Internet. Did you know that Google, and your browser, maintain a history of your Internet activities? In this article, we will take a look at why you want to remove this history and … Continue reading
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
