7-Day Advanced Excel Interview Preparation Plan
Your saved questions plus a day-by-day plan. Add questions with Save to → 7-Day Job Prep on any question page.
Day-by-day plan
Day 1Fundamentals and shortcuts
- Revise references, Tables, named ranges and custom number formats
- Practise conditional formatting rules for whole rows
- Build a dependent dropdown with data validation
- Time yourself on 15 daily shortcuts
Day 2Core formulas
- Solve 15 SUMIFS and COUNTIFS problems with date criteria
- Write commission slab and financial year formulas
- Practise text cleaning with TRIM, SUBSTITUTE and TEXTBEFORE
- Revise the meaning of each Excel error type
Day 3Lookups and dynamic arrays
- Rewrite five VLOOKUPs as XLOOKUP and INDEX/MATCH
- Practise two-way and multi-criteria lookups
- Build a FILTER and SORTBY leaderboard
- Debug a lookup that returns #N/A due to spaces and text numbers
Day 4Pivot tables
- Build pivots with grouping, Show Values As and Top 10 filters
- Create a calculated field for margin and a distinct count
- Connect slicers to three pivots
- List the reasons a pivot total may not match the source
Day 5Charts and dashboard
- Build a combo chart with a secondary axis
- Create a one-page dashboard with KPI cards and slicers
- Add a dynamic chart title and highlighted max point
- Prepare to explain your design choices in two minutes
Day 6Power Query and Power Pivot
- Combine a folder of files and unpivot month columns
- Practise merge joins including Left Anti
- Create a Date table and write YTD, LY and % of total measures
- Revise CALCULATE, filter context and row context
Day 7VBA and mock interview
- Write macros for last row, sheet loop and PDF export
- Revise error handling and speed settings
- Prepare three STAR stories about automation, errors and deadlines
- Take a timed mock test mixing formulas, pivots and scenarios
Frequently asked questions
Can I prepare for a Advanced Excel interview in 7 days?
Seven days is enough to revise and sharpen, not to learn from zero. Use the plan to cover each core topic once, practise questions daily and finish with a mock interview.
How do I add questions to the plan?
On any question page choose Save to → 7-Day Job Prep. Saved questions show up at the top of this page.
How many hours a day should I study?
Two to four focused hours a day works for most people: one hour of revision, one to two hours of questions, and the rest on projects or mock answers.
Questions to practise each day
Company-wise Advanced Excel questionsExperience-wise Advanced Excel questionsRole-wise Advanced Excel questionsCity-wise Advanced Excel questionsMost asked Advanced Excel questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsAdvanced Excel mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsAdvanced Excel topic sheets