Computer Tips and Tricks | Microsoft Windows Tips, Microsoft Office Tips, Apple Tips and SmartPhone

Deleting Clipboard Memory in Windows

noreply@blogger.com (Putu Sentana) — Fri, 22 Apr 2016 17:58:00 -0700

For some reasons if we cannot do Paste for any texts that we copied in Windows it could be the Clipboard memory of the computer is full.

Below are the steps on how to delete and clean the Windows clipboard:

1. On Desktop, Right click and free space

2. On the shorcut Window, Type the location of the item with the following text then click Next:
C:\Windows\System32\cmd.exe /c "echo off | clip"

3. Type the name of the ShortCut e.g: Clean Clipboard Memory then click Finish

The final shortcut Properties looks like below capture:

Any time you encountered cannot copy and paste, just click the new shortcut that we just created.

Hope this help!

Google Search Tips 6: Google as Your Weatherman

noreply@blogger.com (Putu Sentana) — Fri, 19 Feb 2016 14:23:00 -0800

In the Google search box, type in weather followed by the name of the city or the postal code, and Google will give us the current and 7 days weather conditions forecast in the search result:

Google Search Tips 5: Finding Over One Billion Images

noreply@blogger.com (Putu Sentana) — Sat, 13 Feb 2016 00:49:00 -0800

Click on the "Images" link under the search box then type your query, Google will give you any photos or graphics that related you your search keyword.

Google Search Tips 4: Finding The Exact Phrase

noreply@blogger.com (Putu Sentana) — Thu, 11 Feb 2016 03:37:00 -0800

Use the Quotation marks when precision matters, with adding quote marks around any query will tell Google to find for occurrences of the exact phrase as it was typed. It's helpful especially when searching for people's names, song lyrics or expressions. For example "John Lenon"

Google Search Secrets and Tips 3 - Online Converter

noreply@blogger.com (Putu Sentana) — Tue, 9 Feb 2016 02:50:00 -0800

Google can be used as multi unit converter such as: Area, Length,Mass, Volume, etc.
Type any conversion that you need to do in the search box. For example to convert 1 Kilometer to Mile just type 1 Kilometer Mile, then you can convert any other unit like mass, for instance Found to Kilogram buy choosing Mass in the unit.

Google Search Secrets and Tips 2 : Use Google as Dictionary

noreply@blogger.com (Putu Sentana) — Sun, 7 Feb 2016 00:19:00 -0800

In the search box type define followed by any English word. You will find the definition of that word on the top of the search results.

Google Search Secrets and Tips 1 : Use Google as Calculator

noreply@blogger.com (Putu Sentana) — Sat, 6 Feb 2016 00:59:00 -0800

Type any math problem in the search box, we can type numbers and math symbols or we can spell the equation in words or type in a combination of both. For example: five plus ninety six, 45+178, 50% of 45. The result will be appeared on Google's calculator on your screen, and you may use it for any calculations.

REMOVE DUPLICATES IN EXCEL

noreply@blogger.com (Putu Sentana) — Sat, 25 Jul 2015 18:51:00 -0700

How To Remove Duplicates Data in Excel 2007, 2010 and 2013

1. Select any single cell or data range inside the worksheet

2. On Excel menu click Data tab, click Remove Duplicates.

3. Select any Columns that contain Duplicates or Select All

Before - After

Running Control Panel From Command Line Windows

noreply@blogger.com (Putu Sentana) — Tue, 25 Jun 2013 02:04:00 -0700

Below are the list command that we can use to manage the Windows Control Panel,
can be used by System Administrator to do admin task without login with admin account,
use the runas combination.

Example:

C:\control netcpl.cpl

Control panel tool             Command
   -----------------------------------------------------------------
   Accessibility Options          control access.cpl
   Add New Hardware               control sysdm.cpl add new hardware
   Add/Remove Programs            control appwiz.cpl
   Date/Time Properties           control timedate.cpl
   Display Properties             control desk.cpl
   FindFast                       control findfast.cpl
   Fonts Folder                   control fonts
   Internet Properties            control inetcpl.cpl
   Joystick Properties            control joy.cpl
   Keyboard Properties            control main.cpl keyboard
   Microsoft Exchange             control mlcfg32.cpl
      (or Windows Messaging)
   Microsoft Mail Post Office     control wgpocpl.cpl
   Modem Properties               control modem.cpl
   Mouse Properties               control main.cpl
   Multimedia Properties          control mmsys.cpl
   Network Properties             control netcpl.cpl
                                  NOTE: In Windows NT 4.0, Network
                                  properties is Ncpa.cpl, not Netcpl.cpl
   Password Properties            control password.cpl
   PC Card                        control main.cpl pc card (PCMCIA)
   Power Management (Windows 95)  control main.cpl power
   Power Management (Windows 98)  control powercfg.cpl
   Printers Folder                control printers
   Regional Settings              control intl.cpl
   Scanners and Cameras           control sticpl.cpl
   Sound Properties               control mmsys.cpl sounds
   System Properties              control sysdm.cpl

