Intermediate Excel Video Course

Learn to Work Smart with Excel: Advanced Functions, Filters and Search with the Learning365® and Mr Key Shop Course

The Intermediate Excel Video Course by Learning365®, available exclusively on Mr Key Shop, is designed for those who want to take their use of Microsoft Excel to the next level. The course is compatible with Microsoft Excel in Microsoft 365 and Office from version 2019 onwards, and will help you develop essential skills for analysing data, filtering complex lists, using logical functions and combining formulas to achieve accurate and professional results.

Who is Learning365®?

Learning365® is the ideal training solution for those who want to master all aspects of Microsoft Excel: basic, intermediate, advanced, formulas, functions and power tools for data analysis. All courses are available on demand, with unlimited access and divided into short videos for easy and continuous viewing. Each course is accompanied by an optional AI Smart Tutor, which provides explanations and targeted examples during the lesson. The platform also includes a comprehensive monitoring dashboard, which allows you to view individual or group training progress and generate detailed reports on the activities carried out.

Objective of the Intermediate Excel Course

The course aims to teach you how to use Excel's intermediate functions in a knowledgeable and flexible way. By the end of the course, you will be able to:

• Use advanced formulas for sum, average, minimum and maximum
• Perform calculations with dates and times
• Sort and filter complex lists with custom criteria
• Combine functions such as FILTER, RIGHT, INDEX, COMPARE
• Manage text and data in columns, merge strings and transform content
• Apply logical and conditional functions for dynamic analysis
• Use VLOOKUP, HLOOKUP, DROP and XLOOKUP

How the Intermediate Excel course is organised

The course is divided into 30 video lessons for a total duration of 3 hours and 50 minutes. Each lesson is a short training video, full of practical examples and guided exercises. The course also includes a collection of over 40 downloadable Excel templates so you can start practising right away.

Main modules:

• Automatic sum: calculations on cells, ranges, averages and conditions
• Dates and times: time calculations and management of minutes and seconds
• Sorting and filters: complex, customised criteria, FILTER function with variables
• Text management: column splitting, extraction, concatenation
• Logical functions: IF, AND, OR, IF.ERROR, IF.NOT.DISP
• Search functions: VLOOKUP, INDEX, MATCH, DROP

At the end of the course, you will take a final quiz with 10 questions and receive your certificate of completion.

Who is this course for?

This course is suitable for:

• Company or public administration employees who work with Excel on a daily basis
• Those who have been using Excel for some time but want to learn more about intermediate functions
• Those looking for useful training to retrain or certify their skills
• Teams that want to optimise their Excel workflows

Final Certificate

At the end of the final quiz, you will receive a Learning365® personalised certificate, which is useful for updating your CV, demonstrating your skills or adding to your company or public training portfolio.

Support

If you have any questions or needs, you can contact the free support service in Italian provided directly by Learning365®. The course can be purchased securely on the official Learning365® platform, with immediate activation.

Educational support with the AI Intelligent Tutor

During the training course, you can activate the AI Intelligent Tutor: a virtual assistant that answers your questions in real time. It is ideal for receiving practical examples, explanations of functions and clarifications on the course content.