Computer & smartphone Tips Trick

Excel formula for counting number of male or female employees/students, etc. For this purpose you can use the Countif formula. How to use the formula : In the example I have a simple table with male (M) and female (F) gender. To count number of male (M) at cell B9 the formula is: =COUNTIF(B2:B7,"M")  (of course you have to change B2:B7 with the cells of yours)

How to set default save format in office 2016.  In this example is to set default save format to Word 97-2003 (doc). 1. In Microsoft Office 2016 page, choose/click File tab. 2. Then choose Options. 3. In Word options page, choose Save.   And for Save files in this format: choose : Word 97-2003 Document (*.doc). Then click Ok . Now, if I click Save for new document, the dialog will show that save format is already to Word 97-2003 document.

How to remove password protected PDF document without PDF Editor software such as Adobe Professional, PDF Pro, etc. We can do removing the PDF password only by using Google Chrome browser. • Run/open  Google Chrome browser • Open the PDF Protected file that you want to remove its password, (press Ctrl + O for open file menu). • Enter the password for opening the PDF document • After the PDf document opened, now is the trick to remove the password :

In Microsoft Outlook you can set schedule or delay time for delivering the email after you click Send button. the email will be in the outbox depend on setting time you are already made. Compose the new email, setting delay time, and then Send the email. In Microsoft Outlook 2010 to set delay delivery  email follow steps below : • Compose/create New Email • Go to Options tab • Choose Delay Delivery

In the computer it is easy to know what day of the date given. Open the time and date setting and change the date, month, and year that you want to know, and then the day will appear. In this post I will tell you how to show the day of the date given in Microsoft Excel. • Open Microsoft Excel • Give the name for rows, example : Date and Day  • B2 cell will display name of day automatically depends the value of B1 cell (day,month,year) so at B2 column we write :  =b1 then hit Enter key

PST (Personal Storage Table) files, or also called Personal Folders File is a file extension used by Microsoft Outlook to store email data  in a local computer, personal folder or archive folder. If you get your pst file in error so you can't open your email inside that personal/archive folder, you can try to repair/fix  that PST file using internal tool  from microsoft outlook , the tool is :   Scanpst.exe .

How to View Email Headers in Outlook 2010 ? Email headers contain detail information about the email  received, sender, recipient, subject, time of delivery, time of receipt, ip addresses or domains, etc.. If you want to know the headers of  email that you received in Microsoft Outlook 2010 • . Open the email that you want to know the header

When your  computer  connected to a network, use LAN cable or use wireless (wifi), it has an IP (Internet Protocol) address. There are two ways to find out the IP address on a Windows computer, through the Command (DOS) or go to the network connection menu. Here is to know the IP address in Windows 8 via Network connection icon at the lower right corner (Icon differ between connection via wifi, cable and modem)

You can run the application you have in your computer using the email for the trigger. From anywhere you send email with Subject that already set in the rule of email client software and then when the email received, it will instruct to run the Application. To set rule for running Application using email, you have to use email client software such as Microsoft Outlook or others. I am here using Microsoft Outlook 2010 for the Email client software and use email from Gmail. (to set Gmail using Microsoft Outlook you can see at previous post ).

IMAP, Internet Message Access Protocol, is protocol for e-mail retrieval. Gmail offer this protocol to all Gmail users  free of charge, so they can use email client such as Microsoft Outlook or Thunderbird to access, send or receive their Gmail. Server for Incoming Mail : IMAP - Requires SSL imap.gmail.com Port : 993 Requires SSL :Yes Server Outgoing Mail : SMTP - Requires TLS smtp.gmail.com Port: 465 or 587 Requires SSL : Yes Requires authentication : Yes Use same settings as incoming mail server

If you are in vacation or you have no time to answer the email in your Ms. Outlook 2010, you can set  automatic reply or auto response or out of office (the same meaning with different name). To set Automatic reply in Ms Outlook 2010 : • Go to File Tab • Click Info • Choose Automatic Replies .

If you already have/buy the product key for Microsoft Office 2010, then you need to activate the product online through the Internet. And if you find no column/field in Ms Office 2010 for entering the product key here in this post is how to resolve. Sample of error, need to change the product key How to change the product key ?

This post how to solve a problem with Microsoft Outlook, where user cannot open or save the mail attachment. When you click to open the attachment file, the file can not be opened and there is a warning like this : Can not create file ... Right - click the folder you want to create the file in , and then click Properties on the shortcut menu to check your permissions for the folder . When  you try to save-as the attachment file, files can not be saved, and there is a warning as below : Can not save the attachment . Can not create file : ... Right - click the folder you want to create the file in , and then click Properties on the shortcut menu to check your permissions for the folder .

In this post i will tell you how to change, convert, or export Outlook Notes to become  Text/txt (notepad) files. Below are the steps : Create a new folder  in the local drive, for example in drive C  with the name of folder is notes

Generally when we open the excel file, it will show one sheet at the same time, in other words when we are seeing sheet 1 for example, we don't see the other sheets, show only sheet names at the bottom . When we have to compare two worksheets in excel file  (at the same file), we have to be able to see those two worksheets at the same time. How to show two worksheets at the same time?

When we don't have time to edit an image or picture using photo editor application (for example the picture need cropping ) and  immediately picture is need to be inserted to the Microsoft Word, Excel, or PowerPoint, or inserted to the body of an emailin Ms Outlook. We can crop the picture directly  inside Microsoft Office (Word, Excel, PowerPoint, or Outlook) The following example cropping a picture in MS Word 2007, for other Microsoft Office (office 2003 and 2010 is not too different)

If you want to insert  text(s) over the picture/graphic in Microsoft Office Word, the way is using  Text box from the Insert menu. In Ms Word 2007 : • Make sure the picture is not highlighted, click on the right outside of  the picture to make it not highlighted Go to Insert tab, then click on Text Box, choose • Go the Insert tab, select the Text Box , then select Simple Text Box

If you have Ms Excel spreadsheet/document and you want to give the protection using password, so when opening the file, you or anyone need to input the password first, then when the password is wrong, the file can't be opened. Below is how to give password protection on Microsoft Excel 2007 • Open the Ms Excel file that will be given a password

Title of this post means : if you have a table from a list of values In Ms Excel ​​such as Test Scores , and you want to convert those values ​​to character A, B, C, D or E in other Cells  automatically without have to type it manually one by one, you can use IF Function For example, the definition :     Value           Using character    0-59           E 60-74           D 75-84           C 85-94           B 95-100            A

If you want to make an automatic remark or result from one value in Ms Excel, you can use IF Function. For example :  If the value = 70 or above the result is PASS If the value below 70 the result is FAIL To make the word PASS or FAIL without typing them, use the simple IF function bellow In the example below, column A is used for value, and column B to indicate the PASS or FAIL from the value, To make automatic PASS or FAIL without typing them, In the column B use this formula :