Excel for Administrators

Administrators keep lists, registers and trackers that other people rely on. This course shows you how to build them properly in Microsoft 365 Excel, so they stay accurate as they grow, answer questions in seconds and are safe to share. Each module builds a skill you will use in the final tracker builds.

COURSE STRUCTURE • Module 01: Introduction to Excel for Administrators • Module 02: Good Workbook Structure and Data Formats • Module 03: Excel Tables, Sorting and Filtering • Module 04: Formulas, Functions and References • Module 05: Lookups, Dates and Text Functions • Module 06: Data Validation and Conditional Formatting • Module 07: PivotTables and Charts • Module 08: Protecting, Sharing and Printing • Module 09: Building Common Admin Trackers • Module 10: Putting It into Practice

HOW IT WORKS Work through each module online. Most modules end with a short knowledge check (60% to continue). The course ends with a final assessment: pass mark 80%, 60 minutes, 3 attempts. Learners who pass receive a MetaCo certificate.

COURSE MATERIALS Learner Manual, Activity Workbook, Quick Reference Guide, practical toolkit, Action Plan and Evaluation Form, attached to Module 01.