Facebook Matrix

If you have much date that you difficult to find it that is the recent date or the last date.So this way we need to high light the date that make you can find it very fast as soon as possible and easy for processing the work . Here is how to do that: 1. Go to Condition Formatting and Choose New rule 2. Then Click Format only cells that contain 3. Format only Cells with (cell Value+ equal to+ (=Max(cell)) Picture below for detail. Sample Example Download Here

VLOOKUP:  This function returns a value from the intersection between the found lookup value in the leftmost column and a column index number in the Table Array. To use the Vlookup function, we need common value in both the data and the table, if we do not have a common value in another data from which we want to pick the data, then formula will give the #N/A error. vlookup with ISNA Here is the Simple Example ..Please Download Here

Sometime you setup windows server 2008 to vmware using LAN or wifi, you chose Bridge mode to share internet connections between host and virtual machine may be cause of issues with internet connection at virtual machine. They can not connect to the internet or appear a message likes " conflict IP address " Here is how to fix this issue: 1.Run Cmd 2.Type  netsh interface ipv4 show inter It will show like Picture below 3.Type this command  netsh interface ipv4 set interface  77  dadtransmits=0 store=persistent 4.Restart PC it will OK (note if it still not OK please diasble DHCP client service).

Excel 2010 Bible for student and Staff use to learning thank to Jhon Walkenbach than create this book for us to study. I would like to share it  to my friend every body to learn this. Here is the link to Download   Thank.

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. Click the cell where you want the label or heading to appear. Type the first line of information. Press ALT+ENTER. Type the second line. Then repeat step 3 if you have additional lines to enter. Press ENTER when you've finished typing. good luck.

Telnet  is a user command and an underlying TCP/IP protocol for accessing remote computers. Through  Telnet , an administrator or another user can access someone else's computer remotely. Please following the access. 1.Start -->run -> appwiz.cpl and then press Enter 2.And Then it will pop up  Program and Feature --> click on Turn Window Feature On and OF. 3.Find Telnet and click Tick and then Click OK. 4.It will be OK. 5.Restart the PC if it still not work.

I would like to tell every one how to fix this issue with some file in you Hard disk or UBD drive. This  Sometime cause from USB have virus attache with ..That Virus hide all your file and folder and Create link instead that look like your folder.After you click those virus  will  spread all to PC. So if you see this don't click any more.Please take your USB to scan with Antivirus  before OPen it. Here is how to fix: 1.Go to CMD 2.Go to that Drive like E: and press Enter 3.type Attib -s -h /s /d and Press Enter 4.It will be OK.

Some USB drive will see small amount of space that is unallocated.. So i would like to tell you how to fix this  as below with command  wind window PC. First we start CMD and try Diskpart  you will see like picture below and Please try following Command to fix this issue. Microsoft DiskPart version 6.2.9200 Copyright (C) 1999-2012 Microsoft Corporation. On computer: COMPUTER DISKPART> list disk   Disk ###  Status         Size     Free     Dyn  Gpt   --------  -------------  -------  -------  ---  ---   Disk 0    Online          298 GB      0 B   Disk 1    Online         7509 MB  6619 MB DISKPART> select disk 1 Disk 1 is now the selected disk. DISKPART> clean DiskPart succeeded in cleaning the disk. DISKPART> create partition primary DiskPart succeeded in creating the specified partition. DISKPART> exit After you can reinsert your USB again and Try to Format that USB. good luck.

Damaged Recycled Folder The Recycled folder itself can become damaged. Files are moved to the folder and the Recycle Bin on the desktop appears full, but you cannot view the contents and the Empty The Recycle Bin command is unavailable. Deleting this folder and restarting Windows will re-create this folder and restore functionality: How to do with Command that run as Administrator.: Type attrib -s -h recycled . Type del recycled. Restart the computers. Good Luck.

Having problems getting Gmail to work with pop3? Try these settings. GMail as a pop3. - Email sending To send emails using Gmail server enter these details: SMTP Host: smtp.gmail.com SMTP Port: 587 SSL Protocol: OFF TLS Protocol: ON SMTP Username: (your Gmail username) SMTP Password: (your Gmail password) Also make sure your "From email address" in HESK settings is set to your Gmail email address! Still no luck? Check with your host if they have port 587 blocked in firewall. ? POP3 fetching To fetch mail from Gmail server enter these details: POP3 Host: pop.gmail.com POP3 Port: 995 TLS Protocol: ON POP3 Username: (your Gmail username) POP3 Password: (your Gmail password) Important: make 100% sure that "POP3 download" in your Gmail settings is set to "Enable POP for mail that arrives from now on". If not, Gmail will send all existing (even read) messages to HESK when it first connects. ? Error messages Permission denied or Connection timed out Try loggin wi

I had meet this issue when i work as IT technical .It so use full for you and Other. It work for me.I hop it will work for you. Please do following the instruction below: 1) Click on Start --> In search box, type cmd --> Then "CMD" will be displayed in the search --> Now right-click on "CMD" ---> Select "Run as administrator". 2) Now enter this command netsh int ip reset resetlog.txt  OR this command netsh winsock reset Press "Enter". 3) Reboot your computer Good Luck.

