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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...
Predicting the future is always cool.. what if you could do it with just a piece of paper? With this tutorial, learn how to fold an origami fortune teller and at least pretend you can predict what will happen! All you need is a single sheet of paper and some pens or markers to record your fortunes and you are on your way. This is a great little thing to make anytime you are bored with friends - work, school, on the bus, anywhere!
If you have ever wondered how to create a Rorschach knot, this tutorial will show you how to do it in no time. A Rorschach knot is indicative to the blotchy silhouette of Rorschach inkblots, which are primarily used during psychological evaluations. A subject's perception of inkblots are recorded using these. This video is going to be walking you through the process of tying your Rorschach knot, as well as the ways in which it needs to be adjusted while being tied. You will also learn a bit m...
Looking for a new song to play on your acoustic guitar? Justin Sandercoe's instrumental ballad, "From Katie's Window," might be just the ticket. Learn how to play it in this exhaustively thorough four-part guitar lesson.
Whenever deciding to use fields in FileMaker Pro 10, some fields require special handling like the date field. Date field is able to store any date between 1/1/0001 to 12/31/4000. It stores dates in the form of whole numbers. Now, to create a date field, it shows at the bottom of your data and date can be stored. The format of the date can also be changed. One can add dates as well as get the number of days elapsed. This is quite flexible in terms of format as well as keeping records.
Rick teaches the secrets of making a good basic YouTube video in easy steps. Some tips are given below. When creating a YouTube video first assume that your audience has a 10 second attention time. If your introduction takes more than 10 second cut out the part while editing, keep it to 10 seconds only. The second tip is to go for a good lighting, always shoot indoors using your indoor lights itself. If you are using a microphone in the camera to record, always stay very close to the camera. ...
In this video, learn how to set-up a Canon EOS 7D camera for slow motion. Learn about the settings you need to use to prepare to shoot in one of the high speed modes. To see more of the videos on this subject, check out the parts below, especially on processing the slow motion film.
Access auto tune for your Audacity recording software with help from this video tutorial. Step-by-step instructions are gone over, and the following links will be needed:
Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.
Get creative with an old disposable camera by setting up an aerial photography rig using akite! Get a new perspective by taking pictures from a bird's eye view.
See how to repair invalid DVD navigation and structure with FixVTS. With FixVTS, you can easily repair the internal structure of a DVD. This is good for DVD menu correction, invalid DVD file structure and invalid navigation error messages.
This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.
Holography is the scattering of light from an object, which is recorded and reconstructed to create the hologram. As the viewer or viewing mechanism moves, the image appears three dimensional. This instructional video shows how to craft 3 dimensional holograms using scratched arcs on a reflective surface. Using a compass, a picture, and Plexiglas, you can create glowing images that shift and turn inside of a 2 dimensional plane. Who would of thought? Now you can make your very own holograms a...
Most people don't use their cameras to make movies (really bad quality and a sort of user-generated content feel are probably the culprits) but cameras with a record function are great for those impromptu memory-making moments when your dog tries to do a handstand or your grandma unloads the biggest belch ever.
Watch this in-depth video tutorial on how to animate LEGOs for stop motion animated brickfilms. This is a detailed peek behind the scenes of stop-motion animation from the director of the "Circle Circle Dot Dot" music video, Blunty3000.
This tutorial shows you how to install Audacity and install the LAME mp3 encoder to make Audacity ready to export mp3s. Part two goes over editing basics using the free recording software Audacity. By the end of this tutorial, you will be able to create mp3 podcasts in Audacity.
This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiredata to collect, organize, and visualize data using several types of diagrams supported by the program. The movies were recorded on a Mac, but Inspiredata is a cross-platform program so the steps shown should work on the Windows version of the program as well. Inspiredata works like a database system that allows you to add notes and more.
This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiration to create concept maps that help you brainstorm and organize your ideas. The movies were recorded on a Mac, but Inspiration is a cross-platform program so the steps shown should work on the Windows version of the program as well. Watch and learn how to use Inspiration to create concept maps.
Many educators and institutions are already integrating podcasting successfully into their curricula — with great results. Podcasting enables educators to use music and recorded audio to enhance learning. The addition of photos and video to podcasting allows educators to add a wide range of visual content to their teaching and address even more learning styles.
Like most of us, you probably recorded some of your favorite memories onto a VHS tape. Preserve the good times by transferring the tape to a DVD.
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.
This how-to video shows you how to make an infield base to anchor your baseball centerpiece for your Bar or Bat Mitzvah, theme wedding party, sports theme event, corporate event, etc. Indoor/outdoor grass carpeting covers the infield, baseball bases and baseball (or team color) ribbon add accents. Ideas of what your final centerpiece can look like as well as other enhancements, are also shown. Watch this how-to video to learn how to make your own baseball diamond centerpiece.
Learn all about Combinator controller instruments within Reason 5. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.
Taking minutes is the single most important thing you can do at a meeting to record what happened at a business meeting- ideas discussed, new directions for certain departments, etc. But taking minutes isn't as easy as scribbling down notes like you did in 5th grade. Check out this video to learn how to take clear and informative minutes.
In this video from clickherephotography we learn how to take great photos by using depth of field. In a picture of a bird he used an aperture of about 5.6 which increased the shutter speed on a 300mm Canon lens. With depth of field you can blow your background out. If you used a higher aperture, a lot more of the bird would have been in focus and a bit of the background would have been in focus. By using an F-stop and this aperture, you really bring the bird or whatever object is in the foreg...
There are many, many playable characters in Naruto Shippuden: Ultimate Ninja Storm 2, some more hidden / secret than others. In this video you'll learn how to unlock two of the more difficult characters to unlock: Lars Alexandersson and Minato Yamikaze.
In this tutorial, we learn how to cheat on any test by wearing a fake bandage. You will need: a phone, ear buds for your phone, bandages, and transparent tape. First you will need to use your phone to record yourself saying the information you need to hear. Read this off your book or notes so all the information is perfectly correct. Now, plug the ear phone into your phone and then slip it through your sleeve before school. Now place it in your hand and wrap the bandage around it. When you ne...
Sometimes--no matter how much you may want to avoid any trouble--you just have to swallow it up and do it the smart way. Notarizing your documents helps you avoid fraud.
In this tutorial, we learn how to skip commercials with your Comcast DVR remote control. First, press the cable button, then press and hold the set up button until the cable button blinks twice. Now, enter in "994" on your remote. After this, the cable button will blink twice again. Now, press the setup button again and type in "00173", then press a button you don't use a lot. Now, the cable button will blink again. Now, turn on a show you have recorded and it will just through the commercial...
In this tutorial, we learn how to count to 100 in Polish. You will start with "jeden" which means one, then move on to the rest of the numbers. It's very important to take your time when you are learning each individual number, so that you know how the accent should sound and you know how to say it properly in different sentences. It will be extremely helpful if you try and listen to an audio recording while you are saying the numbers so that you learn exactly how to say it. Continue to learn...
In this video, we learn how to check your engine health with a PICO scope. First, you will want to attach your computer to the PICO scope that is connected to your vehicle's "brain". After this, you will run through the different sections of the car to see how each of the different functions are running. Compare the results you are getting to a chart that shows what the healthy charts should look like. As you go through these, record the results you get, then print them out if you need to. Wh...
This video tutorial belongs to the Electronics category which is going to show you how to make a hack pack. This is basically turning a notebook in to something that you can take literally anywhere. Here you will learn how to create a video streaming hack pack to carry around with you and be able to do live internet shows anywhere. For this you will need a netbook, Sony PSP, mobile Wi-Fi thumbstick, microphone and a webcam with Velcro or adhesive. Plug in the mobile Wi-Fi stick for internet c...
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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.
Every time an actor or actress goes in for an audition for a film role, no matter if it's an indie film, school film or Hollywood blockbuster, most auditions use digital video cameras to record them for future reference. You want to make sure your makeup is just perfect for the camera. Not too much and not too little. The point is just to accentuate the face. Watch this two-parter to learn how to apply suitable make-up for these auditions.
Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will permit you to do with your CDs what your turntable permits you to do with your records. In this DJ tutorial, you'll learn how to create a buzzy sound effect with the Pioneer CDJ-800. For more, and to get started creating your own sound effects on your own Pioneer CDJ-800, take a look!
Learn how to open up your turntable platter in order to fix a wobble on your table, getting those records to play smooth. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions, take a look.
