Learning Outcomes

In this free course, you will learn how to:

• Define the main components of the Microsoft Excel interface for effective navigation.
• Identify key features of the ribbon and its role in accessing Excel tools.
• Explain the structure of the worksheet, including rows, columns, and cells.
• Create custom autofill lists to streamline repetitive data entry tasks.
• Explain number formatting options, including currency, percentages, and dates, to present data clearly.
• Identify and use conditional formatting to highlight critical data trends and exceptions in a worksheet.
• Apply various font styles, borders, and fill colours to enhance cell appearance and readability.
• Create cross-sheet references to link data across multiple worksheets for consolidated reporting.
• Apply common functions like SUM, AVERAGE, MIN, and MAX to analyse datasets efficiently.
• Identify and troubleshoot common formula errors to maintain accurate and functional worksheets.
• Recall how to Insert and customise basic charts to visually represent data.
• Explain how to save and reuse chart designs as templates for consistency.