How-to's on current (design) trends in Web Design?

You must check out http://twitter.github.com/bootstrap/. It works out-of-the-box on desktop and mobile so you cover the biggest "trend" of all, which is, http://mashable.com/2012/12/11/responsive-web-design/. Another important "trend" is http://coding.smashingmagazine.com/2012/08/20/towards-retina-web/.

Check out http://www.abookapart.com/products/responsive-web-design. Their http://www.abookapart.com/products/html5-css3-bundle are also good. Some of the Photoshop effects in the article you linked are tutorialized http://www.webdesignermag.co.uk/tutorials/create-stitched-effects-using-photoshop/ and links to http://www.handmadeology.com/your-cheat-sheet-for-re-creating-the-hottest-graphic-design-trends/.

I get that you want tutorials on what will have been the design and layout cliches of 2013, but maybe look at HTML5/JS-based Flash replacements like CreateJS and Adobe's Edge Tools (coincidentally including Edge Reflow, a tool for responsive design that they have in preview apparently). I can't say I'm thrilled about it, but animations will probably come around again as performance and platform issues disappear.

http://foundation.zurb.com/ is a good front end framework to work with.

Honestly, I would pursue some of the things you can do these days with CSS3, things that previously were only available with images. It really is pretty amazing the sorts of things you can do now, that work very well indeed anywhere other than older IE versions (as usual). I think you'll find that a lot of what is current in terms of design trends eschews the kind of image-heavy photoshop-sliced stuff of the past and goes more for simplicity and elegantly-degrading designs using CSS3, judicious scripting, and (increasingly) HTML5. Here's http://coding.smashingmagazine.com/2012/06/21/powerful-new-cssjavascript-techniques/ SmashingMag article from a year ago that talks about some of that.

http://tympanus.net/codrops/ is also a good resource to follow - a mix of tutorials and inspiration. Their weekly "http://tympanus.net/codrops/collective/" has the right blend for me.

http://www.agiledesigners.com/ -- great compendium of web development resources. http://webplatformtools.org/ is a similar thing... http://hub.tutsplus.com/ is the granddaddy of web design tutorial sites. The quality isn't always awesome, but there are some great tutorials if you sift through it. Also, they do keep on top of design trends. http://webplatformdaily.org/ is a new one, and does a great job of compiling all of the day's best web development news and resources into a single page. (Like a daily -- but broader -- version of JavaScript weekly or http://html5weekly.com/, which you should also be reading) http://hackdesign.org/ has some design lessons geared toward developers.

http://www.webresourcesdepot.com/ has a lot of pdf freebies, too, if that's the way you want to go. http://www.webappers.com/ usually has good stuff as well.