Access courses

Basic to Advanced Excel Course

What will I learn?

Level up your Business Intelligence skills with our Basic to Advanced Excel Course. Learn the most important Excel formulas and functions, including logical and lookup functions, to make managing your data easier. Learn how to deal with missing data, importing techniques, and methods to clean your data. Improve your analysis with pivot tables, filtering, and calculating key metrics. Explore forecasting with trendlines and scenario analysis. Get useful insights through analytical reports and data visualisation, using line, bar, and column charts. Turn data into actionable insights efficiently, lah!

Apoia's Unique Benefits

Online course with lifetime access
Certificate aligned with educational standards
Printable PDF summaries
24/7 online support
Select and organise the chapters you want to study
Customise your course workload
Instant feedback on practical activities
Study anytime, no internet required

Build skills

Enhance your practical skills in the areas listed below

Master Excel formulas: Become better at data analysis with logical and lookup functions.

Efficient data management: Clean, import, and deal with missing data like a pro.

Advanced data analysis: Use pivot tables and calculate important numbers effectively.

Forecasting skills: Use trendlines and scenario analysis to predict future outcomes.

Data visualisation expertise: Create and customise impactful charts and reports, can or not?

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 it offers practical and relevant knowledge for your professional journey.