EXCEL: AVERAGE, COUNT & SUM
A useful feature of Excel that you might not have noticed is that when a group of cells is selected, information about those cells is displayed at the bottom of the screen in the Status bar: By default, the status bar is set to display the Average, Count, and Sum of the selected values, but […]
EXCEL: CREATING CUSTOM LISTS
The AutoFill feature in Excel can be used with lists to simplify data entry. For example, enter “Monday” in a cell: Then pull the fill handle down to fill in the days of the week: Excel uses “lists” with the AutoFill feature. The lists that are built into Excel are the names of days and […]
EXCEL: HIDE AND UNHIDE
Large worksheets in Microsoft Excel pose a challenge in their display, printing, and sharing of information. To work with the data on screen requires scrolling in both directions, printing either spans multiple pages or reduces the font to an unreadable size, and there could be underlying data that is not appropriate to be shared with […]