Deliver Human Resource requirements using MS Excel (2010-365 versions). This webinar is designed to present a sample of instructor-led exercises that conform to generally accept standard data structures of a Human Resource Information System (HRIS) using MS Excel as the mode of development.
The data visualization reports for HRIS include: Employee Master, Training, Dependents, On-Boarded and Off-Boarded Employees, Leaves, Tardiness Absences, Assigned Supervisors, Prior Work Experiences, Compensation Summary, Recruitment Data, Time and Attendance.
Microsoft Excel provides the following salient features: tabular data using format as table, dynamic naming for formula creation, advanced features (Xlookup, filter, Xmatch, Vlookup, Lookup, Index-Match, and Hlookup), connecting to web-based data sources, creating navigable and hyperlinked menus, geographical maps, and auto-data consolidation capability.
An email with a Zoom link should be with you an hour before the event. If it's not in your inbox, please check your spam folder. The email is from maan.yu@nordcham.com.ph.
Oct 26, 2020
9:00 AM - 10:00 AM GMT+8
The European Innovation, Technology, and Science Center Foundation (EITSC) is an initiative of several European and Philippine development-oriented organizations.
Vision
To be a catalyst in driving innovation, technology, and science in the Philippines, and support equitable and inclusive economic growth in the country.
To be a partner of choice in knowledge building and skills enhancement stimulating interest among the youth and the Filipino professionals to see innovation, technology and science as their future.
To be a hub for Compliance Management with emphasis on Governance, Risk, & Compliance (GRC) Competence in Data Privacy and Security, Cyber Security, Anti-Trust and Anti-Corruption.
Mission
We help build lives through youth development and professional training.
We assist organizations in compliance management through consultancy, training and the automation of policies, procedures and controls.