More About MS Excel

1. More About MS Excel Formatting Numbers Creating custom lists Modifying and formatting data

2. Formatting Numbers Select the range of cells that you wish to format. Click Format menu  Cells option. The Format Cells dialog box appears as shown below: You can choose numbers, date or time Click OK

3. Formatting The Fonts Select the cell or range of cells Click Format menu  Cells option. Click the Font tab on the dialog box: You may select the required formats such as Font Style, Size, Color etc. Click OK

4. Formatting Cells Select the cell or range of cells Click Format menu  Cells option. The Format cells dialog box appears. Click on the Patterns tab Click on Patterns Choose Patterns Click OK

5. Creating Custom Lists Click on Tools options from the Menu Bar. Click on Options. The Option dialog box appears. Custom lists tab Add button Import Option