by Ilker | Apr 1, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 27, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 26, 2020 | Excel Tips & Tricks
You can use the COUNTIFS function to count the values in ranges that meet certain criteria. The criteria can contain a not equal logic as well. However, the COUNTIFS function requires individual arguments for each range-criteria pair. This requirement can make it...
by Ilker | Mar 26, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 5, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 5, 2020 | Excel Tips & Tricks
Excel allows you to enter a formula with up to 8,192 characters. However, managing a formula will certainly get harder as you get closer to that limit. You might especially have this issue when working with nested formulas – functions in functions. In this...
by Ilker | Mar 4, 2020 | Excel Tips & Tricks
In this guide, we’re going to show you how to enter data in form structure, without using VBA. Here are a few reasons why this might be a preferable option: A spreadsheet’s tabular form is a great way to keep records and work on them. On the other hand, entering data...
