HLookup function of Formulas tab in Microsoft Excel 2016

HLookup function of Formulas tab in Microsoft Excel 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, […]

Read More →

Read More →

VLookup function of Lookup & Reference in Microsoft Excel

VLookup function of Lookup & Reference in Microsoft Excel

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 […]

Read More →

Read More →

Splitting data using Text to Columns button worksheet MS Excel

Splitting data using Text to Columns button worksheet MS Excel

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 […]

Read More →

Read More →

Apply Filter on data with Cells in worksheet Microsoft Excel

Apply Filter on data with Cells in worksheet Microsoft Excel

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 […]

Read More →

Read More →

Using Flash Fill feature introduced from Microsoft Excel 2013

Using Flash Fill feature introduced from Microsoft Excel 2013

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 […]

Read More →

Read More →

Advantages of Text Box over Cell content in Excel 2016

Advantages of Text Box over Cell content in Excel 2016

Benefits of Text Box in worksheet MS Excel See Previous Post: Understand Quick Access Toolbar (QAT) Microsoft Excel 2016 In this post, we’ll know about the advantages of the Text Box. First of all, the Text-Box is part of the Text group. This group is present in the Insert tab ribbon. Also, the Text Box can be find inside the Shapes […]

Read More →

Read More →

Top