99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Some Simple Yet Less Common Excel Functions
Tue 19th October 2010
If you have lots of numbers with lots of decimal places and you would like to show them all as rounded to a specified number of decimal places, normally this can be achieved simply through formatting. Even if you did not want to lose the list of numbers that was the original, you could copy and paste the column and then format it. To achieve this, right click the column or cell, select format cells, choose Number as the data type and then specify the number of decimal places you require. There is also a rounding function to achieve this which is as follows:
= ROUND(number, num_digits)
The number can be the cell you require and the num_digits is the number of digits you would like it rounded to. If cell A1 contained 4.32 for example and the function read = ROUND(A1, 0) then the result would be 4 since no decimal places would round it down to 4. There are also separate ROUNDUP and ROUNDDOWN functions.
It is true that if you type a web address and then click Enter, Excel will automatically recognise it as a hyperlink. When the link is clicked, the web site will open assuming it is a valid address. Using the Hyperlink formula allows the user to add a link to a specific document stored anywhere on your computer or on the internet. It also allows the sheet designer to give the link a name so that the friendly name will appear as the link rather than the full address of the document. The Hyperlink function is as follows:
Hyperlink (link, display_name)
An example of the formula would be Hyperlink ( "C:\Test Folder\Test.xls", "Test Doc" )
If you are unsure of what pathway to use for your document, open windows explorer and copy the pathway from there and add the filename plus the extension on the end. Always use the quotation marks to enclose your pathway name.
If you require information on your sheet such as the current operating system, the Info formula will retrieve them for you. The formula will return the current directory, the number of active worksheets in the current workbook, version of Excel, the name of the operating system and several other useful titbits of information. The formula is as follows:
=INFO(information you require goes here)
If for example, you require the current operating system then type the following:
And this will return either pcdos for Windows or Mac for a Macintosh. If for example you would like to know how many worksheets are in use, type the following:
There are simply hundreds of Excel formulas and functions which perform all kinds of strange and interesting needs. The chances are if there is anything you need Excel to do then it can be done so give it a go!
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Manager, Credit & Receivables
From Storyboard to Presentation Deck
My suggestions and comments are as follows:
1. I have said so much from the beginning of the training; I saved the best for the last. One of the best things in this training is the training Support for 2years. Bravo! this is the first of its kind.
2. I am also very happy and grateful for the software short cuts known as the 'Cheat Sheet'. These would be very useful and handy for everyday work.
3. Every other thing I have said in the last feedbacks apply to this one; You all rock! I love your professionalism, kindness and compassion, patience etc.
Integer Research Ltd
I thought the course was very helpful. The instructor was knowledgable and the pace was perfect for intermediate users.
Amazing course. Pace of toward the end was a little brisk. But a great Q&A session at the end improved my confidence