Video - PowerPivot or Helper Column and PivotTable and Custom Number Format
User Rating: / 0
PoorBest 
Written by Bill Jelen   
Sunday, 18 September 2011 20:50

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 formatting
4. Learn about default setting for empty cells in a Pivot Table using PivotTable Options

Read more...

  Tags: excel
 

Varigence Vivid