Manually Record Search Results

How To: This Workaround Lets You Record Music Playing on Your iPhone While Filming a Video

As soon as you try recording a video in the Camera app on your iPhone, any music playing on your device comes to a halt. Apple Music. Spotify. Pandora. Tidal. Deezer. No matter what you're listening to, as soon as you switch to "Video" in the Camera app, the music will stop. However, if you want background music in your movie files, there's a workaround to avoid having to add an audio track in post.

How To: Share Your ETA to Contacts from Apple Maps Manually or Automatically

Are you here yet? When will you arrive? How long until you get here? How far are you? Hurry up! When you're meeting up with someone or a group of people, you may get flooded with messages like that. Instead of trying to answer them mid-trip, you can send them your status from Apple Maps, so they know precisely when you'll arrive, and they'll even get updates if traffic is holding you back.

How To: Protect Yourself from macOS High Sierra's Glaring Empty-Password Security Flaw

There's a new macOS vulnerability that hackers within physical reach of your computer can use to gain root access to your system and accounts. Just by using "root" as the username and a blank password on a privilege escalation prompt, someone can install malware on your computer, access hidden files, reset your passwords, and more. Root access gives them the ability to do anything they want.

How To: Find Stored Usernames, Emails, & Passwords on Safari

Every time you log in to a website in Safari on iOS, you're also asked if you would like to save the username and password—a great feature of just about all browsers that makes it so that don't have to enter your credentials each time you access website in the future. While this feature is great for quickly getting into all your favorite websites, have you ever wondered where all those passwords are saved on your device? In this guide, I'll be showing you where to find all of the stored usern...

How To: Record and use macros in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to record and use macros in Microsoft Excel 2007.

How To: Select speakers/mics & adjust sounds in Windows 7

In this video the instructor shows how to select speakers, microphones, and adjust system sounds in Windows 7. To do this, first go to the start menu and select the Control Panel. In the Control Panel select the Hardware and Sound link when the panel is in view by category mode. In the next page click on the Sound link. This opens up the Sound properties setting window. There are four tabs in that window like Playback, Recording, Sounds and Communications. In the Playback tab you will find th...

How To: Make picture frames for vinyl record covers

This video tutorial is in the Home & Garden category where you will learn how to make picture frames for vinyl record covers. These frames do not use nails or clips to hold the covers. The covers slide in and out of the frames so that they can be changed easily. For this you will need 4 pieces of wood 3/4" thick, ¼" wide and 14" long. First you sand all the pieces. Then you set up your router and the rabbeting bit to cut out the four wooden pieces. Now you need to make indentations on the to...

How To: Mute the vuvuzela sounds from an audio recording

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...

How To: Highlight rows that contain unique values in MS Excel

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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Use VLOOKUP to verify a record is in an Excel table

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 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in VLOOKUP function.

How To: Extract part of a table from a larger table in Excel

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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Batch automate in Photoshop

This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...

How To: Turn your doorbell into a guard dog alarm

This video shows you how to make a security device out of a door bell. The concept is that most thefts happen when people are away from home. To make sure of this the thief rings the door bell to make sure that nobody is home, if nobody answers then they will break in. A lot of people have dogs and alarm systems which will scare off the thieves, but this alarm system combines both. To make this devise you have to buy a speaker system that connects to your door bell. When the door bell rings i...

How To: Upload HD videos using Camtasia Studio (WMV)

In this video the instructor shows how to upload High Definition HD videos using Camtasia Studio. Here the instructor shows how to upload the videos that you recorded using Camtasia in HD to YouTube. Now to generate a HD video you will need to record in high resolution like 1280 by 800 pixels. Now record the video at full screen. Now after recording you will have your HD video. Open the video in Camtasia and add the clip to the time line by right clicking it and selecting the option from it. ...