The ability to enter, calculate, analyze, and visualize data using spreadsheets. Spans from simple record-keeping to designing automated data models.
Excel is the most widely used tool for working with tabular data. You start with number entry and basic totals, then automate repetitive calculations with formulas and functions, and uncover patterns through Pivot Tables and charts. At higher levels, you automate workflows with macros and VBA, and integrate multiple data sources through Power Query and data models. The growth path runs clearly from personal productivity all the way to organization-wide data governance.
You type text and numbers into cells and adjust basic formatting like column widths, fonts, and borders. You use foundational functions like SUM, AVERAGE, and COUNT for simple calculations. This is the stage where you learn file management basics: saving workbooks and setting print areas.
What Comes Next
If you've checked off most of this list, you're ready to enter the Formula User stage, where you'll start working with cell references and conditional functions for dynamic calculations. According to the ICAEW Spreadsheet Competency Framework (ICAEW), the shift from Basic User to General User marks the first qualitative change: moving from static data entry to formula-driven dynamic calculations.
The two-tier MOS certification (Associate for worksheets, formulas, and charts; Expert for advanced formulas, macros, and data management) sets official benchmarks for the L3-L4 and L5-L6 level boundaries.
A four-stage behavior-based competency model (Basic User / General User / Creator / Developer) that defines proficiency boundaries and serves as the backbone for the Levelica 7-level mapping.
The four domains and weightings of the Expert exam provide specific skill evidence for L5-L6 checklist items.
Three-tier feature lists (SUM-AVERAGE through VLOOKUP-Pivot Tables to VBA-Power Query) provide mapping evidence for L1-L5 checklist items by feature.
A university-backed four-course sequence (Essentials through Intermediate I and II to Advanced) gives pedagogical grounding for skill scope distribution across L1-L5.
