Spreadsheet and Data Manipulation Questions

Practical proficiency with spreadsheet tools such as Microsoft Excel to clean, transform, and prepare data for analysis and reporting. Core skills include using pivot tables to summarize and slice data, lookup functions such as VLOOKUP and INDEX MATCH to reconcile and join datasets, building formulas for calculated fields, text and date transformation, conditional formatting, data validation, filtering and sorting, and using extract transform and load tooling available in spreadsheets to automate routine transformations. Comfortable importing and reconciling data exports from customer relationship management systems such as Salesforce, diagnosing inconsistencies, and producing clear tables and charts to support analytical recommendations.