Sarrifka Oday Cuke
Summary Report..
Bakhaarka Maacuunta
cuke lookup
Cuke1
Cuke2
calendarjaja
calendardiff
xajixis
abtidonticket50
abtidonFares
abtidonFares2
bashirmoi
Bashirhospitalhelp
Advanceduserform
(Excel 2010 Tutorial For Beginners #1  Overview (Microsoft Excel)
  DropDown List:
select ur list > DATA > Data Validation > in the dialouge set Allow to LIST > type in the SOURCE
Yes,No,Don't know > OK
 to Align Value select it then rightClick > Format Cells > Alignment > General > Left.
 To do serial Numbers use
type this code in ur second number position =IF(ISBLANK(E4)," ",D3+1) then copy from number 2 to the ur last name
this means if E4 is blank (which is not blank) make blank, but if its not blank from D3 (which is ur 1st No)
add 1
see youtube MS Excel : Automatically Insert Serial Number
 to calc a sum in a culumn, and want to add another sums in the future just =SUM(B4:B17
so if u had B4 upto B7 its calc, then once u add B8 it will calc Auto.
 to AutoCalc a row sum =SUM(from point : to another point) such as =(B3:F3) .
 that SUM u've done as a Row, to AutoCalc as Culumn, just pull BlackCircleSign to the bottom
OR hover ur mouse over Plus sign then DoubleClick.
 to Center a Title text, click on first cell & pull until ur desired cell.
 to edit or Bold a diff text rows, click on first cell & pull until ur desired cell, then tap on Cntrl & go to & click
on ther other Row or Col, then pull ur Row or Col, SEE: (Excel 2010 Tutorial For Beginners #1  Overview (Microsoft Excel)
 For BORDERS Select all your Data, then click on after B I U (Bold, Italic, Underline) & select ur Borders
 NB: 2 '+' ayaa jirta tan weyne dhexda cad waa editing such as TextCenterting, tan yare madowse waa command ..
 to do CHART, highligh all data except Totals, > INSERT > COLUMN > 2D COLUMN
Once u Add 2 sums:
 to edit some text or number, click on it & just type ur new.
 To spreed a cell which not suficient its text, go to upper divider line & doubleClick =B3+B4)
 use TAB key, once u want to next row click Enter.
 To calc a Sum =(B3+B4)/3)
 to calc Average =AVERAGE(B3:B4)
 calc all is written in number 9 =SUM(3:3)
 to limit or stop in center of No3 Row =SUM(B3:F3)
 to calc all is written in E column =SUM(E:E)
 to calc different sums, such as Jan to April and June to Oct =SUM(B3:B5,B9:B11)
 to calc have of cell sum or 50% =B4*.5)
 to calc 20% =B4*.2)
 to calc total of entire ROW use numbers =SUM(9:9)
 to calc total of Entire Coloum =SUM(B:B)
 to calc AVERAGE or the have of a two diff sum: =AVERAGE(B3:B4 
 to edit a sum, just double click the result or the Formula Bar.
 to undo use ESCAPE
 to allow for user or deny click Data > click Data Validation Dialoge box.
 to cut a sum from another sum, just click any blank cell then type '=' sign, then click on ur 1st sum,
then type ur logic sign '+', then click on ur 2nd sum, then Enter.

02 05. Adding Pivot Table columns to enhance data analysis,
to create calculated field in 2007:
select any cell of a table > options > in a tool click formulas > Calculate field

Excel 2010 Tutorial For Beginners #3  Calculation Basics & Formulas (Microsoft Excel)
 to calc result u can use Enter or tick sign at the formula Bar.
