Library Workshops

Excel Intermediate - Learning Objective #4:

Using formatting features:

Skills and concepts covered:

• Merge and Centre
• Conditional Formatting
• Custom Sort

Activities:

• On the OrderForm worksheet, select row 1 → right click and insert a row → enter “Orders Pending” in cell A1 → change font to Arial 12, bold text and select background colour orange → Select cells A1:AH → click merge and centre from alignment section of home tab

• On the OrderForm worksheet highlight row G → select conditional formatting from home tab in styles group → select highlight cell rules → select between → Enter date 1/1/2015 in first box and in second box enter 1/31/2015 → select red fill

• On the OrderForm worksheet highlight rows 2-119 → select custom sort from editing section of home tab → sort by date ordered (column G)
• Next try sorting based on cell colour → select custom sort from editing section of home tab → sort by cell colour → Select Red on top