How to transpose Excel data using the Paste Special feature

How to transpose Excel data using the Paste Special feature

by | Apr 14, 2020

When it comes to flipping the rows and columns your data in Excel you have two options: The Paste Special feature and the TRANSPOSE formula. Transposing in this sense means rotatating a range of values columns to rows or vice versa. In this guide, we’re going to show...
How to add a diagonal line to a cell in Excel

How to add a diagonal line to a cell in Excel

by | Apr 6, 2020

A diagonal line in a cell is not a very common sight in Excel workbooks. Although they have a somewhat limited use, you can improve your worksheet visuals with simple tricks like this one. In this guide, we’re going to show you how to add a diagonal line to a cell in...
How to save an Excel chart template

How to save an Excel chart template

by | Apr 1, 2020

Charts are a staple in creating dashboards and reporting. It’s only natural that Excel supports many chart types with various features. The ability to save templates is very useful for quick access to frequently used chart types. In this guide, we’re going to...
How to use Paste Special to modify formulas in Excel

How to use Paste Special to modify formulas in Excel

by | Mar 31, 2020

In addition to using Paste Special to evaluate numbers with operators, you can also use this feature to modify formulas. Formulas can be bound to other formulas or named ranges with the use of mathematical operators. In this guide, we’re going to show how to use Paste...
How to multiply multiple cells in Excel using Paste Special

How to multiply multiple cells in Excel using Paste Special

by | Mar 31, 2020

If you need to modify multiple numbers at once, you can use the Paste Special feature of Excel. Although pasting only values or formatting are more common use cases of the Paste Special feature, it has more tricks in its pocket. In this guide, we’re going to show how...
How to create an Excel summary table using UNIQUE and SUMIFS

How to create an Excel summary table using UNIQUE and SUMIFS

by | Mar 27, 2020

SUMIFS like other …IF or …IFS function are great tools to aggregate data based on a set of conditions. The downside of this approach is that the criteria must be supplied manually, especially when you need to create a summary table. In this guide, we’re going to show...
How to use COUNTIFS Excel Function with Unequal Ranges

How to use COUNTIFS Excel Function with Unequal Ranges

by | Mar 26, 2020

The COUNTIFS and COUNTIF functions can count the values in ranges which meet certain criteria. Although the COUNTIFS function accepts multiple range-criteria pairs, it doesn’t allow using different size ranges. You can overcome this with the help of the SUM and...
How to count if not equal to x or y in Excel

How to count if not equal to x or y in Excel

by | Mar 5, 2020

The COUNTIFS function can count the values in multiple ranges with multiple criteria. The function counts each given range-criteria pair and combines the result with AND logical operator. Unfortunately, there is no quick and easy way to use an OR logic with the...