Microsoft 365 User Training Excel and Forms - Beginners Training in Reading

Reading Beginners Microsoft 365 User Excel and Forms Overview

Reading is a convenient location for businesses looking for practical, instructor-led Microsoft 365 User Training Excel and Forms training. We can deliver the course either at your premises or at a local venue, depending on what works best for your team.

This location is well suited to Microsoft 365 collaboration training, where delegates benefit from practical guidance on communication, file sharing and team-based workflows.

200 Brook Drive
Green Park
Reading
RG2 6UB

The Green Park venue gives delegates space to concentrate fully on the course. It works well for organisations that want structured training which can be applied quickly across everyday workplace systems.

If you would rather keep the training in-house, we can usually bring the equipment needed for the session, including laptops and a projector where required. It suits teams looking to improve collaboration, consistency and confidence across Microsoft 365 tools.

If you are exploring other options as well, you can also view our computer training courses in Reading.

Microsoft 365 User Training Excel and Forms training for Reading teams

We can deliver Microsoft 365 User Training Excel and Forms Beginners training for organisations in Reading and nearby areas such as Wokingham, Bracknell, Maidenhead, Newbury, Basingstoke and Berkshire. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Reading venue at Green Park gives delegates space to concentrate and is a practical option for Berkshire teams that want a local training setting.

Local training use cases

Microsoft 365 User Training Excel and Forms training in Reading is useful for teams who want skills they can apply quickly in real work. This location is well suited to Microsoft 365 collaboration training, where delegates benefit from practical guidance on communication, file sharing and team-based workflows. It works well for organisations that want structured training which can be applied quickly across everyday workplace systems. It suits teams looking to improve collaboration, consistency and confidence across Microsoft 365 tools.

Reading is a strong setting for Microsoft 365 User Training Excel and Forms Beginners training. This location is well suited to Microsoft 365 collaboration training, where delegates benefit from practical guidance on communication, file sharing and team-based workflows. It suits teams looking to improve collaboration, consistency and confidence across Microsoft 365 tools.

This Office 365 user training in Excel and Forms you will see the full potential of using MS Forms in conjunction with Microsoft Excel. Basically harnessing the power of Microsoft Forms and Excel.

It used to be, that to create an online form it would require a lot of coding, you would have to develop new databases. Now with Microsoft Forms you can create forms simply and quickly.

In this course you will gain the skills needed to successfully create professional forms, quizzes and polls. you will also take an in-depth look into some of the most popular Excel formulas and functions. You will then learn how to use them together. Take your Office skills to the next level with this Forms and Excel Course.

What You'll Learn

Use Microsoft Forms to:

• Create a Form
• Add Form Components
• Change Form Options
• Share your Form
• Handle Form Responses

Use Microsoft Excel to:

• Generate Pivot Charts & Tables
• Use VLOOKUP, XLOOKUP, IF and SUMIF Functions

Link Forms with Excel

• Create and Store a Form that links in Real Time to Excel

Part of our Office 365 Pick and Mix training course series.

Course Duration: 1 Days

Course Prerequisites for your training in Reading

This course is suitable for new or experienced Office users who are looking to gain a comprehensive understanding of common Office 365 Apps.

This course is suitable for Microsoft 365 users with a basic Excel knowledge. Delegates attending this course should

• Be familiar with navigating and editing Excel spreadsheets
• Have experience with simple formulas and functions like SUM and AVERAGE

Complete Course Outline

Microsoft Forms

Getting Started

• Locating Microsoft Forms
• Creating and naming forms with components such as choice, text, ratings, and file uploads

Customising Forms

• Changing form themes and settings
• Adding images, videos, and other multimedia

Sharing and Managing Forms

• Creating links, QR codes, or embedding forms on websites
• Exporting form responses to Excel for analysis

Advanced Features

• Building quizzes with branching logic
• Collaborating on form results

Microsoft Excel

Tables

• Creating, sorting, and filtering tables
• Applying table formulas

Formulas

• Using VLOOKUP, XLOOKUP, IF, and SUMIF for data analysis

Basic PivotTables

• Creating and navigating PivotTables
• Restructuring and formatting PivotTables

PivotCharts

• Building and customising bar, column, pie, and doughnut charts

PivotTable Features

• Using slicers, timelines, and percentage views
• Setting up auto-refresh for dynamic data

Using Forms and Excel Together

• Linking Forms to Excel
• Creating forms linked to Excel in real time
• Storing and managing linked forms

Other Related Courses

Learn Microsoft Copilot for Business Copilot 365 App and Free Voice Chat Beginners

Microsoft Office 365 Training Teams and PowerPoint Beginners

Microsoft Office 365 Training Teams and Forms Beginners

Microsoft Office 365 Training Sway and Teams Beginners

Microsoft Office 365 Training Power BI and Teams Beginners

Microsoft Office 365 Training Planner and Teams Beginners

Microsoft Office 365 Training Outlook and Teams Beginners

Microsoft Office 365 Training OneNote and Teams Beginners

Microsoft Office 365 Training OneDrive for Business and Teams Beginners

Microsoft Office 365 Training Forms Stream and Sway Beginners

Microsoft Office 365 Training Forms and OneDrive for Business Beginners

Microsoft Office 365 Training Forms and Sway Beginners

Microsoft Office 365 OneDrive Delve Yammer Planner and SharePoint Training Course

Microsoft SharePoint 365 Training Course Beginners

Post-Course Resources

• Training notes & exercise files
• Online materials: video tutorials & shortcuts
• 3 months post training support

Helpful Links for Reading Learners

• View the main Microsoft 365 User Training Excel and Forms Beginners course page
• Browse all computer training courses in Reading
• See this course in other training locations

Location FAQs for Reading

Computer Tutoring Training Centres

We can also arrange instructor-led training from these Computer Tutoring training centres.