This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
In this tutorial, we learn how to scratch records like a professional DJ with Eric Roman. First, go to your DJ equipment and move your hand back and forth to scratch the record that is inside of it. Make sure you aren't too loud so you don't over power the song you are currently playing. You can use the normal way, which is using the left player. Or, you can use the right side to open up the left player. Either way you choose to do, you are doing a back and forth movement with the record and ...
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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...
Check out this instructional turntable video to learn how to cue your vinyl records. It's not scratching, but it is cueing. This takes some skill because you want to align two songs perfectly in sync. Remember, this only works if the stop and start time of your platter are the same! It does not matter if your start or stop time is 1 hour, 34 minutes and 48 seconds! Use this method if you need a clean, fast and easy way of starting a vinyl in sync. This video tutorial is great for DJs and anyo...
DJ Dream with a new exciting video hooking all potential DJs with DJ tips
Alright folks, this is how you do the baby scratch, in 4 or 2 moves. Why do you want to do a regular scratch, when you can do a baby scratch?
DJ Fooders teaches you some basic record scratches for beginning DJs. Techniques covered included the baby scratch, forward scratch, chops and stabs, and the tear.
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.
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.
You can create the Google apps email like Gmail for your domain. So to do this first you need to go to the google.com/a and click on the standard in "other Google apps editions". Now click on "get started". Now select "administrator: I own..." and enter your domain name and click get started. Now on next page create your account by filling all the fields and click continue and now fill the info of your administrator account and click I accept button. Now next step is for the verification of y...
DJ Tutor shows you a series of lessons on how to scratch properly, and how to do some awesome scratches.
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.
Learn the basics of scratching with DJ Spinbad.
DJ Stylewise breaks down the science to scratching.
A dirty or dusty record can pop or skip. Learn how clean vinyl records in this free record player maintenance lesson from an experienced disc jockey.
Antique store owner Jan Braunstein has seen her share of rare records. In this series, she shows you her very own copy of one of the rarest, the infamous “butcher cover” of the Beatles’ “Yesterday and Today” album. She gives you an overview of record collecting in general and talks about some albums by Bob Dylan, Elvis and the Beach Boys which you should snatch up whenever you see them.
Does your 12" record get stuck on your turntable platter? Learn how to prevent this.
Ever wonder how to play 7" vinyl records on a turntable? Guess what that round piece that came with your turntable is for.
How to put the sticker in the corect place on a 12", for your DJ set and why it's done
New software technology allows cell phone and PDA users to download their medical records, making them quickly accessible in case of emergency. The new software, to be available in a year, can even display animated 3D scans. Computer scientists say the technology will also enable students to do research using their portable devices. The software will be available in 2007. Download medical records on a cell phone.
In this Dreamweaver 8 video tutorial you will learn how to display records by extracting info from a database. Learn how to create a data connection, create a query, work with recordset, display items, and use repeat regions. Note: To use this tutorial you need XAMPP and make sure to hit "play tutorial" in the top left corner of the video to start the video. There is no sound, so you'll need to watch the pop-up directions. Display records in Dreamweaver 8.
Every once in a while you stumble across a HowTo on the internet that seems too good to be true. Magic. This happens to be one of them.
Holy *&@!... imagine flying faster than a speeding bullet. Or traveling at 1 mile per SECOND. Or being propelled 6 X the speed of sound.
Aside from the bizarre fascination with being able to see celebrity homes in Malibu (see the Streisand Effect: http://en.wikipedia.org/wiki/Streisand_effect), the CCRP is a great place to check out local surf spots up and down the Coast:
If you read a lot of video game press on the internet, you've probably salivated at the high-quality HD video footage of console games that reviewers are able to record and use to illustrate their points about games. If you too want to be able to record HD footage of XBox 360 and Playstation 3 games and put them on your computer for editing and distribution, this video will show you how to do it. All you need is a $200 device called an HD PVR, which is an external device that records your gam...
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to record voice memos on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
Play records with a piece of paper and a needle. Amazingly easy to make! I don't recommend using your good records for this though.
If you're record player doesn't work anymore, but it still turns, then this is the perfect solution for you. The video show you how to make a cone record player. It's also a neat trick for playing your records with out a record player, instead of a regular phonograph needle.
Seeing as record players are getting harder to find, here's something useful to do with your records, turn them into serving dishes! What you need to do is get some tin foil, oven safe dishes and of course records. Two different types of dishes can be made, a shallow plate-like dish and deeper bowl-like dish. For the shallow one use a cake pan for its form, you'll need a glass jar or an empty tin can for the other one. Start off by setting your oven to 350 degrees Fahrenheit or 177 degrees Ce...
Check out this tutorial and see how to add a library to an existing Record Center site, apply policies to the library, and configure the Records Center site so that submitted documents are routed to the right library.
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...
This shows you how to install an app for the Apple iPhone that records video. You have the capability to record video. The hardware is there. It's simply a deficit of software. Both the iPhone 3G and regular iPhone can record video with the right iPhone App. Here's what you need to get video captured with your phone.
Digital video recorders, or DVRs are changing the way people watch TV. Check out this comparison of the top DVRs on the market.
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.
If you're running out of room to store your records, buying a cabinet can be a smart idea. What's an even better idea is building one yourself. Not only are you able to make your own style, but you can build it to whatever size you need.
In this how to video, you will learn how to set up a tone arm on a record player. First, you will notice the counter weight at the other end of the tone arm. Remove this first. Set the dial set to zero and have the lever pushed forward. Slide it on and lift the arm off of its rest. Play around with it until the arm floats. The next thing to do is to balance the cartridge. Many cartridges have different weight requirements. If you do not have the weight set up behind the arm, you cannot use di...
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.
Whether it becomes mandatory or not to show your COVID-19 vaccination card at events, restaurants, bars, hotels, airports, and other public places, it's a good idea to digitize the paper card on your smartphone so that it's always with you. It's also wise to give yourself quick, convenient access to it, so you're not holding up lines while trying to locate the file, and there are a few ways to do that on your iPhone.
With each year that we anxiously await Apple's next big version of iOS, there comes the sad reality that the eldest iPhones will not continue to receive support. That's not the case with iOS 12, however, as the software is compatible with all iPhones currently running iOS 11, going back as far as the iPhone 5S.
