Excel for Business Analytics
Formulas, lookups, PivotTables and clean data — the spreadsheet skills every office role assumes.
Certifies the Excel competence employers expect from analysts, finance, operations and MBA hires: relative and absolute references, conditional formulas, XLOOKUP and INDEX/MATCH, PivotTables and Tables, cleaning messy data, dynamic arrays and clear reporting.
What it measures
Formulas & Functions
References, SUMIFS/COUNTIF, IF logic, IFERROR and TEXT.
Lookup & Reference
XLOOKUP, VLOOKUP, INDEX/MATCH and lookup errors.
PivotTables & Tables
Summarising, value settings, refresh and structured tables.
Data Cleaning
TRIM, UNIQUE, splitting text, numbers stored as text and validation.
Reporting & Dynamic Arrays
Combo charts, conditional formatting and FILTER.
Who it's for
- Commerce, BBA and MBA students
- Analysts and operations, finance and HR staff
- Anyone who lists 'Advanced Excel' on a CV
How the test works
- 20 questions drawn at random from a larger bank, balanced across every skill area above.
- Answer options are shuffled for each candidate, and the timer keeps running once you start.
- Your answers save automatically. If your connection drops, reopen your link to continue.
- Score 70% or more to earn a verifiable ARISE certificate. You get 2 attempts.
Try a sample question
Cells A1:A3 contain 2, 4 and 6. What does =SUM(A1:A3) return?