How to filter as you type without VBA in Excel

How to filter as you type without VBA in Excel

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...
How to extract data from a website in Excel

How to extract data from a website in Excel

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...
Excel TEXTAFTER Function

Excel TEXTAFTER Function

The TEXTAFTER function is a Text function that returns part after a given character or string. In this guide, we’re going to show you how to use the TEXTAFTER function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider Beta...
How to get filename from path in Excel

How to get filename from path in Excel

In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...