Payroll calculation in Excel

In this Excel tutorial 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 wages in this system is not simple as it was in earlier cases. Because in this situation first we have to identify the number of units employee has identified. Then we have to look up for the slab in which that output......

Read more »

The best things of Office 365

The new Microsoft Office: As with the previous versions, you can get Word, Excel, PowerPoint and more as a locally installed suite of applications or as Office 365, a cloud-based subscription. However, choosing between Office 2013 desktop software and the new Office 365 is a dramatically different decision than in the past. This time, there is virtually no decision to make. Comparing Office 2013 to Office 365 is an exercise in semantics;......

Read more »

How to Add a Filter in Excel 2007-2010-2013

For example your worksheet contains a lot of content, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need. How to filter data: In this example, we'll apply a filter to an equipment log worksheet to display only the laptops and projectors that are available for checkout. In order for filtering to work correctly, your worksheet should......

Read more »