KISS Training – Keeping IT Simple
Posts tagged Computer Tips
5 Brilliant Excel Functions
May 24th
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 function is;
=LARGE(array, k)
Array – the range of cells you want to find the k-th largest value within
K – the position in the range of values, from the largest, you want to return
For example, =LARGE(B2:B10,4) returns the 4th largest number from the range B2:B10.
Deleting your Google Search History
Feb 22nd
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 how to do it.
Most people do not know that their Internet activities are logged. These activities are ostensibly logged for your convenience. For example, if you have visited a page in the past, your browser maintains this information so that you do not need to type the whole website URL again.
Or in other cases, you may have typed something into the Google search box. These searches are maintained by Google to present you with similar searches if you happen to be looking for the same thing in the future. In fact, Google combines your previous searches with their own database to try to provide you with the optimal results.
However, what will happen if someone logs into your computer? Can they see your previous Internet activities?
In many cases, the answer is yes.
The answer is certainly yes if yours is a Windows-based computer which only has one user ID. In situations such as this, it is very easy to see the data used by other people on that computer.
If you do not want this to occur, you will need to take action to delete your Google search history.
There are three places to look to delete your Google history. The first place, and the place that snoopers are likely to first check, is your browser bar where you put in the address of web sites that you visit. This area maintains your search history which can easily be accessed by clicking the drop down box.
In most browsers, to remove your browser history, you will click “tools” and then “options” to find the tab that will allow you to delete your personal history.
Another location in which your history is maintained is in the Google Toolbar. If you have installed the Google Toolbar, your history can be deleted by right-clicking in the search area and clicking “Clear History.”
Finally, the third piece of information that is stored is the information that you have typed into the Google search box. This is maintained by your browser and can usually be deleted on a tab within your browsers “Tools-Options” choice.
In summary, if you do not want others to track your Google search history, make sure that you take the proper steps to delete it.
For more information on this topic, visit the how to delete Google history page, which is part of the how to Google series at ThisIsHowYouDoIt.com, your original home for how to do things.
|
Article Source: http://EzineArticles.com/?expert=Richard_Tyler_C |
Using Excel Dynamic Named Ranges in Pivot Tables
Jan 28th
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 or pivottable, especially if the full range is fixed for the year. However, if the final range is not fixed, then we have to manually update the range for the charts or pivottables every time the new data is added to the database or excel list. To update a pivottable manually, you need to select the table and then pivottable wizard, select back and then reselect the range. The source range also needs to be open.
You can use VBA code that opens up the source and updates the relevant pivottables automatically instead of having to do the above. If all the updating was left to the end, you could easily call all macros and update with one click!
However, in excel version 2003. A new data List feature provide dynamic lists. Another benefit is that there is no need to load the source file first as when using the OFFSET formula. The list range is usually given a named range. If you are using an older version then use the offset formula outlined below.
Once the formula or list range has been completed, go into the relevant pivottable and add the name of the dynamic range after the file name e.g. yourworkbook.xls’!yournamedrange
This means that when new data is added to the database, the named ranged should automatically expand to include the new data. When you refresh the pivot tables manually or by using the code, the pivot tables should now show the new data. This is a great way to start the development of an excel dashboard. Dynamic pivottables are a useful data model.
Go to: Insert>Name>Define and in the Names in workbook box type any one word name (I will use MyRange) the only part that will change is the formula we place in the Refers to box depending on if you are using offset or are using the list feature.
For the offset formula only use this:Expand Down as Many Rows as There are Numeric Entries.In the Refers to box type: =OFFSET($A$1,0,0,COUNT($A:$A),1)
If it is the data list you are using, then Go to: Insert>Name>Define and in the Names in workbook box type any one word name. Use this formula in the refers to box. Adjust the sheet name and range accordingly: =’yourworksheet’!$A$5:$G$339
Gary is an internet writer and expert in excel. View our latest excel dashboard guide at http://www.stewarttraining.co.uk Click here to view a sample excel dashboards
|
Article Source: http://EzineArticles.com/?expert=Gary_Conway |
MS Excel – Examples of ‘What If’ Scenarios
Jan 19th
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!) with what-if scenarios.
Click here to read more.
