Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...