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...
How to enable grouping in Excel

How to enable grouping in Excel

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...
How to show hidden data in chart in Excel

How to show hidden data in chart in Excel

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...
How to filter a table based on another in Excel

How to filter a table based on another in Excel

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

Excel TEXTBEFORE Function

The TEXTBEFORE function is a Text function that returns part before a given character or string. In this guide, we’re going to show you how to use the TEXTBEFORE function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider...
Excel TEXTSPLIT Function

Excel TEXTSPLIT Function

The TEXTSPLIT function is a Text function that returns an array of substrings split by a given delimiter. If you use the function itself, Excel spills the substrings into multiple cells as a regular dynamic array. In this guide, we’re going to show you how to use the...