In Excel 2010 Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course. Course outline on next page.

• Read more + Download »

In his new Photoshop Extended One-on-One series, Deke McClelland covers the basic techniques for working with 3D in Photoshop, showing how to create textured type and drawing objects that can be manipulated in 3D space. The course covers creating 3D type with Repoussé; moving, scaling, and rotating objects along the X, Y, and Z axes; applying materials to create believable textures; adding realism with lighting, shadows, and contrast; and more. Exercise files are included with the course.

MORE THAN 5 HOURS OF TUTORIALS FOR WINDOWS AND MAC, EXERCISE FILES ARE INCLUDED.

• Read more + Download »

Join the Magic Circle Close-Up Magician of the Year, Andrew Murray, as he performs thirteen of the World’s greatest, professional, easy-to-do card tricks. Recorded live and in the studio, witness the reactions these stunning card tricks have on members of the public, and then discover just how easy they are to do yourself!

All you need to supply is a deck of cards!

• Read more + Download »

FXPHD: MYA301 – Maya in Production: Moving Day
English | MOV | MPEG4 | 1152×720 | 204 kb/s | 10.00 fps | AAC, mono | 3.5 GB
Genre: eLearning

This course, taught by Matt Leonard, is going to be slightly different from our other Maya offerings because we’re going to be working alongside a new and very exciting project called ‘Moving Day’. This short film is being directed by award wining director Jason Wingrove. ‘Moving Day’ tells the story of a young girl and her fight against the fairies who inhabit the garden of her new home. Our short film is literally being produced throughout the term and we’ll have first hand experience of working in post during a live project.

• Read more + Download »

Magic for the Eyes by Luke Dancy DVD
English | DVD5 | MPEG2 | 720х480 | 6000 kb/s | 29.97 fps | AC3, 256 kbps | 3.51 GB
Genre: eLearning

David Regal presents Luke Dancy, a rising star on the magic horizon and someone you will hear much more about! Luke has assembled a collection of some of the most visually arresting card effects ever seen, using the simplest of secret gimmicks: double-stick tape!

• Read more + Download »

Love Cards by Craig Petty & Russell Leeds
English | DVD5 | MPEG2 | 720х480 | 6414 kb/s | 29.97 fps | MCP, 1536 kbps | 4.22 GB
Genre: eLearning

For years the book test has been one of the most powerful effects available to mentalists. Now this classic effect has been brought bang up to date with a version that you can literally carry in your wallet.

• Read more + Download »