Access courses

Excel Intermediate Course

Preview certificate

What will I learn?

Take your Business Intelligence skills to the next level with our Excel Intermediate Course, tailored for professionals looking to wield the power of Excel for making informed decisions based on data. Get to grips with vital functions like INDEX, MATCH, SUMIF, and AVERAGEIF for spot-on data analysis. Improve your data visualisation skills with effective charts and conditional formatting. Make your workflow more efficient by getting the hang of advanced features such as pivot tables, multiple worksheets, and named ranges. Turn raw data into insights you can act on and drive business success.

Apoia's Advantages

Online and lifetime access to courses
Certificate aligned with educational standards
Printable PDF summaries
Online support always available
Select and arrange the chapters you'd like to study
Set your own course workload
Instant feedback on practical activities
Study at your convenience, no internet required

Develop skills

Strengthen the development of the practical skills listed below

Master data lookup using INDEX and MATCH for accurate analysis.

Design impactful charts and graphs for clear data visualisation.

Clean and prepare data efficiently using text functions.

Analyse sales data to pull out actionable business insights.

Create and customise pivot tables for comprehensive summaries.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can change the chapters and the workload.

  • Choose which chapter to start with
  • Add or remove chapters
  • Increase or decrease the course workload

Examples of chapters you can add

You will be able to generate more chapters like the examples below

This is a free course, focused on personal and professional development. It is not equivalent to a technical, undergraduate, or postgraduate course, but offers practical and relevant knowledge for your professional journey.