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 23, 2022 | Excel Tips & Tricks
Although Excel has a handful advanced filtering feature to filter by multiple criteria, it is not dynamic and may require complex prep work. On the other hand, the FILTER function can give the dynamic approach you need. However, establishing logical rules can be hard...
by Ilker | Nov 22, 2022 | Excel Tips & Tricks
If you ended up in this article, it's a big probability that you had referred a column or cell in your Excel table and press F4 and finally heard the annoying chime. Fortunately, you haven't given up and made manual changes on the references. In this guide, we’re...
by Ilker | Nov 2, 2022 | Excel Tips & Tricks
You might have already seen that Excel's date-related functions return errors or incorrect values with external data. The most common reason is the difference between date formats, such as reverse day and month figures. Usual scenario between US and European...
by Ilker | Nov 1, 2022 | Excel Tips & Tricks
Date formats vary between countries. If you need to work with external source reports from a different country, you may see that Excel doesn't recognize the dates or recognize them wrongly. The most common case happens between US and European countries because of the...
