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.
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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
In this video, we learn how to delete an SMS or email message on an iPhone. Not only is this quick and easy, it can be done for multiple messages that you don't want to keep in your inbox. First, turn your iPhone on and go to your inbox (email or SMS). Next, slide your finger left to right on the message you don't want to keep and then click on the red "delete" button. This will then delete your message! Click anywhere other than the red delete button and this will cancel out the deletion of ...
In this video tutorial by photoshopuniverse, from Free Photoshop Video Tutorials, shows you how to automate the process of resizing images using Photoshop, primarily for sending over the internet. The guide takes you through the step by step process of creating a new action to record the process of resizing an image. Using this recorded action, you will learn how to go about applying that action to an entire folder, which will resize all the images contained in that folder.
Learn to record audio with the Camtasia recorder by watching this video tutorial. First, if you want to record audio click on the mic. It's easier than clicking on capture. Next, you'll find on the same menu a selection for custom or full screen modes. After you've made these selections you have cursor selections to choose from. Those options are listed under the effects tab. Are you a silent mouse or a squeaker? If you want your viewers to hear your clicks then under the same tab there is an...
A short tutorial on how to use Audacity to record a poem to submit to CloudyDayArt.com poetry contest.
After you've jammed with your song for a while, you can record your guitar part as a real instrument track with your guitar connected to your Mac and a real instrument track selected.
You can attach a microphone to your Mac and record your own voice or any acoustic instrument right to a track in Garageband.
You don't need an obsessive ex stalking you to benefit from the ability to record calls on your iPhone in a pinch. Besides protecting yourself from nefarious intent, recording important conversations like verbal contracts and agreements can help you cover all your bases and ensure you're insulated from any potential liabilities that may appear down the road.
Native screen recording, one of the hottest features that Apple included in iOS 11 and later, is easily started from the optional Control Center toggle on your iPhone. From there, you can stop recording from the same place or from the red status bar or bubble. It's a very convenient addition to iOS, but there's one obvious downside — that red indicator, which can appear in your recordings.
Three months after its promise, Apple has pushed out an iOS update that gives you important information about the health of your iPhone's battery. This means you no longer need tools such as Geekbench and Battery Life to determine whether or not you need a replacement battery.
The Galaxy S8 and S8+ might not have made it into the hands of the public yet, but we sure have come across a lot of the stock apps from Samsung's latest flagship phones. First, there was the new launcher, then Hello Bixby, and now, the extremely elusive Record Screen feature has been leaked.
Just over a month ago, the Rubik's Cube world record was smashed by Mats Valk, a Dutch speedcuber, during the Jawa Timur Open 2016. Valk was able to shave 0.16 seconds off the previous record of 4.90 seconds, which was a pretty impressive feat.
There are plenty of legitimate reasons that you might want to record a phone conversation. Let's say you operate a business and take orders over the phone, and you don't want to miss an item. Or perhaps you need to jot down some notes from a recent conference call, and things were just happening too quickly in real time.
Piracy, it can be argued, is the scourge of the internet. But when it comes to music, sometimes it's best to give a listen to a track or album before deciding to spend your hard-earned money on fully supporting it.
Unruly customers. Crazy exes. Horrible bosses. When you need proof of insanity or just want it for your records, recording a phone call is a must. Problem is, it's not the easiest thing to do on an iPhone — but it's completely possible.
The shooting of Walter Scott (who was unarmed) has been dominating the news these past few weeks. Scott, who ran away from police officer Michael Slager after a routine traffic stop, was shot in the back and pronounced dead shortly thereafter. Unlike similar cases where a cop shoots an unarmed person, the police officer involved in this particular shooting is currently in jail, facing a potential murder charge.
Back in the '80s, recording live radio was as simple as popping a cassette tape into your boombox and pressing the record button. While we've come along way with regard to accessing radio stations thanks to websites and apps that stream live broadcasts over the internet, it's no longer quite as easy to record.
Podcasts are back. The Rich Eisen Show, The Joe Rogan Experience and StarTalk Radio with Neil deGrasse Tyson make up just a tiny fraction of what's become an incredibly dense market, with these being some of the most popular available right now.
By now, you've probably already installed 10.10 Yosemite, the newest version of Mac OS X, on your computer. While you most certainly noticed the visual changes, you might have missed some of the really cool additions.
Unlike the suave 007 that Daniel Craig portrayed, I am not a spy, nor am I that charming, but I do occasionally enjoy taking a stealthy video. Maybe I'm a jerk, but I often catch people doing ridiculous things and just think, "Aren't you embarrassed?"
Before your carrier got its grubby little hands on your Galaxy S5, there was less bloatware installed and more functionality offered by the Samsung flagship device. Case in point: the GS5 that Samsung designed was capable of recording phone calls, yet the one that you own probably isn't.
Whether it's because you want to make a quick tutorial video or want to show off your gameplay skills, recording the screen your Nexus 7 tablet isn't an easy feat. At least, until now. Hidden inside Android 4.4 KitKat is a built-in screen capturing feature, but it takes a little effort to dig it out.
In the UK, 20 percent of divorce filings include the word "Facebook." You may think you're being slick by using the site to chat with your ex, but the problem is that Facebook saves everything, and I mean everything. All someone needs is your login information and they have access to everything you've ever said on Facebook, public or private.
Many screencasters record their audio while they are recording their screen, but not many can do both well at the same time.
There isn't as much use for old-school four-function calculators anymore since we all have them on our cell phones now. If you've still got one lying around, you can hack it to play recorded sounds, use it to make a metal detector, or turn it into a custom name plate that says anything you want...
The video shows us how to use audacity to record audio. Firstly you need to have the software audacity installed in your system and for that Google and search for 'audacity' and after that you get a link to save and install the software. Once the installation is done, open audacity and on the drop down menu the default is set to microphone, change that to stereo mix and copy my settings. Once this is done we will be recording the audio. Go to a site like youtube and press the record button in...
You want to transfer your cassettes to digital music but don’t have a clue where to start. With these tips and the right equipment, your old music will sound brand new.
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're having a hard time beating specific challenges in Batman: Arkham Asylum, this next tutorial should help.
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.
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...
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...
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!