In cooperation with Experts Exchange. Notes are like yellow stickies where you can enter free-form text. They get associated with specific cells. Comments are threaded discussions you can have with other people sharing the workbooks with you, and comments also get associated with specific cells. Excel gives you a couple
In cooperation with Experts Exchange. With Excel’s Choose function, you can create a list of items, then select which of those items you want the function to return. For example, if you have a list of ice cream flavors that’s chocolate, vanilla, and coffee and specify item #2, the function
In cooperation with Experts Exchange. With Excel’s Choose function, you can create a list of items, then select which of those items you want the function to return. For example, if you have a list of ice cream flavors that’s chocolate, vanilla, and coffee and specify item #2, the function
In cooperation with Experts Exchange. You can insert a drop-down list into a cell on a worksheet. This allows whoever is using the worksheet to choose from a specific list of values rather than having to type a value. It also reduces errors and keeps values consistent. In this episode,
In cooperation with Experts Exchange. It’s easy for worksheets to get complicated, where it isn’t clear which data cells feed into which calculations. If calculations throw errors, it might not be immediately difficult which input cells are contributing. The auditing features show visual indicators to make it easier to see
