How to create a full name from first name and last name located in two cells

You can create a full name from first name and last name encoded in different cells by using a formula. i.e, =a2&" "&b2

If u want in the complete name to be family name first use, this formula: =b2&", "&a2


1. Click on the cell where you want to create the full name(image A) then type the formula(image B) then press enter
how to create formula?
a. press enter
b. click or type the name of the first cell to be merged
c. then use &"
d. press the space bar
e. then "&
f. click or type the name of the second cell to be merged


2. To copy the result, click on the cell where the formula is to be copied (image A) then dragged it to the cell where you want to copy the formula(image B)

Monitor display turned upside down or sideways

error : monitor display turned upside down or sideways

solutions: press and hold "ctrl" + "alt" buttons and at the same time press the up arrow

Yahoo mail : signing in – fast and easy way

1 . In typing your yahoo ID you can omit @yahoo.com


2. Instead of using the mouse to transfer the cursor to the password menu in order to key-in your password just press the tab button in the keyboard

3. After typing your password just press the enter button in your keyboard instead of clicking the Sign In button

4. Tips for your privacy & security: when you are using a shared computer make sure that the"Keep me signed in box" is always unchecked

Error in Printing Excel Documents : Ok in Print Preview But Smaller in Printout

How to Unhide Folder or Files Hidden Caused by a Virus

or If the above solution doesn't work do this one that will surely work

step 1 to 2 has a shortcut: press the window button and letter R at the same time




6. The hidden files and folders will be displayed

“Expectations of the Administration From The Library in Support of Its Institutional Objectives”

3 June 2011


Dear Colleagues:


Warm greetings from PLAI-NCR!


Library and librarians’ work is never ending and always changing. The nature and expectations of the performance of library tasks and duties have changed and evolved dramatically in the last few decades. It is now more than ever, that information professionals are being compelled to make their presence felt by their institutions and more importantly by the administrators and other stakeholders. It is based on this premise that the Philippine Librarians’ Association, Inc.–National Capital Region (PLAI-NCR) Librarians’ Council in cooperation with the Academic Booksellers Association of the Philippines (ABAP) invite librarians, information professionals, library support staff, teachers and students of library and information studies to attend and participate in a Forum on the topic “Expectations of the Administration From The Library in Support of Its Institutional Objectives”


This Forum specifically aims to:

1. Promote effective partnership between the administration and the librarian in the realization of the institution’s vision and mission.

2. To encourage involvement in the optimal utilization of library resources and services by:

a. Providing library updates to the administration and members of the faculty

b. Continuing to motivate clienteles to read and use the various resources in the library.



We have invited Dr. Benjamin G. Tayabas, President of Technological College and CHED Consultant, as our Resource Speaker.


This forum will be held on July 12, 2011 at the Megatrade Hall 5th Floor, Building B of SM Mega Mall, Mandaluyong City from 1:00 – 4:00 p.m. This shall coincide with the 15th ABAP Book Fair. Fees to be assessed are as follow: PLAI members PHP200.00, non-PLAI member PHP 250.00, undergraduate students PHP 100.00. These shall cover the Registration fee, certificate of participation and snacks.

For more details, please contact any of the following:

Rebecca M. Jocson

President

Pamantasan ng Lungsod ng Maynila

5250217

rebyjocson@yahoo.com


Elvira B. Lapuz

Vice-President

University of the Philippines

9818500 loc. 2865

Elvira.lapuz@up.edu.ph


Marietta D. Molina

Secretary

Centro Escolar University

7359406

mayettemolina@yahoo.com


Mona Lisa P. Leguiab

Treasurer

Polytechnic University of the Philippines

3387413

mpleguiab@pup.edu.ph /


Yolanda E. Jacinto

Auditor

The National Library of the Philippines

5253196 / 5251748

yolandajacinto@yahoo.com


Jorge Erwin A. Rada

PRO

DLSU-Manila

09175824694

Jorge.rada@dlsu.edu.ph


Miguel M. Cobaria

Trustee

Philippine Normal University

3027717

Miguel_m.cobaria@yahoo.com


Thank you and we look forward to your participation.


Sincerely yours,



ELVIRA B. LAPUZ

Chair, Education and Training Committee

PLAI-NCR


Noted:


REBECCA M. JOCSON

President, PLAI-NCR

Job Vacancy @ IRRI

Senior Librarian – Rice Bibliography
Reference number: RAS-2011-112-MR

