Tips & Tricks

WW Works for You!

Excel Tips……..

Jan, Tue 24th, 2012
Posted In:Tips & Tricks
By:admin

Customise the Quick Access Toolbar

The Quick Access Toolbar appears in the top-left corner of the Excel window in Excel 2007 and 2010. By default, it contains buttons to save your work and undo or redo/repeat the last action. You can customise what appears here, and it's a very useful place to dock your most commonly used tools.

Click the 'Office' button followed by 'Excel Options' and 'Customize' in Excel 2007. In Excel 2010, choose 'File | Options | Quick Access Toolbar'. Select a tool that you want to add in the left-hand column and click 'Add'. Change the available commands using the dropdown list labelled 'Choose commands from'. Click 'OK' to save your changes.

Tips on How to Free Up Memory on Your Blackberry and more…

Dec, Thu 15th, 2011
Posted In:Tips & Tricks
By:admin

Blackberry – Clear Event Log and Free Up Memory

Your daily activities are stored on your phone within the “event log”, periodically clearing this log will help keep your device running smoothly.
To access your Event Log, go to your Home Screen, hold down the ALT key and then type "LGLG". To delete your list of events, hit the BlackBerry MENU key while any event is highlighted and then click "Clear Log."


How to Search the Web for Exact Phrases

Google Chrome Tips……..

Oct, Thu 27th, 2011
Posted In:Tips & Tricks
By:admin

Keyboard Shortcuts:

  • Control + Shift + N opens an 'incognito' window – sites you view in this window won't appear in your history and cookies served by sites in this window will be deleted when the window is closed.
  • You can open a link in an incognito window by right-clicking the link and selecting Open link in incognito window.
  • Alt + Home loads your Google Chrome home page, with thumbnails of your most visited sites shown in the active tabbed window.

Excel Tips……..

Sep, Tue 20th, 2011
Posted In:Tips & Tricks
By:admin
Master the clipboard pane
  • The clipboard can be very useful when using Excel, as you often need to cut or copy and paste information from one part of a sheet to another, or between different sheets and workbooks. The chances are that you'll need to repeatedly copy and paste different items at different times, depending on the complexity of the task in hand.
     
  • You can make this easier by opening the clipboard pane as it enables you to handle multiple clipboard items at the same time. On the Home tab of the ribbon, click the arrow button to the bottom right of the Clipboard group to toggle it open or closed.

Software, Web and Email Tips…….

Aug, Fri 26th, 2011
Posted In:Tips & Tricks
By:admin
 
 
Cute PDF
CutePDF, a very simple program for creating a PDF without the need to have a full copy of Adobe Acrobat.
Web Tip
Did you know that when entering a web address you no longer need to enter the http://
With the newest advancements in internet browsers, did you know that you can type your search query straight into the address bar to get your search results without having to browse to www.google.com or any of the search providers first.
Out of Office
Always remember to set your out of office message when leaving the office.

Anti-Virus and iPad Tips…..

Aug, Fri 12th, 2011
Posted In:Tips & Tricks
By:admin
 
 
FREE Antivirus Solution for Home Users
Microsoft released Microsoft Security Essentials (MSE) almost 2 years ago, and it’s still seems to be a well-kept secret.
Not only is MSE free for home use, it’s very highly-rated.
For corporate use, we still recommend a fully-managed enterprise-grade product such as what we include in our ServiceWorks Package, but for home use you can’t beat a well-respected FREE option!
MSE can be downloaded direct from Microsoft at http://www.microsoft.com/en-us/security_essentials/default.aspx
A 2010 comparative third-party report can be downloaded from AV-Comparatives at http://www.av-comparatives.org/images/stories/test/summary/summary2010.pdf
 
