Mastering MS Excel for Reporting

Excel is a tool that enables most professionals to be more productive and efficient in managing data. While there are other database systems like Oracle (ORCL) and SAP (SAP) being used in HR related functions, exporting that data into Excel allows users to discover trends, summarize expenses and hours by pay period, month, or year, and better understand how the workforce is spread out by function or pay level. It allows HR professionals to create a spreadsheet full of employee data and analyze financial implications for cost planning.
 

This training course is designed to provide participants with techniques, applications, and basic knowledge on using MS Excel for reporting and preparing HR related documents such as employee compensation, salary, leave, benefit, and the like. 

• Gain a comprehensive understanding of MS Excel techniques and applications used in reporting, particularly in HR related tasks and documents.
• Create special flash and management reports by linking Excel with Access, web, text, SQL, and other databases
• Use pivot tables and pivot charts to prepare the HR report, analysis, and reconciliation most efficiently.
• Repeat tasks and generate reports efficiently by recording, running, and editing macros
• Acquire numerous tips and tricks that will improve working efficiency