MS Excel for Administrative Professionals

INTRODUCTION

Administration workers will learn how to save time on their regular activities in this training. We will present participants with recommendations to assist them overcome the issues they have while working on employee remuneration, salary, leave, benefits, and the like in a fraction of the time. Participants will practice formatting approaches to transform data from various sources and learn how to make the greatest use of the most significant formulae throughout this course. They will design relevant charts and diagrams, employ logical functions, and connect their spreadsheet to other worksheets and programmes. Participants will also learn how to automate certain simple Excel activities, do advanced analysis, and resolve issues.

Excel tools improve our productivity and efficiency. Investigate the use of Excel as an audit and analytical tool, as well as chosen features that aid in the preparation of reliable reports.

COURSE METHODOLOGY

This course is designed in the form of workshop which will includes a variety of learning tools to help participants function effectively and efficiently in a multifunctional environment through various methodologies including;

• Short lectures
• Brainstorming
• Case studies
• Group activities
• Role playing

COURSE OBJECTIVES

The attendees of this Certificate Program will be able to:

• Improve your Excel reporting abilities in HR and administration by practicing data slicing and dicing, data massaging, and data analysis.
• To accomplish automated report authoring and analysis, use pivot tables and pivot charts.
• Create operational dashboards that include business KPIs.
• Record, execute, and edit macros to effectively repeat processes and create reports.
• Learn a variety of strategies and tricks for increasing job productivity.

WHO SHOULD ATTEND THIS COURSE?

• HR and administration professionals
• Compensation and benefits professionals
• HR reward and payroll professionals
• HR managers
• Students
• Anyone who is seeking improvement in skills for enhanced performance and career development

TARGETED SKILLS

• Data modeling
• Integration with external data sources
• Report structuring techniques
• Automation of routine tasks
• Charting and visualization techniques
• Leveraging pivot table powers