MS Excel for HR Professionals - CHRMP Academy

Course Content

Episode 1: Overview

📝 1.1 Course Guidelines

🎬 1.2 Introduction

Episode 2: Introduction to MS Excel

🎬 2.1 Excel View

🎬 2.2 Creating a database

🎬 2.3 Creating a table

🎬 2.4 Format options

Episode 3: Basic Formulas

🎬 3.1 Using the Date Function

🎬 3.2 Splitting data

🎬 3.3 Data Validation

🎬 3.4 Conditional formatting

🎬 3.5 Formulas

📝 3.6 Short Cuts

Episode 4. Cleaning your data

🎬 4.1 Using Filters

🎬 4.2 Using Advanced Filters

🎬 4.3 Cleaning your data

🎬 4.4 Removing duplicates

🎬 4.5 Lookup function

Episode 5: Creating a Pivot

🎬 5.1 Creating a Pivot

🎬 5.2 Pivot Value Function

🎬 5.3 Pivot Filter and Columns

1 of 2

About Instructor

CHRMP Team

145 Courses

+1493 enrolled

Not Enrolled

Take this Course

Buy CPD Membership to access this course

Course Includes

29 Lessons

Responses

You must be logged in to post a comment.