Page 7 - Ms Excel Note and Workbook

TABLE OF CONTENT

1 GETTING TO KNOW EXCEL ................................................................................................................ 1

The Excel Interface ..................................................................................................................... 1
Working with the Excel environment ........................................................................................ 2

The Ribbon ................................................................................................................................. 2
The Quick Access Toolbar .......................................................................................................... 5

Worksheet Views ....................................................................................................................... 7
Backstage view ........................................................................................................................... 9
2 CREATING & OPENING WORKBOOKS ............................................................................................. 10

About OneDrive........................................................................................................................ 10
Using templates ....................................................................................................................... 15

Compatibility Mode ................................................................................................................. 17
3 SAVING & SHARING WORKBOOKS ................................................................................................ 19
Save and Save As ...................................................................................................................... 19

Using Save As to make a copy .................................................................................................. 21
To change the default save location: ....................................................................................... 21

AutoRecover ............................................................................................................................. 23
Exporting workbooks ............................................................................................................... 25

Sharing Workbooks .................................................................................................................. 29
4 WORKING WITH CELLS AND SHEETS ............................................................................................... 31

Understanding cells .................................................................................................................. 31
Cell content .............................................................................................................................. 34
To use the fill handle: ............................................................................................................... 48

5 MODIFYING COLUMNS,ROWS & CELLS .......................................................................................... 51
Modify Width and Height ......................................................................................................... 51

Inserting, deleting, moving, and hiding.................................................................................... 56
Wrapping text and merging cells ............................................................................................. 65

Formatting Cells ....................................................................................................................... 68