1 / 17

Microsoft Excel grade 8

Microsoft Excel grade 8. By : Reem Hasayen. General information. Types of files. Word document. *.doc Excel sheet *.exl Publisher *.pub Database *.dba PowerPoint *.ppt Picture *.gif or *.jpeg. Introduction to Microsoft Excel. Microsoft excel interface N ew additional tab “ File”

triage
Download Presentation

Microsoft Excel grade 8

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Microsoft Excelgrade 8 By : ReemHasayen

  2. General information • Types of files. • Word document. *.doc • Excel sheet *.exl • Publisher *.pub • Database *.dba • PowerPoint *.ppt • Picture *.gif or *.jpeg

  3. Introduction to Microsoft Excel • Microsoft excel interface • New additional tab “ File” • Save in different types • Open recent workbooks • Microsoft excel options

  4. practice • Open new worksheet • Resize the first 8 columns, make them smaller. • Write your name in cell A6 • Save it in th

  5. Microsoft excel workbook • Rows and columns • Resizing • Insert and delete rows and columns • Hide and show • Renaming and adding sheets • Auto fill function

  6. Format cells • Format painter • Shading cells • Adding border • Merge cells • Text wrapping • Shrink to fit • Time and currency format • Insert comment • Format comment

  7. Find cells • Use the find function • Use find and replace • Spell check

  8. Table formatting • Creating table • Adding new row and columns • Changing table styles • Sorting data in the table • Moving a table

  9. Printing work • Print preview • Print orientation • Print area … set it • Print area …remove

  10. Smart art graphics • Creating smart art graphics • Changing the design • Changing colors • Applying styles • Adding further boxes • Adding bullet points

  11. Microsoft excel functions • Sum, average • Concatenate • Count • CountA • CountBlank • Max, Min • Round, Rank

  12. Sorting data • Single column sort in a table • Multiple columns sort in a table • Custom list sorting • Creating new custom sorting

  13. Functions • Count • Average • Concatenate • Hlookup • If ,if OR, if AND • Now (date today) • Round

  14. Filtering data • Auto filter basics • Display all rows in filtered list • Costuming search criteria

  15. Protecting a worksheet • Protecting a worksheet • Unprotecting a worksheet • Protecting a range of cells

  16. Form controls • Add spinner • Add combo box

  17. Macros • Developer tab • Record a macro • Assigning a macro to a button • Viewing the macro codes • Closing the macro code

More Related