IT cheat sheets for all

They may seem like no-brainers to you, but some of your IT tricks and workarounds look magical to your peers. We've collected our favorite IT cheat sheets on topics ranging from AS/400 to HTML and Outlook so everyone can look like a whiz.

They may seem like no-brainers to you, but some of your IT tricks and workarounds look magical to your peers. We've collected our favorite IT cheat sheets on topics ranging from AS/400 to HTML and Outlook so everyone can look like a whiz. If you have a favorite (original please) cheat sheet or shortcut, send it along to [email protected] and you'll be eligible to win our Cheater's prize: A $50 American Express gift certificate. Send us your secrets!

  AS/400  
The AS/400 - formally renamed the "IBM iSeries," but still commonly known as AS/400 - is a midrange server designed for SMBs and departments in large enterprises and now redesigned so that it will work well in distributed networks with Web applications. There are a number of resources available to help you save time.

            AS/400 commands for Unix programs
            http://www-128.ibm.com/developerworks/eserver/articles/building.html
 
            Common AS/400 commands
            https://whatis.techtarget.com/reference/Common-AS-400-commands
 
            Favorite iSeries cheat sheets
            https://search400.techtarget.com/general/0,295582,sid3_gci1049222,00.html>
 

  Databases  
If your database goes down, your business is down. Check out these quick commands to get your database up and running in a snap.

MySQL cheat sheet
http://www.ilovejackdaniels.com/cheat-sheets/mysql-cheat-sheet/

Oracle cheat sheet
http://www.technochallenged.com/oracle-8-cheat-sheet.html

SQL cheat sheet
http://www.3gwt.net/demo/SQL_redux.html

  HTML and Web page  
Coding HTML can be time consuming and daunting. Mistakes are easy to make and hard to find. These cheat sheets offer a number of shortcuts to help you code quickly and successfully.

A simple guide to HTML
http://home.alphalink.com.au/~rhduncan/htmlguide/cheatindex.html

Web Monkey HTML cheat sheet
http://www.webmonkey.com

Cheat sheet for creating links
http://www.webdiner.com/webadv/begin/cheat4.htm

Copy and paste JavaScript cheat sheet
http://javascript.internet.com/

ASCII code
http://htmlgoodies.earthweb.com/tutors/ascii.html

Special characters
http://www.webmonkey.com/webmonkey/reference/special_characters/

"&" Commands
http://htmlgoodies.earthweb.com/tutors/&command.html

XHTML cheat sheet
http://www.htmlgoodies.com/primers/html/article.php/3616166

Cascading Style Sheet (CSS) cheat sheet
http://www.tek271.com/articles/css_cheat_sheet.html

  Keyboard shortcuts  
If Ctrl+Alt+Delete is the only keyboard shortcut you know, then you definitely need to check out these keyboard cheat sheets.

Mac OS X keyboard shortcuts
http://developer.apple.com/documentation/UserExperience/Conceptual/OSXHIGuidelines/XHIGKeyboardShortcuts/chapter_20_section_1.html

Keyboard shortcuts for Windows
http://www.labmice.net/articles/keyboard.htm

Keyboard shortcuts for Word
http://www.fgcu.edu/support/office2000/word/shortcuts.html

Keyboard shortcuts for Excel
http://www.fgcu.edu/support/office2000/excel/shortcuts.html

Keyboard shortcuts for PowerPoint
http://www.fgcu.edu/support/office2000/ppt/shortcuts.html

Microsoft Outlook -- Keyboard shortcuts
http://blogs.msdn.com/kclemson/archive/2003/12/19/44746.aspx

Alt+num combinations for Word -- sorted by task
https://itknowledgeexchange.techtarget.com/itanswers/keyboard-shortcuts-for-ms-word/


  Microsoft Outlook  
Managing your email takes enough time from your day. Use these following resources to learn how to handle your email quickly and efficiently.

Outlook Express shortcuts
http://www.stevenchalmers.com/Tips/Outlook.shtml

Setting rules in Outlook to limit spam
https://searchexchange.techtarget.com/tip/Create-Outlook-2007-rules-to-organize-email


  Microsoft Word and Excel  
Whether it's copying and pasting or creating charts, these resources offer shortcuts and commands for two of the major Microsoft Office applications -- Word and Excel.

Getting rid of that (*)#"@^ paperclip! -- Taming the Office Assistant
http://www.addbalance.com/word/officeassistant.htm

Creating equations in Word
http://ist.uwaterloo.ca/ec/equations/equation.html

Using the basics in Excel
http://www.carleton.edu/campus/ITS/staff/sfox/excel_cheat_sheet.pdf


  Operating systems  
Windows (Vista, XP, 2000, 98, NT, ME), Unix, Linux and Mac OS are just a few of the operating systems SMBs may use. Use these resources to learn ways to save time with your operating system.

Cisco IOS Cheat Sheet
http://www.skullbox.net/ioscheat.php

Windows Vista cheat sheet
http://software.silicon.com/os/0,39024651,39164399,00.htm

DOS commands
http://www.csulb.edu/~murdock/dosindex.html

DOS to Linux cheat sheet
https://access.redhat.com/documentation/en-us/

Linux Cheat Sheet for Mac and Windows Programmers
http://www.mozilla.org/build/unix-cheatsheet.html

Rosetta Stone for Unix
http://bhami.com/rosetta.html

Treebeard's Unix cheat sheet
http://www.rain.org/~mkummel/unix.html


  Programming and scripting languages  
Haven't programmed since the days of FORTRAN? Don't worry, use these resources to get you up to date?

Javascript cheat sheet
http://www.ilovejackdaniels.com/cheat-sheets/javascript-cheat-sheet/

Ruby script cheat sheet
http://www.zenspider.com/Languages/Ruby/QuickRef.html#36

Python cheat sheet
http://www.yukoncollege.yk.ca/~ttopper/COMP118/rCheatSheet.html

PHP cheat sheet
http://www.ilovejackdaniels.com/cheat-sheets/php-cheat-sheet/

PHP cheat sheet
http://www.blueshoes.org/en/developer/php_cheat_sheet

ASPLogin
http://support.acmeinternet.com/powerfaqs/asplogincheatsheet.htm

Erich's Java cheat sheet for C++ programmers
http://www4.ncsu.edu/~kaltofen/courses/Languages/JavaExamples/cpp_vs_java/

  Search engines  
Search engines have become the go to place for looking for information. Don't waste time sorting through results you don't need or want. Use these commands and search techniques to find what you're looking for as quick as you can.

Ask.com cheat sheet
http://websearch.about.com/library/cheatsheet/blaskcheatsheet.htm

Google cheat sheet
http://www.adelaider.com/google-cheat-sheet/

GoogleGuide cheat sheet
http://www.googleguide.com/advanced_operators_reference.html

Yahoo cheat sheet
http://websearch.about.com/library/cheatsheet/blyahoocheatsheet.htm

>> For many more cheat sheets, check out WhatIs.com's list.

Read more on Operating systems software