Microsoft Excel for Students | Formulas, Tables & Charts

Microsoft Excel for students is more than a grid where numbers are entered and a chart appears. It is a tool for expressing mathematical relationships in formulas, organising observations, checking totals and testing how a result changes when the data change.

Parents searching for Excel for beginners, Excel formulas for students, Excel SUM and AVERAGE, how to make charts in Excel, or Microsoft Excel school projects often want practical lessons that connect the software to school Mathematics, Science and research. The important skill is not memorising a hundred menu commands. It is understanding what a calculation means and whether a spreadsheet has performed it correctly.

This guide explains cells, ranges, basic functions, relative and absolute references, Excel tables, sorting, filters and charts. We include worked examples for Singapore Primary and Secondary learners, common traps involving numbers stored as text, and an independent checking routine. It also explains where Microsoft Excel differs from Google Sheets.

Quick answer: Microsoft Excel organises data in worksheets and uses formulas to calculate results. A formula begins with =, as explained in Microsoft’s official guidance. Students should follow question → data → formula → manual check → interpretation → explanation. The spreadsheet can calculate quickly, but it cannot automatically decide whether the learner has asked the right mathematical question.

What Is an Excel Workbook?

An Excel workbook is a file containing one or more worksheets. Each worksheet is a grid divided into rows and columns, with individual cells addressed by a combination such as A1 or B7.

A student could create a workbook for a Science experiment. The first worksheet might contain measured values, the second a summary table, and the third an explanatory chart.

However, a complicated workbook is not always better. For a Primary pupil recording six readings, one simple worksheet with clear headings may be preferable to a network of tabs and formulas.

Keep each variable in its own column where possible. A heading such as Temperature (°C) is more informative than Result because it states both the quantity and its unit.

An Excel file can look professional before any meaningful thinking has occurred. The first educational question should be what the observations represent, not which theme looks attractive.

Cells, Ranges and Formulas: A Simple Language

A formula begins with an equals sign. Microsoft documents operators including + for addition, – for subtraction, * for multiplication, / for division and ^ for exponentiation.

For example, if A2 holds 6 and B2 holds 4, the formula =A2*B2 returns 24. In a rectangular area question, that could represent 24 square units, provided the two inputs are the appropriate side measurements.

A range is a group of cells, for example B2:B6. Functions such as SUM and AVERAGE can use ranges directly.

The student should explain what each referenced cell represents. Copying =A2*B2 from a tutorial without knowing which quantity belongs in each column is not mathematical understanding.

Cell references help formulas update when inputs change. This is useful because the model can be tested with new values while preserving its calculation method.

The result remains only as valid as the data, formula and assumptions.

Worked Example 1: SUM and AVERAGE for a Reading Log

Imagine a learner records pages read on five school days: 8, 12, 10, 15, 5. Enter the values into B2:B6 and label the column Pages Read.

The total is 8 + 12 + 10 + 15 + 5 = 50 pages. The formula =SUM(B2:B6) should give 50.

The average per recorded day is 50 ÷ 5 = 10 pages. The formula =AVERAGE(B2:B6) should give 10 when all five entries are valid numbers.

Now change the last day from five pages to seven. The total becomes 52 and the average becomes 10.4. A correctly configured spreadsheet updates both results.

The arithmetic is easy enough to verify by hand. That manual check is worth doing because a wrong formula range can omit the last observation without creating an obvious error message.

Students should learn that automatic recalculation saves time, but it does not remove the duty to confirm that the correct cells were included.

Blank, Zero and Missing Are Different

Suppose a sixth reading day has no recorded value. The student might leave the cell blank, enter 0, or type not recorded. These choices represent different information.

Zero means the learner measured or reported none. Blank might mean the entry is missing. “Not recorded” explicitly describes a lack of observation.

Functions count and average data according to their rules. A numerical zero can affect the mean, while an empty cell may be excluded. If the student treats a missing observation as zero without justification, the conclusion can be distorted.

Before calculating a summary, ask whether the denominator should be all planned days, only observed days or another clearly defined group.

