Access courses

Excel And Advanced Excel Course

Preview certificate

What will I learn?

Master Excel and Advanced Excel skills designed for Business Intelligence professionals with our full course. Get stuck in to advanced functions like IF and VLOOKUP, improve how good your data is with validation rules, and make importing and cleaning data easier. Look at sales data by product and region, find out what's trending, and show your findings clearly with conditional formatting and pivot tables. Make your reporting even better by creating insights that can be acted on and finding products and regions that are doing well. Sign up now to change your data analysis skills.

Apoia's Unique Features

Online course with lifetime access
Certificate aligned with educational standards
Printable PDF summaries
Online support always available
Select and arrange the chapters you wish to study
Customize your course workload
Instant feedback on practical activities
Study anytime, no internet connection required

Develop skills

Enhance the growth of the practical skills listed below

Master advanced Excel functions to sort data properly.

Put in place data validation to make sure things are correct and consistent.

Use VLOOKUP to find and analyse data accurately.

Create useful pivot tables to summarise data.

Design visuals that have an impact to show sales trends clearly.

Suggested summary

Workload: between 4 and 360 hours

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

  • Select which chapter to commence with
  • Add or remove chapters
  • Increase or decrease the course workload

Examples of chapters you can include

You’ll be able to generate additional chapters similar to the examples below

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