Course Aims

• Introduce students to the Excel interface and core functions.

• Equip them with essential spreadsheet skills for work, school, or daily life.

• Build confidence to use Excel for calculations, data organization, and simple analysis.

Course Outline

Session 1: Getting Started with Excel, Formatting for Clarity & Presentation

• What is Excel? Common uses and benefits

• Excel interface tour: ribbons, worksheets, columns & rows, cells

• Creating, saving, and opening workbooks

• Entering and editing text, numbers, and dates

• Autofill basics

• Formatting cells: fonts, colors, number formats (currency, percentage, date)

• Adjusting column width and row height

• Using cell borders and shading

• Wrap text and merge cells

Session 2: Introduction to Formulas & Functions, Visualizing Data with Charts

• What are formulas? Writing simple calculations (+, –, ×, ÷)

• Understanding cell references (relative vs. absolute – intro only)

• Using basic functions: SUM, AVERAGE, MIN, MAX

• AutoSum and Formula Bar

• Why use charts? Choosing the right type

• Creating column, bar, and pie charts

• Modifying chart titles, colors, and labels

• Moving and resizing charts

Session 3: Organizing & Managing Data, Sharing, Printing & Wrap-Up

• Sorting data (A–Z, Z–A, by numbers or dates)

• Introduction to filtering data

• Inserting and deleting rows/columns

• Using Freeze Panes for large sheets

• Print preview, adjusting margins and scaling

• Saving in different formats (Excel, PDF)

• Basic sharing options (email, OneDrive)

• Review of key skills learned

• Final mini-project: create and format a simple data table, add calculations and a chart