# Office for students: a survey report step by step, from Excel to Word

> **The short answer**: Office for students is free in its web version if your university email is eligible with Microsoft, and it includes Word, Excel and PowerPoint. The best way to learn it is one complete task: survey data in Excel, then a chart, then a report in Word, then a short deck.[^1]

**Key takeaways**

- Office 365 A1 for education gives students the web apps free with an eligible school email.[^1]
- Verification is often instant but can take up to a month at some institutions.[^1]
- Start with the data in Excel, move the chart into Word, build the deck from it.
- Use heading styles in Word so the table of contents builds itself.[^3]

![table, chart and report page](https://tiswa.app/assets/blog/office-for-students-survey-report/office-for-students-survey-report-cover-en.webp)

You have a report for a research-skills course: a survey of thirty classmates on weekly study hours, due in a week. You open Word and type the numbers into a table by hand, then lose an hour centring columns. The trouble is not time. It is order. The numbers belong in Excel, the chart belongs in Excel, and the report is only the place they sit.

> **tiswa's take**: Our view is that a real task teaches Office better than a tour of the menus. Three programs in one task show you where each piece starts and ends, which is more useful than memorising every button.

## How do students get Microsoft Office for free?

Microsoft says a student with an eligible school email can get Office 365 A1 at no cost, a plan it donates to eligible institutions. It includes the web versions of Outlook, Word, Excel, PowerPoint and OneNote.[^1] The full desktop apps need a paid plan, so ask your university whether it licenses them for you before you buy anything.[^1]

1. **Open Microsoft’s education page**: Go to the Office 365 Education page on Microsoft’s own site, not to a link that reached you in a message.[^1]
2. **Use your university email**: Enter the address your university gave you. If you do not know it, ask the IT deanship.
3. **Wait for verification**: Often it is instant; some institutions take longer, up to a month, according to Microsoft.[^1]
4. **Save files to OneDrive**: Keep a folder per course, because an education account can be re-verified. If the plan expires you can still view documents, not edit them.[^1]

![Four steps from data to slides](https://tiswa.app/assets/blog/office-for-students-survey-report/office-for-students-survey-report-inline-1-en.webp)


## How do you start a survey report in Excel?

The data here is a practice example, not real statistics. In Excel, make one column for the student (S1 to S30), one for weekly study hours and one for year of study. Keep the first row as headings and do not merge cells; merging breaks sorting and charts later.

1. **Enter the raw data**: Record what classmates answered exactly as given, without rounding. Cleaning comes after.
2. **Work out the average**: Type =AVERAGE(B2:B31) for the mean hours and =COUNTIF(C2:C31,"3") for the number of third-year students. These two are enough for a short report.
3. **Select the data and let Excel suggest a chart**: On the Insert tab choose Recommended Charts, preview the suggestions and pick the best fit. If none suits, open All Charts.[^2]
4. **Write a title that states the result**: Not “bar chart”. Write: average study hours are highest among final-year students, if that is what your data shows.

For more on charts see [Excel charts](https://tiswa.app/en/blog/excel-charts/), and for formulas [Excel formulas for students](https://tiswa.app/en/blog/excel-formulas/).

## How do you move the results into a tidy Word report?

Copy the chart from Excel and paste it into Word. Then write the report headings with the heading styles (Heading 1, Heading 2) on the Home tab instead of enlarging the font by hand. The table of contents is built from those styles, so you add it in two steps rather than typing it.[^3] A survey report needs at least: an introduction with the research question, how the data was collected and how many people took part, the results with the chart, a two-sentence interpretation, and a conclusion.

| Part | Where to do it | Common mistake |
|---|---|---|
| Numbers and averages | Excel | Typing them into Word and forgetting to update |
| Chart | Excel, then paste into Word | A chart with a title that says nothing |
| Contents and headings | Word heading styles | Hand-enlarged headings, so no contents list |
| Slides | PowerPoint | Pasting report paragraphs onto the slides |

![Checklist before submitting coursework](https://tiswa.app/assets/blog/office-for-students-survey-report/office-for-students-survey-report-inline-2-en.webp)


If an instructor will check the formatting closely, see the [table of contents in Word](https://tiswa.app/en/blog/word-table-of-contents/), [page numbering](https://tiswa.app/en/blog/word-page-numbering/) and [report table layout](https://tiswa.app/en/blog/word-report-table-layout/).

## What if my lecturer asks for Google Sheets instead of Excel?

It happens in some courses, especially group work edited by four students at once. Google Sheets runs in the browser and lets you share the file and choose who can view, comment or edit.[^4] The steps you learned here carry across: tidy columns, one row per answer, then a chart built from the table. Only the menu names differ.

A practical rule: give teammates comment access until merge time and keep edit access for yourself. That way nobody changes a figure in the survey file without you knowing. Download an xlsx copy before you submit, even if the lecturer asks for a link, because a link can stop working when someone’s university account is deleted.

## What mistake do most students make with Office?

They rely on one file and forget about copies. A student works a week on a file stored on the laptop, then the laptop fails before the deadline. Save to OneDrive from day one. The second mistake is exporting to PDF before teammates have reviewed it; we cover team review in [comments and track changes in Word](https://tiswa.app/en/blog/word-team-review-comments/). The third is opening a teammate’s file in a different version, and the tables shift. Agree on one version before you start.

## What is the best way to present the results in PowerPoint?

Six slides are enough for a survey report: title, research question, how the data was collected, two charts and the conclusion. A slide carries one sentence that says the point, not the report’s paragraph. For design and colour see [PowerPoint design tips](https://tiswa.app/en/blog/powerpoint-design-tips/). If you want an AI assistant to help summarise the results, read [Microsoft Copilot for students](https://tiswa.app/en/blog/microsoft-copilot-students/) first to learn its limits.

Before you buy any software or device for study, see what your university provides and what suppliers offer in [student deals](https://tiswa.app/en/deals/). [Browse student deals](https://tiswa.app/en/join/)

## Questions

### Is Microsoft Office free for students?

Yes in its web version, through Office 365 A1, if your school email is eligible with Microsoft. Full desktop apps need a paid plan or a licence from your university.[^1]

### How do I get Office with my university email?

Open the Office 365 Education page on Microsoft’s site, sign up with your university email and wait for verification, which is often instant.[^1]

### Which Office programs does a student need?

Word for reports, Excel for data and charts, PowerPoint for presentations and OneNote for notes.[^1]

### How long does Office student verification take?

Often it is instant, but some institutions take up to a month, according to Microsoft.[^1]

### What happens to my files if the plan expires?

You can still view them, but you cannot edit them or create new ones until your eligibility is renewed.[^1]

### How do I add a table of contents in Word?

Apply the Heading styles to your headings, open the References tab and choose Table of Contents.[^3]


## Sources

[^1]: Microsoft Education: Office 365 Education, https://www.microsoft.com/en-us/education/products/office
[^2]: Microsoft Support: Create a chart from start to finish, https://support.microsoft.com/en-us/office/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2
[^3]: Microsoft Support: Insert a table of contents, https://support.microsoft.com/en-us/office/insert-a-table-of-contents-882e8564-0edb-435e-84b5-1d8552ccf0c0
[^4]: Google Docs Editors Help: Get started with Google Sheets, https://support.google.com/docs/answer/6000292