Excel - Productive Tips

The below listed is not the complete topics, but if you cannot find answers to half of them, you sure are the candidates of the workshop.

  • Find duplicates items in combine columns in Microsoft Excel;
  • Retrieving an Item from a List that Meets Multiple Criteria;
  • Splitting a Full Address into Three Separate Cells;
  • Creating a PivotTable Report;
  • Use Goal Seek to change a cell value of a dependent formula;


Workshop