Microsoft Office 365 User Training Excel and Forms Beginners
Training Delivery: Live Online Instructor Led & Classroom Face to Face
Course Duration: 1 Day
During this course you will:
Use Microsoft Forms to:
- Creating 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
Office 365 User Training - All you need to know.
Course Outline
Microsoft Forms and Excel User Training Beginners
Creating Forms
- Locating Microsoft Forms
- Creating a Form
- Naming a Form
- Pinning Forms
- Deleting Forms
Adding Form Components
- Choice
- Text
- Rating
- Date
- Ranking
- Likert
- File Upload
- Net Promoter
- Adding Pictures to a Form
Changing Form Options
- Changing the Form Theme
- Altering Form Settings
Sharing your Form
- Creating a Link to your Form
- Creating a QR (Quick Response) Code
- Putting your Form on Another Site
- Emailing your Form
Form Responses
- Handling Form Responses
- Sharing Form Responses
- Getting Form Results into Excel
- Collaborating with Others
Creating a Quiz
- Handling Correct and Incorrect Answers
- Scoring
Adding Branching
- Create a Basic Branching Structure
- Adding Sections
- Using Branching in Standard Forms
- Incorporating Branching in Quizzes
Microsoft Excel
Creating Forms Linked to Excel
- How to Create a Form that is Linked to an Excel Spreadsheet?
- How to save Excel Linked Forms?
Tables
- Creating Tables
- Sorting Tables
- Filtering Tables
- Creating Table Formulas
Formulas
- VLOOKUP and XLOOKUP
- IF
- SUMIF
Basic Pivot Tables
- Create Pivot Tables from Tables
- Basic Pivot Table Navigation
- Restructuring Pivot Tables
- Changing Pivot Table Styles
- Pivot Table Conditional Formatting
Pivot Charts
- Creating Pivot Charts
- Formatting Pivot Charts
- Bar Chart
- Column Chart
- Pie Chart
- Doughnut Chart
Pivot Table Features
- Using Slicers and Timelines
- Seeing Values as a Percentage
- Changing Summarisation Calculations
- Formatting Pivot Tables
- Refreshing Pivot Tables
- Auto Refresh Pivot Tables
Using Forms and Excel Together
- Creating a Form that links to Excel
- Storing an Excel Linked Form
- Changing the Location and Name of the Excel File
Please note this course is available for private booking on a date convenient for you.
