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