What IF analysis Function

by on August 3, 2017

What IF analysis Function Excel has great analytical functionalities with which one can easily test different scenarios and assess its effects on the results. What IF analysis function used to create scenarios. Assume you are planning to launch a new product or project.  The first step of your planning is to assess what amount of sales […]

Name Manager in excel

by on July 10, 2017

Name Manager in excel Name Manager in Excel is an important function where we give a name to a cell or range of cells. Instead of referring cells in our formula, we refer to the name. Here, we will learn how to use the Name Manager function in excel and what’s are its benefits.  Our aim […]

Accounting Ledgers in Excel

by on May 21, 2017

Accounting Ledgers in Excel Accounting ledgers provide details about the transaction in that particular accounting head. Ledgers are prepared from Journal entries and each entry is passed to ledgers. Here, we will provide the procedure of how you can prepare accounting ledger and excel with the help of pivot table features. Once set-up, you will […]

excel if statement

by on May 2, 2017

excel if statement “IF” function is a logical function which returns one value if the condition is met otherwise it returns other value. Below is the list of students along with their marks. We will use the “IF function” to arrive at the number of students passed the exams. Passing criteria is 40 or more […]