Microsoft Excel grade 8

Microsoft Excelgrade 8 By : ReemHasayen

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 • New additional tab “ File” • Save in different types • Open recent workbooks • Microsoft excel options

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

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

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

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

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

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

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

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

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

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

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

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

Form controls • Add spinner • Add combo box

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

Microsoft Excel grade 8