For research work, record why an observation is missing and avoid inventing replacement data merely to fill the table.

A correct formula answering the wrong denominator question is still a poor analysis.

Worked Example 2: A Class Survey Percentage

Suppose a school survey receives 24 valid responses, and 9 pupils choose walking as their main travel mode.

The percentage is 9 ÷ 24 × 100 = 37.5%. Enter 9 in cell B2 and 24 in B3, then use =B2/B3 in a result cell formatted as Percentage.

The underlying value is 0.375. Percentage formatting displays it as 37.5%. Multiplying by 100 inside the formula and then applying percentage formatting can yield the wrong display if the student does not understand how percentage formatting works.

A strong written conclusion is: Nine of the 24 valid respondents, or 37.5%, selected walking.

A poor conclusion is: 37.5% of all Singapore students walk to school. The sample does not justify that wider claim.

Excel makes division and formatting convenient. It cannot decide whether the sample represents a larger population.

The language of the conclusion must match the evidence.

Worked Example 3: Area and Perimeter of Rectangles

A useful Mathematics workbook contains columns for Length (cm), Width (cm), Area (cm²) and Perimeter (cm).

For a rectangle 8 cm long and 5 cm wide, area = 8 × 5 = 40 cm². Perimeter = 2(8 + 5) = 26 cm.

If length is in A2 and width in B2, the area formula is =A2B2 and the perimeter formula is =2(A2+B2).

Enter a second row for a 10 cm by 4 cm rectangle. Its area is also 40 cm², but its perimeter is 28 cm.

The students should now explain the pattern: two rectangles can have equal area but different perimeters. This mathematical relationship is more important than the spreadsheet’s appearance.

Then close the workbook and ask for the area and perimeter of a 9 cm by 3 cm rectangle. The answer is 27 cm² and 24 cm. That checks whether the learner knows the formulas independently.

Relative and Absolute Cell References

This is one of Excel’s most useful ideas and a common source of errors when formulas are copied down a table.

A relative reference such as A2 ordinarily adjusts when a formula is copied to a corresponding new location. In contrast, an absolute reference such as $B$1 fixes both the column and row in supported formula use.

Imagine a simple price list where each item’s base price is in column A and a hypothetical fixed rate is stored in B1. A calculation applying that rate should continue to refer to B1 as the formula is copied.

A suitable expression might use =A2*$B$1 to calculate the rate amount based on each row’s price. If the reference were only B1, copying the formula downward could move the rate reference to an unintended cell.

Ask the student to predict which parts of the formula will move before copying it. This is better than blindly dragging the fill handle and trusting every result.

For more advanced study, Microsoft also documents structured references inside Excel tables, which can make formulas more readable by referring to named columns rather than only coordinates.

Excel Tables and Structured References

Microsoft’s official table guide explains how Excel tables help organise related records, sort and filter entries, and use structured references.

A table gives columns meaningful names such as Quantity, Unit Price and Total Cost. A calculation can then refer to the relevant fields, depending on how the table is configured.

Structured references, described in Microsoft’s documentation, can make it clearer what a formula is intended to calculate.

For example, a hypothetical class-event cost table might multiply a quantity by the per-item price for each row. The idea is simple even if the syntax is new: every row records one item and calculates a related cost.

The student should still verify that the price and quantity are represented in appropriate units. Multiplying a price per pack by a number of individual pieces would be incorrect without converting the units.

A clear table reduces accidental errors, but it does not protect against misunderstanding the underlying quantities.

Sorting Values Without Breaking Their Records

Sorting makes it easy to arrange observations from smallest to largest, alphabetical order or date order. Microsoft’s sorting guide explains how this works for ranges and tables.

The most dangerous beginner mistake is sorting only one part of a dataset so that values become separated from the student, date or measurement they belong to.

For example, a table might list a fictional pupil code in column A and a measured time in column B. If the time values are sorted independently, the associations between codes and times can become wrong.

Keep each record together and verify the intended range before sorting. For an Excel table, use the built-in sort controls and inspect the resulting rows.

