MGMT 2050 Lecture Notes - Lecture 10: Pivot Table, Blue Screen Of Death
Document Summary
Data - what if analysis - goal seek - set cell (profit/loss) - to value (0) - by changing cell (# of units) Change to value to 10 000 to get # of units for that profit/loss. Keep first 4 rows when scrolling down - freezing. Click on heading label a4 - data - filter - click arrows, deselect all, click which item you would like to see (minimizes list, narrows it down) Total sale - filter - number filters - choose any one - greater than - type 500 in box. Item name - contains - golf will filter all names containing the word golf . Click f - home tab - conditional formatting - highlight cells rule - greater than - 500 - format with (custom format) Conditional formatting - manage rules to set colour range. Click label (a4) - insert pivot table (use to create reports) - click okay if data selected.