MSExcel : Broaden an arrangement with AUTOFILL

MSExcel : Broaden an arrangement with AUTOFILL 

        AutoFill gives you an approach to guarantee exact information passage when a specific information arrangement has an inherent request: days of the week, months of the year, numeric augmentations of two, etc. To utilize AutoFill, start by composing at least one values from which you will produce different values. Select the cell or cells you need to broaden. Choosing two or more cells decides the progression size, or augmentation, by which you need to bounce in every cell. With the cells chosen, click the Fill handle in the lower-right corner what's more, drag. When you discharge the mouse button, Excel fills the cells with values. In the wake of filling the cells, Excel gives a menu button. Snap the button to open a menu that empowers you to change the fill. You can duplicate the initial value; fill the arrangement without rushing too much; or expand it by weekdays, months, or years, contingent upon the kind of fill you make.

1 Click in the cell in which you 
need to insert a symbol. 
2 Click the Insert tab. 
3 Click Symbol in the Content group 

l The Symbol dialog box shows up. 
4 Click here and after that select a font. 
5 Click the Symbol you need. 
6 Click Insert. 
l The character shows up in the cell. 
7 Click Close.

The Symbol dialog box closes

Include A SPECIAL CHARACTER

1 Click in the cell in which 
you need to insert a 
special character. 
2 Click the Insert tab. 
3 Click Symbol in the Content 

group.

l The Symbol dialog box shows up. 
4 Click the Special Characters tab. 
5 Find the character you need and click it. 
6 Click Insert. 
l The character shows up in the cell. 
7 Click Close. 

The Symbol dialog box closes

Did You Know?

In Excel, entries are numbers, dates, times, letters,
or special characters. You can only use numbers,
dates, and times in numeric calculations. Excel
treats letters and special characters as blanks or
zeroes in calculations. To have a currency symbol
appear with a value, as in $400, and use the cell
value in a calculation, you must apply a currency,
accounting, or custom format.

Did You Know?

Excel fonts are based on Unicode, a set of 40,000
characters enabling the display of characters from
approximately 80 languages, including right-to-left
alphabets such as Hebrew. To use a language other
than English, attach an appropriate keyboard and
use the Control Panel to set the Regional and
Language options.

Open

MS Excel : Hide rows by GROUPING AND OUTLINING

MS Excel : Hide rows by GROUPING AND OUTLINING 

You can utilize the Excel grouping and outlining highlight to hide sets of columns and/or rows. For instance, you can hide the subtleties identifying with week by week deals so you can think about month to month deals. Your layouts can incorporate up to eight degrees of detail.

Outlining a lot of rows or columns makes a clickable button on the extreme left or top of your worksheet. The button shows either a minus sign or an or more sign, contingent upon what is shown in the worksheet. Click the minus sign to hide rows or columns, and the in addition to sign to show them once more. Neighboring the button is a strong line that shows, by its length, the estimated number of rows or columns Excel has covered up.

Outlining was designed for use with organized information, for example, records yet can be utilized with any worksheet. When you plot a PivotTable, outlining has a similar impact as it does in some other

worksheet.

Include A GROUP 

1 Click and drag to choose the rows
or columns to hide.
2 Click the Information tab.
3 Click Group in the Layout group.
You can likewise choose the rows or
columns and then press
Shift+Alt+Right Arrow

l The Group dialog box shows up. 

4 Click to choose either the Rows or
the Columns alternative ( changes to ).
Click Rows on the off chance that you need to group rows.
Click Columns on the off chance that you need to group columns.
5 Click alright.

l Excel makes another left or top edge with a minus sign.
6 To hide the rows, click

the minus sign.
The rows vanish, and
an or more sign replaces the
minus sign.
l To show the rows once more, click the in addition to
sign.

Expel A GROUP 

1 Click the Information tab.
2 Click Ungroup.
l The Ungroup dialog box shows up.
3 Click to choose either the Rows or the
Columns alternative ( changes to ).
Click Rows in the event that you need to ungroup rows.
Click Columns in the event that you need to ungroup columns.
4 Click alright.
Excel expels the group

Did You Know? 

You can home frameworks; that is, you can put one group of laid out rows or columns inside another. For instance, inside every year, you can group each month, and inside every month, you can group every week.

