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 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS 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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date criteria.
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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS function.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
This Reason 3.0 tutorial explains use of the Import Midi function and some of ways to use it for practice or remixing a popular song. Also, get tips on spicing up flat MIDI files while learning MIDI remixing and EQing in Reason 3.0
Here is a Final Cut Studio software suite tutorial on how to use the green screen function in Final Cut Pro. Footage that has been shot on a green screen can be brought in and isolated with Chroma Key settings. Once you have your subject removed from the green screen background, you are ready to apply hundreds of effects and transitions in Final Cut Pro.
This video will show you how you can trace IP address or websites to a specific location using Windows command functions.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.
Lawrence Perez, from Saddleback College, and his assistant Charlie, give this two-part calculus lesson on integrating with special substitutions; rational functions with sine and cosines: Karl Weistrass method.
This Microsoft Word tutorial discusses some tips and tricks for speeding up your work and adding extra function to Microsoft Word.
Did you know that you can make a Nintendo Wii Wiimote function as a mouse or joystick on your PC? Here's how you can use your Wiimote as a PC controller using a bluetooth adaptor or card and some specialty software called GlovePie.
Whether your training to be a doctor or a nurse, there is no doubt that this video lesson will help you better understand the procedure for musculoskeletal examinations. Musculoskeletal exams rely exclusively on inspection and palpation and tests using a combination of those techniques. The main purpose of this exam is to identify in your patient any signs of musculoskeletal disease, by way of pain, redness, swelling, warmth, deformity, and loss of function. Watch this video to see the entire...
So you've just installed iMovie on your Mac... but now what? This tutorial walks a budding director through all the basic functions and features available in iMovie, and shows you how you use them to best effect when creating your own film projects.
In this video tutorial, we learn how to create an alpha channel within 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 video tutorial, we learn how to arrange art around a circular grid when designing a CD cover 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 video tutorial, we learn how to create two separate exposures for the same image with Camera Raw when retouching a digital photograph 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 video tutorial, we learn how to use advanced search parameters like "define" and "site" to access hidden functions of the Yahoo! search engine. For more information, including a complete demonstration and detailed, step-by-step instructions, watch this how-to from the folks at CNET TV.
In this clip, you'll learn how to use Recolor Artwork when working within Adobe Illustrator CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
In this clip, you'll learn how to tell the difference between pixel dimension and resolution when working in Adobe Photoshop CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video gu...
The split view display is a useful function of an iPad application, which, by virtue of a larger screen, was not available to iPhone developers. This tutorial shows you how to work with a split view app, especially when changing your orientation.
Swype is a function for the Android phones which lets you input words by dragging your fingers across the keyboard instead of tapping. While newer phones have this feature, some older phones may not. This tutorial shows you how to equip your Android phone with Swype.
PhotoKey is a cheaper alternative to Photoshop if all you want to do is work with green screen effects. This tutorial shows you the basic Chroma Key functions available to editors in PhotoKey, so you can start adding your own backgrounds and special effects.
Having clean, functional valves is essential to proper engine function. Honda cars need to have their valves adjusted when they start to make noise. In this video you will learn how to adjust the valves on a 1996 Honda Civic.
The wheel bearings on a car are the part of the wheel that allow it to spin and carry momentum so effectively, and properly functioning ones are essential. If you want to save some money and replace the wheel bearings on your 2001 Ford Taurus yourself, watch this video to learn how to do it.
This animation can be very useful to create banners, and shows you how to use ActionScript 3 and the timeline function of Adobe Flash CS3 to set the background of mountains and a moon. Then create a few flying bats and animate them to fly across the screen in a loop!
This Adobe Flash CS4 tutorial shows you how to create a graphic symbol. Creating a graphic symbol lets you reuse the image in other projects, and set up a few other interactive and dynamic functions when you incorporate graphic symbols into your animations.
The CS4 version of Adobe Flash has altered the appearance and layout of your screen. If you draw often in Flash, this tutorial shows you how find and use the Smooth and Straighten functions efficiently and add them to a menu using the history and saving as a command.
Interested in becoming better acquainted with the sixth version of Apple's popular iPod Nano? This home-computing how-to from the folks at MacMost will teach you everything you'll need to know. For more information, including step-by-step instructions, and to get started using your new iPod Nano yourself, take a look.
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 720th installment in their series of digital spreadsheet magic tricks, you'll learn how to use filtering, the AND, TODAY and EDATE functions, and conditional formatting to show values between two dates.
This clip presents a whirligig tour of the various functions and features available on the Apple iPhone 4. Whether you're the proud owner of an Apple iPhone 4 or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including complete, step-by-step instructions, take a look.
In this clip, you'll learn how to use a few simple compositing tricks to blend indoor and outdoor architecture within 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.
You don't need a high definition television to take advantage of AppleTV! This tutorial shows you how to set up your Apple TV to function with a standard definition television set. You'll need an HDMI to DVI cable anda VGA to DVI adapter, and use the yellow composite video cords. Then adjust your settings, and you're ready to start watching your new Apple TV!
Cordell Connect is useful software for managing projects for your business. One of the functions of this program is being able export your reports to either an Excel spreadsheet or a PDF document for a greater ease of data manipulation and communication.
