About this document
Excel Data Manipulation Techniques by Hïmãñshü Ãnšhű is a document available to read on EtoBox.
This document contains 7 questions related to data analysis and Excel formulas. The questions include: combining data from two sheets without blanks rows; finding sales values using VLOOKUP and INDEX/MATCH; writing a formula to extract the quarter from a date; writing a formula to count unique countries with sales over $3,000; finding middle names of leads using IDs; creating a pivot table with average age and total sales with Country and Lead slicers; and creating a dependent dropdown list using named rang
- Author
- Hïmãñshü Ãnšhű
- Language
- EN