Microsoft Excel 365 Training Course Guildford Intermediate

Microsoft Excel 365 Training Course Intermediate Guildford Surrey

The town of Guildford in Surrey is known for a fantastic shopping experience. Of course with the Guildford business park and easy access to two popular airports in Heathrow and Gatwick. Your Intermediate Microsoft Excel 365 Training Course training course in Guildford Surrey can be conducted at your premises, where we can bring laptops with the Microsoft Excel 365 Training Course already loaded. We can even bring a projector along with power extension leads, leaving you to concentrate on learning.

Conducting Microsoft Excel 365 Training Course training courses in Surrey is a relatively new venture for us so please try us out and remember to tell us and others what you think.

Excel Training Course Guildford Intermediate Overview

By using Excel 365 along with it's new features, everyone attending this course will have greater confidence in using Excel features that are definitely beyond the basics.

This intermediate Excel 365 course covers a range of advanced functions including VLOOKUP, along with the XLOOKUP function, text, date and time, and logical functions. These functions allow you to search for and retrieve data from other parts of the worksheet or from other worksheets or workbooks. Also, Text functions, such as CONCATENATE and LEFT, MID, and RIGHT, can be used to combine and extract text from cells.

In addition to these functions, the course will also cover pivot tables, which are a powerful tool for summarising and analysing large amounts of data. Pivot tables allow users to rearrange and filter data, and generate summary reports. Pivot tables can be especially useful for quickly identifying trends and patterns in data.

What You'll Learn in this Excel 365 Intermediate Training Course

• Master Lookup, Text, and Date functions, including new array functions
• Develop skills in creating and customising Pivot Tables and Pivot Charts
• Learn to use Data Validation for enhanced data entry control
• Apply Conditional Formatting to visualise data dynamically

See how we roll with a free Leap Year in Excel online lesson.

Length of Course: 1 Day

Other Related Courses

• Microsoft Excel 365 Training Course Beginners
• Microsoft Excel 365 Training Course Advanced
• Microsoft Excel Power BI Training Course Beginners

Browse all of our Excel Training Courses.

Post-Course Resources

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

Microsoft Excel training is available in person and online.

All you need to know about our Live Online Training.