true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Generate Employee Payslip using Excel & VBA Macros

Venkata Seshasai Kanuru

14/10/2016 1 0

yes we can generate the Payslips for each employee from a huge data in the excel.

We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the employees.

ALL THIS JUST USING EXCEL AND MACROS

No need to purchase any software

Yes its Excel and VBA macros.

Excel is not Clerical job ...its Clever Job.

1 Like 0 Dislike

Follow 0

Peggy Wong | 08/02/2020

hi do you have singapore format for the payslip run by excel vba

0 0

Other Lessons for You

AND Function In Excel

Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE. Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than...

Rajan Ghadi

1 0

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.

In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0

A Look at the State of Connected Devices in 2017

The connected devices trend is one that seems to be growing at a faster rate each year. This calendar year will be no different, as more and more companies continue to get involved. But where exactly do...

Rajesh N V

2 0

Create a Grading in Excel using Formulas (All versions)

Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

0 0

Pivot Tables

Pivot table and a very powerrfull feature in Ms-Excel . it is used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information...

Kavita V.

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

What should I learn other than excel VBA training?

17 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

What does the VLOOKUP in MS Excel function do?

5 Answers

I have got over ten years in customer service. Currently working as a team leader in an MLM company....

5 Answers

Which course can be related to MIS executives, Since I have past experience in data base related job...

32 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.