Skip to main content

Library Workshops

Excel Intermediate - Learning Objective #4

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

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback