Joy logo


Warning: Creating default object from empty value in /home1/joynow/public_html/ on line 162
Excel Training Programs - 5 Nice Excel Suggestions And Methods

Excel Training Programs - 5 Nice Excel Suggestions And Methods

Five helpful suggestions to assist overcome common excel issues. The following pointers embody shortcuts for formatting numbers, absolute cell references, wrapping textual content in cells, adding dates to spreadsheets and widening columns.

1) Shortcuts for Formatting Numbers

Here are a number of helpful shortcut keys that can be used when formatting numbers in Microsoft excel training online:

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

An absolute cell reference in a formula, similar to $E$1, all the time consult with a cell in a particular location. If the place of the cell that comprises the formulation adjustments, absolutely the reference stays the same. If you copy or fill the method across rows or down columns, the absolute reference doesn't adjust.

By default, new formulation use relative references, and it's possible you'll need to change them to absolute references. For instance, if you happen to copy or fill an absolute reference in cell C3 to cell C4, C5 and C6 it stays the same in all cells:

To make an absolute cell reference within a method, both manually type within the greenback signs or use the shortcut key of F4.

three) Wrapping Text in Cells

In order for you textual content to seem on multiple lines in a cell, you may format the cell in order that the text wraps automatically, or you'll be able to enter a guide line break.

To wrap textual content automatically:

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

To start out a new line of textual content at a particular point in a cell - double-click on the cell, click the situation the place you wish to break the road in the cell, after which press ALT+ENTER.
4) Adding dates to Spreadsheets

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

For example, for example that you just need every day in September 2009...

Begin by typing within the first date i.e. 01/09/2009
Transfer 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 example, it's possible you'll require each Monday's date for a complete yr starting from the 7th September 2009...

Type the primary Monday's date in one cell, and then the next Monday's date within the next cell.
Choose both cells.
Transfer the mouse cursor to the underside right nook of the cell till it adjustments to a black cross.
Be aware: Excel knows what number of days there are in every month in addition to when there's a leap year.

5) Widening Columns

Widening columns in Excel can be tricky particularly if in case you have quite a lot of knowledge and can't see it all on the screen. Applying AutoFit to columns is a very quick means of getting Excel to automatically widen the column(s) based on the longest cell entry. Here's how it's accomplished:

Place the mouse cursor to the proper 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 may apply AutoFit and the column should increase/lower to fit the longest entry.
Be aware: to apply AutoFit to all columns, firstly press Ctrl & A on the keyboard which selects the entire sheet.

Website URL:

Stay in Touch

Sign up to recieve the latest news, updates and special offers.

facebook This email address is being protected from spambots. You need JavaScript enabled to view it. 5


  • 7009 Caroll Avenue,
  • Lower Level
  • Takoma Park, MD 20912
  • 301 270 2801

Get Directions