Customizing How Excel Saves files and Save settings
Saving is probably the first thing user learns in any application software. Same was the case with me when I stumbled on a software that has mysterious boxes that made no sense to me at that time. And still the very first shortcut I learnt in Excel was Ctrl+S. And from novice to Excel Pro […]
Payroll Calculation in Excel - Differential Piecework with Multiple Scales - How To
Differential piece work wage payments with multiple rate brackets or scales Excel Skill Level: Intermediate [It is strongly recommended if you are new to excel then go through previous tutorials in the series] For the purpose of this tutorial you need to download this excel file In our previous examples things were simpler as we […]
Payroll calculation in Excel - Simple Differential Piecework - How To
Differential Piece Work Wage Payments Excel Skills level: Beginner to Intermediate For the purpose of this tutorial you need to download this excel file In this wage system employees are given incentive for increased productivity. In this system different tiers slabs or scales of output are defined and progressive slab has increased wage rate. Calculating […]
Payroll calculation in Excel - Piecework with Guaranteed wage - How To
Payroll calculations under Piece work with guaranteed wage Excel Skill level: Beginner For the purpose of this tutorial download this excel file In many cases labour force is offered guaranteed wage. In this system wage of employee is calculated on the basis of units produced but if wage is below certain amount then he is […]
Payroll calculator with Piece Work wage payments in Excel - How to Series
In every organization small or big we have to process salaries and wages also known as payroll. And this process is carried out sometimes on monthly basis or weekly and sometimes on daily basis as well. This is a repetitive process that accountants cannot escape and if wage calculation basis are little complex then one […]
Payroll calculation in Excel - Straight Piecework Wage System - How To
Straight Piecework Wage System Excel Skill level: Absolute Beginner For this tutorial download this excel file In this system a fixed wage is given for each unit produced and whatever number of units are produced by the labour are multiplied with that particular rate. In short it is: no. of units produced x wage rate […]
Custom Autofill series and Custom sorting with Custom lists in Excel
If you are already using some of Excel’s custom features then you probably are already in love with them. Few days back we discussed custom views option and how it can help us. Today we have another custom feature of Excel - Custom Lists. Custom lists helps us notably in two ways: by having our […]
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys again to get the tax liability calculated. But we have a rescue pack for you in the name of Excel! Many […]
Using SUMIF with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an alternative to VLOOKUP function and it is much easier to use as well. However, using this formula with dates is a […]
How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency sign in excel?
In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when it comes to currency by default we have Dollar ($) as currency and not every country have this currency nor have the same currency sign. Accountants who are new often struggle […]
