Microsoft 365 User Training Excel and Forms Beginners Hammersmith

Hammersmith Beginners Microsoft 365 User Excel and Forms Overview

If you're wanting to book your Microsoft 365 User Training Excel and Forms and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft 365 User Training Excel and Forms then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft 365 User Training Excel and Forms Beginners training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

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

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