Find the Windows Update

noreply@blogger.com (Putu Sentana) — Thu, 7 Feb 2013 19:46:00 -0800

To Look the Installed or Applied Windows Update in the computer

Go to Start - Command Prompt then type "wmic qfe list"

Google Earth Places Tour

noreply@blogger.com (Putu Sentana) — Wed, 30 Jan 2013 17:34:00 -0800

Google Earth New Tour of Popular Sites, Cities and Places.

Google has added over than 100,000 new tours of popular sites, cities, and places across in 120 countries

Please see below video.

Windows Logo Button Shortcut

noreply@blogger.com (Putu Sentana) — Wed, 30 Jan 2013 17:22:00 -0800

Windows Logo: Start menu

Windows Logo+R: Run dialog box
Windows Logo+M: Minimize all
SHIFT+Windows Logo+M: Undo minimize all
Windows Logo+F1: Help
Windows Logo+E: Windows Explorer
Windows Logo+F: Find files or folders
Windows Logo+D: Minimizes all open windows and displays the desktop
CTRL+Windows Logo+F: Find computer
CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
Windows Logo+TAB: Cycle through taskbar buttons
Windows Logo+Break: System Properties dialog box
Application key: Displays a shortcut menu for the selected item

SEO Tips and Increasing Website Traffic Tips

noreply@blogger.com (Putu Sentana) — Fri, 15 Jun 2012 22:55:00 -0700

SEO Tips and Increasing Traffic to our Website:

Getting more traffic is the lifeblood for any websites, and Search Engine Optimization (SEO) is tricks or tools that can be used to increase those traffics. Below are some tips how to bring more traffic to our website as well as the SEO tips:

Keyword Research : find good keyword or right keyword that we want to target.
On-page optimization : put keyword as title, keyword in the content, etc. This will help your sites rank high by Search Engine, On-page optimization is the first thing that you have to look into for any sites or pages that you want to build. Part of On-page optimization as follows:

Title, H1, H2 and H3 Tags
Keyword Density and Content Length
The Exact Placement of Your Keyword
Images and Links
Font Decorations : bold, italic, and underline.
Bold, Italize and Underline your keywords
Add ALT Tag to Your Images
Testing and Rating the keyword on Each Post and Page

Off-page optimization : building internal and external link

SEO Tips and Increasing Website Traffic Tips

noreply@blogger.com (Putu Sentana) — Fri, 15 Jun 2012 22:55:00 -0700

SEO Tips and Increasing Traffic to our Website:

Keyword Research : find good keyword or right keyword that we want to target.
On-page optimization : put keyword as title, keyword in the content, etc. This will help your sites rank high by Search Engine, On-page optimization is the first thing that we have to look for any sites or pages that we wan to build.

Title, H1, H2 and H3 Tags
Keyword Density and Content Length
The Exact Placement of Your Keyword
Images and Links
Font Decorations

Off-page optimization : building internal and external link

iPhone Tips - iPhone Home Button Tips

noreply@blogger.com (Putu Sentana) — Thu, 14 Jun 2012 17:50:00 -0700

You may know that Apple was not the pioneer in the smartphone, but this company produces a lot of money from their iPhone which sold 18.65 million only in Q2 2011. The iPhone idea came when Steve Jobs was not happy with his smartphone e.g : having many features but mostly can not be used, having many keys and button that confusing the users. Because of this experience he decided to create a smartphone that only have very little button and keys. With money trial and error iPhone was born with one button called Home Button, during the production Steve Jobs rejected many design that initially were having many buttons, and he insist to have how we can make this smartphone only using one button that all people from children and adult can use it.
To operate your iPhone with this button, below some Home Button iPhone Tips that allow you to navigate and use your device easily:

Single press Home button iPhone tips: while you are on the first home screen when you pressing the home button it will ope the search page. Press again to go back to the home screen. When you on the other pages by pressing the home button will bring you back to home screen.
Hold down the iPhone Home Button you will open the voice control
Double clicking iphone home button will ope most recently used Apps that currently running on the Multitask Bar.Scroll left to right to choose the Apps. Double clicking iPhone Home Screen when screen locked: will open the music control and camera.
Triple press Home Button iPhone tips : this can be set what you want your iPhone would like to do by going to Setting-General-Accessibility-Triple Click home.

Microsoft Word-Keyboard Shortcuts

