Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
This image editing software tutorial gives a quick look at the transform functions in Photoshop CS3. This tutorial is for brand new Photoshop users who aren't familiar at all with the workspace. The tutorial covers the tools under the edit menu including flip, rotate, and other transform tools and commands.
Check out this instructional electric guitar video that shows you how to use the Electro Harmonix Q Tron Plus pedal. This demonstrational video is presented by Dave Weiner. With this tutorial, learn about all the functions and capabilities of the Electro Harmonix Q Tron Plus pedal.
Check out this instructional electric guitar video that shows you how to use the Electro Harmonix Micro POG pedal. This demonstrational video is presented by Dave Weiner. With this tutorial, learn about all the functions and capabilities of the Electro Harmonix Micro POG pedal.
Check out this instructional electric guitar video that shows you how to use the Electro Harmonix Holy Grail Plus Reverb pedal. This demonstrational video is presented by Dave Weiner. With this tutorial, learn about all the functions and capabilities of the Electro Harmonix Holy Grail Plus Reverb pedal.
This tutorial covers installing the WAMP (that is, Windows-Apache-MySQL-PHP) all-in-one package and creating a MySQL database using the import function of phpMyAdmin. For step-by-step instructions on the WAMP installation process, or to get started installing your own WAMP serve, take a look.
This instructional knitting video demonstrates how to do a purl stitch. The purl stitch usually functions in tandem with the knit stitch. For the purl stitch, always remember to keep the working yarn in front of your needles. When switching from knit to purl stitch, you will move your working yarn from the back of the work to the front of the work to prepare for a purl stitch.
On OS X Mac portables, like the MacBook and MacBook Pro, the delete key backspaces, or deletes backwards. If you're accustomed to having the keyboard delete forward, just hit function delete. For more, watch this MacBook video tutorial.
This video editing software tutorial shows you how to remove green screen backgrounds using the chromakey tool in After Effects. Removing backgrounds from footage is a common function in After Effects. It allows you to put your subjects in new scenes, movies, effects and backgrounds. Learn how to chromakey in this After Effects CS3 tutorial.
This software tutorial will teach you to use the 3D layer function in Adobe Photoshop CS3. You will learn how to use the 3D tools to move and manipulate imported 3D objects. So find some 3D objects and learn to import and use them in Photoshop CS3 with this tutorial.
Looking for a way to pump up the crowd? In this video tutorial, you'll learn how to employ the loop function in Traktor, formerly known as Traktor DJ studio, to create build-ups and drum rolls without much effort. For a step-by-step walkthrough, press play!
This photo editing software tutorial shows you how to use this free software FastStone Photo Resizer 2.5 for Windows to batch rename and resize your images. Make life easier and resize and rename your photos all at once with the batch functions in FastStone Photo Resizer 2.5.
Sometimes the hardest step to operating a new mobile phone is just turning it on. This video guide to the LG C200 shows the basic getting started type functions, from turning it on and off, to charging, taking photos, and making phone calls. Watch this video cell phone tutorial and learn how to use the LG C200.
Take a look at this instructional video and learn how to use the navigation tools in Google SketchUp. This tutorial covers how to use the orbit, zoom, and pan tools; how to navigate using the scroll wheel on your mouse; tips for zooming; and the functions of zoom previous, next, and zoom extents.
Take a look at this instructional video and learn how to use the tape measure tool in Google SketchUp. You can use this tool to measure edges and distance, create construction geometry or dashed guidelines, and resize individual groups or the entire model. This tutorial covers all three of these functions in a step by step guide.
Take a look at this instructional video and learn how to use the move tool in Google SketchUp. The move tool is actually several tools combined into one. The move tool functions as an auto fold and an array tool as well. This tutorial covers how move is an auto-selecting tool, how to pre-select objects for more control, moving objects with precision, and some common problems.
Take a look at this instructional video and learn about the basics and functions of components in Google SketchUp. The difference between components and groups being that groups have no relation to each other. Any of copy of a group is a completely separate entity. This tutorial covers components versus groups, how to edit components, and the component browser.
Do you spend too much time performing basic functions in Safari? In this tutorial, Gary Rosenzweig takes a look at three simple techniques that make web browsing easier (and thus faster) in Mac OS X: tabs, find-in-a-page, and the bookmarks. Master each of the abovementioned browser features with this how-to.
Check out this instructional turntable video to learn how to cue your vinyl records. It's not scratching, but it is cueing. This takes some skill because you want to align two songs perfectly in sync. Remember, this only works if the stop and start time of your platter are the same! It does not matter if your start or stop time is 1 hour, 34 minutes and 48 seconds! Use this method if you need a clean, fast and easy way of starting a vinyl in sync. This video tutorial is great for DJs and anyo...
This tutorial shows you how to build web services with MapForce. Load an existing WSDL file and build a complete web service by retrieving data from databases or XML files and using a visual function builder. It's easy to build web services in MapForce as this tutorial shows.
The Formula AutoComplete feature in Office Excel 2007 helps you avoid syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. Watch this tutorial and then try it yourself.
Watch this instructional cello playing video that explores the mechanics of playing the vibrato on the cello. The vibrato is an advanced function on the cello that will take a lot of time to master. This tutorial introduces the basic motions to help develop vibrato and aid beginners with their cello skills.
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
In this web application development tutorial you will learn how to use brushes in Microsoft's Silverlight for color, gradient and video. Learn how to write ASP.Net functions in Silverlight to control colors, shapes, gradient and videos on your web app or web page.
This is a tips and tricks video on how to use Microsoft Outlook's calendar function. Outlook is the email software provided by Microsoft Office suite. If you are new to Outlook or Outlook 2007, check out this video and learn some tips and tricks for working with the calenddar.
Take a look at this tutorial and learn how to get additional features on your iTUnes with Growltunes. On top of polling features, this application allows you to use various instant messagers such as amsn, msn, and skype.
Take a look at this tutorial and learn how to install the Joysens 1.42b plugin for the Playstation portable. This plugin is for the analog stick on the PSP. It allows you to add the directonal buttons function onto the joystick as well as provide fixes and realignments for coordinates. Note that this video requires a custom firmware of 3.80m33 or higher.
NFX explains how a Vocoder works, specifically the Vocoder in FL Studio. Even if you don't have Fruity Loops, the functions of a vocoder are similar so you can still learn.
This tutorial will show you how to make your own keyboard shortcut keys to speed up the processes and functions you use the most while getting your Gimp on.
This tutorial covers the very basic functions of using layers in GIMP photo editing software. A good tutorial for GIMP beginners, but if you know Photoshop or other layer based programs, you should skip this one.
This video quilting tutorial shows how to choose and use an appropriate ruler for quilting. Certain kinds of quilting rulers are multipurpose and will be able to perform any beginning quilting function. Learn how to pick out and care for a quilting ruler by watching this instructional video.
Making a buttonhole is easy to sew using the buttonhole presser foot and the four step buttonhole function on a Singer sewing machine. This video sewing tutorial guides through the simple step by step process of making a professionally finished buttonhole. Watch and learn how.
Superglue (cyanoacrylate) has many uses. Besides the typical household function of sticking things together, it's used in surgical procedures and even in crime labs to develop unseen fingerprints. Originally marketed as Eastman #910 in 1958, this stuff is sneaky and it goes everywhere if you don't keep an eye on it.
This tutorial video will show you how you can make your very own Tag Book. A Tag Book is a little book with tags in it, and on each side of the tags are pictures and text. They serve much the same function of a scrapbook, and can make any occasion seem all the more special.
This tutorial video will teach you to make a lovely envelope/thank you card. This is a very cute paper craft idea that your family and friends will surely love. It functions as an envelope and a card!
Regular cleaning of an in-the-ear hearing aid is essential so the sound can escape and be heard. A hearing aid plugged with ear wax prevents proper functioning of the device by making it sound dead or broken. Watch this video tutorial to learn how to clean a hearing aid from an audiologist.
This is a video tutorial to show how to create embossed backgrounds with embossing folders, some cardstock paper, and ink. Learn how to use the Cuttlebug embosser with innovative functions. This video also gives instructions on how to clean off the ink from the Cuttlebug embossing folders.
Joy and Gracie show us how to make a newborn infant stop crying and sleep in peace using a wine tasting secret. This is a Japanese Urawaza trick that uses the white noise of a gurgle to ease a baby's cry.
Use a compact wood burning stove. Check out this how to tutorial to learn how the features function.