Did You Know? 

You can likewise hide rows and columns by clicking and hauling the lines that different the section
letters or the line numbers. Likewise, on the off chance that you click and haul over section letters or column numbers and at that point right-click, a menu shows up. Click Hide to hide the segment or column or Unhide to show covered up columns or rows.

Open

MS Excel : Insert SYMBOLS OR SPECIAL CHARACTERS

Insert SYMBOLS OR SPECIAL CHARACTERS 

In Excel, you are not confined to the standard numerals, letters, and accentuation checks on your keyboard. You can likewise choose from several special characters, for example, foreign letters and money characters, for example, the Euro (€). Every textual style has a distinctive arrangement of special characters. A littler arrangement of standard characters, called symbols, is consistently accessible also; they incorporate dashes, hyphens, and quotes.

Symbols and special characters serve numerous utilizations in Excel. Numerous financial applications, for instance, call for cash symbols. Symbols and special characters are valuable in section and column heads as a component of the text portraying segment and line content, for instance, Net deals in €.

Utilizing symbols and special characters in a similar cell with a worth, for example, a number, date, or time for the most part keeps the incentive from being utilized in a formula. In the event that you have to utilize a symbol in a cell utilized in a formula, utilize a number format. On the off chance that you have to make a custom number format

Include A SYMBOL 

1 Click in the cell in which you
need to insert a symbol.
2 Click the Insert tab.
3 Click Symbol in the Text gathering

l The Symbol dialog box shows up.
4 Click here and afterward select a textual style.
5 Click the Symbol you need.
6 Click Insert.
l The character shows up in the cell.
7 Click Close.
The Symbol dialog box closes.

Include A SPECIAL CHARACTER

1 Click in the cell in which
you need to insert a
special character.
2 Click the Insert tab.
3 Click Symbol in the Text
gathering.

l The Symbol dialog box shows up.
4 Click the Special Characters tab.
5 Locate the character you need and click it.
6 Click Insert.
l The character shows up in the cell.
7 Click Close.
The Symbol dialog box closes.

Did You Know? 

In Excel, sections are numbers, dates, times, letters,
or special characters. You can just utilize numbers,
dates, and times in numeric estimations. Excel
treats letters and special characters as spaces or
zeroes in computations. To have a money symbol
show up with a worth, as in $400, and utilize the cell
esteem in a figuring, you should apply a money,
bookkeeping, or custom format.

Did You Know? 

Excel textual styles depend on Unicode, a lot of 40,000
characters empowering the presentation of characters from
roughly 80 dialects, including appropriate to-left
letter sets, for example, Hebrew. To utilize a language other
than English, append a proper keyboard and
utilize the Control Panel to set the Regional and
Language choices.

Open

MS Excel : FIND AND REPLACE formats

MS Excel : FIND AND REPLACE formats  

Cells can contain numbers, text, remarks, formats,
and formulas. With Excel, you can scan for any
of these components to see them, replace them, or
perform some other activity. You may, for instance,
find and replace qualities to correct missteps, or maybe
you have to come back to an incentive to include a remark or
apply formatting.

The Excel Find and Replace dialog box is accessible on
the Home tab in the Editing group or by squeezing
Ctrl+H. The Find highlight is a piece of Find and Replace
and is accessible on the Home tab in the Editing group
or by squeezing Ctrl+F.

To find and replace formats, determine what you are
looking for and with what you need to replace the thing
you are looking for. Click the Alternatives catch in the Find
and Replace dialog box to indicate extra subtleties.
Utilize the Inside drop-down menu to show whether
to look through the present worksheet or the current
workbook. Click the Formatting catch to confine
your hunt to characters formatted with a particular goal in mind,
for example, intense or rates.

1 Click the Home tab.
2 Click Find and Select in the Editing
group.
A menu shows up.
3 Click Replace.
On the other hand, you can press
Ctrl+H to open the Find and
Replace dialog box.

l The Find and Replace dialog box
shows up.
4 Click Alternatives if your dialog box
does not resemble the one appeared
here.
Note: The Alternatives catch permits
you to flip between the short
and long form of the dialog box.
5 Click here and select Pick
Format from Cell.

