ADEAcademy of
Design Excellence
Explore
Explore ADE
Discover the wider ADE ecosystem beyond courses.
About ADE→

Who we are, why ADE exists and where the ecosystem is heading.

ADE for Business→

Talent, team capability and business collaboration through ADE.

Community→

Connect with learners, professionals, instructors and collaborators.

Events→

Workshops, conversations, showcases and live ADE experiences.

Insights / Articles→

Practical ideas across technology, careers, business and learning.

YouTube & Media→

Videos, interviews, explainers, sessions and stories from ADE.

Partnerships→

Build programs, experiences and shared opportunities with ADE.

Success Stories→

See the people, projects and progress behind real outcomes.

Careers→

Explore ways to help build the next version of ADE.

What’s New→

New launches, platform updates, programs and announcements.

Not sure where to start?Open finder →
Learn
ADE Learn
Choose the learning format that fits your goal, time and stage.
All Courses→

Browse every published ADE course, program and learning experience.

Career Programs→

Deeper programs designed to build career-ready capability and proof.

Work
ADE Work
Find opportunities where skills, projects and proof can move you forward.
All Opportunities→

Browse every open job, internship, freelance role and project on ADE Work.

Full-time Jobs→

Career opportunities for professionals ready to apply verified capability.

Showcase
ADE Showcase
Explore projects and portfolios that make practical capability visible.
All Showcase→

Browse public projects, portfolios, case work and evidence from the ADE community.

Projects→

Focused pieces of work showing the problem, approach, outcome and skills used.

Resources
ADE Resources
Useful tools, trusted recommendations and practical guidance for everyday work and growth.
Tools→

Useful day-to-day utilities for documents, careers, productivity and practical work.

Software & Services→

Curated software and services, including future affiliate-supported recommendations.

Business
ADE for Business
Hire, develop and understand talent through capability, evidence and opportunity.
Overview→

See how ADE connects talent, learning, evidence and opportunity for organizations.

Hire Talent→

Discover people through projects, skills, credentials and public evidence.

ExploreLearnWorkShowcaseResourcesBusiness
Advanced Excel & Business Analysis course
Data & Analytics • Intermediate to Advanced

Advanced Excel & Business Analysis

Use advanced formulas, Power Query, modelling and dashboard techniques for business analysis.

18 estimated hours6 modules12 lessonsGraded ADE certificate
ENROLLMENT
Start with one ADE identity

Sign in before enrollment so progress, graded assessments and credentials remain connected to you.

Sign in to enroll
CURRICULUM

Sequential learning structure

Each lesson unlocks only after the previous required step is completed. Module assessments are gates: a failed checkpoint or capstone keeps the following module locked until the pass mark is achieved.

01
Dynamic formula engineering
Use modern Excel formulas to create flexible analytical outputs.
Use dynamic arraysReduce repeated logic with LETUnderstand reusable formula design
Dynamic arrays for analytical outputs50 min
Readable formulas with LET and reusable logic50 min
02
Advanced lookups and criteria
Solve multi-condition retrieval and aggregation problems.
ADE INDIVIDUAL PLANS
Free. Standard. Pro.

Start at $0, step up to Standard for higher usage, or unlock ADE Full Access with Pro.

Compare plans →
ADE

Learn. Build. Prove. Grow. A skills-to-opportunity ecosystem built around practical learning and trusted evidence.

PLATFORM
ExploreLearningShowcaseADE PassportPlans & Pricing
OPPORTUNITY
ADE WorkBusinessPartnersVerify credential
ACCOUNT
WorkspaceMy planSettingsNotificationsSecurity
ADE V2 beta review build • Subscription catalogue live • Payments disabled during testing
Short Courses→

Focused learning for a specific skill, tool or practical outcome.

Free Learning→

Open sessions and accessible learning experiences to start exploring.

Upcoming Workshops→

Live workshops, masterclasses and hands-on learning sessions.

Certifications→

Assessment-led routes that can lead to recognized ADE credentials.

Learning Paths→

Structured sequences that connect related skills into a clear progression.

Browse by subject, format and level.Open finder →
Internships→

Early-career opportunities to build experience, evidence and industry context.

Freelance & Contract→

Flexible client work, contract roles and independent assignments.

Projects & Gigs→

Short applied projects where practical skills matter more than job titles.

Remote Opportunities→

Roles and projects designed for remote or location-flexible work.

Entry-Level Opportunities→

Roles designed for emerging talent with strong evidence and potential.

Browse by role type, field and work mode.Open finder →
Portfolios→

Collections of selected work that show range, craft and professional identity.

Verified Work→

Projects with an active ADE verification record attached to the evidence.

Featured Work→

High-signal work surfaced for quality, evidence and practical relevance.

Student Work→

Projects and portfolios from learners building their first body of evidence.

Professional Work→

Public work from practicing professionals across the ADE ecosystem.

Browse by work type, field and evidence.Open finder →
Guides→

Practical ADE guides, checklists and templates for skills, projects, careers and business.

Tools for doing. Guidance for deciding.Explore resources →
Post Opportunities→

Publish jobs, internships, freelance work and project opportunities.

Train Your Team→

Build workforce capability through courses, workshops and custom learning.

Verify Skills→

Use evidence-aware assessment and verification to understand demonstrated capability.

Business Solutions→

Combine talent, learning and verification into a solution for your organization.

Partnerships→

Collaborate with ADE on programs, events, technology, community and talent initiatives.

Business Workspace→

Manage your organization, opportunities and applicants in the ADE workspace.

Build a stronger talent and capability system with ADE.Open workspace →
Build multi-criteria lookups
Use INDEX and MATCH patterns
Handle missing matches deliberately
Multi-criteria lookup patterns55 min
Advanced conditional aggregation50 min
03
Power Query transformation
Create repeatable import and data preparation pipelines.
Profile imported dataApply reproducible transformationsMerge and append queries
Power Query import and profiling55 min
Merge, append and reshape data60 min
04
Business modelling and scenarios
Model assumptions, targets and alternative business outcomes.
Use Goal Seek and scenariosSeparate assumptions from outputsBuild sensitivity-aware models
Scenario analysis and Goal Seek55 min
Build auditable business models55 min
05
Executive dashboard engineering
Build interactive reports that remain maintainable as data grows.
Design KPI layoutsUse PivotTables and slicers effectivelyImprove workbook performance and auditability
Interactive executive dashboards60 min
Performance, audit and maintainability50 min
06
Executive analysis capstone
Deliver an executive workbook with transformations, analysis and recommendations.
Integrate multiple techniquesDocument assumptionsPresent decision-ready findings
Capstone brief: executive analysis workbook45 min
Present recommendations with evidence40 min
CERTIFICATE GRADING

Your result is not just “completed”.

Checkpoint scores and the reviewed capstone produce a weighted final result. The certificate displays both the grade and classification.

A+ · High Distinction95–100%
A · Distinction90–94%
B+ · High Merit85–89%
B · Merit80–84%
C+ · Credit75–79%
C · Pass70–74%
Below 70% is not eligible for the course certificate. A failed gated assessment must be passed before progression.
ADE PROOF

How learning becomes evidence

Learning progress is attached to your ADE identity
Assessment attempts retain scored or reviewed outcomes
Applied work contributes to the course result
The certificate records final score, grade and classification
Professional ADE Skill Verification remains a separate, stronger process
INSTRUCTORS

Instructor assignments will appear here when academic operations connects the course to faculty records.