by Ilker | Feb 18, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
VCF (Virtual Contact File), also known as vCard, is a file format for business cards that has been in use since 1996. A VCF is a text-based file format can store various information like the contact name, phone number, and email address. Although Excel does not have...
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to run calculate median by criteria in Excel. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....
by Ilker | Feb 17, 2021 | Excel Tips & Tricks
With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. Download Workbook Application.OnTime VBA’s Application.OnTime...
by Ilker | Feb 16, 2021 | Excel Tips & Tricks
Although Excel doesn’t have a built-in feature for counting cells based on their font colors, filtering results by their font color is possible. In this guide, we’re going to show you how to count cells by font color in Excel. Download Workbook Steps Right-click...
by Ilker | Feb 16, 2021 | Excel Tips & Tricks
Although Excel doesn’t have a built-in feature to count cells by their colors, filtering cells by their color is possible. In this guide, we’re going to show you how to count colored cells in Excel. Download Workbook Steps Right-click on a colored cell in the...
by Ilker | Feb 16, 2021 | Excel Tips & Tricks
In this guide, we're going to show you how to refer a range or a cell in Excel VBA. VBA Basics Before diving into the code, let’s start with a cell or a range means in VBA. First, VBA is an object-based programming language, which means that the language refers each...
by Ilker | Feb 15, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to fill blank cells simultaneously in Excel. Download Workbook How to locate blank cells Begin by selecting your data, including the blank cells Open the Go To Special dialog by following Home > Find & Select...
by Ilker | Feb 12, 2021 | Excel Tips & Tricks
Excel’s number formatting doesn’t support file sizes by default. However, it allows you to program your own formatting style. In this guide, we’re going to show you how to format numbers as file sizes in Excel. Download Workbook The number formatting is one the...