Pictures of data

This is Data for Bakery Shop.xlsx: 1,095 days, 1 January 2013 to 31 December 2015.

• A6:A1100 the date. Excel keeps a date as a number of days and shows it as 1-Jan-13.
• B to F units sold: cakes, pies, cookies, smoothies, coffee.
• G the promotion column, reading promotion or none.
• H a helper column you are about to add: the day name.
• J5:K23 three summary tables.

Fill down with Ctrl+D (Windows) / ⌘D (Mac). On 1,095 rows, select H6, then Ctrl+Shift+Down (Windows) / ⌘⇧↓ (Mac), then fill.