Microsoft Excel Tips

Sum Cells Text Numbers within same Cell Microsoft Excel

Sum Cells Text Numbers within same Cell Microsoft Excel

Add Numbers Text of multiple cells Excel 2016 Previous Post: SumIf function of Formulas tab in Microsoft Excel 2016 This post guides us on about Sum Cells Text Numbers. The prior post, illustrates about the SumIf function. It is part of the Math Trig functions of the Formulas tab. This function helps users to add numbers on […]

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 →

Understand Quick Access Toolbar (QAT) in MS Excel

Understand Quick Access Toolbar (QAT) in MS Excel

Utilize Quick Access Toolbar (QAT) Excel 2016 See Previous Post: Set Printing for worksheet document Microsoft Excel 2016 Let us understand about the Quick Access Toolbar. So, the QAT plays a very important role in Microsoft Excel. Also, it’s quite interesting to know about it, but overlooked by most of the users. This toolbar is the top right most […]

Read More →

Read More →

Top