Excel remains the single most widely used business tool in Ireland. It's in every office, on every desk, and involved in an enormous proportion of the daily work that keeps businesses running. Yet in our training and consultancy work, we consistently see the same pattern: most people use maybe 20% of Excel's capability — often the same 20% they learned years ago.
The skills gap isn't about exotic features. It's about the core capabilities that deliver enormous practical value and that most Excel users simply haven't been shown. Here are the ten we'd prioritise for any business professional in 2025.
1. XLOOKUP
If you're still using VLOOKUP, it's time to upgrade. XLOOKUP is its modern replacement — more flexible, more readable, and without VLOOKUP's frustrating column-number limitation. It can look left as well as right, returns a range rather than a single value, and handles errors elegantly. Learning XLOOKUP makes an immediate, practical difference to anyone who regularly combines data from different tables.
2. PivotTables
PivotTables are arguably the highest-value skill in Excel. They let you summarise, group, and analyse large datasets in seconds — without writing a single formula. The ability to take a flat list of transactions and instantly see sales by region, product, month, or customer is transformative for anyone involved in reporting or analysis. Most Excel users have heard of PivotTables but have never been properly shown how to build and use them confidently.
Quick test: If building a summary of your data currently involves writing lots of SUMIF formulas manually, you're doing work that a PivotTable would do in under a minute. That's the skill gap in action.
3. Power Query (Get & Transform)
As covered in our dedicated Power Query article, this is the feature most business users don't know they have. The ability to connect, clean, and combine data sources automatically — and refresh with a single click — is one of the highest-return skills any Excel user can learn. Especially valuable for anyone who regularly prepares data for reports.
4. Named ranges and structured table references
Converting data to Excel Tables (Ctrl+T) and using structured references like =SalesTable[Amount] instead of =C2:C500 makes spreadsheets dramatically more readable and maintainable. Tables also expand automatically when new rows are added, which eliminates the error-prone task of updating formula ranges manually.
5. Conditional formatting with formulas
Most people know basic conditional formatting — highlight cells above a threshold, colour a column red or green. The real power comes from using formulas in conditional formatting rules, which lets you highlight entire rows based on conditions, flag upcoming deadlines, or visually identify patterns across complex datasets. This skill turns data into visual information that's instantly readable.
6. IF, IFS, and logical functions
IF is one of the most-used functions in Excel, but many users stop at simple single-condition logic. Learning IFS (for multiple conditions), AND, OR, and how to nest logical functions cleanly unlocks the ability to build decision logic into spreadsheets — automating categorisation, flagging, and classification that would otherwise require manual review.
7. SUMIFS, COUNTIFS, AVERAGEIFS
These conditional aggregation functions are workhorses of business reporting. The ability to sum or count only the rows that meet specific criteria — by date range, by customer, by product category, by status — is essential for anyone building reports from transactional data. Used well, these functions can replace complex manual filtering and counting entirely.
8. Data validation and dropdown lists
One of the biggest sources of spreadsheet errors is inconsistent data entry — the same customer entered as "Acme Ltd", "Acme Limited", and "ACME" in different rows. Data validation restricts what can be entered in a cell, and dropdown lists ensure users choose from a controlled set of options. For any spreadsheet that multiple people contribute to, this is an essential skill for maintaining data quality.
9. Keyboard shortcuts and efficiency habits
The speed difference between a proficient Excel user and an average one is often not about knowing more functions — it's about keyboard fluency. Shortcuts for navigating to the end of a range (Ctrl+Arrow), selecting to the end (Ctrl+Shift+Arrow), filling down (Ctrl+D), and entering array formulas (Ctrl+Shift+Enter) save seconds on every operation — which adds up to hours across a working week.
10. Basic chart design principles
Excel's default charts are functional but rarely communicate well. Understanding how to choose the right chart type for different data, remove visual clutter, use consistent colour, and label data clearly is a skill that transforms how your analysis lands with an audience. A well-designed chart communicates a finding in seconds; a poorly designed one requires explanation every time.
How to prioritise your learning
Not all of these skills are equally relevant to every role. If you work primarily with analysis and reporting, PivotTables, Power Query, and SUMIFS should be your first investment. If you build tools that others use, data validation and structured tables are essential. If you present to management or clients, chart design pays back immediately.
The best approach is targeted: identify the two or three gaps that cost you the most time right now, and close those first. Broad Excel training courses cover everything — focused skill development delivers results faster.
Want Excel Training for Your Team?
We run focused, practical Excel training sessions for Irish SME teams — built around the skills your team actually needs, not a generic curriculum.
Book My Free Audit →