by Ilker | May 11, 2023 | Blog, Tutorial
Excel provides a wide range of user interface features that allow users to interact with the application. However, these features can be time-consuming to use, especially when performing repetitive tasks. Macros can be used to automate these tasks and streamline the...
by Ilker | May 4, 2023 | Blog, Tutorial
Incorporating VBA-based UDFs (User-Defined Functions) in Excel empowers users to extend the functionality of their spreadsheets beyond the standard set of available functions. By leveraging VBA (Visual Basic for Applications), a versatile programming language native...
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 | Nov 29, 2022 | Excel Tips & Tricks
Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack of fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a...
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 | Sep 13, 2021 | Excel Tips & Tricks
Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
by Ilker | Jul 30, 2021 | Excel Tips & Tricks
Numeric values are defined by data types like integer or byte. These data types are used for optimizing the processing and memory allocation in Excel. In this guide, we’re going to show you how to convert string into number in Excel VBA. Download Workbook Data types...
by Ilker | Jun 22, 2021 | Excel Tips & Tricks
Excel VBA allows you to open a workbook directly - all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show you...
by Ilker | Jun 21, 2021 | Excel Tips & Tricks