Microsoft Excel Intermediate Training (Instructor-led)

This one day Excel Intermediate course is designed to help participants develop their Excel skills beyond the basic level. This hands-on training will teach you how to use intermediate-level functions and tools, such as Protecting cells, IF functions, VLOOKUP and HLOOKUP more effectively.

You will learn how to streamline your workflow, increase productivity, and create more complex and sophisticated spreadsheets. Our experienced trainers will guide you through the course and provide practical examples and exercises to reinforce your learning. By the end of the training, you will have gained the skills and confidence to apply your Excel knowledge to real-world situations.

Our Intermediate Training is designed to help participants enhance their Excel skills beyond the basic level. Throughout the course, you will explore the following topics:

• Use advanced formulas and functions to manipulate data and perform calculations more efficiently.
• Define names for individual cells and ranges, and work with database tools in Excel to sort, filter, and customise data.
• Protect cells and link workbooks and applications (Excel with Word or PowerPoint).
• Format large spreadsheets effectively by hiding columns, grouping columns and rows, and applying conditional number formatting.

Throughout the course, participants will cover a range of topics including:

• Functions: IF functions, VLOOKUP and HLOOKUP, functions to combine data from multiple cells, data functions, and nested functions.
• Tools: Naming cells and ranges, protecting cells, linking workbooks, and linking applications (Excel with Word or PowerPoint).
• Database tools: Sorting data in ascending, descending, left to right, and in custom sequences, filtering data with AutoFilter, creating customised and advanced filters, using data forms to enter, delete and search for data, and using subtotals to calculate subsets of data.
• Formatting: Hiding columns, rows and formulas, grouping columns and rows, and applying conditional number formatting.

Upon completion, participants will have a strong foundation in Excel Intermediate skills and be able to apply them to their work.

Our Excel Intermediate course is a great course for individuals that have the basic knowledge of Excel and can navigate around spreadsheets but would benefit from learning functions and tools such as IF Statements and VLOOKUPS to help them in their roles.

This training course is recommended for individuals that are looking to improve their knowledge and skill level when using Excel. The skills learned will help the delegates be more effective and efficient in their roles.

This course is designed for participants who have completed the Excel Level 1 course or have equivalent knowledge.

Participants should already be able to create formulas, use basic functions such as SUM, MIN, MAX and COUNT and also be aware of the difference between relative and absolute references.

Completing our Excel Intermediate course builds upon your foundational Excel skills and can lead to career advancement opportunities. Excel proficiency is a valuable skill in today's job market, and our course provides you with the skills to take your Excel proficiency to the next level.

Certificate of completion

Hard copy certificate - Included