- Duration: 8 Hours
Course details
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
Course Location
About 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.
See all PayrollServe courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- MS Office 365 Core Apps Skill-UpSGD 29
SGD 298Duration: Upto 1 Hour - Advanced Excel Formulas eduCBASGD 28Duration: Upto 2 Hours