The Find and Replace
dialog box vanishes.
6 Click in a cell that has
the format you need to
replace.
This model chooses
green fills.
l The Find and Replace
dialog box returns.
l A see of the format
you chose shows up.
7 Click here and select
Pick Format from cell.
The Find and Replace
dialog box vanishes.
8 Click in a cell that has the format you need to
use as a replacement.
This model chooses a cell with no fill.
The Find and Replace dialog box returns.
l A review of the format you chose shows up.
9 Click Replace All.
l Excel replaces the formats.
Excel replaces the majority of the green fills with plain fills.
0 Click alright.
! Click Close.
l You can click Replace to roll out one improvement at
a period.
l On the off chance that you need to find rather than replace formats,
click Find All or Find By feature cells in
the worksheet however not replace formats.

Important! 

Before you start another Find
and/or Replace, ensure you
clear all formats by clicking the
down bolt alongside the two
Format catches and then clicking
Clear Find Format and Clear
Replace Format.

Did You Know? 

In the Find and Replace dialog
box, clicking a Format catch
opens the Find Format or Replace
Format dialog box. You can utilize
these dialog boxes to indicate the
Number, Arrangement, Text style, Border,
Fill, or Assurance you need to
find and/or replace.

Did You Know? 

When scanning for text or qualities,
type the text or worth you are
searching for in the Find What field.
Type the text or worth you need
to replace it with in the Replace
With field.

Open

MS Excel : ADD COMMENTS to your worksheet

MS Excel : ADD COMMENTS to your worksheet

A comment is a descriptive text that allows
document your work when you add text or
Create a formula If someone else keeps your
worksheet, or others use it in a workgroup, their
Comments can provide useful information. You can
enter comments in any cell you want to document or
otherwise write down.

Comments in Excel do not appear until you choose
see them Excel associates comments with
individual cells and indicates their presence with a
Small red triangle in the upper right corner of the cell. Watch
an individual comment by clicking on the cell or
hovering over it See all comments in one
worksheet by clicking on the Review tab and then
by clicking Show all comments.

When you track your changes, Excel automatically
generate a comment every time you copy or change
A cell. The comment records the changes in the
mobile, who makes the change and the time and date
of change For more information on tracking changes

ADD A COMMENT
1 Click on the cell to which
I want to add a comment.
2 Click the Review tab.
3 Click New comment on the
Comment Group

l A comment box appears.
l A small red triangle appears in the
upper right corner of the cell.
4 Enter your comment.
Note: To apply bold and others
formatting effects, select the text,
right click, click Comment format,
and then make changes like
appropriate.
5 Click outside the comment box
when you finish.
The comment box disappears.
Move the cursor over the cell to
Show your comment again.

6 Click Edit Comment on
the Comments group
to edit a comment
7 Click Remove on the
Comment group for
delete a comment

SHOW ALL COMMENTS
8 Click Show all comments in the
Comment Group
l Now you can see all the comments in the
spreadsheet.
To close the comment boxes, click Show
All comments again.
9 To scroll through the comments, click on Previous
o Next in the Comments group.

Did you know

To set the name that is displayed when you enter a
comment, click on the Office button and then click on Excel
Options The Excel Options dialog box appears. Click
Popular and then type the name you want to appear
in the comment box in the Username field.

Did you know

When one comment gets in the way of another
Comment or block data, you can move them. Position
your cursor over the edge of the comment box until
The arrow becomes a four-sided arrow. Click and drag
the comment to a better location and then release
the mouse button Your comment remains in this
position until you show all comments again.
Send feedback
History
Saved
Community

Open

MS Excel : Let Excel READ YOUR DATA

MS Excel : Let Excel READ YOUR DATA

If you have a large amount of data to enter, especially
numbers, you may want to verify the accuracy of
your data entry by having the data read to you
while comparing it with a printed list. Excel can
read your data again. All you have to do is specify the
data you want to read, click on a button and Excel
start reading You can choose to read Excel
through the first row and then move on to the next row,
or down in the first column and then move on to the next
column. You can also have Excel read data while
enter it

add the following buttons to Quick Access
Toolbar: Speak Cells, Speak Cells - Stop Speaking
and talk cells when entering. To learn to add
Quick Access toolbar buttons, see Task # 95.
You can find the necessary buttons for this task in the
Commands not in the section of the ribbon.

