Given an array of data, using Microsoft Excel, you can manipulate the data to quickly access desired information from the dataset using formatting functions or Vlookup feature.
- To sort data by profit column and discover high profit-making orders (>$2000)
- To view details of individual sales orders contained in the dataset using just the sales order number.
- Conditional Formatting
- Vlookup Function