I am a business user.  Do I really need an iPad or iPod Touch?
Originally developed as entertainment devices, the iPod Touch and now the iPad have included enterprise-level functionality for several years, without the need for additional complex software running on your small business communication server.
Most of us need to check our e-mail and calendar on a regular basis, and having an instant-on device instead of having to boot up a PC or Laptop is a huge productivity improvement.
Both the iPod Touch and iPad are able to integrate directly with a corporate Exchange server, as well as Gmail and other communication servers for full access to e-mail, calendar, and contacts.  They offer a quick, easy, and very reliable way to stay up-to-date while at home or on the road as long as you have wireless internet access.
If cellphone functionality is required, the iPhone offers the exact same corporate connectivity!
Synchronize Google Chrome bookmarks and settings across all PCs.
If you use multiple PC’s or laptops, maintaining consistent browser settings and bookmarks across all of them is almost impossible.
Google Chrome has added a feature that allows your bookmarks and settings to be stored as part of your Google Account, and synchronized across all of your Google Chrome browsers on all PC’s!
To use this feature, you need:
-          Google Chrome installed on all your PC’s.
-          A Google Account
-          Enable sync
 
 To enable sync, go into Chrome on all of your PC’s, and:
-          Click on the “Settings” menu (the wrench at the top-left corner of Chrome)
-          Click on “Personal Stuff” in the left-hand menu.
-          Click on the “Set up sync…” button in Personal Stuff
-          Enter your Google Account information
 
Now you’re done!  All synced browsers will automatically maintain their sync across all your PC’s!
This can also be used as backup or in the event of a catastrophic failure.  You simply have to sync Chrome on the new PC to restore your Chrome bookmarks and settings.
Get familiar with your 'Print Screen' key on your keyboard. Very useful for capturing the lengthy error messages on screen that are needed when reporting a problem.

More Tips & Tricks

Jul, Tue 26th, 2011
Posted In:Tips & Tricks
By:admin
Check the Connected Cables

Sometimes a peripheral, like a printer or speakers, will stop working normally. The speakers will crackle or the printer stops responding to the computer. Often this can be a symptom of a simple problem; the cables might not be fully connected to your computer. This happens a lot with laptops that move around a lot and constantly have cables being plugged into and pulled out of them. Make sure all connected cables are fully seated in their respective slots and things should work just fine.

Only Use Your Antivirus Software
Be aware of the specific anti-virus program you have installed. You can find it running in your system tray (the area of icons near the clock in the bottom-right corner). Remember its name; Vipre/AVG/Microsoft Security Essentials/Avast/etc. Many viruses and malware programs try to mimic a real anti-virus program and ask you to click on them to “scan” your computer. They will have clever names like “Microsoft Virus Scanner” or “AntiVirus 2010.” If you do what they ask, they will infect your system with viruses. If you don’t recognize the name, don’t click the pop-ups!
Did you know? 

As most Windows users have experienced at one point or another, software conflicts and bugs can cause undesirable effects, which may prompt you to restart your computer.  What you may not know, is that the best way to restart is to power down the computer for 10 seconds, and then power up again, instead of just clicking restart.  This allows the computer components to drain and reset completely, instead of just restarting Windows!
“Who needs a mouse…”
For those that prefer to leave their hands on the keyboard as much as possible, here are some handy keyboard shortcuts for Windows:
CTRL+C:                             Copy
CTRL+X:                              Cut
CTRL+V:                              Paste
Alt+Tab:                               Switch between open programs
Alt+F4:                                  Close the current program
Windows Logo+R:            Open the “Run” command box
Windows Logo+L:             Lock the computer (forces a login to get back into the computer)
A more complete list can be found at:  http://support.microsoft.com/kb/126449

Here are a few simple tips and tricks!

Jul, Mon 25th, 2011
Posted In:Tips & Tricks
By:admin

Don’t Be Afraid to Reboot!

Sometimes the simplest and more effective fix to a strange problem with a computer is simply to reboot your machine.  While it’s not recommended to reboot multiple times in a row, it will not harm your system to restart every so often.  In fact, your system will need a reboot every so often to clear out stale processes and other things that bog it down.

 

 
-