Main Profile

At A Glance

Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format

1. See Mr Excel and excelisfun try to take a database with repeat names of students with failing Grades and create a unique list of student names that shows an "X" for each class that falls into a Class Category.2. Mr Excel uses PowerPivot and excelisfun uses two Helper Column Formulas and a PivotTable.3. Also learn about Custom Number formatting4. Learn about default setting for empty cells in a Pivot Table using PivotTable OptionsRelated Video Title:Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words Helper Column & PivotTable
Length: 11:19

Contact

Questions about Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format

Want more info about Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question