Excel in 2026
Excel is the most requested technical skill in job postings by a wide margin: a Course Report analysis of 12 million Indeed postings found Excel named in about 531,000 of them, more than any other technical skill and several times Python. In 2026 it has an assistant built in - Copilot writes formulas and summaries - which makes the person who can check a spreadsheet more valuable, not less. The four nodes answer what to learn in Excel in 2026, which roles use it, what companies expect and what gets you hired.
- CertificationOneRoadmap: Excel certification
- Job simulationOneRoadmap: Data Analyst job simulation
- RoadmapOneRoadmap: Data Analyst roadmap
- ArticleMicrosoft and LinkedIn: 2024 Work Trend Index
- ArticleWorld Economic Forum: The Future of Jobs Report 2025
What to learn in 2026
Learn the formulas and lookups that do real work, then the tools that turn Excel into an analysis engine - pivot tables, Power Query and the data model - and then how to use Copilot in Excel while checking what it produces. The sub-nodes order the three. The World Economic Forum's Future of Jobs 2025 report has analytical thinking as the skill employers rank first, and Excel is where most of it happens.
Formulas and lookups
The working core is smaller than the function list: references and ranges, the modern lookups with XLOOKUP and INDEX with MATCH, conditional aggregation with SUMIFS and COUNTIFS, text and date functions, IF and IFS with error handling, dynamic arrays with FILTER, UNIQUE and SORT, and the LET and LAMBDA functions that make formulas readable. The Course Report analysis of 12 million postings found Excel in about 531,000 of them, more than any other technical skill, and the test in those jobs is always the same: a lookup that joins two sheets correctly and a formula someone else can read.
- RoadmapOneRoadmap: SQL roadmap
Pivots and Power Query
Pivot tables answer most business questions without a formula; Power Query turns messy exports into clean tables you can refresh instead of rebuild; the data model and Power Pivot join tables properly and open the door to Power BI, which is the same engine. These three move a learner from spreadsheet user to analyst, and they are the difference between a report that takes a day and one that takes a click. A widely cited 2024 LinkedIn workforce analysis found Excel named in most data analyst listings; the pivot and query skills are what those listings mean.
Copilot in Excel
Copilot in Excel writes formulas, explains them, builds pivots and summarises a table in a sentence - and it is wrong often enough that checking is the job. The Microsoft and LinkedIn Work Trend Index found 75 percent of knowledge workers using AI at work and 66 percent of leaders unwilling to hire without AI skills, so using the assistant is expected. The skill is verification: reconcile a Copilot total against a pivot, check a generated lookup for the wrong match mode, test a formula on an edge row, and keep a cell that states the source of every number.
Which roles use it
Analysts and finance teams live in Excel; operations, HR, sales and administrative roles depend on it; and almost every business role lists it. The sub-nodes name the analyst and finance roles, the operations and admin roles, and the fresher and switcher routes.
Analyst and finance
Business, financial and data analysts build models, forecasts and reports in Excel; finance and accounting teams close books, budget and reconcile in it; consultants build the deliverable in it. These roles test lookups, pivots, modelling discipline and the ability to explain a number. The Data Analyst roadmap is the path that grows out of Excel into SQL, dashboards and statistics; the World Economic Forum's 2025 report puts analytical thinking first among the skills employers want, which is what these roles are hired for.
Operations and admin
Operations, supply chain, HR, sales operations, marketing and administration run on spreadsheets: trackers, schedules, pipelines, payroll checks, campaign reports. The Course Report analysis's 531,000 Excel mentions are mostly these roles, not analyst titles, and the bar is a clean, correct, shared workbook built quickly - Power Query for the weekly export, a pivot for the summary, a lookup to join the two systems nobody integrated. Excel fluency is often the fastest promotion skill in these teams, because it is visible and it removes a manager's pain.
- RoadmapOneRoadmap: English roadmap
Fresher vs switcher
A fresher's best proof is one workbook that answers a real question, reconciled, with a dashboard sheet, shared as a file and explained in a page; Naukri's JobSpeak showed fresher hiring up 17 percent year on year in February 2026 and non-IT sectors leading, which is where Excel-heavy roles sit. A switcher from any business role already has the questions and should learn pivots, Power Query and the lookup that replaces their copy-paste. On this map freshers get the basics filled and the data-model stages outlined; experienced learners get the reverse.
- ArticleNaukri JobSpeak
What companies expect
Companies expect a spreadsheet that is correct, checked against a source, readable by someone else and built fast - with the assistant used for speed and the human responsible for the numbers. The sub-nodes cover the bar, the interview and what gets verified.
The hiring bar
The bar is a workbook someone else can trust: inputs separated from calculations, formulas readable, no hard-coded numbers inside them, a check row that reconciles to the source, a pivot or chart that answers the question, and version discipline. The Work Trend Index found 71 percent of leaders would prefer a less experienced candidate with AI skills over a more experienced one without; Excel teams expect Copilot used for speed and the human owning every total.
What interviews test
Expect a practical test: a messy export to clean and summarise, a lookup across two sheets, a pivot with a specific cut, a short model or forecast, sometimes with Copilot allowed; then questions about how you would check the result and present it. The strongest answer walks through the reconciliation - which total you tied to what, and where a wrong match would have shown up. Speed matters, correctness decides.
Proof they verify
Reviewers open the workbook: is it structured, are the formulas readable, does the check row tie, does the dashboard answer the question. One such workbook beats a list of courses; OneRoadmap's free Excel certification with its public verification link beats a badge; a short note on what Copilot drafted and what you verified is now part of the proof. The Data Analyst roadmap's career stage lists the external credentials that carry weight.
- CertificationOneRoadmap: Excel certification
What gets you hired
A workbook that answers a real question with reconciled numbers, a dashboard a manager could use, a verified certification and a clear account of what Copilot drafted and what you checked. The sub-nodes give the ninety-day plan, the projects that get read and the proof that counts.
- CertificationOneRoadmap: Excel certification
A 90-day plan
Month one: formulas, lookups and dynamic arrays on a real export, with a reconciled summary sheet. Month two: pivots, Power Query and the data model on a public dataset, ending in a refreshable report. Month three: a dashboard workbook that answers a business question with a one-page memo, a note on the Copilot-drafted parts you checked, the Excel certification, and twenty targeted applications a week - and the first weeks of the SQL roadmap, because every analyst role asks for both. Naukri's JobSpeak showed fresher hiring up 17 percent year on year in February 2026 with non-IT sectors leading, which is where Excel-heavy roles sit.
- RoadmapOneRoadmap: SQL roadmap
Projects that get read
Projects that get read solve a business problem: a sales or inventory dashboard refreshed by Power Query from raw exports; a budget-versus-actual model with scenarios and a reconciliation row; a hiring or campaign tracker with pivots that answer the manager's three questions; a cleaned public dataset with the data-quality issues quantified. Each is a shared file with a readme sheet. The World Economic Forum's 2025 report has analytical thinking first among employer-ranked skills; a workbook that shows it is the evidence.
Certification and proof
Proof is verifiable: OneRoadmap's free Excel certification with a public link, a shared workbook whose numbers tie, a dashboard a manager could use and a short account of your Copilot workflow. The candidates who get replies in Excel-heavy roles are the ones whose spreadsheet a reviewer can open and trust.
- CertificationOneRoadmap: Excel certification
- Job simulationOneRoadmap: Data Analyst job simulation