Another problem is numeric-looking data stored as text. Microsoft cautions that mixed text and numeric formats can produce unexpected sorting results.

A student should not trust a ranked list until the data types and associated records have been checked.

Why 10 Can Sort Before 2

The values 2 and 10 have a clear numerical order: 2 is smaller than 10. But when stored as text, their alphabetical or lexicographic ordering may place “10” before “2”.

That is not a mathematical claim that ten is smaller. It is a consequence of asking the software to sort character strings rather than numbers.

A worksheet may contain text-formatted numbers after importing a file from another application or entering a leading apostrophe. Microsoft explicitly warns about this in its sorting help.

Students should distinguish quantities, dates and identifiers. A code such as “007” may intentionally require leading zeros and should not necessarily be treated as the number seven.

When a sort order looks wrong, inspect the data format rather than changing the visual theme or retyping the whole column immediately.

Understanding data types is a foundational digital-literacy skill that extends to programming, databases and statistics.

Filtering and the Hidden-Row Problem

A filter displays rows meeting selected conditions without necessarily deleting the other records.

A student could filter a Science dataset to show only the results for one experiment group. The visible records may then be useful for comparing that group’s observations.

But the learner must remember that the hidden rows still exist. Depending on the formula used, a summary calculation can include values that are not currently visible.

Do not assume that applying an ordinary filter causes every SUM or AVERAGE formula to ignore hidden records. Check the function’s behaviour and use an appropriate visible-rows-only method if that is the analytical goal.

The correct question is: Which observations did this particular result actually include?

If the child cannot answer, the computed value should not be presented as a firm conclusion.

This is especially important in collaborative school research where another student may have applied a filter without telling the group.

Making Bar Charts, Line Charts and Scatter Plots

Microsoft’s chart guidance explains selecting data, creating a suitable chart and then checking titles, axes, labels and layout.

For a survey of categories, a bar chart can show how many respondents selected each option. For a sequence of observations over time, a line chart may help show a trend.

For two quantitative variables, a scatter plot may be more appropriate when the goal is to inspect an association between the values.

Do not choose a pie chart or colourful 3D display solely because it looks impressive. The chart must answer the stated question clearly.

Label units, sample size and dates where relevant. A graph of time against distance is different from a graph of distance against time, even when the same two variables appear.

Ask the learner to describe the finding in a plain sentence, then check whether the chart honestly represents that finding.

Worked Example 4: Repeated Science Measurements

Imagine a hypothetical toy car experiment measuring the time taken to travel a fixed distance in three trials. The readings are 4.2 s, 4.0 s and 4.4 s.

The average time is (4.2 + 4.0 + 4.4) ÷ 3 = 4.2 s. The student can enter the readings into Excel and verify this with AVERAGE.

But the arithmetic mean is not the entire scientific result. Were the same starting conditions used? Did the student release the car consistently? How precise was the timing method?

An average can reduce the influence of some random variation, but it does not automatically remove systematic error or establish a physical law.

Keep the observation order where it matters. A sorted table showing 4.0, 4.2 and 4.4 hides which run occurred first.

The student should report the actual units, method, result and limitations, then explain what the readings do—and do not—support.

PivotTables: A More Advanced Tool for Grouped Questions

When a dataset becomes larger, students may want to summarise records by category rather than calculate each category manually.

Microsoft’s Excel table and analysis ecosystem includes PivotTables, which can group and summarise data depending on the selected fields. The exact features depend on the version and environment.

A simple example uses an anonymised class reading survey with columns for a pupil code, year level and books completed. A PivotTable could summarise the number of responses or mean values by selected categories.

The key educational rule is that the original data must be valid, and the student must understand the measure being summarised. Counting records is different from summing quantities or averaging scores.

If a PivotTable gives a surprising result, check the source range, row and column categories, filters and calculation type before concluding the data are wrong.

This is a useful tool when the question has become more complex—not a necessary prerequisite for a Primary pupil learning a simple mean.

Collaboration, OneDrive and Version History

