Tag Archives: Excel-Function

How to Extract few Numbers using Excel Functions

Excel is a great application spreadsheet software which is used for complex calculations. During working on the Excel you can feed different kind of data. If you have any number is range of cells and want to extract few numbers using Excel functions. In this article we have to guide how to extract few numbers with the help of Value and Left functions in Excel. Read More

How to insert symbols and special characters in Excel

Excel is an important utility application software. It is used for data analysis, modelling, charting, calculations, apply lot of functions for complex calculation and many more. Sometime we need to insert symbols and special characters in Excel, but most of the symbols and special characters does not shown in your keyboard. Read More

How to use Solver command in Microsoft Excel

Solver is an another important utility of Microsoft Excel. With the help of solver you can easily find an optional value which is also called objective cell that satisfies all constraints and maximize or minimize the objective cell value. In this article we have to discuss how to use solver command in Microsoft Excel. Read More

How to use Goal Seek feature in Microsoft Excel

Goal Seek is an important utility of Microsoft Excel. It is an important part of What-If-Analysis, which allows you how to one value in the formula impacts to all of the other values. Goal Seek is the best tool used to find the result by adjusting an input value. In this article we have to discuss how to use Goal Seek feature in Microsoft Excel. Read More

How to split full name into First and Last name in Excel

Suppose you have a large worksheet in which first and last name are combined together in a single column as a full name. Now, It’s difficult to split full name into first and last name in Excel. Now, there is no need to worry this article helps provide quick ways to split full name into first and last name in Excel. Read More