We Will walk you through the steps to fix a file association error in windows 7/Vista (Desktop icons all look the same and only opened with one program; also known as the .lnk error ). No downloads are required in order to fix this error. Please be sure to leave a comment if this has helped you or if you have any further questions regarding this or related errors. Yes by 'suffix' I meant 'file extension'. The steps are listed below: 1. Open start menu (click button on far side of task bar) 2. Type into the search bar: regedit 3. Press yes when prompted 4. Double click each of the folders specified: HKEY_CURRENT_USER Software Microsoft Windows Current Version Explorer FileExts .lnk (or .rar/other extensions in differing cases) 5. Right Click User Choice and select delete 6. Restart Computer I hope this article will help you.

If you are trying to install the Windows XP from scratch on the laptop, please BE SURE that you put the Hard Drive on "Compatibility" mode in BIOS, which was defaulted to "AHCI" (Compatibility is also known as IDE). Otherwise, you will experience the "blue screen" issue. To change that setting, you need to do the following: 1. Press F2 when booting up the computer 2. Select 'Config', then 'Serial ATA (SATA)' 3. Change controller option to 'Compatibility' / 'IDE' 4.I hope it will solved and can install window PC

Noted •/dev/hdc is a device located on the IDE controller. •/dev/sr0 is a device located on the SCSI controller •/dev/cdrom is a symlink to either /dev/hdc or /dev/sr0. ESX hosts run a script that automatically sets up /dev/cdrom to be the correct device, thus using /dev/cdrom is appropriate. To access the local host CD-ROM device when the host is in troubleshooting mode (also known as single user mode or runlevel 1): 1.Ensure that a CD-ROM has been inserted in the CD-ROM drive. 2.Run these commands to create the block device entry for the CDROM in /dev before attempting to mount the CD-ROM: # cd /dev # mknod -m660 sr0 b 11 0 3.Run these commands to create a temporary mount point for the CD-ROM and mount the CD-ROM on the host: # mkdir /mnt/cd # mount /dev/sr0 /mnt/cd # cd /mnt/cd You should now be in the CD-ROM directory and should be able to access the media in it.

How to solve it: 1.run->regedit->HKEY_LOCAL_MACHINE->SOFTWARE->MICROSOFT->WINDOW NT ->CurrentVERSION->PROFILELIST after edit as below value on account that have problem:             .RefCount à modify to value 0.             .Stat    à modify to value 0. After restart pc and log on again. ---------------------------------------------------------------------------------------------------------------- Appears while attempting to logon in Windows Vista, 2008, 2008 R2 and 7. Exact cause is unknown, but this issue may occur if the user profile was manually deleted by using the command prompt or Windows Explorer by a user or by some program. A profile that is manually deleted does not remove the security identifier (SID) from the user profile list in the registry. Since the SID is still present, Windows will still try to load the profile by using the ProfileImagePath that points to a nonexistent path. Therefore, the profile cannot be loaded. This can also be a issue with

