Access courses

Excel Intermediate Course

What will I learn?

Improve your Business Intelligence skills with our Excel Intermediate Course, specifically designed for Eritrean professionals looking to effectively use Excel for making smart decisions based on data. Learn important functions like INDEX, MATCH, SUMIF, and AVERAGEIF for accurate data analysis. Make your data visualizations better with useful charts and conditional formatting. Simplify your work by learning advanced features such as pivot tables, managing multiple worksheets, and using named ranges. Turn basic data into useful information to help your business succeed.

Apoia's Unique Features

Unlimited access to courses for life
Certification aligned with educational standards
Printable PDF summaries
Always-available online support
Select and arrange the chapters you want to study
Customize your course workload
Instant feedback on practical activities
Study at your convenience, no internet required

Develop skills

Enhance your practical skills outlined below

Become proficient in data lookup using INDEX and MATCH for accurate analysis.

Design charts and graphs that clearly display data for better understanding.

Efficiently clean and prepare data using text functions.

Analyze sales data to find useful business insights.

Create and customize pivot tables for thorough summaries.

Suggested summary

Workload: between 4 and 360 hours

Before starting, you can change chapters and 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.