Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
In this Software video tutorial you will learn how to make DVDs from AVI files with Windows DVD Maker. You will need a codec for this, which can be found at www.divx.com. Download the free version. While installing, when the prompt for component selection comes up, keep only ‘divx codec’ checked and uncheck the other components and install the codec. Now insert a DVD in to the drive and open up windows DVD maker. Select the movie you want to record, give a title and click next. Select the...
This video teaches us to partition a hard drive. Open 'Disk Utility' and go to 'Seagate FreeAgent Media'. Go to 'Partitions' and select '2 partitions' in the 'Volume Scheme'. Click on 'Untitled 1' and put the name of the partition, its format as Mac OS Extended (journaled) and Partition Table from 'Options'. Name the second partition and choose 'MS DOS (FAT)' in format. Choose 'Master Boot Record' in 'Options'. Click 'Apply' and 'Partition'. This creates the two partitions of the hard drive a...
This video gives you four steps on how to properly break into a baseball glove. If a glove isn’t correctly broken into, it may affect a player’s performance. The first step is to condition the leather, softening it by adding either glove oil or cream. Remove any excess oil with a paper towel. Make sure to repeat this step throughout the year. The second step is shaping your glove by placing a ball where you would normally hold a baseball and then tying two large bands around the glove in ...
In this video tutorial, viewers learn how to add custom music in the game, WWE Smack Down vs. Raw 2009. Users will need a blank recordable CD and cannot use MP3s or any other audio format. Begin by recording all the music files into the CD and the insert it into the Xbox360. In the Xbox360 dashboard, go to My Xbox and select Play CD. Click on Rip CD and name the information of the CD. Now select the song that you want and add in into a play-list. Now to select the song in the game, select use...
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
In this video, you are shown how to find the BPM, or beats per minute, of a song that you have recorded by using Logic Pro 8. Start by loading up your song. Then go to the inserts menu, and from there go to metering. Inside the metering menu, click on the beats per minute counter. Then click on either stereo or mono, depending on your speakers. Play the song that you uploaded, and the counter will automatically find the beats per minute of your song. Go back into the inserts menu and click on...
This is a software demo. This Mac software allows you to play a song or music or audio track and reduce its speed without affecting the pitch. Select a guitar riff or chord sequence, loop it, and speed up or slow down that loop so it runs faster or slower, without changing the pitch. The program has some sound editing functionality, like EQ, but is mainly a tool for changing a recording's speed. Import a track from iTunes, or directly from a CD, adjust the speed, apply the optional equalizer ...
David Shrein provides a video recording with step-by-step instructions on how to utilize the DVD ripping software 'Handbrake' on a computer running Mac OS X. He shows how to deal with an initial error message, and then moves onto selecting the DVD. You have to be careful as to what you choose, as different DVDs will have different numbers of chapters and features, which use different settings in Handbrake. He shows how to select the right settings for a movie, and preview a chapter using pict...
In this how-to video, you will learn how to censor your eyes using the software Fun Booth. First, click the left arrow on the program until you reach the section My Props. Click the plus sign and upload a black image. Place and reshape the image so that it fits your eyes. Now, click save prop. As you move your head, the black image will follow your eyes. Click file and press record if you want to make a movie using the censor bar. Viewing this video will teach you an easy way to make a censor...
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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.
In this video from KatiesTeachings we learn how to write an annotated bibliography with 4 easy tips. Katie Mitchell gives this tutorial. Once you find your sources you need to record the bibliographic information like who wrote it, when they wrote it, and when it was published. Next you need to summarize the source. Third, you want to assess the source. In doing this you want to answer questions such as was it good and is it valid. Finally the last step is to reflect on the source. These four...
Windows Movie Maker is a basic program that comes with windows, but it actually performs quite well. You can capture video with your webcam and import it into WMM or you can capture it in the program itself. Make sure your webcam is connected and click "Capture from video device". Click next and name the file, click next. Click best quality, then next. The start capture tab will start the recording and stop capture will cease it. Select finish when you are done. The video is then saved to the...
In this video tutorial, viewers learn how to repair the write protect on an SD card. An SD card is a non-volatile memory card format that is used in portable devices. If the write protect on a SD card is broken, the user cannot record any files onto the card. To fix this, viewers will need a small piece of scotch tape. Put the tape on the notch of the SD card. Do not cover the metal tabs at the back. This video will benefit those viewers who have a SD card and would like to repair the write p...
In this video tutorial, viewers learn how to use a digital camera as a webcam on Skype. Users will need the AV cable and a USB capture device. Begin by connecting the AV cable to the USB capture device. Plug the cable to your computer and your digital camera. Users will need to download and install the Debut Video Recording software. Open the program and click on Device. Users may have to go to Options and configure the settings. On Skype, right-click the person you want to call and select Sh...
Ilyce Glink with ExpertRealEstateTips tells us about how often home owners ask her "How much should I pay a contractor before he or she starts the job?". The one who will be answering this question is Line Epstein, Vice President of Baker Construction Group. "You should never pay your contractor in full before the entire job is completed" -he says. "Not that he's going to run off with your money, but you want to keep some incentive to get the job done right. You should give a deposit of 5 to ...
In this video tutorial, viewers will learn how to create their own Apple Loops in Logic Pro 9. Logic Pro is a hybrid 32/64 bit digital audio workstation and MIDI sequencer software application. In this video, viewers will learn how to make any regular audio file into an Apple Loop that can be searched in Logic's Loops browser. This video focuses on setting up a workspace, recording with both live performers and digital instruments, editing and arranging, and mixing and mastering a composition...
This video lesson will show you how to make HD/1080p videos for YouTube in Camtasia. The simplest way to make this is to record your video in 1920x1080 resolution and render it in that setting. That’s all that you need to do. But, if you have a smaller screen resolution and can’t get 1080p, you can use Camtasia Studio to convert it to 1080p. first add your media to the timeline and change the width to 1920 and the height to 1080 click OK and then close the box. In the preview, you will see th...
Alazzo Clothing teaches the viewer how to measure their jacket length. You'll need a flexible measuring tape first. First, put your measuring tape at the point where the shoulder and neck seams meet. From this point, you will measure down to the length desired. Measure down the front of the chest and not the back. The length you will measure will end right around where your thumb joint is. Record this amount in inches and this is your jacket length! Take this number in and get jackets tailore...
A Teacher shows us how to graph compound sentences with the word "or" in them. These graphs will have arrows pointing out in different directions. On the number line draw arrows from the numbers in your compound sentence. So for example if after solving a problem with inequalities the problem has two possible answers that it could be, you would record both of the answers that it could possibly be. For our example we will use x is greater than seven, and x is less than three. You would then dr...
With divorce rates set to hit a record high this year, 'betterdatethannever' explains how to avoid arguing with your partner. Most people experiencing marital difficulties blame financial reasons for their fights. The easiest way to avoid conflict with your partner is to make sure you communicate and share your problems. Holding things deep inside makes them get worse and worse till they explode into one huge argument. Allow your partner to speak their mind and express things they do not like...
In this six minute tutorial the host and keyboard player for the band "Brazilian Girls," Didi Gutman, shows viewers how to play the keyboard in the song titled "Reason." Throughout the video, Didi Gutman shows various methods and techniques that are used for the style of keyboard that he plays. Filmed in Gutman's place of residence in Brooklyn, New York, Gutman also talks briefly about how the band got started and how he first got involved with playing the keyboard. The video also shows him r...
In this video we learn how to use the address book in Windows XP. First go to Start, All Programs, Accessories, Address Book. You can choose to make it your default vCard viewer. Now in the address book, create a new contact by clicking new contact. Fill in the name and email address and click on add. Now there's an email associated with this record. You can also set up information about home address as well. It's important to put as much information as you know so it makes it easy to sort. W...
In this video, Stacy demonstrates how to get a curly hair style on short African-American ethnic hair. The results are beautiful, though it doesn't take long to do and requires only a few products. She has already relaxed her hair prior to recording, so her hair is straight and ready for styling. Stacy recommends using a wrap lotion designed for ethnic hair to help hold the style, such as Styling Finish Silky Hair Foam. After applying wrap lotion, separate small sections of hair using a ratta...
To watch TV on your PC you need a TV tuner. You have two choices. There are usb sticks and pci cards. The pci is an internal circuit board that goes inside your computer. The pci card is very easy to install. Literally just open the computer and pop it into an available pci slot. Then you will need to install the software that came with the usb stick or pci card. Next attach an antenna to the pci card or usb stick connector. You can scan for channels, save favorite programs, and setup recordi...
The presenter beings the video by describing the screen cast program he is using to record the video. It is giving him some problems but he asks us to bear with him. The video then shows before and after images to demonstrate the effect. The effect is achieved by duplicating the eye color to another layer and then using layer blending options to achieve the desired brightness. The presenter has a website with many other Photoshop technique videos.
By utilizing the click and drag features of Xara Xtreme, users can take shapes and duplicate them for quick work (ctrl K). Further by identifying them by colors and other subsets, users can add or delete with just a button push, or (use the add shapes, subtract shapes options.) All this is done in the event for the sake of convenience; eliminating the tediousness of creating shapes one by one, and using them as plot points on a map to create projects within record times.
The ability to create professional and clean presentations can be a valuable asset to one’s career. With this video tutorial, learn how to use Adobe Presenter in order to augment Power Point presentations. Presenter offers users the ability to record narration under a set order of slides in a simple interface, and provides an interactive quiz option to further engage audience members. Alternatively, users may also convert a presentation into PDF format, for use as a physical or virtual document.
British record producer David Spoon explains how he uses the computer program Propellerhead Reason 4 to create rhythm and bass tracks in his home music studio. He explains that by just messing around with the controls within the program, you can create a lot of interesting sounds and effects. Sometimes the best sounds are discovered by accident. He uses Filter 2 to create interesting effects that he describes as "acid-y" or "nasty", having to do with the resonance of the bass sound. He also a...
If you're like most people, you probably dislike watching commercials on TV. That's one of the great reasons to get TiVO!
Do you remember "The Heist" from episode 21? Well, the sequel is even more unfair than the original! Check out this video if you want to stump people with a trick called "The Heist II." For this trick, you need only a few simple supplies: a match, a cup, and a nickel.
New to Audacity? Audacity is a free, open source software for recording and editing sounds. It is available for Mac OS X, Microsoft Windows, GNU/Linux, and other operating systems.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to share files between Ubuntu (Host) & XP (Guest).
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how to use the CDT-05 MKII Hybrid Turntable from Gemini. When in CD mode and you are moving the vinyl, there is no need to have the needle or stily on the record! This DJ tutorial video provides a small demo of the CDT-05 MK2 from Gemini -- a turntable that's a C...
Check out this instructional electric guitar video that shows you how to train your ear to play the electric guitar. This is Season 3, Episode 38 of Dave Weiner's Riff of the Week series titled "An Intro To Ear Training." Dave Weiner is a Favored Nations recording artist, a G.I.T. graduate, and has been playing in Steve Vai's band since 1999. You want to tune your ear so that you can better communicate in music better. A tuned ear will give you better chord choices, better voicings, better no...
Check out this instructional electric guitar video that teaches you about the slap and pop technique and puts it into some chordal work. The slap and pop techniques are commonly used with pull-offs and hammer-ons with the fretting (left) hand, to further increase the rate at which notes may be played. This is Season 3, Episode 35 of Dave Weiner's Riff of the Week series called "Slap & Pop Evolved with Chords." Dave Weiner is a Favored Nations recording artist, a G.I.T. graduate, and has been ...
Check out this instructional electric guitar video that teaches you about the slap and pop technique. The slap and pop techniques are commonly used with pull-offs and hammer-ons with the fretting (left) hand, to further increase the rate at which notes may be played. This is Season 3, Episode 34 of Dave Weiner's Riff of the Week series called "Slap & Pop Evolved For Guitar." Dave Weiner is a Favored Nations recording artist, a G.I.T. graduate, and has been playing in Steve Vai's band since 19...
Check out this instructional electric guitar video that shows you how to simplify complex riffs on the electric guitar. This is Season 3, Episode 26 of Dave Weiner's Riff of the Week series titled "Complex Riffs Made Easy." Dave Weiner is a Favored Nations recording artist, a G.I.T. graduate, and has been playing in Steve Vai's band since 1999. With this lesson and a bit of practice, improve your guitar playing skills by learning to simplify complex riffs and to improvise a little on the elec...
