This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. Microsoft Excel as a savvy tool for enabling quantitative and research skills. HR data is either entered manually in Excel or downloaded from HRIS. For an evidence-based approach, it must be analyzed and summarized to reveal key indicators. Ordinarily, gleaning action-ready information from a large dataset could be challenging for many employees. This course focuses on Excel tools that will add to your perceptiveness and insight into data for effective decision making. On completion of this course, you will • Learn how to create and maintain well formatted data in Excel. • Use the advance tools and complex criteria to filter and query the data. • Create and apply custom criteria for sorts and nested sub-totals. • Use PivotTable to create complex, well formatted summary reports effortlessly. • Apply formula based conditional formatting to sort and filter visually. • Create a dynamic HR dashboard in the class to reveal and monitor key indicators. • In short, on completion of this course, you will be able to perform many analytical tasks with ease, speed, and a great level of confidence. View the detailed course outline on the course description page of our website.

This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. The course focuses on learning Excel formulas and functions and their applications in various HR scenarios. Learn a variety of Excel functions designed to tackle quantitative tasks for effective decision making. Orientate your approach towards automating tasks with logical functions and reducing tedious labor with Excel time savers. On completion of this course, you will be able to • perform many calculations with ease, speed, and a great level of confidence. • manipulate text-based data. • perform effective lookups. • set a worksheet on autopilot with logical functions. • create and manage budgets, metrics, and projections with ease. • create business charts to display the key HR indicators. • design a form for collecting HR data with validation rules. • create a template. • use Excel as a system with far-reaching capabilities. View the detailed course outline on the course description page of our website.

This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. Microsoft Access is a widely used desktop database application for business, commercial, and industrial purposes. As a relational database, it organizes data into tables that can be interconnected. Additionally, it features a robust query tool, enabling users to retrieve information from the database for reporting and decision-making purposes. The Access for HR & Admin Professional course is an introductory program tailored for HR and Admin personnel eager to discover how MS Access can significantly benefit a Human Resources department. The practical exercises are HR-centric, providing a solid foundation in desktop database creation. Participants will learn to construct a new Access database with employee data, establish Table Relationships, and develop Queries, Forms, and Reports. Additionally, the course enhances confidence in managing existing databases, given that databases form the core of all HRIS software. For a comprehensive understanding of the course content, please consult the detailed outline available on the course registration page. After completing the one-day intensive course, the participant will be able to • Get a good understanding of MS Access interface, objects, and features. • Create a new HR Database in MS Access. • Identify the elements of a Table design in Access. • Create multiple Tables for storing employee data. • Understand and setup relationships between the Tables. • Identify the elements of a Query design in Access. • Create multiple Queries to extract the right information for decision making. • Create a Form for easy data entry. • Create a professional Report for printing or PDF making.

This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. Microsoft Access is a widely used desktop database application for business, commercial, and industrial purposes. As a relational database, it organizes data into tables that can be interconnected. Additionally, it features a robust query tool, enabling users to retrieve information from the database for reporting and decision-making purposes. The Access for HR & Admin Professional course is an introductory program tailored for HR and Admin personnel eager to discover how MS Access can significantly benefit a Human Resources department. The practical exercises are HR-centric, providing a solid foundation in desktop database creation. Participants will learn to construct a new Access database with employee data, establish Table Relationships, and develop Queries, Forms, and Reports. Additionally, the course enhances confidence in managing existing databases, given that databases form the core of all HRIS software. For a comprehensive understanding of the course content, please consult the detailed outline available on the course registration page. After completing the one-day intensive course, the participant will be able to • Get a good understanding of MS Access interface, objects, and features. • Create a new HR Database in MS Access. • Identify the elements of a Table design in Access. • Create multiple Tables for storing employee data. • Understand and setup relationships between the Tables. • Identify the elements of a Query design in Access. • Create multiple Queries to extract the right information for decision making. • Create a Form for easy data entry. • Create a professional Report for printing or PDF making.

This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. Microsoft Excel as a savvy tool for enabling quantitative and research skills. HR data is either entered manually in Excel or downloaded from HRIS. For an evidence-based approach, it must be analyzed and summarized to reveal key indicators. Ordinarily, gleaning action-ready information from a large dataset could be challenging for many employees. This course focuses on Excel tools that will add to your perceptiveness and insight into data for effective decision making. On completion of this course, you will • Learn how to create and maintain well formatted data in Excel. • Use the advance tools and complex criteria to filter and query the data. • Create and apply custom criteria for sorts and nested sub-totals. • Use PivotTable to create complex, well formatted summary reports effortlessly. • Apply formula based conditional formatting to sort and filter visually. • Create a dynamic HR dashboard in the class to reveal and monitor key indicators. • In short, on completion of this course, you will be able to perform many analytical tasks with ease, speed, and a great level of confidence. View the detailed course outline on the course description page of our website.

This is a one-day, hands-on, instructor-led course delivered ONLINE. Attend it from anywhere. We have several course dates available. The course focuses on learning Excel formulas and functions and their applications in various HR scenarios. Learn a variety of Excel functions designed to tackle quantitative tasks for effective decision making. Orientate your approach towards automating tasks with logical functions and reducing tedious labor with Excel time savers. On completion of this course, you will be able to • perform many calculations with ease, speed, and a great level of confidence. • manipulate text-based data. • perform effective lookups. • set a worksheet on autopilot with logical functions. • create and manage budgets, metrics, and projections with ease. • create business charts to display the key HR indicators. • design a form for collecting HR data with validation rules. • create a template. • use Excel as a system with far-reaching capabilities. View the detailed course outline on the course description page of our website.