This tutorial shows how to create a great digital bokeh effect with hexagons. You will use the brush tool the polygon tool, blends, layer effects, and filters in this tutorial.

It can be used for a really nice background.

Click here to see the tutorial.

How to create creative designs with vectors in Illustrator. This tutorial shows you the process of creating a nice design with Illustrator by using various tools and techniques.

Click Here to view the tutorial.

In this tutorial you will learn how to create the neon effect in Photoshop using layers, filters, and other tricks.

Click here.

In this tutorial you will learn how to create a very cool typographic portrait in Photoshop.

In this tutorial you will use the Displace filter and some Blend Modes to create this effect.

Click here to view the tutorial.

I found this great list over at CSS-Tricks that Chris Coyier put together for what Designers These Days Should know.

...have a good design sense and understand the fundamentals / design principals.
… know all the major design software including the entire Adobe Creative Suite.
… have some basic video editing skills.
… know HTML, CSS, and JavaScript.
… know enough about server-side languages (PHP, ASP, Ruby, Python, etc) to understand how they work, what they do, and the possibilities of their use.