Different methods to Extract only Numbers from a Column

In this tutorial, I will show you 5 different ways to Extract only Numbers from a list of Strings. Following is a Table containing Text as well as Numeric Values and we will be using this data for explaining the different methods. FILTER Function to extract Numbers The ISNUMBER function in Excel can be used…

Slicers in Excel

Slicers are floating filters associated with PivotTable, PivotChart and official Tables in Excel. Apart from filtering data, Slicers also provide the current filtering status. In this blog post, we will see how to add Slicers for PivotTables and Excel Tables. We will also cover how to ‘Connect a Slicer to two or more PivotTables.’ Add Slicer for an…

Apply the same formula to an Entire Column in Excel

While dealing with tabular data in Excel, quite often you will need the same formula in multiple cells. Following are 3 quick methods to apply the same formula to an Entire Column in Excel. Using Keyboard Shortcut Ctrl + Enter is the keyboard shortcut to enter the same value or formula into multiple cells. So…

How to Connect Excel Tables

How to build Relationships between Excel Tables using the Data Model of Excel is explained in this Tutorial. Purpose of connecting Tables VLOOKUP and INDEX+MATCH formulas always get the job done, but a lot of them will essentially slow down the workbook. Moreover, the Lookup and Reference formulas also demands maintenance with addition or deletion…