Top 50 Excel & Business Modeling Questions
Conquer investment banking, consulting, and business analyst spreadsheet assessments covering XLOOKUP, dynamic arrays, SUMIFS, Power Query, and DCF modeling.
Mastering XLOOKUP for Exact Value Retrieval in Modern Excel
Retrieve product prices or employee attributes using Excel 365's modern XLOOKUP with built-in exact matching.
Classic VLOOKUP with Exact Match and Column Indexing
Perform traditional table searches using VLOOKUP with the mandatory FALSE / 0 exact match argument.
Two-Way Matrix Lookup with INDEX and MATCH
Dynamically lookup intersection values in a 2D matrix by matching both row header and column header.
Multi-Criteria Lookup Using Boolean Array Multiplication
Lookup records matching two or more criteria simultaneously without creating helper concatenation columns.
INDEX MATCH vs VLOOKUP: Performance, Flexibility, and Best Practices
Understand why financial institutions enforce INDEX-MATCH over VLOOKUP for mission-critical spreadsheet models.
Multi-Condition Revenue Aggregation with SUMIFS and Date Boundaries
Aggregate numerical amounts matching text criteria and dynamic date ranges using SUMIFS.
Filtering Transaction Records with COUNTIFS Multi-Criteria
Count the number of records meeting simultaneous categorical and threshold conditions.
Calculating Weighted Average Cost of Capital (WACC) with SUMPRODUCT
Compute mathematically rigorous weighted averages without intermediate helper columns using SUMPRODUCT.
Implementing OR Logic Inside SUMIFS Using Array Constants
Sum numbers where a column equals Condition A OR Condition B using array constants wrapped in SUM.
Combining Multi-Cell Strings with Delimiters Using TEXTJOIN
Concatenate arrays of text cells with custom separators while automatically skipping blanks.
Splitting Full Names into First and Last with LEFT, RIGHT, and FIND
Parse delimited strings into distinct components dynamically using classic text functions.
Parsing Multi-Delimiter Strings Dynamically with TEXTSPLIT
Split text across rows and columns simultaneously using Excel 365's modern TEXTSPLIT dynamic array function.
Building Cascading Dependent Dropdown Lists with Data Validation
Create secondary dropdown menus whose options automatically filter based on the primary dropdown selection.
Creating Dynamic Calculated Fields in Pivot Tables for Profit Margins
Add custom computed metrics like Gross Margin % inside a Pivot Table without modifying source data.
Displaying Hierarchical Contributions with % of Parent Row Total
Show relative percentage contributions within nested categories using Pivot Table 'Show Values As' settings.
Normalizing Wide Cross-Tab Reports with Power Query Unpivot
Convert wide summary matrices (months across columns) into tall tabular datasets ready for relational analysis.
Replacing Fragile VLOOKUPs with Power Pivot Data Model Relationships
Build Star-Schema relationships between fact and dimension tables in Excel without bloating files with millions of VLOOKUPs.
Calculating Distinct Customer Counts in Excel Pivot Tables via Data Model
Calculate unique customer counts in Pivot Tables by enabling the Excel Data Model.
Dynamic Record Extraction with the Modern FILTER Array Function
Extract matching multi-column records dynamically using Excel 365's FILTER function without macros or manual filtering.
Generating Sorted Unique Dropdown Sources with UNIQUE and SORT
Deduplicate and sort categorical arrays dynamically in a single spilled formula.
NPV vs XNPV: DCF Valuation Accuracy for Irregular Cash Flows
Understand the mathematical difference between annual periodic NPV and exact-date XNPV in financial valuation.
Calculating Private Equity Returns with IRR and XIRR
Determine the annualized internal rate of return for irregular private equity investments using XIRR.
Calculating Compound Annual Growth Rate (CAGR) Correctly in Excel
Formulate mathematically accurate Compound Annual Growth Rates without confusing years with periods.
Building Two-Variable Sensitivity Matrices with Excel Data Tables
Stress-test financial model outputs across varying combinations of two independent input drivers using Data Tables.