Microsoft Excel Presentation - PowerPoint PPT Presentation

june
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Excel Presentation PowerPoint Presentation
Download Presentation
Microsoft Excel Presentation

play fullscreen
1 / 16
Download Presentation
Microsoft Excel Presentation
187 Views
Download Presentation

Microsoft Excel Presentation

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft Excel Presentation By Mr. Gul Rukh Khan In respect of Prof. Dr. Himayatullah Khan

  2. Microsoft Office Tool 3 in 1 Worksheet (Analysis) Database Graphs (Visualize Data)

  3. Series in Excel = Char (number) goto Practical work

  4. Copy and Paste • Cell data (Text and Numbers) • Values • Formulae • Formats • Comments (Review  New Comment) • Cell validation • Transpose (Rows in columns and vice versa) goto Practical work

  5. Data Validation To enter valid data under specific Criteria. e.g. I want to enroll the students in class 5th not greater than 8 and less than 5 years old.

  6. Data Validation – List (Combo Box in Excel) goto Practical work

  7. Frequency Distribution Block Percentage Data cells  click on Block Amount Data  Name to SALE Block below Cells =FREQUENCY(Sale,D2:D8) Ctrl + Shift + Enter D S a l e

  8. Observation, Mean and Standard Deviation in Excel

  9. Standard Deviation 2nd Method

  10. To handle Missing ValuesIF ( ) FUNCTION =IF(ISNA(LOOKUP(F2,C21:C25)),0,LOOKUP(F2,C21:C25)) =IF(ISNA(LOOKUP(F2,C21:C25)),0,LOOKUP(F2,C21:C25))

  11. AND Clause in IF ( ) F4 to lock the Cell =AND(B26>=$B$21,C26>=$B$23) =if(AND(B26>=$B$21,C26>=$B$23),”Extended”, “No Credit”)

  12. Conditional Formatting Conditional Formatting:

  13. OR Clause in IF ( ) =OR(B26>=$B$21,C26>=$B$23)

  14. Grade Example with Nested IF( ) function

  15. Days30( ) for Age in days, months, years