Excel Training Courses - 5 Great Excel Ideas And Tricks

Excel Training Courses - 5 Great Excel Ideas And Tricks

Five helpful tips to help overcome widespread excel issues. These tips embrace shortcuts for formatting numbers, absolute cell references, wrapping text in cells, adding dates to spreadsheets and widening columns.

1) Shortcuts for Formatting Numbers

Listed below are a number of helpful shortcut keys that can be utilized when formatting numbers in microsoft excel courses malaysia Excel:

Select the cell(s) containing the numbers you want to format.
To use the Foreign money type, press CTRL SHIFT and $ on the keyboard
To apply the Comma type, press CTRL SHIFT and! on the keyboard
To use the Proportion style, press CTRL SHIFT and % on the keyboard
To use the Normal model, press CTRL SHIFT and on the keyboard
2) Absolute Cell References

An absolute cell reference in a system, reminiscent of $E$1, always check with a cell in a specific location. If the place of the cell that comprises the formulation changes, the absolute reference remains the same. For those who copy or fill the system across rows or down columns, absolutely the reference doesn't adjust.

By default, new formulas use relative references, and it's possible you'll want to modify them to absolute references. For instance, for those who copy or fill an absolute reference in cell C3 to cell C4, C5 and C6 it stays the identical in all cells:

To make an absolute cell reference inside a method, either manually type within the dollar indicators or use the shortcut key of F4.

3) Wrapping Text in Cells

If you want text to look on multiple lines in a cell, you possibly can format the cell in order that the text wraps automatically, or you possibly can enter a handbook line break.

To wrap textual content automatically:

Choose the cells that you just need to format.
Inside Excel 2007 - On the House tab, within the Alignment group, click on Wrap Text.
Within Excel 2003 or earlier - Click the Format Menu, select Cells, choose the Alignment tab, choose the Wrap Text check box.
Data in the cell wraps to fit the column width. While you change the column width, information wrapping adjusts automatically.
To enter a line break:

To begin a new line of text at a particular point in a cell - double-click on the cell, click on the location the place you need to break the line within the cell, after which press ALT+ENTER.
four) Adding dates to Spreadsheets

In case you require dates to be displayed on a spreadsheet, using AutoFill saves you having to type in every particular person date.

For instance, for example that you simply need daily in September 2009...

Begin by typing in the first date i.e. 01/09/2009
Move the mouse cursor to the bottom right corner of the cell until it adjustments to a black cross.
In addition to the above, Excel can increment the date by any quantity of days/months/years. For instance, you could require every Monday's date for a whole year starting from the 7th September 2009...

Type the first Monday's date in one cell, after which the following Monday's date within the subsequent cell.
Choose both cells.
Move the mouse cursor to the bottom proper corner of the cell until it modifications to a black cross.
Notice: Excel knows what number of days there are in each month as well as when there's a leap year.

5) Widening Columns

Widening columns in Excel might be tough especially if you have quite a lot of data and can't see all of it on the screen. Making use of AutoFit to columns is a really fast approach of getting Excel to automatically widen the column(s) based mostly on the longest cell entry. Here is how it's accomplished:

Place the mouse cursor to the best of the column header until the mouse cursor changes.
Instead of dragging the column to widen it, double-click on with the left mouse button.
It will apply AutoFit and the column should enhance/decrease to fit the longest entry.
Word: to apply AutoFit to all columns, firstly press Ctrl & A on the keyboard which selects the whole sheet.