City of St. Catharines Learning & Development

To take this course you must know the topics in Excel Course 1A and Excel Course 1B AND consider yourself as intermediate or better Excel user.

Boost your productivity by exploring Excel’s hidden gems—those underused features that can seriously streamline your workflow. This course highlights time-saving tools that make a real difference, with topics adjusted based on time and learner needs.

Great Features

• Show Sheets in Separate Windows
• Hyperlinks to Navigate Workbook
• Custom Number & Date Formats
• Customize the Quick Access Toolbar
• Concatenating / Create Custom Fill Lists
• Checkboxes / Goto Special to Select / Cell Styles
• Data Types / Quicker Hide Columns & Rows
• Save Filters or Print Settings

Quick Tips

• Trick with Absolute Referencing
• Copy Visible Cells Only
• Quick Ways to Navigate, Select & Move Data
• AutoFit Column Cell Range
• Zoom to Width of Data
• Formatting Tricks / Quick Paste Values
• Better than Merge Cells
• Go Back to Cell Pointer / Copy Cell Above
• Cell Messages / In Cell Pictures / Focus Cell