main c2a

Excel Training Courses - 5 Nice Excel Tips And Tricks

Excel Training Courses - 5 Nice Excel Tips And Tricks

5 useful suggestions to help overcome widespread excel issues. These tips embody shortcuts for formatting numbers, absolute cell references, wrapping text in cells, adding dates to spreadsheets and widening columns.

1) Shortcuts for Formatting Numbers

Listed here are a couple of helpful shortcut keys that can be used when formatting numbers in Microsoft Excel:

Select the cell(s) containing the numbers you wish to format.
To apply the Currency style, press CTRL SHIFT and $ on the keyboard
To use the Comma fashion, press CTRL SHIFT and! on the keyboard
To apply the Percentage style, press CTRL SHIFT and % on the keyboard
To use the Basic style, press CTRL SHIFT and on the keyboard
2) Absolute Cell References

An absolute cell reference in a formulation, corresponding to $E$1, all the time refer to a cell in a particular location. If the place of the cell that accommodates the formula changes, the absolute reference remains the same. For those who copy or fill the formulation throughout rows or down columns, absolutely the reference doesn't adjust.

By default, new formulation use relative references, and you may need to change them to absolute references. For instance, when you 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 within a components, either manually type within the dollar indicators or use the shortcut key of F4.

three) Wrapping Text in Cells

If you need textual content to appear on multiple lines in a cell, you possibly can format the cell so that the textual content wraps automatically, or you may enter a handbook line break.

To wrap textual content automatically:

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

To begin a new line of text at a selected level in a cell - double-click on the cell, click on the placement the place you wish to break the line within the cell, and then press ALT+ENTER.
4) Adding dates to Spreadsheets

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

For example, let's say that you simply want every day in September 2009...

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

Type the primary Monday's date in a single cell, and then the following Monday's date in the next cell.
Select each cells.
Transfer the mouse cursor to the underside proper nook of the cell till it adjustments to a black cross.
Be aware: Excel is aware of how many days there are in every month as well as when there's a leap year.

5) Widening Columns

Widening columns in Excel may be difficult particularly in case you have plenty of data and cannot see it all on the screen. Making use of AutoFit to columns is a very fast method of getting excel training online to automatically widen the column(s) primarily based on the longest cell entry. Here's how it's done:

Position the mouse cursor to the best of the column header till the mouse cursor changes.
Instead of dragging the column to widen it, double-click on with the left mouse button.
This will apply AutoFit and the column ought to increase/lower to suit the longest entry.
Note: to use AutoFit to all columns, firstly press Ctrl & A on the keyboard which selects the entire sheet.