by Ilker | Dec 26, 2018 | Excel Formulas
Excel AND function is a logic comparison function that returns TRUE, if all specified conditions are met, and FALSE, if they're not. It In this guide, we’re going to show you how to use Excel AND function and also go over some tips and error handling methods....
by Ilker | Dec 25, 2018 | Excel Tips & Tricks
You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we're going to show you how to hide named ranges in Excel using VBA. How to hide named ranges using VBA Named ranges are objects in a...
by Ilker | Dec 25, 2018 | Excel Tips & Tricks
Hidden named ranges can be tricky to find and work with. This article will guide you through how you can show named ranges that were hidden using VBA.How to show named ranges that were hiddenNamed ranges are objects in a workbook’s Names collection and they have...
by Ilker | Dec 21, 2018 | Excel Formulas
AVERAGEIF function takes the average of the values in a range of cells that match a criteria. In this guide, we’re going to show you how to use the AVERAGEIF function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax...
by Ilker | Dec 21, 2018 | Excel Formulas
COUNTIF counts the values in a range of cells that match a given criteria. In this guide, we’re going to show you how to use the COUNTIF function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax COUNTIF(range,...
by Ilker | Dec 21, 2018 | Excel Formulas
SUMIF function can sum up the values in a range of cells that match a single criteria. In this guide, we’re going to show you how to use the SUMIF function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax SUMIF(range,...
by Ilker | Dec 21, 2018 | Excel Tips & Tricks
The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music. However, standard keyboards don’t have a button for this useful symbol. In this article, we’re going to show you 4...
by Ilker | Dec 21, 2018 | Excel Tips & Tricks
A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it’s used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use...
by Ilker | Dec 18, 2018 | Excel Tips & Tricks
Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...