Saturday, July 7, 2012

Excelsheet for Beginners Day 2 (two)

 Next we will learn Creating Cell Data -Day 2

Making Cell Entries
Excel recognizes only two types of cell entries: text (label) and number (or value).

Numeric cell entries are those that consist solely of numbers or calculable formulas.

Text entries are those that consist of all letters or a combination of letters, numbers, and punctuation on which Excel can perform no sort of calculation.

Excel Worksheet automatically left aligns all text entries and right-aligns all numeric ones, you can often tell immediately how your entry has been classified by noting how it’s aligned in its cell.

Entering data in a cell range
To make the same entry in several different cells in the same worksheet, select all the cells and cell ranges and then press Ctrl+Enter to complete the entry you make in the active cell and simultaneously insert it into all the other selected cells.

Pasting Data
The cut, copy, and paste features are used by virtually everyone who uses Excel. However, Excel offers additional advanced techniques for pasting that a great many Excel users are unaware of or rarely use, even though they allow the user to do some very powerful data manipulation.

Using the Paste Special feature, you copy values using various options without copying formula from the cells.

Filling in a data series with the Fill handle
The tiny black square in the lower-right corner of the cell cursor is known as the Fill handle. The Fill handle is your key to the AutoFill feature that makes it easy to fill in a continuous range with the same entry or with data series.

To create a sequential series that increments by one unit (day, hour, month, number), you enter the first entry in the series in a blank cell and then drag the Fill handle in the direction you want the series to appear (down or to the right are the most common directions).

To create series that increment by other units (every other day, every third number, every fourth hour), you enter the first two entries in the series (that serves as an example of the increment to be used) in two adjacent blank cells and then, after selecting them both, drag the Fill handle in the appropriate

Applying Auto Fill for a Data Series
You can quickly fill adjacent cells with data that continues a formula or a series of numbers, days, or dates, either manually from the Fill menu, or automatically by dragging the fill handle. When copying or filling data by using the Fill menu commands, you can set specific options for the pattern of the data sequence you want to create.

Go to Edit menu > fill menu > Series option> click AutoFill (day, weekdays, months, years.)

Copying a formula with the Fill handle
AutoFill is not only useful for filling in a data series or copying a data entry into a continuous cell range, but also for copying a formula across a row or down a column of a data table. When you copy a formula, Excel automatically adjusts the column and row references.

Excel automatically uses the relative column and row cell references in all formulas you create.
If you ever need to override/avoid this so that all or part of a cell reference is not adjusted in the copied formulas, you enter a $ (dollar sign) (it locks reference cell) before the cell’s column letter or row number (you can have Excel do it for you by pressing F4 while building the formula on the Formula bar).

Formulas are entries that have an equation that calculates the value to display. When creating any formula, Excel always follows the mathematical(algebraic) order of operations.

Formulas OR Functions always BEGIN with an equal sign ( = ) , in a formula, constants(numbers like 1,2,3), functions and cell reference may be used.

when making/evaluating a formula, the order is/should as follow (from highest to lowest priority):
1.parenthesis ()
2.Negation(ex. -1)
3.Percentage (%)
4.Exponentiation (^ 'caret sign' is symbol for square,its written as 2^2)
5.Multiplication and Division (* for multiplication and / for division)
6.Addition and Subtraction (+ for addition and - for subtraction)

Probably the most popular function in any spreadsheet is the 'SUM' function.
The 'Sum' function takes all of the values in each of the specified cells and totals their values to give their total value.
=SUM(first value, second value, etc)

Formula Condition:
Text cells can not be added to a number and will produce an error.

The 'Average' function finds the average of the specified data.
=Average (first value, second value, etc.)

The 'Max' (which stand for Maximum) Function, will return the largest (Maximum / Highest) value in the selected range of cells.

'Min' (which stands for minimum) Function will return the smallest (Minimum / Lowest) value in the selected range of cells.
Conditions for Max-Min Functions:
Blank entries/cells are not included in the calculations of the Max/Min Function.
Text entries in cells are not included in the calculations of the Max/Min Function.

The 'IF' function will check the logical condition of a statement and return one value if true and a different value if false.

 The formula condition is:    =IF (condition, value-if-true, value-if-false)

value returned may be either a number or text,if value returned is text, it must be in quotes like this "HELLO".

End of day 2.. to continue...


stock tips said...

Good post however, I was wanting to know if you could write a little more on this subject? I'd be very
grateful if you could elaborate a little bit more. Appreciate it!
Stock Tips

Mamta Soni said...

Your blog is very informative and gracefully
your guideline is very good.Thank you
Regional pharmacy college
deepshikha group of colleges

sid quanto said...

NIFTY 04-Feb-2013
Current Market Situation :

NIFTY current close : 5987
NIFTY resistance level : 6158
NIFTY support level : 5912
NIFTY sentiment : positive
NIFTY dominant cycle period : 18 days

Levels Tomorrow :

NIFTY intraday resistance 1 : 6012
NIFTY intraday resistance 2 : 6041
NIFTY intraday resistance 3 : 6083

NIFTY intraday support 1 : 5962
NIFTY intraday support 2 : 5933
NIFTY intraday support 3 : 5891

for more log onto
Markets Quantified