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...
He starts off performing the task that he then describes. It's one technique that is called a mirrored double click flare. This is done by moving the record forward a double click and then back a double click then forward a single click. The whole process is then done in reverse, starting with moving the record back a double click. On his DJ table he moves a cross fader to mirror his movement of the record. First start the technique slow without a beat to get the movement memorizes. Add a bea...
The video is about the process required to remove vinyl record noise. You should have audacity programmed software installed in your computer. First clean the records as best as possible. The noise between the songs are first visualized, then go to the selection tool and press noise removal. The portion depicting the noise is enlarged to view clearly their removal. The portion between the songs is chosen and noise removal is selected and pressed. You can put in your pre-recorded songs in this...
The video describes how Audio Editing Software, Record, and Reason can be used together on the same computer. Once all the three are installed on the same computer, they can be merged to form one large audio editing program on the same account. After installation of both of these, ensure that the program Record recognizes the installation of program Reason. By merging these two audio editing programs, the users will be able to access the features of both programs as if it is one large editing...
Not exactly sure how to get a hold of a death certificate? Whether you need a death certificate to trace your family history or to make a legal claim, follow these steps to get the record you need.
This is a great tutorial on cracking the iphone to record more than 30 seconds on the iPhone 3G's video camera. This is a hack of the previously still camera that comes stock with all of Apple's phones. Enable your iPhone to shoot video instantly and free!
This tutorials shows you how to get started with Camtasia. It addresses techsmith online tutorials, audio recording devices, and basic editing (cut and insert).
This Apple music editing software tutorial shows you how to step record in Logic Pro 8. Learn how to use the Piano Roll editor to create step recordings in Logic 8.
How to record your XBox 360 video games onto video files to share over the Internet.
In this riveting episode of The Shirtless Apprentice, Matt discusses recording audio for your internet video and podcast.It all begins with your camera, microphone options, surroundings and the inherent sexiness of your voice.
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.
Learn how to record audio from video files (even Flash .flv files or Youtube videos) using the Windows sound recorder. All of the software used in this tutorial comes bundled with Windows.
Whether you're a World War 2 veteran (thank you), the next-of-kin of a vet, or a member of the general public, there are lots of reasons you could want to look at service records for WW2 vets. Watch this video for tips on acquiring these service records from the US government.
In this video tutorial, we learn how to use PreSonus StudioLive to record or augment a live performance. Whether you're new to PreSonus' DAW or new to digital recording more generally, you're sure to find much to take away from this free video software tutorial. Take a look.
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 you can set up the American Audio TT-Record Turntable. This is a Belt Drive turntable that can record your vinyl with a press of a button. All you need to do is plug in your memory stick and off you go. This unit does not need to be used as a direct drive sin...
Trying to find a new use for old, scratched vinyl? This easy do-it-yourself project shows how to turn a record into a decorative bowl; just follow along with the step-by-step instructions in this video. You will need a record, an oven, a pot (unless you want to free-hand mold the record), and some cold water. Check out this simple craft sculpting project and learn how to make a bowl out of a record, but remember not to eat soup out of it.
Recording home movies is quite a joy - how else would you remember that time your son shot milk out of his nose from laughing too hard, or when your shih tzu did a headstand? But it's often a pain transfering all your film files from your video camera to your computer.
This is a tutorial that shows you how to record your computer screen and save it as a video. This is useful for recording something you want to put online. The program I use is called SnagIt. This works for Vista and XP.
Practice your soloing skills and record melodic lead lines over your favorite song or backing track by importing pre-recorded tracks into Logic.
Does your 12" vinyl record wobble in the middle of the turntable spindel? Learn how to stop records from wobbling on the platter while you're DJing.
This video demonstrates how to record your guitar using a home studio. The video walks you through setting up the correct equipment and various recording techniques.
Slow motion recording is an incredibly handy feature that works by capturing moments at a higher frame rate than they're played back at. Timing is everything when recording in this setting, so if you want a user-friendly app that keeps device interactions to a minimum and leaves you to focus on capturing your subject, Google Camera will surely fit the bill.
Many apps claim to record phone calls on Android, but very few actually deliver. There's just too many different devices floating around out there for one app to be able to support them all — or so it would seem.
HoloLens developer Arvizio has expanded its collaboration suite of tools for enterprises with a device that can stream and record mixed reality experiences in high-definition for local and remote audiences.
If you're using iOS 10 or lower, there is no built-in way to record an iPad, iPhone, or iPod touch screen, and Apple doesn't allow any third-party apps to screen record either. If malicious, an app could theoretically continue recording even after you think it's off, allowing it to capture account and password information that you enter on your device. This changes in iOS 11, which introduces native screen recording, but what do you do if you're still running iOS 10 or lower?
Whenever you need to record a quick message to yourself or someone else, the stock Voice Recorder app on the Galaxy Note 2 does a fine job. However, the situations when you need it the most are when you forget or don't care to actually use it, like during a heated argument or a random police stop where your words can be misconstrued or altogether unheard.
Not too long ago, we told you about a new feature within Android KitKat that allowed for video recording directly from the screen of your Nexus 5. Though functional, the method was a bit clunky and involved hooking your phone up to your computer and sending over an ADB command to start the recording.
Ever since its introduction back in iOS 6, AirPlay has been helping us iOS and Mac users stream content over to an Apple TV or third-party speaker system. It's an incredibly useful feature. However, it's also severely limiting. The few compatible products out there are extremely expensive, making wireless streaming a not-so-easy task.
Are you interested in beginning research of your family's history? I began this journey about 3 or 4 years ago and here is what I found. I've done almost ALL of my research online, and gotten farther, faster and more comprehensively than anyone else who has researched my family the old fashioned ways. This is the kind of thing that technology is made for. Here's how to use it.
This guide goes over the basics of 3D video recording and the mechanics behind it before delving into something a little more specific. The host discusses how to build a rig that allows for adjustments to be easily made to the interaxial distance and convergence of the two cameras.
OK, your recording session is done and it went great! Well, except for the guitar. And bass. And drums. Oh, the trumpet was off. Tamborine was "meh", the harmonica was off key, the wood block was off time... you get it. The music was all wrong. BUT, the vocals were great. So, this tutorial shows you how to create an acapella track using the popular audio recording/editing software Audacity. This method is a little different than others out there on the web so check this one out and see how it...
This how to demonstrates how to use your Apple iphone as a spy camera to spy on others. If you're suspicious, paranoid or just downright creepy, this video can show you how to convert your Apple smart phone into a device for surveillance on others.
Learn how to increase your knitting speed with Miriam Tegels, the World's Fastest Knitter. She can stitch 118 stitches in one minute; a record that appears in the Guinness Book of World Records. Miriam Tegel's knitting secret is keeping all movements to a minimum. Use size 8 knitting needles and DK weight yarn for optimal performance. After casting on sixty stitches, see how many stitches you can knit in three minutes. Good luck!
Check out this cinematography tutorial video that demonstrates how to use your professional JVC DR-DV5000 Direct to Edit (DTE). The DR-DV5000 is designed to mount directly to your JVC GY-DV5100 and turn it into a DV-Disk recording solution. It becomes possible to shoot directly to disk or simultaneously to tape and disk. The DTE capture files are a mirror image of what's recorded. Learn everything there is to know about the DR-DV5000 with this instructional cinematography video and start usin...
NOTE: Chapter One is a demonstration, click on chapter two to learn how to solve the cube. This cool and very smart video teaches you how to solve the popular (and annoying) Rubik's Cube in just five steps. Sounds easy, doesn't it? First, check out this video of Leyan Lo as he achieves the world record for the fastest blindfolded solve. He beat Tyson Mao's record by about 30 seconds, they are both friends.
Trying to make your own Terraria let's play series? Ensure the quality of your video by watching this guide to rendering and recording smooth Terraria gameplay. Learn what tools to use to get great looking video of your Terraria world.
Trying make your own Terraria Let's Play? Worried about lag disturbing your video quality? Watch this video and learn how to use Fraps to record Terraria with no lag. This Terraria guide presents a simple solution to a common problem.
Looking to add your voice to the conversation? Get started recording gameplay on Xbox 360, PS3, or Wii, so that you can make commentaries, let's play's and how-to videos to share with the world. This video explains how to set up your Roxio capture card.
Would you like to record your PC screen? Download CamStudio and watch this video to learn how to capture video of your PC, perfect for making tutorials and let's plays. This video explains all you need to know about CamStudio: what to download and how to use it.