This error is related to the old printer you have set as default before. Printers name that was recorded in your registry are priority on the system which you cannot modify if you're trying to set a new default printer. So you have to manually modify the registry. Note that the registry section is very sensitive,  serious  problems might occur if you modify the registry incorrectly.  Therefore, make sure that you follow these steps carefully.  For insurance included, move down the registry before you alter it. And that point, you can restore the registry if an issue happens. For Additional data about how to go down and restore the registry, click the accompanying article number to view the article in the Microsoft Knowledge Base: How to back up and restore the registry in Windows: (http://support.microsoft.com/kb/322756/) Now, here's how to troubleshoot: 1. Click the Start button and type "regedit", then right click and "run as administrator" 2. Now go to th

To turn on the Read all standard mail in plain text option in Outlook 2003, follow these steps : Start Outlook 2003. On the Tools menu, click Options . On the Preferences tab, in the E-mail area, click E-mail Options . In the Message handling area, click to select the Read all standard mail in plain text check box. Note By default, the Read all standard mail in plain text option is turned off. To turn on the Read all standard mail in plain text option in Outlook 2007, follow these steps: Start Outlook 2007. On the Tools menu, click Trust Center , and then click E-mail Security . Under Read as Plain Text , click to select the Read all standard mail in plain text check box. To include messages that are signed with a digital signature, click to select the Read all digitally signed mail in plain text check box. When the Read all standard mail in plain text option is turned on, you receive the following notification on the Info

I had meet proxy LAN with my PC that make my internet not working any more. Because Proxy LAN in my PC has tick automatically . We need to Uncheck or Untick  the proxy to solved this. Here is the guide: Go to ->control panel  ->internet- à internet option  and then choose  connection tab. After  click  LAN Setting and then uncheck the Proxy More info please see on picture below:

THis document will tel you how to unprotect an excel spread sheet without having the password In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. 1 . Press ALT +  F11 or click on View Code in Developers Tabs In the Above White Space Enter the below Code. Do not change the code just copy paste: Sub PasswordBreaker()     'Breaks worksheet password protection.     Dim i As Integer, j As Integer, k As Integer     Dim l As Integer, m As Integer, n As Integer     Dim i1 As Integer, i2 As Integer, i3 As Integer     Dim i4 As Integer, i5 As Integer, i6 As Integer     On Error Resume Next     For i = 65 To 66: For j = 65 To 66: For k = 65 To 66     For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66     For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66     For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126     ActiveS

