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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH functions.
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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.
New to 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 Excel tutorial from ExcelIsFun, the 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
Led Zeppelin's famous song "Stairway to Heaven" is totally worth learning. Whatever the social function there's bound to be a group of folks who get down on jamming with those familiar chords. This video tutorial demonstrates how to play "Stairway to Heaven" on an acoustic guitar in a clear and simple manner, so grab your six-string and head striaght up those stairs to acoustic heaven.
Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of transactoinal records and extract only the new records (records that are in new list but not in old list).
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
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.
