Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
Purplesn0w and Purplera1n are both very powerful tools for jailbreaking an iPhone, and this video will show you how to use them! Before you begin, it's important to know that this tutorial will only work if you have 3.0 firmware. If not, download it, or check out another video that covers 3.0.1.
Google SketchUp is a powerful 3 dimensional modeling tool that boasts comprehensiveness and versatility for the average, everyday user. Unlike some of its contemporaries, this program is very user friendly. Check out this tutorial and learn how to go about modeling a Tractor from start to finish in Google SketchUp 6. It is sped up so it takes only 8 minutes to watch, though the original model took about 65 minutes to complete! Feel free to pause at any juncture during the tutorial in case you...
Check out this two-part Autodesk Maya 8.5 video tutorial on creating set driven keys. If you're and animator and your having trouble with your organic or unorganic animation, maybe this is your problem; it's a very powerful tool in 3D modeling in Maya. When ever you come into an object that you are constantly rotating, maybe you should put a set driven key on it, no?
There are some very powerful tools in CINEMA 4D that you can use very quickly to create some 3D graphic elements. Once you start practicing you'll find it may be easier to create your own reference than to find the "just right" one on the web. So, if you're in need of some barbed wire, for reference or otherwise, check this tutorial out. Of course, it takes quite a bit longer to actually SHOW you how to create the barbed wire (creating the barb, wrapping it around the wire, using MOGRAPH in o...
Hedge trimmers are powerful pieces of yard equipment, but even their mighty blades go dull and stop cutting well. Watch this video to learn two different methods for sharpening hedge trimmer blades, one using a mill file and the other using a power grinder.
The life of a busy entrepreneur isn't easy. In addition to coming up with original business ideas and marketing strategies, you also need to be continually thinking about investors, overhead, the competition, and expanding your customer base — often with a limited budget.
Few things are more important than search engine optimization when it comes to increasing a brand's visibility online. Regardless of whether you're launching a new business from scratch or working as a marketing professional at a major corporation, you need to ensure that you're drawing the most people to your website and affiliate links by utilizing the latest and most powerful SEO tools and methods.
I've been doing tutorials on Rasberry Pi and I would like to thank everyone that have both read the tutorials and gave me feedback on how well I'm doing. But now I've decided to take a small break and start a mini series that I'm hoping to be at least five tutorials. This doesn't mean I'm gonna stop posting Raspberry Pi tutorials, but since I'm learning so much at the same time I've decided to share some of that knowledge. Hence this tutorial. Please sit back, relax and read on.
Google's Chrome browser is evolving into a very powerful platform. Not only can it be used to view your favorite website or mirror tabs to your Chromecast, but now that it has an App Engine, more powerful tools can be run within Chrome.
In this web design tutorial, you will learn to use the Xara Shadow Tool. Use the Xara Web Designer shadow tool to add shadow types such as: floor, wall and glow.
jQuery is a popular and powerful Javascript that is easy to use and heavily extensible. Have you wanted to learn how to use it, but lacking in the Javascript skills expected of you by many tutorials on the subject? This video for beginners will introduce you to the basics of using jQuery, from downloading it to making your first projects. Now you can take advantage of this powerful library to make your websites more dynamic and increase traffic.
If you've got an extra DVD drive laying around not being used, watch this video and learn how to give the lens new life—as a powerful macro lens for your camera phone! You'll be able to take incredible pictures on your camera phone using this clever mod.
This is a tutorial that will show you how to create a powerful bow and for under $5. The material you'll need is 1 curved pipe, poly poli string, tape, scissors, and a knife. First you want to cut a slit and a hole on each end of the pipe and then add some tape underneath it to prevent it from splitting. Next, you want to line up the string with the pipe and cut it at that length. Also, you want to tie a knot at both ends of the strings and attach it by using the slits you made in the pipe. T...
If you live in a cold climate, a snowblower can really be a lifesaver during the winter months. But a snowblower is actually a pretty powerful piece of equipment, and using them incorrectly can be very dangerous. In this video tutorial, Tim Carter, of Ask the Builder, shows you how to safely use a Craftsman snowblower.
This audio editing software tutorial will show you how to use all the different editing tools in Pro Tools. This includes the zoom, edge, selector, grabber, scrubber, and pencil tools. (Connor Smith also talks about the multiple types of zoom tools, the time compression/expansion and loop tools, and also the object and separation grabber tools). So if you aren't familiar with the editing tools available in Pro Tools, watch this tutorial and get started editing music!
This audio editing software tutorial will show you how to use the smart tool in Pro Tools. Besides showing you the smart tool, Connor Smith will cover the different edit modes (shuffle, spot, slip, grid, and relative grid) available in Pro Tools.
A jigsaw is a powerful piece of equipment, and it can make your home repair projects go a lot faster. But what should you look for when buying a jigsaw? In this tutorial, Mark Donovan of HomeAdditionPlus.com explains what you should look for when you are going to purchase jigsaws and jigsaw blades.
Before you can get started recording or mixing in Pro Tools 9, you'll need to create a new session for your project. This free video software tutorial from Lynda presents a complete and thorough overview of the process. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief video.
Learn how to use the Beat Detective drum replacement tool in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using Beat Detective in your own Pro Tools projects, watch this free video guide.
In a tool shed there are two gentlemen discussing how handy a well organized tool shed or tool box is. One man starts to say that he has come up with a easy and in expensive way to keep hand tools organized. Find a old simple nail apron and draw some lines down the pouch. This lines will later turn into places to put tools so it is a good idea to think ahead about what tools you will end up using and adjust the size accordingly. Next, snitch up those lines that you have drawn. Finish up by pu...
A tool rack doesn't need to look great, it just needs to keep your tools organized. But having your tool rack look its best can really improve the whole look of your tool storage area. In this video tutorial, Mark Donovan of HomeAdditionPlus.com shows us how to install a level, good-looking tool rack.
Choosing which programming language to learn next can be a truly daunting task. That's the case regardless of whether you're a Null Byter just beginning a career in development and cybersecurity or you're a seasoned ethical hacking and penetration tester with years of extensive coding experience under your belt. On that note, we recommend Python for anyone who hasn't mastered it yet.
For anyone using open source information to conduct an investigation, a balance between powerful tools and privacy controls are a must. Buscador is a virtual machine packed full of useful OSINT tools and streamlined for online research. This program can easily be set up in VirtualBox, and once that's done, we'll walk you through some of the most useful tools included in it.
Snapchat just fast-tracked the majority of its app user base into the world of augmented reality production by making its Lens and Filter tools available to anyone with a web browser.
Want to speed up or slow down an audio region while leaving its timbral characteristics alone? Whether you're new to Digidesign's Pro Tools digital audio workstation (or DAW) or just want to learn how to take advantage of Pro Tools 8's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use Pro Tools' Elastic Audio feature to time warp audio regions.
Want to quickly undo an edit in Pro Tools 9? This free video software tutorial from Lynda presents a complete and thorough overview of the process. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief view.
Learn to navigate and use the menu system in Pro Tools 9! This free video software tutorial from Lynda presents a complete and thorough overview. Whether you're new to Pro Tools or just new to Pro Tools 9, Avid's first native, software-only version of their popular Pro Tools DAW, you're sure to find much of value in this brief view.
Want to learn the basics of mixing and mastering? Whether you're new to Digidesign's Pro Tools digital audio workstation (or DAW) or just want to learn how to take advantage of Pro Tools 8's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use Pro Tools' assorted plug-ins and tools to mix and master.
If there is anyone who can help you get closer to finding your true love it is Dr. Diana Kirschner. Dr. Kirschner is a love expert, media psychologist and bestselling author. She is the go to psychologist on most talk and reality TV shows and for newspapers and magazines in need of a relationship expert.
So much information exists online that it's easy to get lost in data while researching. Understanding the bigger picture can take a lot of time and energy, but narrowing the question to one that's easy to answer is the first step of any investigation. That's why analysts use open-source intelligence (OSINT) tools like Maltego — to help refine raw data into a complete understanding of a situation.
Welcome back, my neophyte hackers! Metasploit is such a powerful tool that I can only scratch the surface of its capabilities here. As it has developed over the years, it is now possible to use Metasploit for nearly everything from recon to post exploitation to covering your tracks. Given its versatility, every aspiring hacker should have at least a tentative grasp of Metasploit.
Many marketers are NOT using this powerful strategy to get free traffic and increase their brand exposure. It's as simple as signing up for a free Gravatar account and commenting on blogs in a similar niche. See some good examples and some bad examples...
Move over Pro Tools LE— Pro Tools 9 is here! One of the most exciting things about Pro Tools 9 is that there's more tracks without having to have a Toolkit. Another great thing is being able to run Pro Tools without having to use Digidesign, M-Audio or any Avid hardware. Also, there's Delay Compensation Engine on a native system that doesn't require HD hardware or HD native. And this is just the beginning. To see more of the features in Pro Tools 9, watch this overview video.
In this tutorial, we learn how to maintain your tools for extended usage. First, get a good sturdy brush to clean off all the crusted on dirt from your tool. The dirt will promote rust and deteriorate your tools. Once it's cleaned, also make sure it's dried off from anything that is wet. Also set the tool on a flat surface or table to remove rust off of the tool. You can also sharpen the sides of the tools or shovels so you are pulling out any kinks and making it sharp and more useful. Once f...
Learn how to use the Beat Detective tool to convert drum transients into MIDI notes when working in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using this useful drum replacement trick yourself, watch this free video guide.
Learn how to punch up your drum tracks when working in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started improving drum sounds in your own Pro Tools projects, watch this free video guide.
Learn how to use Pro Tools 8's time warp features to conform and quantize your audio files. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started conforming and quantizing audio clips in your own Pro Tools projects, watch this free video guide.
This video instructs the viewer on how to do a powerful Driven Free kick for soccer. First, you will need to come on to the ball and strike it with your in-step. Your in step is the inner part of your foot that is right next to the laces. The most important tip is that when you do strike the ball, come through the ball and not around it! Finish with a hop at the end which will create more power! You'll want to kick the ball just under the center for proper height and maximum power. Kick the b...
The most important items in a tool kit, are the protection and safety equipment, like a breathing mask, ear muffs, and eye goggles. Other than that, tools vary on your needs. Some basics are a handsaw, a hacksaw, a level, a hammer, screwdrivers, a measuring tape, a shifting wrench, a chisel, pliers, a combination square, a utility knife, and a clamp. Watch this video home improvement tutorial and learn how to select tools for a basic tool kit.