noreply@blogger.com (Putu Sentana) — Fri, 1 Jun 2012 21:47:00 -0700

Keyboard shortcuts Microsoft Word-Function Keys

Like in the other applications, Function Keys (F1-F12) on the computer keyboard can help computer users to perform certain actions. In Microsoft Word you can use these function keys and combination with some other keys which you can press two or more keys simultaneously, some useful Function Key shorcuts as follows:

F1	Vew Microsoft Word help or go to Microsoft office online help
F2	Move any text or graphics
F4	Copy/repeat last action
F5	Open Go To command
F6	Go to the next pane
F7	Spelling command
F8	Extend any selection
F9	Update the selected fields
F10	Show key tips in the menu
F11	Go to the next field
F12	Save As commmand

SHIFT + F7	Thesaurus
SHIFT + F12	Save command


CTRL + F2	Print Preview
CTRL + F4	Close active Microsft Word Window
CTRL + F6	Go to next Window
CTRL + F2	Maximize the window
CTRL + F2	Open command

ALT + F4 Close the Microsoft Word

More ...

Networking Tips-Shutdown Remote Computer

noreply@blogger.com (Putu Sentana) — Sun, 27 May 2012 02:09:00 -0700

Remotely Shutdown Windows PC

As a network Administrator, sometime we need to restart or shutdown remote computer on the network. Below video from PC-Addicts.

power by :

Microsoft PowerPoint Tips-Active Slide Show

noreply@blogger.com (Putu Sentana) — Sat, 26 May 2012 06:53:00 -0700

Slide Show Presentation B, W, Ctrl +P Keyboard Shortcut

During Slide Show Presentation there are some keys that we can use to manipulate the screen.

B keyboard letter: to display black screen on the monitor or LCD projector, rather than switch the projector off. This purpose is to gain more audiences focus on our speaks instead of watching the screen.

When we press "b"on the keyboard during the slide show presentation the screen become black.

To return back to the slide show press "b" one more time.

W keyboard letter : to display white screen on monitor or LCD projector, we can use white screen/blank screen to write or draw anything using pen from Pointer option. Press "W" again back to the presentation.

We can write or draw anything on this blank/white screen using Pointer option (right click somewhere to open the Pointer option.

Ctrl + P : free to write or draw something ( annotation ) on the active presentation.

Right click anywhere on the active screen to view pointer option, to erase or clear any annotation

We can save the annotation into our presentation permanently.

Blog Tips-Change Blog Address on Blogspot

noreply@blogger.com (Putu Sentana) — Thu, 24 May 2012 16:12:00 -0700

Change Blog Address on Blogspot

Go to your blog configuration - Setting - Basic - Publishing - Blog Address

Windows Logo Tips-Key Function and Shortcut

noreply@blogger.com (Putu Sentana) — Mon, 21 May 2012 01:30:00 -0700

Microsoft Windows Logo/Microsoft Windows Simbol Keyboard keys function:

Windows Logo: Open Start menu program
Windows Logo+R: open Run dialog box
Windows Logo+M: Minimize all opened program/application
SHIFT+Windows Logo+M: Undo minimize all (return back to all opened applications)
Windows Logo+F1: open Windows Help
Windows Logo+E: Open Windows Explorer
Windows Logo+F: open Search for Find files or folders
Windows Logo+D: Minimize all opened windows and application and displays the active desktop
CTRL+Windows Logo+F: to Find computer in the network
CTRL+Windows Logo+TAB: Switch to any opened application or windows
Windows Logo+TAB: switch to taskbar active applications
Windows Logo+Break: open System Properties

Source: www.microsoft.com

Microsoft Excel Tips-Keyboard Function Key Shortcut

noreply@blogger.com (Putu Sentana) — Sat, 19 May 2012 08:56:00 -0700

Below are some Microsoft Excel function keys shortcut that we can use while worming in Microsoft Excel

F1 key : to view Microsoft Excel Help
F2 : is for editing formula in the cell

3. F4 : copying last format that we have done

4. F5 : navigating spreadsheet fast, easy and accurate.

Add Trusted Site - GPO Windows Server 2008

noreply@blogger.com (Putu Sentana) — Fri, 18 May 2012 20:40:00 -0700

Edit your GPO Setting - Select "User Configuration-Policies-Administrative Templates-Windows Components/Internet Explorer/Internet Control Panel/Security Page-Site to Zone Assignment List"

2. Click Show Button to add the list

3. Add domain or Sites that you one to put in the Trusted sites list

Add any websites with value name and 1, 2, 3 or 4 as value.

1. Intranet zone
2. Trusted Sites zone
3. Internet zone
4. Restricted Sites zone