تفاصيل الدورة
The workshop caters for HR/Payroll Personnel who require the use of MS Excel for payroll reconciliation or reports generation. Through practical hands-on sessions, workshop participants will learn how to prepare accurate reports in a much shorter time, freeing up time to concentrate on more important tasks.
Introduction
- Excel orientation
- Creating a new spreadsheet
- Formatting font & cells
- Customising worksheet printouts
- Setting up security restrictions and excel data protection
- Shortcut key commands
Basic Excel Functions
- Adding a group of numbers
- Computing data based on dates
Text / Number Excel Functions
- Showing count of characters of data in cells
- Displaying partial content in other cells
- Modifying presentation of data in cells
- Rounding numbers (upwards & downwards)
Lookup Excel Functions
- Comparing and verifying information gathered from different excel worksheets
- Auto-formatting of important data
نبذة عن معهد PayrollServe
We_They cutting-edge solutions and team of experienced professionals have earned us the reputation of being Singapore’s leading provider of web-based, cloud-based and fully managed We_They and HR services and solutions. This makes us the prime choice for internationally active businesses across diverse organisation types and industries.
We_They is the Payroll and HR Administration Services division of Chio Lim Stone Forest, the largest accounting and business advisory group outside the Big 4 in Singapore. We are part of a team of more than 950 professionals in Singapore and 320 in China, specialising in areas such as Payroll, Human Resources, Accounting and Tax.
عرض الجميع دورات PayrollServe- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Sage 50 Accounts & Payroll Diploma St. Paul's College47 درهم
1,194 درهممدة الدورة التدريبية: Upto 8 Hours - Microsoft Excel : VLOOKUP Formula Course Central84 درهم
367 درهممدة الدورة التدريبية: Upto 1 Hour
