Microsoft Excel Level 1, Mini Session 2

Multiple Formula Entries

Copying formulas and keeping same or changing

Transpose from vertical to horizontal and vice versa

Absolute and relative addressing in formulas

View and hide formulas

Create titles

Enter and edit comments

Insert rows and columns or cells

Delete rows and columns

Insert picture or image from internet

Printing options:

• Headers and footers
• Margins
• Page breaks
• Repeat columns or   rows
• Comments
• Gridlines
• AutoFit

Arrange windows for multiple viewing

Window split to see two parts of the same file

Freeze panes to scroll through data and keep columns / rows constant

Click here to enroll in this Zoom session.