READ CELLS
1 Click and drag to select the cells
You want Excel to read.
2 Click Talk for
Columns or talking in rows
button.
l Click Talk by columns if
do you want Excel to read the
columns
l Click Talk by rows if desired
Excel to read through the rows.

3 Click the Talk cells button.
Excel reads the cells.
l To stop reading cells, click
the Speak Cells - Stop talking
Cell Button

SPEAK CELLS WHEN ENTERING
4 Click Speak on
Enter button
Excel says: "The cells will
now it is spoken in
Get in."
5 Enter data in your
spreadsheet.
Excel reads the data as
5 you enter it.

6 Click the Talk button when entering again.
Excel says: "Disable Talk on entry."

Important!

For Excel to read your worksheet, you must have
speakers connected to your computer and you should
configure the option of voice, sound and audio devices
in the control panel correctly. Click on start
button, Settings and then Control Panel to verify
these device settings.

Did you know

You can also verify the accuracy of your data entry
performing a spell checker. Just click on Review
tab, Review and then Spelling. If your worksheet
has errors, the Spelling dialog box appears and
offers suggestions for correct spelling. You can
Accept one of the suggestions or click on one of the
Other dialog box options.

Open

MS Excel : Create your own ORDER OR AUTO COMPLETE

MS Excel : Create your own ORDER OR AUTO COMPLETE

In Exceed expectations, you can sort your information sequentially, by
days of the week or months of the year. Watch
Chapter 4 for more information on how to sort your data. you
You can likewise naturally fill cells with the times of the
week or months of the year using Excel Auto Complete
characteristic. See Task 3 for more information on Auto Complete.

If you have a series of data that you use frequently, you can
make your own custom rundown and use it to fill cells
automatically or to sort a list. You for example
collect data by region and the data is always listed
in the following order: Northeast, Southeast, North
Central, South Central, Northwest and Southwest.
You can create a custom list that allows you
Autocomplete and sort according to your list.

Use the Custom List dialog box to create your custom
list. You can type your list in the Custom List dialog box
box or import your list of cells in your worksheet.
Access your custom rundown a similar way you would
Any other custom list or Autocomplete.

1 Click and drag to select the cells
with which you want to create
your custom list
2 Click the Office button.
A menu appears.
3 Click Excel Options.
The Excel Options dialog box
appears.




4 Click Popular.
5 Click Edit custom lists
button.
twenty

l The Custom Lists dialog box
the picture appears
l The range you selected in
Step 1 appears here.
You can click and drag or
write the range in the
Import cell field list.
l Alternatively, you can
write your list here and
then click Add.
6 Click Import.

l Your list appears as a custom list.
7 Click OK.
Your list is ready to use.

Did you know

To create an AutoComplete using your custom list, type the
First item on your list. Click and drag the fill handle
situated in the lower right corner of the cell.. Standing out
Fill the cells with your custom list. If Excel does not
Fill the cells with your custom list, click AutoComplete
Options button () that appears and then click
Fill series (changes to).

Did you know

To order using the custom list you created, click and
Drag to select the items you want to sort. Click on the
Data tab and then click Sort on Sort and filter
Group. The Sort dialog box appears. In the order
field, click Custom List. The Custom List dialog box
appears. Click your list and then click OK. by
detailed instructions, see Chapter 4.

Open

MS Excel : ENTER FORMULAS using a variety of methods

MS Excel : ENTER FORMULAS using a variety of methods

In Excel, you can perform calculations such as
Simple arithmetic in three ways. One method is
use the plus (+), minus (-), multiplication (*) and
signs of division (/). Start by writing an equal sign and
the values   to add, subtract, multiply or
divided, each separated by an operator; for example,
= 25 + 31. Press Enter, and Excel does the calculations and
Show the answer in the same cell. You also can
type an equal sign, click on a cell that contains the
value at which you want to perform an operation, and then
write the operator

A second method involves functions. The functions
perform calculations on your information and do
The results available to you. To use a function, type
an equivalent sign pursued by the capacity; for instance,
= SUM (). Place the numbers you want to add inside
parentheses, separating them with commas. Yes
The numbers are on the worksheet, click on the cells.
A third method is to use the Excel AutoSum function,
which offers a point and snap interface for a few
functions, including SUM, AVERAGE and COUNTING.

