Are you a Human Resource or Finance personnel that manages employees’ payroll computation? You will agree with me that in preparing staff payroll there are a number of computations that are required based on statutory requirements and the organization’s policies. In this training, we will look at how to design an Excel template that computes …
How To Compute Employee Seniority Bonus in Excel Automatically Read More »
Accounts receivable also known as debtors are customers that owe your business due to credit sales. This item is captured as current assets on the balance sheet and a vital area of any business financials. If this aspect of your business is not properly managed, it can result in a loss of assets. In this …
If you sell physical goods and tracking your inventory has been a challenge then here is an easy-to-use tool that will do the job for you. When I say tracking your inventory, I mean your ability to keep track of the movement of the goods you buy and sell. Here are the benefits of what …
How To Design An Inventory Tracker Excel Template Read More »
You have an invite with the date of the event stated as 20/03/2023 I believe the first thing you would love to know is what day of the week is 20/03/2023 The WEEKDAY Excel function can be of great help. The function returns a number from 1 (Sunday) to 7 (Saturday) which represents a day …
The DATEDIF Excel function calculates the number of days, months, or years between two dates. The DATEDIF function is one of the undocumented functions in Excel. This means that when you input the Excel function it will not pop up any suggestion as Excel will do for all other functions that are documented. The good …
In a two-way lookup, you will have to get the value at the point of intersection of a column and a row. In such a scenario, you will have two criteria to test. We shall use the knowledge from advanced lookup functions to generate this dynamic report from an extensive database using a two-way lookup. …
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 »
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 = …
