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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. 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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
Insipired by Harlan Hogan's Porta-booth, here's a video showing you how you can get a great sound booth that fits in your suit case and goes anywhere. The video shows you how to build the booth and a convenient way to pack it for travel. Details on where to get the parts are here at our creator site.
If you are watching the World Cup live and the vuvuzelas are driving you slowly (or quickly) insane, this video isn't going to help, sorry. However, if you are recording the World Cup or working with someone else's recordings of it, it is possible to almost completely eliminate the sound of the vuvuzelas while mixing in Garageband or another audio editing program. This video will show you how to create the proper parametric EQ's and mute the vuvuzelas while preserving the rest of the audio tr...
John Park from Make Magazine hacks a Nintendo Wii controller and turns it into a personal flight recorder that can sense and measure the stomach-churning G forces of roller coasters and other high-speed, high-risk activities.
The Canon 5D is a wonderful camera for shooting HD video footage, but one thing it isn't great at— sound. In order to get great quality audio, you're going to have to use an external sound recorder. If you want professional grade sound, you have to use professional equipment. You need to make sure your sound recorder has a sampling rate of 96 KHz at 16 bit resolution or better.
Watch and learn how easy it is to create your very first Screencast recording, using the free desktop screen recording application CamStudio.
This audio production software tutorial shows you how to set up audio and MIDI recording devices on a PC using SONAR 6 Home Studio. See how to plug-in cables, and set up audio and MIDI for optimized recording and playback on a PC. This video shows the process in SONAR Home Studio 6, but the concepts can be applied to most Cakewalk software.
Looking to convert your vinyl records to mp3? In this two-part tutorial learn how to using the software program Audacity and the LAME plugin installed. This video is helpful for those DJs who use Serato, Final Scratch, Traktor Scratch, or Virtual Vinyl and need conversion help. You can download Audaicty here.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).
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 525th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records using advanced filter and wild-card criteria. See, for example, how to extract records that start with the letters W or J.
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 remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
DJ Q-Bert of the Invisibl Skratch Piklz shares a tip on how to modify your vinyl records to keep them from skipping while playing or scratching with them.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
Turn your digital footage into something that looks more like film! Set your frame rate to 24 and shoot with a low depth of field to mimic the look of a film camera. Also make sure you pick the right aspect ratio, resolution and use a tripod!
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 tutorial video will show you what the purpose of compression is and how compression works through its parameters. Your instructor illustrates a drum beat and a plucked guitar line. Beginning with how to compress the drum beat, take (download) a drum sound pack without compression and to add compression using the software right click on the drum machine, choose create, and then choose combo on compressor. The virtual compressor has all the dials and adjusters found on any basic compressor...
You might have heard the term "phase" before, but do you know what it is? Check out this instructional recording video that demonstrates how to avoid a phase. Hear some audio examples and learn to listen for a phase. Record better sound quality by learning a few tricks outlined in this tutorial video.
In order to build your very own home studio, you'll need the following: a microphone, drafting tools, paper, contractors, the Internet, and recording equipment.
Watch to learn how to do a direct performance recording into either song or pattern mode on the Motif XS Yamaha synthesizer.
You can create many types of domain name service records in Microsoft Windows Server 2008. Glue records, CNAME records, mail exchanger and many other types of records are possible. Follow the instructions in this video to learn how to manually create DNS records.
Cubase digital audio workstation supports lots of equipment and gear. Learn what you need to record MIDI music in Cubase in this free digital music recording video series.
This video shows how to clean old records using Titebond II wood glue. He has the record turning slowly on the turntable, and while it's turning, slowly squeezes a line of glue around and around onto the surface of the record, starting from the middle. He explains that it takes between four and twelve hours for the glue to dry completely. After the glue is applied to the entire record, he takes an old credit card and spreads the glue evenly onto the record, all the way out to the edge. When t...
Learn the basics of scratching/editing sounds on vinyl record decks and CD decks when DJing. Part 1 of 3 - How to Scratch records.
This tutorial covers several aspects of using Pro Tools. You'll learn not only how to record an audio track to include in your final project, but also how to record at a specific point and make use of cycle or loop recording.
This video shows a method of cleaning LP records using steam. He uses a Perfection steamer and a record cleaning machine with vacuums, along with a set of brushes, Disc Doctor cleaner, and laboratory grade water. He uses distilled water in the steamer. He turns the turntable on, applies the cleaner, spreads it with a brush, and applies the steam while the record turns. After the steaming is done, he continues rubbing it with the brush, and turns on a vacuum. Next he runs the steamer of the re...
Digital video recorders, or DVRs are changing the way people watch TV. Check out this comparison of the top DVRs on the market.
Military service records can teach you a lot about a person. If you want to see the service records of a friend or family member to prove their service or simply research your past, watch this video to learn how you can.
If you can believe it, there's actually a jukebox in Minecraft, and you can put records in it! Yes, there are records! But how does one acquire such records you ask? Well, it's not easy, but if you can do it, you will be well rewarded! In this video you will learn how to line up a creeper with a skeleton archer and have him accidentally shoot the creeper instead of you, and with any luck, you will be walking away with a record!
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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.
Eyepatchentertainmen teaches you how to use a Canon 7d and understand the recording audio issues. The 5D only shoots 30 frames per second, as opposed to the 7D, which records in a standard frame rate, which will help you sync the audio to the video. The microphone that comes with the Senheiser G2 wireless kit plugs directly into the Canon 7D and works well. There is no manual control over the audio yet. The 5D and the 7D are amongst the best audio recording DSLRs out there. To make sure you h...
Pro Tools 8 enables you to add all kinds of effects to all of the audio you are recording and working on. Music producer and musician David Franz has taken on the role of educator to share the knowledge that can only come from his years of experience to demonstrate some of the many things you do in audio editing. In this video, David Franz shows you how you can add effects while recording with Pro Tools 8.
Check out this film and theater video tutorial on how to set up a wireless microphone for sound recording.
DJ Fooders teaches you some advanced record scratches for intermediate and advanced DJs. Techniques covered included scribbles, the transform, flares, the orbit, the tweak, the crab, and record control techniques.