CALCULATE WITH AN OPERATOR
1 type =.
2 Click in the cell with the number
do you want to use in your
calculation, or write the first
number.
3 Type an operator, as more
(+), minus (-), multiply (*) or
divide (/).
4 Click in the cell with the number
do you want to use in your
calculation, or write the following
number.
5 Repeat steps 2 to 4, if necessary.
6 Press Enter.
l The result appears in the current
cell.

CALCULATE USING A FUNCTION AND
CELLULAR ADDRESSES
1 Enter the numbers you want
calculate in adjacent cells.
2 In another cell, type = followed
for the first letters of the
function.
A list of options appears.
3 Double-click the option that
want to use.
4 Click and drag to select the
numbers you want to calculate.
5 Click Verify.

l The result appears in
the cell.
CALCULATE USING AUTOSUM
1 In adjacent cells, type
numbers.
2 Click on the cell in which
do you want the result
3 Click the Formulas tab.

4 Click here and select an option.
l This example uses SUM.
l Excel places = sum () in the cell, with the
cell address for the numbers you want
to add
5 To accept the cell addresses chosen by
Excel, press Enter.
To select other addresses, click and drag
them and then press Enter.
The result appears in the cell selected in
Step 2.

Did you know

You can click on the gallon () in
the end of the formula bar to
Expand and contract the bar.
Expand the formula bar allows
You enter longer formulas.

Did you know

When you click and drag
Multiple cells, Excel automatically
place the average, a number
account and sum of values
in the status bar, at the bottom
from the screen.

Did you know

You can add buttons for the same,
more, less, divide and multiply
to the quick access toolbar. you
you can use these buttons to enter
formulas quickly To learn to
add buttons to quick access
toolbar,

Open

MS Excel : How to Name CELLS AND RANGES

MS Excel : How to Name CELLS AND RANGES

In Excel, you can name singular cells and gatherings of
cells, called ranges.. A cell called Tax or a range
called Northern_Region is easier to remember than
the corresponding cell address. You can use named
cells and ranges directly in formulas to refer to the
values   contained in them. When you move a name
range to a new location, Excel is automatically updated
any formula that refers to the named range.

When you name a range, determine the scope of
the name when telling Excel if it applies to the
Current worksheet or the entire workbook. You can
name several ranges at once using Excel Create
from the Selection option. You can use the name
Administrator to delete named ranges.

Excel range names must be less than 255 characters.
The first character must be a letter. Can't use
spaces or symbols, except the period and
underscore. It is better to create short, memorable
names To learn how to use a named range.

NAME A RANGE OF CELLS

1 Click and drag to select the cells
do you want to name
Alternatively, click on a cell with a
value to create a named cell.
2 Click the Formulas tab.
3 Click Define Name.

l The New Name dialog box
appears.

4 Enter a name for the range.
5 Click here and then select the
range reach.
l The range you selected in Step 1
appears here
6 Click OK.
Excel creates a named range.
l The defined name is now
available when you click on Use in
Formula.

CREATE NAME RANGES OF
A SELECTION

