BLOG

Tom’s Tutorials For Excel: New in Version 2016, the “Tell me what you want to do” Field


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: New in Version 2016, the Multi-Select Icon for Pivot Table Slicers


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Summing a Range of Separate Pairs of Delimited Numbers


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Customizing the Status Bar


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Using a Formula to Transpose a Vertical Range Horizontally


Share Button

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.

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Using a Ribbon Group’s Dialog Launcher


Share Button

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.

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Hiding Your Named Ranges


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Displaying a Column’s Width


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Using SUMPRODUCT on Multiple Columns


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Summing and Averaging Dynamic Lists, Including or Excluding Blank Cells


Share Button

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

Read more ›

Posted in Tom's Tutorials for Excel
Tags: