There's a new LCD viewfinder on the Canon EOS 7D, and in this video, you get to see all about it. See how you can change your viewfinder options on this digital SLR camera with ease. You can display almost any information you want.
In this medical video, learn the process of examining the lower extremity of the body. See demonstrations of how you inspect the lower extremity, how you palpate and then perform passive range of motion of the hip, knee and ankle. John D. Gazewood, MD, MSPH, will also teach doctors special maneuvers to help examine a knee injury. With any type of musculoskeletal exam, you're looking for things like deformity, swelling, and changes in coloration.
This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.
Yanick's Photo School demonstrates how to use Photoshop to make HDR images in Photoshop CS3. This tutorial first explains that HDR means "High Dynamic Range" which is a process to get details from a photo from both the highlights and shadows of a particular scene. The first thing that is necessary is to take multiple views of the same image with different exposures. To start off, you will take three exposures: one that is two stops down, one that is normal exposure, and one that is two stops ...
Aspiring singers can learn how to sing high notes with vocal coach Robert Burnley. When you attain an extended range, your vocal chords will stay in place and then your chords will thin, shorten, or dampen allowing you to reach higher notes. This is what occurs physically when you are reaching higher notes. The key is to have the mentality that you are allowing your vocal chords to get thinner or shorter to reach those higher notes. Part of the struggle is not having the right mindset that yo...
Cross processing is a Photoshop version of slide processing. The result would be you get all these weird color shifts. For reasons best known to people who run the fashion magazines, this look became very popular in the 1990s. Start by adding in a curves layer. Add a new adjustment layer for curves. If you've never used curves before it is recommended that you take a curves tutorial first as for this effect we will need to adjust individual color channels. It is not difficult but if you don't...
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
This is all about vector, swirling rainbows. Have you ever seen those looping, swooshing, swirling rainbow graphics used in all kinds of graphics ranging from logos, and sketches, to grungy and retro illustrations? Well, you are going to create one of them in Illustrator. Watch this Illustrator video tutorial to create vectored rainbows. Also, learn how to export it to a program, such as Photoshop, as a smart object, to utilize it as a smart object so we can both retain vector scalability whi...
Not sure how to properly warm up your voice before belting a tune? Learn the right way to warm up your voice so you can surprise friends without setting off the neighborhood dogs.
Check out this video tutorial to show you how to use the Sony DSR-PD170 MiniDV camcorder. This video was made by the equipment room at CUNY Journalism School in New York.
How do you get bigger biceps, the age-old quest for bigger guns. Well, first things first, more is not better. Hefting around 50-pound dumbbells as opposed to 20-pound dumbbells is not necessarily going to build you bigger biceps because what's probably happening, you're probably not using full range of motion, you're jerking a lot, you're not focusing on that muscle alone. Practice lifting weights to get bigger biceps. Learn how to increase arm strength and size in the biceps with weightlift...
Learn how to do single arm cable reverse pulls. Presented by Real Jock Gay Fitness Health & Life. Benefits
Almost 20% of the US population (about 60 million Americans) live in rural areas where mobile reception is weak or nonexistent. In times of crisis, these Americans can't rely on the internet to communicate with loved ones or receive new information. This is why being able to interact offline is so important.
When you look at the top corner of your phone, what do you see? Upon upgrading to Android 11 or iOS 14, you'll see either "5G," "5G+," or "5G E" if you're connected to the right network. But what exactly do these symbols mean? They indicate not only if you're using 5G, but also what type you're connected to.
After hosting millions of free 3D models online, Sketchfab is betting that augmented reality and virtual reality developers and creators will be willing to pay for premium 3D content.
One of the most overlooked components of talking about augmented reality and virtual reality is getting people to actually use the hardware and software associated with these platforms.
The future of forests looks dreary in the face of a warming climate, but scientists are exploring the relationship between soil microbes and the ability of trees to move to higher altitudes, a key component of their survival.
Wi-Fi signals have limited range, so if you live in a two-story house or work in a larger office, you may have set up multiple routers or repeaters to ensure full wireless coverage. Sadly, Android handles the transition between networks pretty poorly.
When exercising at a high intensity, you know to expect some level of pain. That can make it difficult to identify when your body gives you a warning sign of injury. If you pay close attention, however, you can tell the good hurt from the bad. I talked to Dr. Brian Parr again, professor at the Dept. of Exercise and Sports Science at the University of South Carolina Aiken, who explained which symptoms of exercise are normal and which are bad:
Having trouble getting a strong Wi-Fi signal on your Samsung Galaxy S3? Does the signal drop out on you when changing rooms? Frustrating, isn't it?
It's called the AUDynamicProcessor, and it's very helpful when it comes to mastering your songs in GarageBand. In this video tutorial, you'll learn how to utilize and manipulate the sound dynamics of your songs in GarageBand using the AUDynamicProcessor filter, which effects the high and low ends of audio.
GarageBand is a great tool for composing your own beats and jingles, but when it comes to filters, it's not so easy to understand exactly what they do, as in the case of the AUBandpass filter. This video explains exactly what the AUBandpass feature does in GarageBand and how it can be used to make quality-sounding instrumentals for you beat projects.
Is this how a modern geisha would look like? We don't know about that, but this avant garde makeup look sure is inspired by the simultaneously refined and intensely hued colors of geisha makeup. Intense cranberry red lips and pale skin make this look sweet and refined, while the crazy long red false eyelashes add a modern twist.
We didn't know that how you cut ginger can impact how it tastes until we saw this video. According to the tutorial, the type of cut you should make to a piece of ginger depends on what you need the ginger for.
In this tutorial, we learn how to do ultra wide pushups for a big chest. A basic pushup can be way too easy if you are an experienced body builder, but you can do different variations to strengthen your body further. First, get down on the ground and place your arms much wider outside of your body than they normally would be. This will make you push harder up while your hands are pushing outward. This will make you work hard and squeeze at the same time, and your range of motion will be limit...
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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
Panoramic photographs are deliciously delightful to the eyes, but an HDR version of that same picture will make people go nuts! If you know anything about HDRI (high dynamic range imaging), then this will be a breeze. Watch and learn.
Over the last few years, the musical "Wicked" has become a highly popular phenomenon whose awesomeness has spread mostly through word of mouth. Well, that and the musical's extremely talented and gorgeous costars, Idina Menzel and Kristin Chenoweth, have unparalled charisma and vocal ranges that do nothing less than astound.
In this video, we learn how to film skateboarding. First, get a camera that fits your price range and you will be ready to start filming. Next, use a long lens so you capture the best shots of people on their boards and in motion. Next, make sure you capture the lines that the skateboarder is skating on. Use different angles to get the best shot possible. You want to get close to the action, so you will need a fish eye lens. Use your skateboard to follow the skater around. Using these simple ...
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 642nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budget summary table that adds by month and payee. See the benefits and drawbacks of the SUMIFS & EOMONTH functions method or the PivotTable method. Also learn about the Excel Table feature for adding dynamic ranges.
In this video lesson for doctors, you will learn how to do a shoulder examination. First, you'll get a review of the procedures for evaluating any joint, and then jump into the basics of inspection of the shoulder, then learn palpation, and range of motion. This is a very general shoulder examination, meant to serve as a refresher course for those medical doctors or medical students who already know the exam procedure.
With Adobe Photoshop CS5, it's easier than ever to work with HDR or high dynamic-range images. This video tutorial presents an overview of some of the bigger enhancements. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial. For more information, and to get started taking advantage of Photoshop...
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 to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
In this how to video, you will learn how to become more flexible. This refers to the range of motion you can attain around a joint. This can be useful for keeping your body fit and becoming a better lover. You will also be less prone to injury. You will also get slimmer. The best time to do this is after a workout. Hold each movement for ten to fifteen seconds. Although you may feel a pull in the muscle, do not stretch to the point of pain. Yoga and Pilates is another away to increase flexibi...
Whether you're new to Adobe Photoshop or a seasoned digital photographer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...
Drawing is an excellent exercise for the brain that also lets your mind wander. This video tutorial demonstrates how to draw a serene mountain landscape using charcoal techniques. Begin with a simple sky and mountain range, then add trees and a beach. Pencilling in water will help to bring the trees to the foreground. Finally, add shadows and a waterfall to provide a sense of depth to the entire rendering.
Photoshopuniverse will show you how to change a person's hair color in PhotoShop. You can achieve this by using hue and saturation adjustment layers and set to colorize. Set the saturation to about 50%. Go back to the background layer and select the color range select parts of the hair color, select the parts of the hair you want to change and with the eye dropper click it. Once the selection is made invert the selection the color will change. You can now change the hue to make it what you want.
