ROWS FORMULA in Excel
How to Use the ROWS FORMULA in Excel The ROWS-formula is used to count the number of rows that are selected in a range. The formula is very simple, just select the array or the table which contains the rows that you want to count within the brackets of the row...
COLUMNS FORMULA in Excel
How to Use the COLUMNS FORMULA in Excel The columns formula in Excel is used to count the number of columns that are selected in a range. The formula is very simple, just select the array or the table which contains the columns that you want to count within the...
Win/Loss Sparklines Chart in Excel
How to Use the Win/Loss Sparklines Chart in Excel A win-loss chart shows positive and negative values with different colors in a single cell. The win-loss chart assists with the visualization of trends in data. It shows an upward-facing marker for positive values and...
Table Of Contents With Macro in Excel
How to Make Table Of Contents With Macro in Excel If you have multiple tabs in a workbook and want to create an easy reference to each of them, a top-level table of contents tab in Excel is appropriate. A table of contents tab has a summary of all the sheets and each...
