City of St. Catharines Learning & Development

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

Learn how to manage data like a pro in this course.

We cover the essentials of building a solid database, sorting and filtering like a champ, and getting the most out of Tables—to keep your data organized, clean, and easy to work with.

Required Prior Knowledge: Solid understanding of most Course 1A topics needed. Helpful if you have some knowledge of Course 1B topics.

Includes:

Setup a Valid Database

• Why Correct Setup is Important
• Valid Database Rules
• Selecting and Navigating Data
• Freeze Headings & Print Titles

Sort & Filter

• Basic and Custom Sorting
• Activating Filter
• Entering/Selecting Filter Criteria
• Totaling Filtered Data
• Clear & Reapply
• Copy/Paste and Delete Filtered Data
• What are Custom Views and Sheet Views

Formats as Table

• Static vs Dynamic Ranges
• Working in a Table
• Filter with Table Slicers