Search This Blog

15 January 2011

Formulas in Excel

 Some Info for formulas:
  • All formulas begin with a = sign
  • To enter a formula, Simply click on the cell, and start typing the formula. Remember the “equal to” sign.
  • The simple mathematical operators that can be used are 
                          *              Multiplication
                         
/               Division                         
                         +              Addition                        
                          -              Subtraction
  • Always remember the order of operations, indicating which procedures need to be performed first in the given mathematical expression. (DON'T PANIC; it gets easier as you keep on doing it).
  • Mnemonics like BE(I)DMAS and PEDMAS can help a lot. Wiki Article Mnemonics Link Here 
              It stands for Parentheses (Brackets), Exponentiation (Index), Multiplication, Division, Addition, Subtraction.
  • When in doubt USE PARENTHESIS/BRACKETS to indicate the preference of operations.
              So in future instead of writing 2*4-5  write it as (2*4) - 5 and read it as "2 times 4 and then minus 5"
              Once you start reading the formulas correct the battle is won. 
  •  Formulas like  =21*5 will yield result when enter/return is pressed. This will stay static.
  •  Formulas which use the cells as operands i.e., like =D3+E3 will result in the sum of cells D3 and E3. This will change results once the values in the mentioned cells change. Note that a  blank cell is treated as zero.
            These are the basic formulas. 

Other than this there are some inbuilt formulas and you can use complex mathematical operands in excel. More about it in the later posts.


Hope this Helps.

11 January 2011

Excel Art























This was done using the Windows executable Program called Excel Art

The other way of doing this is manually

Complete instructions for doing the Google Logo can be found Here




Hope this Helps.

What is Excel?

Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.
The basic understanding being that excel is a spreadsheet.
What most of us- as casual users of Excel- don't know is that Excel is a Very Powerful tool for not only producing Graphs but also for in depth Analysis of data.

Heres what the Basic Excel Window looks like

A couple of Graphing examples:
Bar Graph/Chart
Pie Chart   





Creating Applications


More complicated 3D Graph



Hope this Helps.