1 Click and drag to select
the cells you want
include in the named
distance.
Include headers;
they become the range
Name (s
2 Click the Formulas tab.
3 Click Create from
Selection.
l Create names of
Selection Dialog Box
appears.

Click on the location of the range names
(changes to).

5 Click OK.
l Defined names are now available
when you click on Use in Formula.
l Click here to move to a named range.
6 Click Name Manager.
l All rank names appear in the Name
Manager.
7 Click on a name.
8 Click Remove.
Excel removes the named range.

Did you know

If you click on the Edit button on the
Name Manager dialog box, you
you can change the name of the range or the
cell address to which a name
range refers.

Did you know

When you click on the down arrow
on the left side of the formula bar,
A list of named ranges appears.
See step 5 in Create
Named ranges of a selection.
If you click on one of the
ranges, you move to the cells
define.

Did you know

When creating a formula, yes
click and drag to select a group
of cells that have a range name,
Excel automatically uses the range
name instead of cell address.

Open

MS Excel : How to Define a CONSTANT

MS Excel : Define a CONSTANT

Use a constant when you want to use it
value in different cells and / or formulas. With
constants, can refer to a value, either
simple or consists of many digits, simply using
The name of the constant.

You can use constants in many applications. by
For example, the sales tax rate is a family constant that,
when multiplied by the subtotal on an invoice, the results
in the tax due. Also, the income tax rates are the
constants used to calculate tax obligations. Although
tax rates change from time to time, tend to
remain constant within a tax period.

To create a constant in Excel, you must write your
esteem in the New Name exchange box, a similar discourse.
box that you use to name ranges as shown in Task # 11.
When you define a constant, determine the
constant scope telling Excel if
Applies to the current worksheet or all
work book. To utilize the steady in any equation in the
same exercise manual, simply utilize the name you characterized.

DEFINE A CONSTANT

1 Click on the Formulas tab.
2 Click Define Name.

The New Name dialog box
appears.

3 Enter a name for the constant.
4 Click here and select the scope of
the constant.
5 Type an equal sign (=) followed
for the value of the constant.
6 Click OK.
Now you can use the constant.

SHOW A CONSTANT

1 Click on a cell.
2 Write an equal sign
followed by the first
letter or letters of the
constant name

A menu appears.

Note: if you don't know
the name of the constant
click on the Formulas tab
and then Use in Formula.
When the menu appears,
click on the name and then
press Enter.
3 Double click on the name of
the constant.
4 Press Enter.
l The value of the constant appears in the cell.

Did you know

You can use the Excel name manager to rename, edit or delete named ranges and constant values.
On the Formulas tab, click Name Manager. The Name Manager dialog box appears. Double click
Name you want to edit. The Edit Name dialog box appears. Make the changes you want and then
Click on OK. To delete a constant, click on the name in the Name Manager dialog box and then click on Erase. On the off chance that you need to make another steady, click New in the Name Director exchange box.. The new The Name dialog box appears; You can make your tickets. In addition to the formulas, you can also enter text as a constant value Simply type the text in the Refers to field.

Open

MS Excel : CREATE FORMULAS that include names

MS Excel : CREATE FORMULAS that include names

Formula building can be complicated, especially
when you use several functions in the same formula
or when multiple arguments are required in a single
function. Use named constants and named ranges
can make create formulas and use functions
easier by allowing you to use terms that you have created
that clearly identify a value or range of values. A
argument is the information you provide to the function
so that the function can do its job. A constant with name is
a name that you think refers to a single, often
value used

A named range is a name
It is assigned to a group of related cells.
To insert a name in a function or use it in a
formula or as an argument of a function, you must write
access it using Use in formula in formulas
tab, or select it from the AutoComplete Function list.

USE A CONSTANT OR RANGE NAME IN A
FORMULA

1 Place the cursor on the cell in
which one do you want to create?
formula.
2 Type the name of the constant
or rank
As you type, a list of possible
The values   appear. Double click on a
value to place it in the formula.
3 Press Enter.

l The cell shows the result.

USE A CONSTANT OR RANGE
NAME IN A FORMULA

Note: use this technique if
you forget the name of a
constant or range.
1 Start writing your
formula.
2 Click the Formulas tab.
3 Click Use in formula.

A menu appears.

4 Click on the constant or
range name you want
use.
If necessary, continue
writing your formula and
press Enter when
finish.
5 Press Enter.
l Excel feeds the selected constant or range
name in the formula, which then
Show a result based on it.

Did you know

To create several named constants at the same time,
create two adjacent columns, a list of names and
the other list of values, for example, status names
and state sales tax rates. Select both columns. Click
the Formulas tab and afterward snap Make from choice.
The Create Names dialog box from the selection appears.
Click on a checkbox to indicate which column or row you want
use for name. Click OK Click Name Manager to
View the constants listed in the Name Manager dialog box
box. Use the same procedure to create named ranges.

Did you know

Naming a formula allows you to simply reuse it
typing your name To create a named formula, click
the cell that contains the recipe, click Formulas and
at that point click on Characterize Name.. The New Name dialog box
appears. Type a name for the formula in the Names
field, define its scope and then click OK.

Open

MS Excel : Calculate with THE FUNCTION WIZARD

MS Excel : Calculate with THE FUNCTION WIZARD

Excel Function Wizard simplifies the use of
functions You can take advantage of the wizard to
each of the Excel functions, from the sum (SUM)
function at the most complex statistical, mathematical,
Financial and engineering function. One simple but
useful function, ROUND, round the values   to
number of places you choose.

You can get to the Capacity Wizard in two different ways. One
form implies selecting a cell where the result is
appear and then click on the Insert Function button
and using the Insert Function dialog box to select a
function. Another way, which is a little faster, makes
Feel when you know the name of your function.
Start by selecting a cell for the result. Write an equal
sign (=) and the beginning of the function name. In
the list of functions that appears, double click on
function you want and then click Insert function
button.

Both methods show the Function Arguments box,
where you write the values   you want in your calculation
or click on the cells that contain the values.

1 Enter your information in the
spreadsheet.
Note: This example shows the
ROUND function, which takes two
arguments, one that indicates the
number to round and the
another indicating the number of
digits to which to round.
2 Click on the cell in which
He wants the result to appear.

3 Click the Insert Function button.
l The Insert Function dialog box
appears.
4 Click here and select All to list all
The functions.
5 Double-click the function that
want to use.

l The arguments of the function
the dialog box appears.
6 Click the cell (s) or
write the values
requested in each field.
l For this example, click on
the cell that contains the
entered value
Step 1.
l Enter the number of
decimal places to which
do you want to round ONE
negative number refers
to decimals to the
to the left of the decimal point.
7 Click OK.

The result appears in the cell.

Did you know
If you don't know what function you want
use, type a question in Find a function
field in the Insert Function dialog box. For help with
the capacity itself, click Help on this capacity in the
Function Arguments dialog box.

Caution!
Do not confuse the ROUND function with the number
ROUND formatting works by evaluating a number in a
argument and rounding it to the number of digits that
specify in the second field of the function arguments
dialog box. When formatting numbers, simplify the
appearance of the number on the worksheet, making
The easiest number to read. The underlying number is
without changes.

Open

MS Excel : Find out the LOAN TERMS

MS Excel : Find out the LOAN TERMS

You can use the Excel payment function (PMT) when
buy a house or car This function allows you
compare the loan terms and make an objective decision
based on factors such as the monthly amount
payment.

You can figure advance installments from numerous points of view when
using Excel, but using the PMT function can be
more simple because you simply enter the arguments
in the Function Wizard. To do your job even
easier, enter your argument values   in your
worksheet before starting the wizard. Then by
By clicking on a cell, you can enter the value of the cell
in the wizard

The PMT function takes three required arguments. by
RATE, enter an annual interest rate of 5 percent
and afterward type .05 isolated by 12 to compute the
monthly rate For NPER, number of periods, enter
the number of loan periods for the loan that you are
searching. For PV, present value, enter the amount of
the loan. The monthly payment appears surrounded
in parentheses, which means that the number is
negative, or a cash outflow.

1 Write the principal (this
value), interest rate and number
of periods
2 Click on the cell in which
He wants the result to appear.
3 Click the Insert Function button.

l The Insert Function dialog box
appears.
4 Click here and select Financial.
5 Double click on PMT.

l The PMT function
Arguments dialog box
appears.
6 Click on the cell with
the interest rate.
7 Divide the interest rate
by the number of
periods per year; for
example, type 12.
8 Click on the cell with
The number of periods.
9 Click on the cell with
director.
0 Click OK.

The result appears in the cell.

Note: The result shows the amount of a
Single loan payment.
Note: you can repeat steps 1 to 10 for others
combinations of the three variables.

Did you know

On a worksheet, you can create a loan calculator
showing all values   at once. Place the labels
Principal, interest and number of months of a loan
period in a column. Enter their respective values   in
adjacent cells on the right. Use references to those
cells in the Capacity Contentions discourse box for PMT.

Did you know

Excel's objective search function allows you to calculate
payments With the goal search, you can set up a
problem to specify a goal, such as payments less
that $ 1,100 per month, and that Excel vary a single
courage to reach the goal. The limitation is that you can
vary only one value at a time. See Task # 59 for more
information.

Open