20+ Excel Table tricks to turbo charge your data
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
Introduction to Excel Tables - Data beyond just formatting
Many people think converting data into table is basically a formatting options giving it colours and other eye candies like giving data “zebra lines”. But there is much more to it beside data formatting and face lift that comes in terms of functionality and features that are available if data is maintained in tables. In […]
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 […]
Spell Checking and Proofing in Excel - Ten things to learn how it works
Although Excel is a spreadsheet but one of things it has borrowed from in-family word processor (Word) is Spell check feature. Excel uses the same kind of framework to find spelling mistakes in the worksheets. However, in excel things are not exactly same as normal word processor. In Excel you have to invoke spell check feature. Calling […]
Automating Data Entry using Data Validation in Excel
Profits is backed by revenue and revenue is backed by products entity is selling. Accountants often on daily basis have to prepare sales report. Two of the important ingredients of every sales report is the product name itself and price per unit. For such reports accountants often have to type products’ names and per unit […]
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 […]
