AXIORA | LEARN
AXIORA WorldAXIORA AIAXIORA LifeAXIORA LearnAXIORA MarketplaceANEARST

Advanced Excel: Job-Ready Skills

Use lookup, logic, summaries and error checks for practical analysis

Version 1.0.0 · about 120 min · 6 lessons

A practical AXIORA Learn course for excel users who already know basic formulas. It teaches six applied skills through examples, practice, knowledge checks, module assessments and a final assessment.

This course is not open for enrollment.

Work with Structured Data beginner

Apply the methods in work with structured data to realistic work.

  1. Work with Structured Data
    1. Use Excel Tables and structured references 18 min · required
    2. Clean text and category inconsistencies 18 min · required
    3. Assessment: Work with Structured Data assessment

Lookup and Summarise intermediate

Apply the methods in lookup and summarise to realistic work.

  1. Lookup and Summarise
    1. Use reliable lookup logic 18 min · required
    2. Use SUMIFS and COUNTIFS 18 min · required
    3. Assessment: Lookup and Summarise assessment

Summarise and Audit intermediate

Apply the methods in summarise and audit to realistic work.

  1. Summarise and Audit
    1. Build a PivotTable 18 min · required
    2. Audit formulas and errors 18 min · required
    3. Assessment: Summarise and Audit assessment

Final assessment

Final assessment

AXIORA Learn is a product of AXIORA GLOBAL SYSTEMS PRIVATE LIMITED.