Tom’s Tutorials For Excel: New in Version 2016, the “Tell me what you want to do” Field New in Excel 2016, you can click into the “Tell me what you want to do” field as shown in the picture, or press Alt+Q from your worksheet, to enter a topic for…

Tom’s Tutorials For Excel: New in Version 2016, the “Tell me what you want to do” Field New in Excel 2016, you can click into the “Tell me what you want to do” field as shown in the picture, or press Alt+Q from your worksheet, to enter a topic for…

Tom’s Tutorials For Excel: New in Version 2016, the Multi-Select Icon for Pivot Table Slicers New in Excel 2016 is the Multi-Select icon for pivot table slicers, a welcome convenience to the heretofore requirement of pressing the Ctrl key to select multiple labels. In the picture for example, I clicked…

Tom’s Tutorials For Excel: Summing a Range of Separate Pairs of Delimited Numbers Here are two formula options to sum a range of cells, when each cell holds a delimiter (in this example, a hyphen character), and you want to separately sum the cells’ numbers to the left and right…

Tom’s Tutorials For Excel: Customizing the Status Bar You can right-click the status bar for additional edit, formatting, and analysis options. The following picture shows a Before and After comparison of the additional information you can choose for the status bar to show. In this example, the Minimum and Maximum…

Tom’s Tutorials For Excel: Using a Formula to Transpose a Vertical Range Horizontally As the picture shows by example, you can horizontally transpose a vertical range at any cell outside the vertical range with the formula =INDEX($A$2:$A$25,COLUMNS($A$2:A25)) Note the absolute and relative references.

Tom’s Tutorials For Excel: Using a Ribbon Group’s Dialog Launcher To see all the options for a Ribbon group, click the dialog launcher in the group’s bottom right corner.

Tom’s Tutorials For Excel: Hiding Your Named Ranges In the below picture, your workbook’s named ranges can be shown by clicking the down arrow next to the Name box. The following macro hides the named ranges, and as the next picture shows, you can work with hidden named ranges the…

Tom’s Tutorials For Excel: Displaying a Column’s Width You can display a column’s width manually, or in a cell with a User-Defined Function. The first picture shows that when you press and hold your left mouse button between column headers, a column’s width appears in a tooltip. Column C is…

Tom’s Tutorials For Excel: Using SUMPRODUCT on Multiple Columns Most examples of the SUMPRODUCT function show a single list of numbers being evaluated for a particular criteria. The following 6 pictures show a simple modification involving SUMPRODUCT, to demonstrate some versatility with that function. The first picture shows a range…

Tom’s Tutorials For Excel: Summing and Averaging Dynamic Lists, Including or Excluding Blank Cells The below picture shows a side-by-side comparison of summing and averaging the last 5 cells in a dynamic list, depending on if blank cells should or should not be included in the formula results. Today the…