An MBA and a working knowledge of VLOOKUP, Pivot Tables, and Power Query is a stronger starting point than many aspiring business analysts realize. The question isn't about how many more Excel tools you need to learn, but about how you reframe the tools you already have. Technical skills matter, but the real value of a BA lies in translating business questions into data-driven answers, and your MBA has already trained you to ask the right questions.
The skills you listed are not a junior's checklist; they are a functional core. VLOOKUP (and its more stable cousin, INDEX-MATCH) connects disparate data sources. Pivot Tables summarize and explore patterns instantly. Power Query automates the tedious work of cleaning and reshaping data, which is often 80 percent of a BA's actual effort. If you can clean data reliably and aggregate it meaningfully, you have the mechanical foundation for most intermediate analyst roles. What you may lack in advanced formula gymnastics, you can offset with the strategic thinking your MBA instilled, understanding *why* a metric matters, not just how to calculate it.
Where you should focus next is on two adjacent skills that amplify what you already know. First, learn basic SQL. It is the language of databases and the most common ask in BA job descriptions. SQL uses the same logic as VLOOKUP and Pivot Tables, filtering, joining, grouping, but scales to larger datasets. Second, practice building dashboards, even simple ones in Excel. A clean, annotated dashboard that tells a story from your Pivot Table outputs is worth more than a hundred complex formulas no one else can follow. Your audience will be stakeholders who want clarity, not technical spectacle.
The temptation is to keep adding tools to your resume, but depth in the tools you have will serve you better than breadth in tools you barely use. Spend your time on cases and projects that force you to combine your existing skills end-to-end: pull data with Power Query, summarize with Pivot Tables, and present findings with a clear narrative. That workflow is the actual job. You don't need to be an Excel guru to start it. You need to be someone who can turn a messy spreadsheet into a decision. You already have the parts. Now connect them.