Advanced Excel Video Course

Advanced Excel: Learn Strategies, Automation, and Data Analysis with the Professional Course from Learning365® in partnership with Mr Key Shop

The Advanced Excel Video Course by Learning365®, available on Mr Key Shop, is the complete training course for those who want to master Excel at an advanced level. With 55 video lessons totaling over 7 hours, this course guides you beyond simple formulas to teach you how to solve real problems, create automations, and manage complex data analysis with efficiency and awareness.

About Learning365®

Learning365® is the perfect choice for organizations that want to improve the digital skills of their staff, with courses accessible on demand on essential applications such as Excel, Word, Access, and PowerPoint. Each lesson is structured in a clear and practical video format, with real examples and use cases. Learning is supported by the optional AI Smart Tutor, available during the course to answer technical and operational questions. The platform also includes a monitoring dashboard that allows managers to track each user's progress and evaluate the effectiveness of the courses taken.

Objective of the Advanced Excel Course

The course is designed for those who already use Excel and want to acquire advanced skills in data analysis, automation, macros, pivot tables, and data protection. You will learn how to:

• Use financial and analysis functions
• Create and customize all types of charts (including interactive and 3D)
• Manage complex data, structure reports, filter, sort, and import data
• Use pivot tables in an advanced way
• Record and manage macros, automating repetitive tasks
• Protect sheets, folders, and cells with passwords and specific criteria
• Create templates and simulation scenarios

How the Advanced Excel course is organized

The course consists of 55 video lessons totaling 7 hours, divided into short training videos lasting a few minutes, each covering a single topic or advanced function. The course also includes over 40 Excel templates to download for practice. The main topics are:

• Financial functions: amortization schedules, rate and installment calculations
• Advanced charts: histograms, lines, pie charts, radar charts, 3D maps, sparklines
• Data analysis: conditional formulas, scenarios, forecasts, and advanced functions
• Tables and Pivot: summaries from multiple sheets, complex sorting, pivot charts
• Macros and automation: macro recording, buttons, custom saves
• Protection and security: restricted access, cloud management, local protections

The course includes intermediate quizzes and a final test with 10 questions to check your knowledge. The training dashboard allows you to track your progress or that of your team, with the option to export data for business reports.

Who is this course for?

This course is designed for:

• Company teams or public administrations that use Excel for reporting, analysis, and data management
• Professionals who want to retrain with a marketable certification
• Users who already know Excel and want to exploit its full potential
• Those who work with large amounts of data and want to speed up their operations

Final certificate

Once you have passed the final quiz, you will receive a personal certificate issued by Learning365®, applicable for your CV, internal company training, or reporting to public authorities.

Assistance

Technical and educational support is available in English and provided directly by the Learning365® team. The purchase of the course is secure and is completed directly on the official Learning365® platform.

Teaching support with the Intelligent AI Tutor

Throughout the course, you can activate the Intelligent AI Tutor, which allows you to ask contextual questions while studying and receive personalized, up-to-date answers. Ideal for immediate clarification and further information.