Usually, we need to do many tasks repeatedly while creating spreadsheets in Excel. These include clearing cells, deleting ranges, printing ranges, etc. You can automate these tasks with the help of VBA in Excel. Here, we will learn how to insert a command button to Clear Contents of a specific range in Excel.
How To Add Clear Content Button in Excel? Read More »
Ready-to-use Employee Attendance Sheet in Excel, OpenOffice Calc & Google Sheet to manage the attendance of 50 employees. Record attendance of your employees in just 3 easy steps: Enter year and select the month, Mark attendance for each date from the dropdown list for each employee, and Save data to Yearly Attendance Record with a click of a button.
Download Employee Attendance Sheet Excel Template Read More »
In this article, we will learn the step-by-step process to pull data from another sheet in Excel and OpenOffice using Macros and Advanced Filter Option. In Google Sheets, it uses the inbuilt FILTER Function. All the techniques consist of an example to understand the complete process.
How To Pull Data From Another Sheet Based On Criteria? Read More »
Accounts Receivable Template in Excel, OpenOffice Calc, and Google Sheets to record & manage client-wise account receivable ledger with aging. Just insert your invoices in Accounts Receivable Ledger and the template automatically saves the debtor’s receivable data in their respective file. It uses the Advanced Filter Function as well as predefined macros.
Ready-to-use Accounts Receivable Excel Template Read More »
SpellNumber Sri Lankan Rupee is an Excel Function manually created with VBA code to change the given number in written words in Sri Lankan Rupees. In simple terms, inserting this function allows you to display the numbers in Sri Lankan Rupee.
SpellNumber Sri Lankan Rupee Function In Excel Read More »
Salary Slip Format Sri Lanka in Excel, Google Sheets, and OpenOffice Calc that helps to make salary slips as per the Sri Lankan pay structure. We have created this template on the basis of the salary structure in Sri Lanka. It is simple and easy to use. Insert the Basic, applicable allowances and deductions. That’s it, your salary slip is ready to print.
Ready-To-Use Salary Slip Format Sri Lanka Read More »
Download Free Salary Slip Format in Excel, Google Sheets, and OpenOffice Calc that helps you prepare the salary slip in minutes. Salary Slip UAE English version and Salary Slip UAE Arabic version. These salary slips are designed based on the UAE Salary structure. Simple and easy to use. Just enter the credentials and your payslip is ready.
Ready-To-Use Salary Slip Format UAE Read More »
Simple Salary Slip and Corporate Salary Slip. These salary slips designed based on the Indian Salary structure. Simple and easy to use. Just enter the credentials and your payslip is ready.
Ready-To-Use Salary Slip Excel Template – India Read More »
Simple, easy, and fully automated Payroll Excel Template with attendance. A simple 3 step process to manage your company payroll: Mark the attendance, Insert CTC & applicable allowances/deductions, and print salary slips of all 50 employees in just one click.
Ready-To-Use Payroll Excel Template With Attendance Read More »
Download Employee Salary Sheet Template in Excel, Google sheet, and OpenOffice Calc to easily process salaries of 50 employees as per Indian laws. This Salary Sheet auto-calculates all the allowances and deductions including EPF (employee provident fund).
Ready-To-Use Employee Salary Sheet Excel Template – India Read More »
