Loading Events

« All Events

  • This event has passed.

MS Excel Boot Camp for HR Professionals

February 22 @ 9:00 am - 6:00 pm UTC+8

Php6048
MS Excel Boot Camp

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 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
  • MAX and MIN
  • ROUND

Module 3 – Advanced Formula and Functions

  • TRIM and IFERROR
  • VLOOKUP and HLOOKUP
  • INDEX and MATCH
  • Nested Formula
  • CHOOSE
  • 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:
February 22
Time:
9:00 am - 6:00 pm UTC+8
Cost:
Php6048
Event Category:
Event Tags:
, ,
Website:
https://forms.gle/QMxJWK7p5y4xoaXY8

Organizer

UpRush Social Geekers, Inc.
Phone:
835 8993
Email:
support@readywritenow.com
Website:
http://www.readywritenow.com/

Venue

Makati
Philippines + Google Map