• Outline:
o Overview of the Excel interface, including the ribbon, cells, columns, rows, and worksheets.
o Basic Data Entry: Entering and editing data in cells, including text, numbers, and dates.
o Formatting Cells: Formatting cell content, including font styles, colours, alignments, and borders.
o Working with Formulas and Functions: Introduction to basic Excel formulas (e.g., SUM, AVERAGE, COUNT) and functions for performing calculations.
o Managing Worksheets: Adding, deleting, renaming, and navigating between worksheets.
o Sorting and Filtering Data: Sorting data alphabetically or numerically, and filtering data to display specific information.
o Creating Simple Charts: Creating basic charts (e.g., column, line, pie charts) to visualize data.
o Printing and Sharing Workbooks: Printing worksheets, adjusting print settings, and saving and sharing Excel workbooks.
• Learning Outcomes:
o Participants will become familiar with the Excel interface and understand the basic elements of a spreadsheet.
o Participants will be able to enter and edit data effectively in Excel.
o Participants will learn how to format cells to enhance the visual appearance of their worksheets.
o Participants will gain proficiency in using basic Excel formulas and functions to perform calculations.
o Participants will learn how to manage multiple worksheets within a workbook.
o Participants will understand how to sort and filter data to analyse Information more efficiently.
o Participants will be able to create simple charts to visualize data trends and patterns. o Participants will learn how to print worksheets and adjust print settings, as well as save and share Excel workbooks with others