Digital Video Search Results

How To: Use the LARGE and SMALL functions in Microsoft 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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:

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: Make payment calculations with MS Excel's PMT function

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 47th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the PMT function to calculate payments. Specifically, this video addresses the following topics:

How To: Calculate & compare interest rates in Microsoft Excel

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 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:

How To: Use the INDEX & MATCH functions in Microsoft Excel

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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.

How To: Use & understand compression when digital recording

This tutorial video will show you what the purpose of compression is and how compression works through its parameters. Your instructor illustrates a drum beat and a plucked guitar line. Beginning with how to compress the drum beat, take (download) a drum sound pack without compression and to add compression using the software right click on the drum machine, choose create, and then choose combo on compressor. The virtual compressor has all the dials and adjusters found on any basic compressor...

How To: Bring vocals into Reason with no timing problems

Josh shows how to correctly add vocals into Reason software without timing or drift audio issues. The purpose of learning how to do this is to be able to add additional creative flair to a song, which Josh shows in a separate tutorial. To learn how to do this, you can begin in GarageBand or any other digital audio software program. To successfully do this, make sure you begin and end on a measure and export on a one into Reason. This ensures a seamless addition. In the next step outlined in t...

How To: Make a pinhole camera

In the age of digital cameras and instant gratification, make the simplest camera ever invented using just a light proof box, a hole, and paper. Check out this Howcast video tutorial on how to make a pinhole camera.

How To: Measure intraocular pressure to diagnose glaucoma with a Diaton Tonometer

Attention all optometrists and ophthalmologists— there's a new tool in town, and it's called the Diaton Tonometer. Diaton's tonometer is an easy-to-use and accurate instrument for measuring intraocular pressure (IOP) through the eyelid, which makes it simple to diagnose patients with glaucoma during the early stages, so that immediate treatment and medicines can be administered. This transpalpebral tonometer is handheld, pen-like and no-contact, which provides absolutely no risk of infection....

How To: Use the Cardio Trainer app on an Android cell phone

Staying in tune with the digital age doesn't mean you have to sacrifice personal health. In fact, new technology only makes it easier to workout and keep track of your progress. On any Android mobile phone, there's an application called Cardio Trainer that could help you out significantly. But how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use the Cardio Trainer app your Android enabled cell phone.

How To: Transfer music from an Android phone to Mac or PC

Staying organized with your digital music library can be frustrating, especially when you're downloading songs on different devices. Transferring music files to one central location doesn't have to be hard though, even when you download music on your Android mobile phone. So how do you get that music off the phone? Best Buy has answers. The Best Buy Mobile team explains how simple it is to transfer music files from your Android enabled cell phone to a Mac or PC computer.

How To: Give yourself a sun tan using Photoshop

In this video tutorial, viewers learn how to make a digital sunburn using Adobe Photoshop. Begin by importing the image into the program. Then use the masking tool and select the areas of the skin that you want to sunburn. Now select a reddish color and use the brush tool to paint the select areas. Then click on the masking tool to create a selection use the marquee tool to invert the selection. Now right-click on the selection and select Inverse Selects. Then go to Image, click on Regulation...

How To: Use MIDI in Logic Pro 9

This Lynda tutorial teaches how to use the Logic pro, a songwriting application. Midi sequencing and quantizing is the main focus of this video. Midi is a short name for Musical instrumental digital interface. Midi is not sound. It is a low resolution computer protocol, developed in early 80’s to enable computer to communicate each other. Midi is fast, simple and reliable. It has a intensity stream. In this project, Scot Hirsch explained how a midi file is manipulated in Logic pro. Midi file ...

How To: Use basic sculpting methods in Zbrush 3.1

Are you fed up using Zbrush? Are you just not cut out to be a 3D digital sculptor? Nah, all you need is a little practice. Check out this three-part Pixologic video tutorial on how to use the basics when sculpting a head. You'll see how to make the perfect 3D animated head, and you'll learn how to make an imperfect head. You'll learn how to form with a few tools, and be on your way to great 3D animated character modeling. NOTE: the tutorial starts by using a squirkle, NOT a square mesh - if y...

How To: Retouch photos in Photoshop CS2

This video gives another iteration of a digital makeover, using Mama's Powder w/sharpen action. This series will highlight some advanced masking techniques; rubilith and quick mask modes, and adjust makeup colors using Levels Adjustments rather than Curves. Hopefully this will broaden your understanding of mixing color using a different type of adjustment, in Photoshop or Photoshop Elements.

How To: Use Apple & Google's COVID-19 Screeners on Your Phone to See if You Might Have Coronavirus

The COVID-19 pandemic has created a frenzy for news and information that is nearly unprecedented in the smartphone era, with a major side effect of misinformation. Now, major tech companies are making it easier to ask for advice about novel coronavirus from their respective digital assistants. Results may vary, but Apple and Google are the most useful at the moment.