Follow the steps in this video tutorial to learn how you can design a search box that filters partial and exact match in Excel. Understanding how to design this will help you extract specific data from an extensive database to a different section on the same worksheet. You can watch the video tutorial here. Ensure …
HOW TO DESIGN A SEARCH BOX THAT FILTERS PARTIAL AND EXACT MATCH Read More »
Imagine having a large database of employee details and you desire to search for an employee that starts with a particular First Name. You will either have to scroll through the large worksheet to get details of such employees or better still activate the Filter option in Excel. In this tutorial, I will share another …
HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT MATCH IN EXCEL Read More »
Imprest is a fixed amount of funds set aside for petty or small expenditures and replenished back to float when the balance is below the minimum level. In this tutorial, you will learn how to design an automated Excel template that keeps track of imprest and petty cash expenses. This template will help you track …
Excel For Accountants – How To Design A Petty Cash Excel Template Read More »
Cashbook is a book where cash and bank transactions are recorded. In other words, is a book that records transaction that affects cash and bank balances. In this training, I will show you how to design an automated cash book in Excel. Watch the training here If you don’t want to go through the process, …
Do you know there is an Excel function that easily computes the square root of any number? First of all, let me explain what a square root means. By illustration, here is what a square root mean. 2 x 2 = 4 right, then the square root of 4 is 2 3 x 3 = …
Record-keeping or Book-keeping is an integral part of any business that wants to grow and succeed. There are different parts to record-keeping and in this video, I will show you how to maintain a Credit Purchase Book in Excel. The Credit Purchase Book is an Excel template that helps you track all credit purchase transactions …
The INDEX function returns a specific value from a one-dimensional or two-dimensional range. The MATCH function returns the relative position number of an item. The INDEX function actually returns the value in the cell, not the position. Let’s examine the INDEX function syntax below =INDEX (array, row_num, [column_num]) The array (First argument) is the range …
The MATCH function returns the position of a value in a given range. Let’s examine the function syntax =MATCH(lookup_value, lookup_array, [match_type]) lookup_value is the first argument in the Function syntax. It can be a cell reference, value or text string. lookup_array is the second argument in the function syntax. This is the cell range to …
If you are an accountant, cashier, bookkeeper or finance person in any capacity, you will agree with me that the task of reconciliation can be daunting when you don’t have the right tool at your disposal to make it easier. Microsoft Excel is a tool that is used by a wide range of individuals across …
HOW TO RECONCILE BANK STATEMENT AND CASH BOOK IN EXCEL Read More »
The VLOOKUP function is used to look up values in a cell range and returns a value that is in the same row as the specified lookup value. Let’s examine the function syntax for better understanding: =VLOOKUP(Look_value, table_array, Col_index_num, [range_lookup]) The Look_value is the first argument in the VLOOKUP syntax above – this the value …
