City of St. Catharines Learning & Development

To take this course, you must have a solid understanding of most topics covered in Excel Course 1A.

Get comfortable with the behind-the-scenes tools that make Excel easier to use and share. In this course, you’ll learn how to set up print options, add comments and notes, move smoothly through your sheets, and protect your data with sheet and cell security.

Required Prior Knowledge: Solid understanding of Excel Course 1A topics.

Includes:

Page Layout & Printing

• Print Preview / Printing
• Scaling / Paper Size / Orientation
• Margins / Centre on Page
• Normal, Page Layout & Page Break Views
• Headers and Footers
• Print Titles / Page Breaks
• The Page Setup Dialog box

Cell Comments / Notes

• Adding Comments & Notes to Cells
• Edit, Delete, Move, Size, Print Comments
• Comment Colour / Adding Pictures
• Working with Threaded Comments

Working with Sheets

• Add, Rename, Hide, Delete Sheets
• Move & Copy Sheets
• Using Group Mode
• View Multiple Sheets Together

Protect

• Protect a workbook or sheet