ICT IGCSE Spreadsheets Guide | Microsoft Excel Step-by-Step

EXCEL

Work Smarter with Excel • Organize • Calculate • Analyze • Achieve

Master ICT IGCSE Microsoft Excel

Your ultimate minimalist study companion covering basic spreadsheets, formulas, advanced lookups, data entry steps, and practical exam skills. Curated by Tr. WaiLinHtet.

Step-by-Step Guide Open Official Mindmap PDF

Microsoft Excel Step-by-Step Data Guide

Follow this exact exam workflow to ensure clean data input and error-free formatting.

Import CSV Data

Open or import provided CSV files carefully. Check column delimiters, ensure headers align with row 1, and verify that no text is cut off.

Data Entry & Types

Enter text left-aligned and numbers right-aligned. Apply correct data types: Short Text, Number (Integer/Decimal), Date/Time, and Currency ($2 decimal places).

Formulas & Functions

Construct accurate formulas using uppercase function names (`SUM`, `AVERAGE`, `IF`, `VLOOKUP`). Double-check cell references (`C3` vs `$C$3` absolute references).

Page Setup & Print

Set landscape/portrait orientation, adjust margins, enable gridlines visibility in print settings, and ensure fit-to-page rules are met before capture.

The 9 Core Spreadsheet Modules

Directly mapped from Tr. WaiLinHtet's masterclass mindmap.

Basic Spreadsheet

• Workbook: File containing multiple worksheets.
• Worksheet: Individual grid sheet.
• Rows & Columns: Numbered (1,2,3) & Lettered (A,B,C).
• Cells & Address: Intersection (e.g. C3).

Formula & Functions

• SUM / AVERAGE: Aggregate numerical values.
• MIN / MAX: Find smallest or largest value.
• IF Condition: `=IF(A1>=50, "Pass", "Fail")`
• COUNTIF / COUNTA: Conditional counting.

Data & Formatting

• Number Formats: Currency ($), Percentage (%), Date.
• Conditional Formatting: Highlight cells based on rules.
• Text Alignment: Left align text, right align numbers.

Tables & Charts

• Organize, sort, and filter tabular records cleanly.
• Charts: Column, Bar, Line, and Pie charts.
• Ensure clear axis titles, legends, and chart titles.

Excel Interface

• Formula Bar: View and edit cell formulas.
• Name Box: Displays active cell reference.
• Ribbon & Sheet Tabs: Switch worksheets easily.

Data Tools

• Sort: Arrange data ascending or descending.
• Filter: Display specific subset rows.
• Data Validation: Restrict input values.

Lookup Skills

• Lookup Value & Lookup Table range.
• Return column index number.
• Exact match (`FALSE` or `0`).

Printing & Page Setup

• Set Print Area & Margins correctly.
• Choose Portrait or Landscape orientation.
• Scaling: Fit to 1 page wide if required.

Practical Skills

• Grade calculation & weighted averages.
• Comprehensive data summaries and trend analysis.
• Clean evidence capture for examiners.

Advanced Lookup & Filter Evolution

From basic lookups to modern dynamic arrays.

LOOKUP

Basic

Introduced basic lookup functionality across a single row or column vector.

=LOOKUP("Samit", A2:A4, B2:B4)

VLOOKUP

Vertical

Added exact-match vertical searching in a structured table range.

=VLOOKUP(101, A2:B4, 2, FALSE)

HLOOKUP

Horizontal

Enabled horizontal data lookup scanning across rows.

=HLOOKUP("Q3", A1:D2, 2, FALSE)

INDEX + MATCH

Flexible

Improved lookup flexibility by decoupling return columns.

=INDEX(B2:B4, MATCH("Table", A2:A4, 0))

XLOOKUP

Modern

Simplified and modernized lookups with intuitive syntax.

=XLOOKUP("Emma", A2:A4, B2:B4)

FILTER

Dynamic

Introduced dynamic array filtering based on boolean conditions.

=FILTER(A2:B4, B2:B4>55)

Excel & Spreadsheets