by Ilker | Nov 29, 2022 | Excel Tips & Tricks
Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a feature...
by Ilker | Jun 27, 2022 | Excel Tips & Tricks
An array is a collection of similar-type values or objects in computer science. This isn’t different for Excel. The only caveat is that Excel has two definitions for arrays, one for workbooks and the other for VBA. In this guide, we’re going to show you How to get the...
by Ilker | Apr 4, 2022 | Excel Tips & Tricks
Although manual calculation mode helps to deal with big files that take seconds or minutes to be calculated, waiting for the calculation of the entire workbook may not be convenient. Instead, it would be better to calculate certain cells for quick try-error changes....
by Ilker | Mar 31, 2022 | Excel Tips & Tricks
The ability to create a User-Defined Function (UDFs in short) is an awesome feature of Excel. It basically removes the limitation of built-in functions. Aside from coding them, storing and distribution of UDFs are another point. In this guide, we’re going to show you...
by Ilker | Feb 21, 2022 | Excel Tips & Tricks
If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...
by Ilker | Nov 9, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to save each sheet as CSV in Excel. Download Workbook Excel to CSV Saving an Excel worksheet as a CSV file is an easy task. All you need to do is to use Save As section in File menu and select the CSV as the file type. This...
by Ilker | Nov 2, 2021 | Excel Tips & Tricks
Apparently, Excel doesn't have a hover (mouse over) event support for cells. However, we can use the HYPERLINK function to mimic this functionality, thanks to mouse-over support for hyperlinks in Excel. In this guide, we’re going to show you how to trigger a macro by...
by Ilker | Nov 1, 2021 | Excel Tips & Tricks
It is common to lose your way in a big table of data. Even though Excel's freezing features help you to display selected row and column's primary data, no feature can beat highlighting to express the selected data. In this guide, we’re going to show you how to...
by Ilker | Sep 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...