Screening will start on 13 June 2011 and will continue until a suitable candidate has been found.
To supervise the compilation of the rice bibliography database, the library’s flagship project, by thoroughly searching and indexing published and unpublished rice literature in all languages, in order to meet the information needs of rice scientists all over the world. Identifies rice literature for inclusion in AGRIS database in accordance with AGRIS bibliographic standards; bibliographic data are regularly send by e-mail to AGRIS headquarters in Rome.
Major Accountabilities/Responsibilities:

* Searches for rice references from print journals, conference proceedings. Reports, and electronic sources and other sources of rice literature
* Assigns codes, subject headings and descriptions to rice and related articles for efficient retrieval and ease of access.
* Translates all bibliographic citations of foreign language literature into English by using dictionaries or by seeking foreign language support from local scientists as needed to ensure consistency
* Monitors weekly rice technical literature alerts from Current Contents. Connect and other sources
* In charge of the Rice Database building and Rice Literature update
* Supervises library support staff
* Performs other related duties that may be assigned by the supervisor

Qualification Requirements:

* Bachelor degree in Library and Information Science;
* Holder of Professional License
* 2 years, preferably in a research or academic library
* Indexing skills; Computer skills; Excellent on-line and mutual searching skills; knowledge in library automation; attentive
* to details; thorough; and organize

Please indicate the position reference number in the e-mail subject line. IRRI regrets that only shortlisted candidates will be contacted.

IRRI provides a multicultural work environment that reflects the values of gender equality, teamwork, and respect for diversity, with a competitive compensation and benefit package. Women are encouraged to apply.

Join us to deliver rice science for a better world

Interested candidates should apply online online please email at IRRIRecruitment@irri.org.

15th Philippine Academic Book Fair on July 12-16

The Academic Booksellers Association of the Philippines (ABAP) will hold the 15th Philippine Academic Book Fair on July 12-16, 2011 at the Megatrade Hall 3, SM Megamall, Mandaluyong City.

15th Philippine Academic Book Fair 2011
Picture of 15th Philippine Academic Book Fair 2011

This event will feature the latest academic books, journals, references, educational video and audio materials, publishing aids, electronic references, computers and other materials for educational institutions. This fair will provide the Filipino people the opportunity to avail of these materials at the most reasonable price with mint copies from participating book companies.

Established book companies such as Academic Book Sales, Catholic Book Center, Claretian Communications, Creative Minds Book Center, Goodwill Bookstore, UST Publishing House, New Day Publishers, UP Press, New Century Books, Global Learning Media Corporation, Golden Books Services, Inc., Ateneo University Press, Book Trends Enterprises will be exhibiting their educational materials in the said event.

Reviewers, educational/professional institutions, independent publishers' representatives, independent booksellers, librarians, publishers, school leavers, students, teachers/tutors, trainers/consultants and working adults are invited to visit the fair which opens at 10:00 a.m. and closes at 8:00 p.m.

For more information, contact Ms. Ma. Cristina S. Capistrano, Vice President, Primetrade Asia, Inc. at telephone nos.: (02) 896-0661 and (02) 896-0682; or e-mail at bookfair Qprimetradeasia.com and website www.primetradeasia.com

PICS TAKEN DURING THE PLAI-BRLC GEN.ASSEMBLY & ELECTION OF NEW OFFICERS FOR 2011-2013

PLAI-BRLC ELECTED OFFICERS FOR 2011-2013

President
Ms. Edna San Buenaventura
(Ateneo de Naga University)

Vice President
Mr. Stephen Granatin
(Bicol University-Tabaco Campus)

Secretary
Nirvana Ramos
(Naga College Foundation)

Treasurer
Imelda Belale
(Camarines Sur Polytechnic Colleges-Naga Campus)

Auditor
Bernadette Federico
(Ateneo de Naga University)

PIO
Lourdes Francisco
(University of Nueva Caceres)

Board Member
Norma Mago
(Our Lady of Lourdes College Foundation)

Rico Vinluan
(Raul S. Roco Library)

Nomelec Chair
Elvira Obias
(Ateneo de Naga University)

Nomelec Vice Chair
Paulina Breboneria
(Divine Word College of Legazpi)

Nomelec Secretary
Careen Bayrante
(Universidad de Sta Isabel)

Nomelec Member
Antonio Morada
(UNEP/CAT College)