New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
Created by Houdini Product Specialist Stephen Tucker, this crash course series focuses on the concept of Smooth Particle Hydronamics and how they work within Houdini. The following videos on Particle Fluids continue working with fluid dynamics in Houdini 9.5 and assume that the viewer is relatively familiar with how dynamic simulations work, or have been following along through the series. The basics are still covered including creating water from an object but also include more conceptual si...
In this video series, learn how to create a simple dynamic simulation by creating a procedural pre-vis avalanche in Houdini 9. Rigid body dynamics (RBD's) are a powerful and important part of creating visual effects in 3D. This tutorial shows you how to use them in Houdini 9 to create a procedural pre-vis avalanche.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create an old rusty control panel in Photoshop.
This is a great solution if you need to get something off your computer, but you are not home. Want access to your files stored at home? How about hosting a home web server? Static IPs are expensive, if you can even get one. We set up Dynamic DNS instead!
This software tutorial shows you how you can blend three differently exposed images using Photomatix, and then demonstrate how to use some basic Photoshop techniques to touch-up the resulting image. [Note: the Flash overlay in this video doesn't sync completely with the audio; pausing for a second and then resuming it fixes the problem.]
In the current state of the augmented reality space, Leap Motion is the only well known name in DIY AR headset kits with its Project North Star design, which gives makers the blueprints to build their own headsets.
Painting custom leather kicks like Dunks is increasingly popular as the art community realizes what great canvases these big bold shoes make. If you want to get in the game watch this video for a one-stop guide to customizing leather shoes (in this case Dunks) with whatever paint designs you want.
If you're working on a website and want users to use it repeatedly and form a community on it, you should probably give them a way to create an account and log in to your site. This video will show you how to create an AJAX login script using AJAX with jQuery, which will allow your users to do exactly what I described above, making your website much more professional and a much better place for people to stay and click on ads or whatever else you want them to do.
In this brief video tutorial, the host 'Uncle Todd' demonstrates how to 'attack a beat'. This video is intended for beginners. Watch as he shows you how to keep your tempo up as you time your drum strokes in a beat. You should practice my trying just your right foot and your right hand, and then alternating to to your left foot and your left hand. The host in this video uses an electric metronome to keep his tempo steady and accurate, something that he recommends you try at home. Don't forget...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
Todd welcomes us to a new episode of the YouTube show All Things Adobe - Chad and Todd Podcast. This episode concentrates on adding alpha and rotation effects to Dynamic Text Field in Flash CS3. First we get to see a 100 frame text animation and the preview works perfect in the program. But when you go to preview it in an outside window, the effects do not work, due to the default nature of the settings. You have to go to Library, then click the text symbol. Click embed in the property inspec...
There's no better way to learn or simply brush up on a scripting or programming language than using it. In keeping with that philosophy, this video tutorial will walk you through putting together a full-featured, dynamic clock app that keeps track of both the tdate and time.
You can take high dynamic range photos with a regular point and shoot digital camera. You may need to take up to three versions of the same photograph and make a high definition composite photograph. Even a small digital camera can take three photographs at the same time using an auto bracketing feature. You can also do this by hand if you have a steady hand or a tripod. Edit the individual photographs on the computer using Adobe Photoshop or a another digital photo editing program.
Get moving! Learn how to walk, run and jump your way through LittleBigPlanet. LittleBigPlanet exclusively for the PLAYSTATION 3. It lets you PLAY alone, or with friends, in a world of infinite possibilities. Run, jump, grab and swing your way thru imaginative levels and mini-games. If you're feeling creative, you can CREATE your own levels, enemies, obstacles and even storyline. Once done, SHARE them with our online community of thousands of User Generated Levels from around the world for
Stick it to them! Learn how to resize, rotate, and stamp your sticker collection in LittleBigPlanet.
Get some clothes on! Dress up or Dress down, learn how to express your own SackFashion for Little Big Planet on PS3.
I'm starting to wonder if the people at Boston Dynamics have ever watched a Terminator movie. Not just because the robotics company with the oxymoronic name develops machines that are able to move around environments with animal- and human-like agility, but because the people testing them seem to take such joy in openly antagonizing their creations. It's one thing to tempt fate by creating superhuman robots that could potentially end mankind. You've reached a whole new level of hubris when yo...
Welcome back, my novice hackers! In a recent tutorial, I showed how the SNMP protocol can be a gold mine of information for reconnaissance on a potential target. If you haven't already, I strongly suggest that you read it before progressing here, as little of this will make much sense without that background.
Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.
As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.
"Necessity, not novelty," is a phrase I use often when it comes to HoloLens development. It would be fair to call it my mantra, or mission statement, as I prototype and explore software creation on this new frontier of mixed reality.
During today's press event at the company's headquarters in Cupertino, California, Apple announced that iOS 7 will come bundled with several new ringtones—something that has stayed relatively static the past few years.
Give your animated characters realistic looking hair by using MoGraph Physics with Cinema 4D! You can use the same principles to animate fur, grass or anything similar. This is a pretty simple technique that anyone reasonably familiar with Cinema 4D can pick up.
In this tutorial, create concave objects in Cinema 4D such that particle objects behave and interact realistically with the concave object. The automatic setting for objects is configured in a way that simplifies calculation and speeds up rendering time. By changing the automatic setting within Cinema 4D, the physical properties of concave and curved objects are calculated more thoroughly and are rendered more realistically.
This tutorial shows you how to replicate a popular Hollywood technique. It can be difficult to get the camera projection look with an actual camera, but Adobe After Effects has an easy alternative. Turn any 2-D still image into a dynamic 3-D clip.
In this video tutorial, we learn how to get started using HDR (or high dynamic range) toning in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
In this clip, you'll learn how to create custom, dynamic slideshows with Adobe Flash Professional CS5. Whether you're new to Adobe Flash or merely unfamiliar with Flash Professional CS5, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
This video tutorial covers creating a fun and dynamic title sequence in After Effects. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
In this clip, learn how to create eye-catching idents in C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
Learn how to use the bend deformer to make your models a little more dynamic without having to learn all that bothersome animation stuff! Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with application and its workflow, you're sure to be well served by this video tutorial. For more information, including detailed instructions, watch this free video guide.
The mouse is the primary way in which web users interact with most websites, and it can do almost anything if your website allows it to. This video will teach you how to use Flash CS3 and Actionscript 3 to create custom mouse and movie clip interactions. This will make viewing your website, movie, or game a much more dynamic experience.
This video from accredited Maya instructor Andrew Klein of the Art Institute of San Francisco will teach you how to use just one of the innumerable powerful features of Autodesk's Maya 3D modeling software. It covers how to use a spline IK and a dynamic hair curve to drive a joint chain and geometry for wiggly objects like hairs and antennae. Hair is a really tough thing to model well, so watch this video and master the art.
Learn how to create dynamic lines in your projects by using the Cinema 4D Tracer Object in tandem with a Sweet Nurbs object. This free, eighteen-minute video Cinema 4D tutorial will show you everything you'll need to know. For more information, and to get started using the Tracer Object in your own Cinema 4D projects, watch this helpful guide.
If you're using Adobe Dreamweaver CS4, the Spry Ajax framework menus make creating dynamic drop-down windows a snap. Whether you're new to Adobe's popular WISYWIG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS4 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating Spry drop-down menus in Adobe Dreamweaver CS4 yourself, watch this free video guide.
Whether you want to be subtle or brash, the greatly improved HDR features in Photoshop CS5 are worth a close look. This tutorial presents an overview of Photoshop's new HDR Pro and HDR Toning high dynamic range functionalities. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
Almost every website on the web has buttons that enable users to interact with it. They are easy to make, but making them interesting and reactive to user's activities is more of a challenge. This video demonstrates how to create animated rollover buttons in Adobe Flash CS4 quickly and easily. Your website will be much more dynamic and enticing if you apply the skills taught in this video.
Using Flash CS4 to make websites is a great way to make them dynamic and interesting, it can also be a daunting challenge to both new and experienced web designers. This quick video demonstrates how to create a cursive font with mask typography that resembles real cursive handwriting. Great for creating more formal look on you sites.
Adobe Flash CS4 is a powerful, but intimidating program for creating awesome, dynamic websites. This video tutorial demonstrates how to make a slideshow in the newest version of Flash and the Slideshow Pro plugin, which is readily available for free download. These step-by-step instructions should will have your images attractively displayed on your site in no time.
