MS Excel (Intermediate)

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.

This Excel 365 intermediate training course will teach you the following:

• Using Lookup, Text, and Date functions along with the new array functions
• Pivot Tables and Pivot Charts
• Data Validation
• Conditional Formatting

Finally, this Excel 365 training course will give you a chance to dip your toe into the world of conditional formatting. That's right! This Excel 365 training course will show you how to change the colour of a single cell or an entire row depending on the data.

At the End of the Course

• Each student will receive:
• Comprehensive training notes coupled with exercise files they can use at their leisure
• Access to online training materials including Video Tutorials and Keyboard shortcuts
• 3 months of post training support which includes email, phone and screen sharing assistance