Microsoft® Office Excel for HR (Basic-Int Level) +971501045727

The aim of this course is to provide targeted MS Excel tuition to meet the requirements of a job in HR. The course focuses on the key requirements of the average job description. The course acts as excellent preparation for job interviews and assessment centre and is ideal for those working in the industry but need to improve their Excel. skills. This course focuses on learning Excel formulas and functions and their application in various HR functions. With this course, you will be able to perform many calculations with ease, speed, and a great level of confidence. Take the course avoid manual labour and save your valuable time. Learn how to use logical functions for automating tasks. Create and manage budgets, metrics, and projections with ease. Create business charts and a dashboard to display key HR indicators. After the course, you will be able to use Excel as a system with far-reaching capabilities and functions.

Exploring Microsoft Excel • Starting Excel 2016 • The User Interface • The Backstage View • Excel Options • Working with Worksheets • Using the Ribbon • Hiding the Ribbon • Customizing the Quick Access Toolbar • Customizing Tabs • Customizing the Ribbon • Customizing the Status Bar • Exiting Excel • Practice – Exploring Microsoft Excel 2016
Cell Formatting • Merging Cells • Vertical Alignment • Splitting Cells • Adding Borders • Drawing Borders • Adding Fill Color to Cells • Pasting Formats • Format Painter • Copying Formats using Auto Fill • Clearing Formats • Inserting Selected Cells • Inserting Cut or Copied Cells • Deleting Cells • Practice-Cell Formatting
Basic Formulas • Using Basic Formulas • Entering Formulas • Basic Functions • Using the AutoSum Button • Using the AutoSum List • Using Formula AutoComplete • Editing Functions • Using Auto Calculate • Modifying Formulas using the Range Border • Error Checking • Creating an Absolute Addressing • Using the IF Function • Practice – Basic Formulas
Data Management • Sorting • Sorting Multiple Columns • Finding Data • Replacing Data • Finding and Replacing Cell Format • Practice – Data Management
Creating Charts • Inserting a column chart • Inserting a line chart • Inserting a bar chart • Inserting a pie chart • Resizing a chart • Adding a Chart Title • Changing the Chart Background • Changing a column, bar, line or pie slice colors • Changing the chart type • Adding a Data Table • Changing the Chart Layout • Copying and moving charts • Creating a 3-D Chart • Adjusting 3-D View • Deleting a chart
Advanced topics for HR use.. • Getting to know the shortcuts and ‘Time Savers’ • Using Flash Fill & Pick from List • Creating a custom list of HR items. • Refresher-basic formula & functions • Formulas for HR Metrics • Creating & using named ranges • Consolidating training budget using 3D formulas • Using text functions to tackle text data • Joining text with CONCATENATION function • Splitting text into columns • Using function TODAY to track years of service, tenure and contracts • Using logical functions IF, AND, OR for automation, calculation and tracking key indicators • Setting up VLOOKUP function to retrieve HR data efficiently • Creating an Employee Lookup • Extracting figures with custom logic using SUMIF & COUNTIF functions • Creating business charts from HR data • Linking several workbooks to create a summary • Creating an HR Form & Template with validation rules.
Printing • Print Preview • Printing the Current Worksheet • Printing a Selected Range • Printing a Page Range • Printing Multiple Copies • Practice – Printing