Printer is the part of  every office need to use.If printer has problem IT will got complain to much.As my experience about printer too.We have many way to connect with printer but today i would like to show every one how to configure printer by window server 2012 with Group Policy : 1. Add role for server Printer Manager in Server 2. Add Printer to Share in Server (install Driver for printer) 3. After Create GPO for that printer as below: ü   Find Group Policy Object à Right click and then click New .It will pop up new window of Policy Type the name and click OK. ü   After we get one GPO (ex: printer) à Right Click that GPO and Click Edit. ü   You will see new window .Please find à Computer Configuration à Policies à Administrator Template à Printer à Point and Print Restriction  after Edit to enable ü   Clear two text Box(not tick)     ü   When install Driver for a new connection choose (do not show warning or evaluation prompt.      ü   When update Driver from existing Connection (s

I would like to guide every body how to upgrade from window 7 to window 10 by Media create Tool that provide from Microsoft. Microsoft has provide 2 tool that for upgrade to window 10 .One is for window 10 x32 bit and Other one is for Window 10 x64 bit. Here is the two tool link to download Below: Media Create Tool for window 10 X32 bit : Download  Media Create Tool for window 10 X36 bit : Download How to upgrade from window 7 to window 10 by Media create Tool 1.Double Click Media Create Tool that you had download already 2.Do Following instructor  that you would like to upgrade or download ISO to burn in Flash or DVD to clean install. Thank you for watching.

What’s New in Excel 2010?   64-bit version: If your hardware (and Windows version) supports it, you can install the 64-bit version, which lets you create larger workbooks. Most people do not require the 64-bit version, and using it might cause some add-ins to not function. Sparkline charts : Create small in-cell charts to summarize a range of data graphically.  Slicers: A new way to filter and display data in pivot tables, by clicking buttons.    New pivot table formatting options: You have more control over the appearance of pivot table reports. Office button changes: The big round Office button in Excel 2007 has been replaced by  a File button/tab, displayed to the left of the tabs. Clicking it displays a screen that lets you perform various operations on your workbook. This view essentially replaces the traditional File and Print menus — plus quite a bit more. Conditional formatting enhancements: Data bar conditional formatting can display in a solid color, and the bars provide

Excel, as you probably know, is the world’s most widely used spreadsheet program, and is part of the Microsoft Office suite. Other spreadsheet programs are available, but Excel is by far the most popular and has become the world standard. Much of the appeal of Excel is due to the fact that it’s so versatile. Excel’s forte, of course, is performing numerical calculations, but Excel is also very useful for non-numeric applications. Here are just a few of the uses for Excel: 1.Number crunching : Create budgets, analyze survey results, and                                     perform just about any type of financial analysis you can think of. 2.Creating charts : Create a wide variety of highly customizable charts. 3.Organizing lists: Use the row-and-column layout to store lists                               efficiently.   4.Accessing other data: Import data from a wide variety of sources.   5.Creating graphical dashboards: Summarize a large amount of                                      

This is the limon keyboard khmer .It seem old version but it still use today. Because some document still need Limon Font to read. So i would like to make a download link for Limon Font Download Limon Font After download Font Please extract the Zip file and Copy and Past To Drive C:\Windows\Fonts It will Ok for your Document that need Limon Font. Thank

This the Khmer Unicode Font that every body need for PC window . How to install just download zip file and extract  and than Copy to C:\Window\Font  of your PC .It will be OK. Here is the link Download If you would like for install font  execute file (exe) that just only download and extract file and then Double click to install Unicode.exe file it will be OK. Here is the link for Execute file Download

Khmer Unicode keyboard This is the Khmer Unicode Keyboard that help every one to learn and typing Khmer Unicode fast . Now Khmer Unicode is official you by the law.So We Cambodian should be learn and study this keyboard .

This the use full element that every body need to use very day of excel.

When you search google sometime it redirect to google custom search engine(cse).Some people don't like it because it not provide full functional of search experience . Here it is how to disable it . go to Control penel  find Internet Option Find Connection Tab Click on LAN Setting Untick Proxy . More info please check in Picture above. Noted : You should be an administrator of PC. Thank you.

1. Which of the following statements are true regarding the command  ip route 172.16.4.0 255.255.255.0 192.168.4.2 ? The command is used to establish a static route. The default administrative distance is used. The command is used to configure the default route. The subnet mask for the source address is 255.255.255.0. A. 1 and 2 B. 2 and 4 C. 3 and 4 D. All of the above Answer & Explanation Answer:  Option  A Explanation: Although answer D almost seems right, it is not; the mask is the mask used on the remote network, not the source network. Since there is no number at the end of the static route, it is using the default administrative distance of 1. 2.  Which command displays RIP routing updates? A. show ip route B. debug ip rip C. show protocols D. debug ip route Answer & Explanation Answer:  Option  B Explanation: The  debug ip rip  command is used to show the Internet Protocol (IP) Routing Information Protocol (RIP) updates being sent and received on the router. 3.  Which s