Laptop Battery Life Tips

Easily create a personnel information database

The staff is the core of enterprise management, human resources staff, employees use Office 2007 you can easily create a personnel information database, sorting out the basic information of all employees, and staff contact information added to the Outlook contacts, in order to facilitate and timely communications.
Problem to be solved:
How column headings converted to the title of the table, keep the title is always visible while browsing data?
How to make personnel repository like a system dialog box to enter or query employee information?
According to the data “entry date” column automatically calculates the employee’s length of service and annual leave days?
Personnel Information Library staff contact telephone number, e-mail address and other information be imported into Outlook contacts, there is no quick way?
Want to keep the title is always visible? You can do
First of all, we have an employee information to an Excel table, the table lists the employee’s name, date of birth, home address, identity card number, e-mail, this table is the basic employee information database.
Contains a lot of employee records in the repository of employee information, so that browsing data will become very convenient, how to browse the data at the same time, keeping the title is always visible?
You can select all employee records and the title where the range of cells, press the key combination “CTRL + T to open the” Create Table “dialog box, select the table contains the heading” check box, click “OK” button will data area is converted to a table (see Figure 1).
The data area is converted to a table, any position in the table, click,HP 6730b battery and then slide the mouse wheel or drag the worksheet in the vertical scroll bar to browse employee information. Can be found, the column headings of the worksheet conversion became the title of the table, so that you can always see the title of the table browsing the.
Want to enter through the dialog box and check employee information? You can do
Hope “the personnel information database like a system dialog box to enter or query employee information, and can operate in accordance with the following steps (see Figure 2).
The first step:
Click the triangle button to the right of the Quick Access Toolbar, and execute “command” command, open the Excel Options dialog box.
Step two:
“From the Choose commands from” drop-down list box, select “all commands” in the bottom of the list box,Thinkpad T43 Battery
select the record sheet. And then click “Add” button to add it to the right list box (see Figure 3).
The third step:
After setting, click “OK” button, you can see the “records” in the Quick Access Toolbar button.
Step four:
Select any cell in the table, “records” button and then click the Quick Access Toolbar, you can open the dialog box shown in Figure 2, can view and edit employee information, add records, browsing history, modify the records and delete records.
Want to calculate the employees length of service and annual leave days? You can do
According to the data “entry date” column automatically calculates the employee’s length of service, as well as the number of days annual leave, then the operation can be carried out in accordance with the following steps.
The first step:
Enter the field name “seniority” and press the Enter key in the table adjacent columns J2 cell, can be found in the selected table style is automatically applied to the field added (see Figure 4).
Step two:
J3 cell input for the calculation of an employees length of service of the formula “= DATEDIF (F3, TODAY (),” Y “). The table format is extended to length of service “column, no need to fill, Excel will automatically fill to the other cells in the column the formula in cell.
DATEDIF function for the number of days between two dates, and its grammatical structure DATEDIF (start_date, end_date, unit)
Start_date: first date, representing the time period start date.
End_date: representative time period last date, end date.
Unit for the return type of the required information:
When the unit parameter is “Y”, the function returns the number of years in time.
When the unit parameters for the “M”, the function returns the number of whole months in the period of time.
When the unit parameters as “D”, the function returns the number of days in the period of time.
When the unit parameters for the “MD”, the function returns the difference between the number of days between start_date and end_date, ignore the date, month and year.
When the unit parameter is “YM” function returns the difference of the number of months between start_date and end_date, ignore the date and year.
When the unit parameters “YD” function returns the difference between the number of days between start_date and end_date,Toshiba PA3534U-1BAS replacement battery ignore the date in the year.
The third step:
In accordance with the provisions of the employees accumulated work the full year but less than 10 years, annual leave of five days; full 10 years less than 20 years, 10 days annual leave; full 20 years, annual leave of 15 days. Follow a similar approach to add “leave days” column in the table in the adjacent column, and the input to calculate the first employee to paid annual leave days the formula = IF (J3 <1,0, IF (K3, cell J3 <10,5, IF (J3 <20,10,15))) “, Excel will also automatically populate to other cells in the column, so that you get each employee’s paid annual leave days.
IF function is used to perform the truth value judgment, according to the logic calculation of true and false values ​​return different results. You can use the IF function on values ​​and formulas for conditional testing. The syntax structure IF (logical_test, value_if_true, value_if_false), the parameters are as follows:
· Logical_test: the need for the inspection of any value or expression of the true and false.
· Value_if_true: logical_test for the TRUE (true) return value, the value_if_true also may be other formulas.
· Value_if_false: logical_test for the return value of FALSE (false), the value_if_false also can be other formulas.
To the staff contact quickly imported into Outlook? You can do
Personnel Information Library staff contact telephone number, e-mail address and other information to be imported into Outlook contacts, in order to communicate with staff, then there is no quick way?
Can be operated in accordance with the following steps.
The first step:
Open the workbook that contains staff contact, selected to contain the entire table, including the header row.
Step two:
In the “formula” tab “defines the name of the option group, click the” Define Name “button to open the New Name dialog box. In the Name text box, enter employee information, as the name of the selected range of cells, enter the complete, click “OK” button.
The third step:
Click the Office button, then open the drop-down menu in the implementation of the “Save As” command, open the “Save As” dialog box. In the Save as type “drop-down list, select Excel 97-2003 workbook (xls)”, click “Save” button, save it to the specified location.
Step four:
Open Outlook 2007, the implementation of the menu bar “File → New → Folder” command, open the “New Folder” dialog box. In the Name text box, enter “staff contacts” in “folder contains” drop-down list,Price of Dell Vostro 1320 battery select the contact item in the “Select where to place the location of the folder list box, select” Contacts “, set When finished, click “OK” button (see Figure 5).
Step five:
Implementing the File → Import and Export command to open the “Import and Export Wizard dialog box, select the action to perform” list box, select “Import from another program or file” (see Figure 6).
Import and Export Wizard dialog box
Step Six:
Click “Next” button, open the “Import File” dialog box, select from the following location to import the file type “list box, select Microsoft Excel 97-2003″.
Step Seven:
Click “Next” button, click the “Import Text” text box to the right of “Browse” button, open the “Browse” dialog box, select the previously saved workbook containing employee information, click “OK” button. Back to the “Import File” dialog box.
Step eight:
Click “Next” button in the “Select destination folder” list box, select the “Staff Contacts”.
Step 9:
Click “Next” button, open the “Import File” dialog box. Click the “Map Custom Fields” button, open the mapping from the Define Fields dialog box, the list box on the left side of the “value” is the range of cells named “employee information” employee information in the Excel workbook, drag it to the right side of the corresponding mapping source to make it with Outlook contact information corresponds to (see Figure 7).
Set mapping source ”
Step 10:
The setup is complete, click “OK” button to return to the “Import File” dialog box, click “Finish” button, and employee information in an Excel workbook will be automatically imported into Outlook contacts. In the left pane of Outlook 2007, select “Contacts” tab, and click the “Staff Contacts” folder, you can see just import employee information (see Figure 8).
Employee information in the Outlook contacts imported into an Excel workbook