17 August 2018

13 August 2018

HOW TO: Calculate Age and Sort Monthly for the Birthdays using Microsoft Excel

Sometimes, you need to sort out a list of people from youngest to oldest and categorically arrange by month with the given birthdate using Microsoft Excel to increase productivity and easier access.

This could be tough and complicated but somehow it kinda helps you play some functions.

Some EXCEL functions used:
  • The DATEDIF function is useful in formulas where you need to calculate an age.
  • The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
  • The NUMBERVALUE function is useful when you convert text to a number, in a locale-independent way.
  • The TEXT function is useful when you change the way a number appears by applying to format to it with format codes.

HOW TO: Calculate Age
  • Using Function =DATEDIF()
    • Syntax: =DATEDIF(start_date,end_date,unit)
    • Sample: =DATEDIF(E4, NOW(),"y") where E4 is the birthdate field (m/d/yyyy), "y" to fetch and result for year.
1. First, you need to add some header titles on top row or wherever you want to add. Here I put it on the first row with the following header titles like:
  • #
  • Lastname
  • First name
  • Birthdate
  • Status
  • Age
  • Sex
  • MM
Since we are getting the age the most important here is just the birthdate and age cell.
Important: I usually add # or No. on headers for me to easily sort on the later part of the project.

12 August 2018

06 August 2018

10 Things You Need To Know Before Taking Career Service Examination-PPT

To fully qualify in becoming a permanent staff in a government agency, at least, get a certificate of passing and ideally the CS Professional.

In the coming exam this August 12, 2018, the CSC Region 10 posted an advisory to their Facebook page of the things an examiner should know.

03 August 2018

Napolcom Exam Reviewer For 2017-2018

Ever want to become an aspiring police personnel? The interested party shall pass first the PNP entrance in which I will be sharing some useful details, latest development, and newest system to implement.

What is Napolcom?
According to the Napolcom

Napolcom or National Police Commission is the agency mandated by the 1987 Constitution and the Major Police Reform Laws, Republic Act Nos. 6975 and 8551 to administer and control the Philippine National Police. Under R.A. 8551, otherwise known as the "PNP REFORM AND ORGANIZATION ACT OF 1988" the Commission gained the powers to investigate police anomalies and irregularities, administer police entrance and promotional examination and summarily dismiss erring police officers.

SEE FILES: [REVIEWER] Napolcom Additional FILES 2017-2018

NAPOLCOM MANDATE
The National Police Commission is the agency mandated by the 1987 Constitution and the Major Police Reform Laws, Republic Act Nos. 6975 and 8551 to administer and control the Philippine National Police. Under R.A. 8551, otherwise known as the "PNP REFORM AND ORGANIZATION ACT OF 1988" the Commission gained the powers to investigate police anomalies and irregularities, administer police entrance and promotional examinations and summarily dismiss erring police officers.