Event box

Use Excel to work with data from a survey (MS Forms)

Use Excel to work with data from a survey (MS Forms) Online

Excel is software included in your DMU MS365 package for creating spreadsheets. These are documents where you can add data in rows and columns to analyze, calculate, apply formulas and algorithms, create tables of data, and generate diagrams and graphs. 

Excel is properly one of the most-used software programs in the business world and an application that will be very helpful in your studies. 

What will be covered:

  • What are cells? Why are rows and columns important in Excel.
  • How to extract data from a survey made in MS Forms.
  • How to create format a table of data in Excel and add to a Word document.
  • How to generate a chart/diagram from a table of data (and add to a Word document)

In session exercises:

  • Extract data from MS Forms
  • Filter, analyse and present data

Figure 1: Example of data collated in MS Forms

Related LibGuide: MS365 Office by Jina Ali

Date:
Wednesday, 11th November 2020
Time:
14:30 - 15:45
Time Zone:
UK, Ireland, Lisbon Time (change)
Online:
This is an online event. Event URL will be sent via registration email.
Audience:
  Student Session  
Categories:
  Intermediate workshops     MS365/Office > Excel     MS365/Office > MS Forms     MS365/Office  
Registration has closed.
Browse/Search for more events

Event Organizer

Profile photo of Jina Ali
Jina Ali

Digital Partner & Assistive Technology Officer.

MS365 Office, Digital Skills, Assistive Software and Learning Technologies support.

LLS Digital Partners
DE MONTFORT UNIVERSITY
Kimberlin Library
Leicester LE1 9BH

Profile photo of Digital Partners LLS
Digital Partners LLS

Digital Partner, Assistive Technology and E-Learning.

MS Office 365, Assistive Software and Learning Technologies support.

LLS Digital Partner
DE MONTFORT UNIVERSITY
Kimberlin Library
Leicester LE1 9BH