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

How To Use Tell Me Box ............................................................................................................ 6
Worksheet Views ....................................................................................................................... 6
Backstage view ........................................................................................................................... 9

2 CREATING & OPENING WORKBOOKS ..................................................................................... 10
About OneDrive........................................................................................................................ 10

Using templates ....................................................................................................................... 14
Compatibility Mode ................................................................................................................. 15
3 SAVING & SHARING WORKBOOKS ........................................................................................ 18

Save and Save As ...................................................................................................................... 18
Using Save As to make a copy .................................................................................................. 20

To change the default, save location: ...................................................................................... 20
AutoRecover ............................................................................................................................. 22

Exporting workbooks ............................................................................................................... 24
Sharing Workbooks .................................................................................................................. 27

4 WORKING WITH CELLS AND SHEETS ....................................................................................... 28
Understanding cells .................................................................................................................. 28
Cell content .............................................................................................................................. 30

To use the fill handle: ............................................................................................................... 38
5 MODIFYING COLUMNS, ROWS & CELLS .................................................................................. 40

Modify Width and Height ......................................................................................................... 40
Inserting, deleting, moving, and hiding.................................................................................... 43

Wrapping text and merging cells ............................................................................................. 48