When you use the conditional formatting feature in Excel to highlight duplicate values only, you will notice that any value that appears more than once will be highlighted not minding that your goal is just values that appear twice on your data set. To find only duplicate values on your data set, you will need …
HOW TO USE FORMULA TO FIND DUPLICATES AND TRIPLICATES IN EXCEL Read More »
Searching for an exact and partial word across multiple columns makes it easier to filter results that meet such criteria in the entire database. One of the benefits of using this search box feature is the ability to filter the results of the search item unto a different section for easy visibility and decision making. …
HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT & PARTIAL MATCH ACROSS MULTIPLE COLUMNS Read More »
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 …
