Loading Events

« All Events

  • This event has passed.

MS Excel Boot Camp for the HR Professional

June 13 @ 10:00 am - 3:00 pm UTC+8

Free
MS Excel Boot Camp for HR Professionals

MS Excel is a must in any HR arsenal. It’s the easiest way to track projects, create and maintain databases, and even come up with reports.

Module 1 – Basics of MS EXCEL

  • Understanding and Navigating the Toolbar
  • Formatting Sheets, Cells and Values
  • Managing Your Workbook and Your Worksheets

Module 2 – Basic Formula and Functions

  • CONCATENATE
  • SUM and SUMIF
  • AVERAGE
  • IF, AND, OR
  • COUNT, COUNTA, COUNTIF

Module 3 – Advanced Formula and Functions

  • VLOOKUP, HLOOKUP and XLOOKUP
  • Nested Formula
  • Circular References and Conditional Formatting
  • Dropdown Menus

Module 4 – USING Pivot Table and Building Dashboards

  • Uses of Pivot Table
  • Building A Pivot Table
  • Analyze and Design
  • Building A Dynamic Dashboard using Pivot

Details

Date:
June 13
Time:
10:00 am - 3:00 pm UTC+8
Cost:
Free
Event Category:
Event Tags:
, , ,
Website:
https://forms.gle/QMxJWK7p5y4xoaXY8

Venue

Online

Organizer

UpRush Social Geekers
Phone:
835 8993
Email:
support@readywritenow.com
Website:
www.readywritenow.com