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 | Mar 6, 2023 | Blog, Tutorial
Excel is a powerful tool that has been widely used in the business world for decades. While it is commonly associated with financial analysis and data management, entrepreneurs often use Excel to build applications that are viable and specifically tailored to a niche...
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 | Nov 28, 2022 | Excel Tips & Tricks
Excel's extracting data capability is not a new thing. However, it has become more flexible with Power Query. In this guide, we're going to show you how to extract data from a website in Excel. Download Workbook Extracting data from a website in Excel by using Power...
by Ilker | Nov 25, 2022 | Excel Tips & Tricks
If you ended up in this article, you should have already seen the message "Microsoft has blocked macros from running because the source of this file is untrusted." Microsoft has recently started to show this message in Office products when users open a file that came...
by Ilker | Nov 25, 2022 | Excel Tips & Tricks
Excel's Grouping or "outline" is a fancy feature to wrap up and summarize data in a compact view. It is a common scenario that you may see the button are greyed out. In this article, we are going to show how to enable grouping in Excel. Shared workbooks A shared...
by Ilker | Nov 24, 2022 | Excel Tips & Tricks
If you wonder why your graphs vanish after you hide or filter data, you are in the right place. In this guide, we’re going to show you How to show hidden data in chart in Excel. Download Workbook Why does a chart not show hidden data? This is a feature and default...