November 2016

HLookup function of Lookup & Reference MS Excel Previous Post: VLookup function Lookup & Reference Microsoft Excel 2016 Alright, the previous post was on the VLookup function of the Formulas tab. Basically, this function helps us to retrieve answers referring from a column of a Table. Particularly, this table is in the Vertical direction. In fact, “V” is for Vertical, […]

VLookup function of Formulas tab Excel 2016 Previous Post: Splitting data using Text to Columns button Microsoft Excel 2016 The Previous post was about the Text to Columns button of the Data tab. It helps to split any single column tabular data into multiple columns. To split any column data, it must be selected first, then the Text to Columns tool […]

Split content use Text Columns button Excel 2016 Previous Post: Apply Filter on data with Cells in worksheet Microsoft Excel 2016 While working in Microsoft Excel, there are often times, when we need to separate the data. The content present in a single cell has to be split into other cells from a single cell. So, in […]

Apply Filter on content in spreadsheet Excel 2016 See Previous Post: Using Flash Fill feature tool worksheet Microsoft Excel 2013 In this post, we’ll explain about, What is the use of the Filter ? And, How to Apply Filter in a workbook ? In the first place, before answering these questions; let us know the positions of the Filter button […]

Use Flash Fill feature of Microsoft Excel 2016 See Previous Post: Advantages Text Box over Cell content Microsoft Excel 2016 Through this post, we’ll discuss about; How to Use Flash Fill feature ? This remarkable tool had been introduced in Excel, from the 2013 version. Also, the other things to know, are the Column and the Row in the […]