Even seasoned users of Excel might not know that you can use the COUNTIFS, DCOUNTA, and SUMPRODUCT functions to count the number of entries that fall between the values given by two other cells. Well, you can. And in this Excel tutorial from ExcelIsFun, the 545th installment in their series of Excel magic tricks, you'll learn how to do just that.
Remember that DVD Shrink is basically a free software that backs up DVD movies on your computer by shrinking them to a manageable size as configured by you. You would need a separate DVD/CD burning software to actually write the disc. This video is for newbies to DVD Shrink and basically gives the user a good overview of the main function(s) of the software.
Watching this video will teach you a couple different ways to use the auto-focus function on your Canon 40D camera. You can set the auto-focus to the same for every shot, or you to change it for every shot very easily. Whichever one you choose, this video makes it easy to understand.
Simon Leach from Simon Leach Ceramics provides some great workshop footage on preparing to glaze Raku ceramic pots. This tutorial video provides answers on the beauty and function of Raku pots, as well as some great ideas for home decoration. Simon walks you through the process of glazing these pots, including important specifics about proper materials and methods, easy recipes for making your materials and tools at home, as well as common mistakes that you should avoid when glazing your cera...
In this video, you will learn the steps to take to enable JavaScript in Microsoft's Internet Explorer (IE) web browser. Although JavaScript support is typically enabled by default in most modern browsers and many web applications depend on JavaScript being enabled to function properly, some persons and organizations may occasionally disable JavaScript to negate the effects of annoying or insecure implementation of JavaScripts on some web pages (such as pop-ups, hidden tracking links, unwanted...
This video explains how to find the sign of slope of a line. The way shown means that you can find whether it is positive or negative without knowing its equation. It uses a simple analogy so that anyone would be able to use this method, even without much math knowledge. Being able to find the slope of a line is very important, as it leads to advanced function and calculus.
Automixing in Virtual DJ is basically a jukebox function that will attempt to mix two songs together, without you having to do it manually. Discover how it works in this video. Download a free trial of Virtual DJ and start mixing.
There comes a time in a phone's life where it needs a completely fresh start. Delete contacts, photos, and more on the iPhone using the "Erase iPhone" function.
In this video, get to know the Verizon Droid from Verizon Wireless. In this video, learn about the useful features and functions behind this phone, like watching YouTube videos in high quality, and getting alerts while browsing.
The locks in most houses are fairly basic, making this lock picking technique fairly easy. If your door lock has a hole in it, and functions similarly to the one in this video, check this video out! All you need is a bobby pin.
The slip knot, also called a running knot, is a very diverse knot. It's practical application ranges wildly from crochet and knitting to building a noose. The basic function of a slip knot is to create a flexible knot, with one end tied to the middle for greater mobility. Check out this how to video and learn how to tie a slip knot, because you never know when you might need it.
Augmented reality comes to the iPhone at least in the Yelp application. Check out this video iPhone tutorial and learn how to turn on this handy function. Now you can use Yelp on the go. Follow along with the steps and learn how to use the iPhone's Augemented Reality Yelp application.
Mistress Didi brings you an instructional video on how to have graceful hands. These are simple exercises for beauty and function. Graceful hands can create greater comfort and beauty in your self-expression. Use these exercises if you want to achieve graceful hands.
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 COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this 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 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.
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.
