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...
by Ilker | Dec 18, 2018 | Excel Formulas
Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling methods.Supported...
by Ilker | Dec 18, 2018 | Excel Formulas
Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods.Supported versionsAll...
by Ilker | Dec 10, 2018 | Tutorial
This tutorial shows how to create multi-level columns in designer applications, effectively ‘categorizing’ columns into multiple levels. A typical example is a monthly data table grouped into quarterly sections. We’re going to be using a monthly...
by Ilker | Dec 5, 2018 | Excel Macros, Resources
Getting rid of specific cells could prove challenging if you were to do it manually. In this article, we’re going to show you how to make Excel delete rows with value of your choosing, using VBA. You can remove cells with certain strings or create an input cell...
by Ilker | Nov 26, 2018 | Excel Formulas
The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods. Supported versions All Excel versions Excel MID...
by Ilker | Nov 26, 2018 | Excel Formulas
The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the RIGHT function and also go over some tips and error handling methods. Supported versions All Excel versions...
by Ilker | Nov 26, 2018 | Excel Formulas
The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods. Supported versions All Excel...
by Ilker | Nov 26, 2018 | Excel Macros, Resources
Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...