Microsoft’s co-authoring guide describes sharing eligible Excel workbooks stored in OneDrive or other supported cloud environments so that authorised users can edit together.

Permissions and application versions matter. A file merely copied to a friend’s device is not necessarily the same thing as a shared workbook with coordinated editing.

When working with classmates, assign clear roles: data recorder, calculation checker and interpretation writer. One student should not be responsible for all the reasoning while others only change colours.

Version history in supported Microsoft 365 environments can help inspect or restore earlier versions if a formula is accidentally changed.

Do not place identifiable student assessment records or private school information in broadly shared workbooks. Grant only the appropriate access for the task.

A school project is successful when all participants understand how the final calculation was produced.

Excel Versus Google Sheets for Students

Google Sheets for Students supports many similar tasks: tables, calculations, charts and collaboration. Excel adds its own established desktop and web workflows, table features and advanced data tools.

A student does not need to declare one product universally superior. The school may require a particular format, or the project may depend on a feature available in one environment.

For a small class survey, either can provide useful analysis. For a complex workbook, compatibility, formulas, macros, institutional policies and version-specific features may affect the decision.

Do not assume formulas or charts convert perfectly between programmes. After importing or exporting a file, check the data types, formulas and displayed results.

The conceptual skills—identify the quantity, calculate accurately and interpret honestly—should transfer between spreadsheet platforms.

A Twenty-Minute Beginner Excel Routine

A short practical exercise should leave time for thought instead of spending the whole session searching menus.

Minutes 1–4: Define the question and create clearly labelled columns.
Minutes 5–8: Enter a small set of valid numerical observations, checking formats and units.
Minutes 9–12: Write one relevant formula and verify the result independently.
Minutes 13–15: Create a simple chart or table summary.
Minutes 16–18: Investigate one possible error involving sort order, missing values or cell references.
Minutes 19–20: Explain the result and one limitation in the student’s own words.

This is a pedagogical routine, not a built-in Excel lesson. It can be extended for Secondary students working with real datasets or multiple conditions.

For a group of three, rotate calculation author, formula checker and result interpreter. A strong group project makes all three students capable of explaining the analysis.

The final work should survive a challenge such as, “What happens to the average if this reading changes?” The child should predict before letting Excel recalculate.

Frequently Asked Questions

Is Microsoft Excel free for students?

Web access, installed application features and school licensing can differ. Some accounts have browser-based use and schools may provide Microsoft 365 Education access. Confirm the actual entitlement rather than assume every pupil gets the same desktop version.

What does an Excel formula start with?

Formulas ordinarily begin with an equals sign. A calculation such as =A2*B2 multiplies the values in those cells.

How do I calculate an average?

A common formula is =AVERAGE(B2:B6). Verify that the range and the treatment of blanks, zeros and missing values match the question.

Why does 10 sometimes sort before 2?

The entries may be stored as text rather than numbers. Check data types and sort the full relevant records, not one disconnected column.

What is the difference between relative and absolute references?

Relative references usually adjust when copied to another cell. An absolute reference such as $B$1 is designed to stay fixed.

Can Excel create charts?

Yes. Use the chart tools after selecting relevant data, then check titles, axis values, labels, units and the honesty of the display.

Is Excel useful for PSLE Mathematics?

It can support permitted home exploration and data literacy. It does not replace mental calculations, word-problem reasoning, handwritten working or the conditions of the actual assessment.

Can Excel prove a correlation is causal?

No. Spreadsheets summarise and visualise data; causal conclusions depend on the study design, evidence, controls and assumptions.

Is Excel the same as Google Sheets?

They overlap substantially, but interfaces, features, version behaviour and sharing arrangements differ. Choose according to the school task and verify imported results.

Official Sources and eduKateSG Learning Routes

The lasting lesson: Excel makes calculations repeatable, but it cannot decide which question the student should ask. Accurate formulas, correct data types and carefully limited conclusions turn a spreadsheet into real mathematical learning.

Microsoft Excel for Students | Formulas, Tables, Charts and Data Reasoning