Archive for 'Tutorials'
Excel 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 Story
