Excel 2019: Navigate the Interface & Tools

Course description

This course focuses on helping learners become proficient with the essential interface tools in Microsoft Excel 2019. Building on introductory knowledge, it provides an in-depth look at how users interact with Excel’s core features to create, view, and manage data efficiently. The course begins with an exploration of the Excel ribbon, the central hub for all commands and tools. Learners will understand how ribbon tabs such as Home, Insert, Formulas, Data, and View organize commands into functional groups for formatting, inserting, analyzing, and reviewing data. Participants will explore the purpose of contextual tabs and how to navigate, customize, and reveal hidden features to optimize workflow. The lessons then shift focus to the structure of an Excel worksheet, breaking down how rows, columns, and cells work together to store and reference data. Learners will examine concepts such as cell addresses, the name box, and formula bar, and gain an understanding of how formulas differ from static data entries. The course also covers how to manage multiple worksheets within a workbook, including renaming, referencing, and linking data across sheets. Finally, learners explore the Backstage view; Excel’s behind-the-scenes environment for saving, printing, sharing, protecting, and customizing files. By mastering these tools, users will feel confident navigating Excel’s interface, managing workbooks, and leveraging built-in features to create a structured, efficient workflow for data management and reporting.

Course outline