Archive by Author
Excel Hyperlink
An Excel hyperlink gives the reader quick access to related information in another file or on a Web page. In addition to being able to insert hyperlinks into cells, you can also insert them into specific chart elements. Links usually open web pages, but they can also lead to pictures, email addresses or programs. The hyperlink itself can be text or a picture.
Full StoryExcel Viewer
If you have an Excel workbook to open but you don’t have Excel, don’t worry. There is a freely downloadable utility provided by Microsoft that enables you to open Excel files, even without having Excel installed. Enter Excel Viewer.
Full StoryExcel Smart Tags
Smart tags in Excel 2010 recognise specific data and then offer action options based on the type of data recognised. The actions are made available with a button that appears near the cell that contains the recognised data. The button appears when the cell is activated or when you move the mouse pointer over the cell.
Full StoryExcel Function
A function in Excel calculates a result based on one or more input values. For example, the SUM function returns the sum of all the cells you specify as arguments. If you were to type into a cell the following:
Full StoryFormulas In Excel 2010
If you need to dynamically calculate values that are dependent on other values entered in your worksheets, then you need formulas. Formulas will calculate values for you so that you don’t have to spend time struggling with Maths and risk making mistakes. In Excel 2010, you can use formulas to calculate things like:
Full StoryExcel Text
The way to wrap text in Excel is a mystery to many people. However, it’s quite straightforward and here we explain how. Suppose you enter a long sentence into an Excel cell. Press F2 to make the cell’s contents editable or click somewhere in the Formula Bar.
Full StoryThe Developer Tab In Microsoft Excel 2010
In Microsoft Excel 2007, the Developer tab is not displayed by default. To make it display in the ribbon, you have to go to Excel options and check the appropriate option in the Popular tab. Excel 2010 is similar in that you have to take action to display the Developer tab, but this action is slightly different.
Full StoryCreate An Excel Macro
Excel macros are useful if you find yourself repeating the same actions time after time. When you create a macro, you record all the actions and commands you perform to complete a task. Then instead of repeating those actions you can simply run the macro. Doing this saves you time and reduces the probability of making mistakes.
Full StoryBackstage View In Microsoft Excel 2010
One of the biggest differences you’ll notice in Microsoft Excel 2010 is the introduction of the Backstage View. Backstage View is displayed by clicking on the Office Button in Excel 2010, as in all the other applications that comprise Office 2010. The backstage view in each application uses a different colour scheme to differentiate it [...]
Full Story
