From Spreadsheets to Strategy: How to Move Beyond Excel and Into Real Data Analytics
Marisa Crous
If you’re the person everyone comes to when the numbers need untangling, you’re already closer to a data analytics career than you think.
Maybe you’ve built five-tab Excel dashboards for your team. Maybe you live inside pivot tables, VLOOKUPs and forecasting spreadsheets. Maybe your role title says “operations manager”, “finance lead” or “marketing executive”, but half your job already revolves around data.
And yet, when organisations hire “data analysts”, the role often sits elsewhere.
That gap is becoming more visible as businesses shift from spreadsheets to scalable analytics, AI-assisted workflows and real-time decision-making. Data roles have grown significantly faster than the wider job market, while employers increasingly expect analysts to work across SQL, visualisation tools, Python and GenAI-enabled workflows.
The good news is this: moving beyond Excel does not mean starting your career over. In fact, your existing business experience may be your biggest advantage.
“What I was looking for was to reposition myself, leveraging my commercial background, but building a set of tools that would help me provide commercial teams with better insights.”
This article walks through a practical four-step path to make that transition – from diagnosing the Excel ceiling to building a portfolio and positioning yourself for a real analytics role.
The Excel ceiling – and why it holds so many careers back
Excel is still one of the most important business tools in the world. It teaches people how data is structured, how analysis works and how decisions get made.
But there comes a point where Excel stops scaling.
You feel it when spreadsheets start crashing under large datasets. When version control turns into “Final_v7_REALfinal.xlsx”. When every weekly report depends on you manually refreshing formulas. When teams can’t collaborate cleanly across systems. When repetitive work eats up hours that should be spent solving problems.
That’s the operational ceiling. Then there’s the career ceiling.
Today, “advanced Excel skills” alone rarely signal analyst-level capability to employers. SQL now appears in up to 60% of data analyst job postings, while Python and visualisation platforms increasingly sit alongside it in role requirements.
This matters especially for professionals trying to make a data analyst career change without “official” analyst experience. Many people already do analytical work every day – they just lack the technical stack and portfolio evidence that hiring managers recognise.
As Harry Kelleher, Course Facilitator on the LSE Data Analytics Online Career Accelerator, explained during a recent webinar:
“The analyst role has become a lot broader… not just doing your technical job very well, but having a very good understanding of the business problems that you’re investigating.”
Your Excel experience already gives you the business foundation. Modern analytics tools help you scale that impact across larger datasets, faster workflows and more strategic decisions.
For a broader beginner’s view of the data analyst career path, our guide on how to become a data analyst covers the foundations – this article picks up where that one ends, for readers already comfortable in Excel.
The first step in any data analyst learning path is recognising the signs that your current workflow has outgrown spreadsheets.
There are usually five clear indicators:
1. Your datasets are becoming too large
Excel works brilliantly – until it doesn’t. Large operational datasets quickly become slow, unstable and difficult to manage.
2. Collaboration becomes messy
Spreadsheets are notoriously difficult to govern across teams. Different versions, conflicting formulas and unclear ownership create friction fast.
3. You become the bottleneck
If every dashboard refresh depends on you manually updating formulas or cleaning data, the process cannot scale.
4. Automation is limited
Modern analytics workflows rely on repeatability. Excel often struggles with robust automation, especially when pulling from multiple systems.
5. Insight delivery becomes reactive
You spend more time maintaining reports than solving strategic problems. That’s often the point where professionals start looking beyond spreadsheets.
Excel users already bring valuable business context, stakeholder awareness and operational understanding. The next step is building the technical stack that helps you scale that impact.
Step 2 – Learn the stack that replaces Excel at scale
The transition from spreadsheet user to analyst is less about learning “coding” and more about learning the right workflow.
Strong data analyst skills today are typically built in layers – each tool solving a problem Excel cannot solve efficiently at scale.
Start with SQL – the single most in-demand data skill
If you’re moving from Excel to SQL, the good news is this: the leap is smaller than most people expect.
SQL is essentially the language of business databases. It allows analysts to filter, join, aggregate and analyse millions of rows directly from the source.
For Excel users, the mental model already exists.
As Harry Kelleher explained:
“A really important foundation for anyone working with AI is knowledge in the subject matter, and therefore knowing your basics in coding, and being able to understand the data analytics lifecycle.”
Think of it this way:
Filters become WHERE
VLOOKUPs become JOINs
Pivot tables become GROUP BY
A good first milestone? Replicate one Excel report in SQL within two weeks.
Add visualisation – Tableau or Power BI
Excel charts communicate information. Tableau and Power BI communicate decisions.
Modern organisations increasingly expect dashboards to be interactive, shareable and connected to live data sources. Analysts are now expected to build tools businesses actually use – not static screenshots pasted into PowerPoint decks.
Luis Cantu, now a Data and Insights Analyst at Leeds United Football Club, moved into data analytics from a career in independent commercial consulting. In his current role, he has seen firsthand how effective data visualisation can influence decision-making:
“Showing them dashboards that come from the analysis… and condensing it into a concrete, well-presented dashboard… helped me feel confident going in front of directors.”
The programme includes dedicated visualisation training using Tableau, helping learners move from “reporting numbers” to telling business stories.
Layer in Python – for automation and real analytics
Python is often the point where Excel users stop repeating manual work and start automating it.
Instead of spending hours cleaning spreadsheets every week, Python allows analysts to automate workflows, process large datasets and perform analysis at scale.
It also unlocks capabilities that Excel simply cannot support effectively:
Predictive modelling
Sentiment analysis
API integration
Unstructured data analysis
Scalable automation
Python is often the point where Excel users start automating repetitive work.
As Luis Cantu explained:
“Using advanced statistical tools like R and Python to really dig into the data using just a few lines of code is really powerful.”
Don’t skip GenAI fluency
The future-thinking analyst works alongside AI, using it to solve problems faster and more strategically.
During the webinar, Harry Kelleher described it this way:
“We’re going to be writing less code, and we’re going to be more orchestrating the use of AI, and doing a lot more strategic thinking.”
That means analysts increasingly need to know:
How to prompt effectively
How to validate outputs
How to identify hallucinations or bias
How to apply AI within business context
How to communicate findings responsibly
The LSE research on data literacy in the AI era reinforces this change: the competitive advantage is moving away from pure tool execution and towards problem framing, strategic thinking and human judgement.
Step 3 – Build a portfolio that proves you can solve business problems
Hiring managers increasingly want proof that you can apply data tools to real business problems.
That means building a data analyst portfolio.
The strongest portfolios are not built around generic datasets like Titanic survival predictions. They’re built around business problems that feel commercially real.
Good portfolio projects usually demonstrate:
A clear business problem
A structured analytical process
Appropriate tool selection
Actionable insight
Communication clarity
This is where Excel users often have a hidden advantage. You already understand how businesses operate. You know what stakeholders care about. You know what “good enough” looks like in a commercial environment.
Structured programmes can accelerate this process significantly. The LSE Data Analytics Career Accelerator culminates in a live Employer Project where learners solve real business challenges with organisations, including EdPlace and GAEA AI.
Karen Munro, a Career Coach on the programme, described the transition this way:
“Coaching helps learners realise that they’re not starting from zero… helping them weave together previous experience with their new data skills.”
Step 4 – Position yourself for the role (not the restart)
One of the biggest mistakes career switchers make is positioning themselves as beginners. You are probably not a “junior analyst with no experience”.
You are more likely:
A marketer with analytics capability
An operations professional with automation skills
A finance lead with data visualisation capability
A commercial manager who can translate insight into revenue impact
That combination is extremely valuable.
As Luis Cantu explained during the webinar:
“We’re going to be measured not on how well we solve problems, but how much value we’re adding.”
Hiring managers increasingly want domain-fluent analysts – people who understand both the technical workflow and the commercial environment.
This changes how you position yourself:
Lead your CV with business outcomes, not tasks
Quantify impact wherever possible
Bring portfolio projects into interviews
Use existing professional networks
Reframe your experience as analytical, not administrative
This is also where coaching comes into play. Karen Munro described one of the biggest mindset shifts this way:
“Shifting from ‘I’m a student’ to ‘I’m a data professional who solves problems.’”
That reframing is often what unlocks the transition. And the outcomes can be significant. Career Accelerator graduates reported an average salary uplift of 31% after completion (FourthRev Completers’ Survey).
The move from spreadsheets to analytics builds on the experience you already have.
The professionals best prepared for the future combine business understanding with modern analytics skills.
The roadmap is straightforward:
Diagnose the Excel ceiling
Learn the modern analytics stack
Build portfolio evidence
Position yourself around business impact
The LSE Data Analytics Career Accelerator is built for exactly this transition.
Over six months, learners build practical fluency in SQL, Python, Tableau, GenAI tools and data storytelling, culminating in a live Employer Project. Learners earn a Certificate of Competence from LSE and receive up to 12 months of 1:1 career coaching.
Excel is an excellent foundation, but most modern analyst roles now also expect SQL, visualisation tools and some familiarity with Python or AI-enabled workflows.
How long does it take to move from Excel to data analytics?
That depends on your starting point and study intensity, but many professionals can build job-ready analytics capability within six to 12 months through structured, portfolio-led learning.
Do I need a degree to move into data analytics?
Not always. Many employers prioritise practical skills, portfolios and commercial experience. Structured programmes may also offer aptitude-based entry routes for experienced professionals without formal quantitative degrees.
SHARE
Find out more about the LSE Data Analytics Career Accelerator
A practical four-step guide for Excel-confident professionals who want to become data analysts – without starting their career over. Get the essential tips.
Becoming skilled in data doesn’t necessarily mean becoming a data analyst. We list diverse careers you can explore with data analytics skills. Read more.
Everyone seems to talk about digital marketing as though it's a language you should have learned years ago. If you've spent the last decade building your career in traditional marketing or sales, it's easy to feel as though you've missed the boat.
The reality is very different.
