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

How to use COUNTIF Function

by on May 2, 2017

Countif Function COUNTIF formula counts the number of cells within a range based upon the single criteria/condition. It’s work similar to sumif function with the only change is that sumif function sums the numbers while countif count it. In the above, we want to calculate the total number of employees attended the office, the total […]

Conditional Formatting to Find Top 5 Numbers

by on May 2, 2017

Conditional formatting In the previous article, we explore the way how to use conditional formatting to highlight a cell value based upon a single condition. If you have not read it yet, you can do so by clicking here. In this article, you will learn how to use conditional formatting to find Top 5 Numbers […]