EXCEL TUTORIAL ```Sarrifka Oday Cuke Summary Report.. Bakhaarka Maacuunta cuke lookup Cuke1 Cuke2 calendarjaja calendardiff xajixis abtidonticket50 abtidonFares abtidonFares2 bashirmoi Bashirhospitalhelp Advanced-userform (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 Text-Centerting, tan yare madowse waa command .. - to do CHART, highligh all data except Totals, > INSERT > COLUMN > 2-D 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. ```