♥ ♥ ♥ Microsoft Excel basic ♥ ♥ ♥

SESSION 1

What is Microsoft Excel...???

= Microsoft Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.
= Excel screen just shown us  a rectangular table or grid of rows and columns.
=  horizontal rows are identified by numbers (1,2,3).
=  and the vertical columns with letters of the alphabet (A,B,C).

Uses of Microsoft Excel...!!! 

~ ♥ ~ wrapping text and merging cells 
~ ♥ ~ formating text 
~ ♥ ~ create a simple formula in Excel (with cell reference,using point and click method) 

SESSION 2 

~ ♥ ~ Advanced of Microsoft Excel.

Sparklines

~ is a type of information graphic characterized by its small size and high data density.
~ miniature charts that fit into a single cell.
~ can place a large of number into our cell.

Type of Sparkline

@ there are 3 type of Sparkline :
     1) Line

     2) Columns

     3) Win/loss

Pivot Table

~ manage a data in worksheet.
~ summarizing data and allowing user to manipulate it in different ways.

Reviewing & Sharing Workbook

1) Track changes
   =used to record a history of any changes made to the workbook
2) Adding and deleting comments
   =create a comment
   =viewing a comment
   =hide comment
   =modifying comment
   =deleting comment 

Finalizing and Protecting Workbook

♥ Check Spelling
   - select cell you want to check spelling.
   - Click SPELLING command in review tab
   - SPELLING dialog will open
   - then, you can review and correct any misspelled.
♥ Document Inspector
   - go to Backstage view
   - click Info,Check for Issue, then Inspect Document
   - check boxes beside the content you want to inspect.
   - To unselect a box, click it again, and the check mark will disappear.
   - Click Inspect.
   - after Inspector Document finished, a new dialog box will appear.