Learning Institutions Search Results

How To: Filter data in eight different ways in Microsoft Excel

hether 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 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.

How To: Reference worksheets and workbooks in Excel formulas

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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.

How To: Multiply & sum arrays with Excel's SUMPRODUCT

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 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.

How To: Create projections for sales numbers in MS 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.

How To: Create an average with multiple criteria in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Evaluate vendors with array formulas in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Count unique records exceeding a hurdle in MS Excel

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.

How To: Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate plate cost for a print shop in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Make a long stem rose out of duct tape

Learn how to put that roll of duct tape to use with help from this tutorial! In this video, learn how to make a long stemmed rose out of duct tape... Perfect to surprise a girlfriend or boyfriend with to show them how much you care. Make unique duct tape gifts and hone your duct tape skills with guidance from this instructional!

How To: Do a Pop Tornado freerun trick

In this video tutorial, viewers learn how to do a pop tornado free-run trick. The pop tornado is the same as a tornado kick except he pop tornado does not have that extra step. Because there is no step, this move is more difficult to perform. Users should learn how to do the tornado kick before attempting this move. Start with a wide leg stance and turn the body. Then do a hook kick and set the feet down. Now quickly jump as you pull your arms in and spin the body. Lift the knee up. This vide...

How To: Make a bicycle wheel windmill

In this video, you'll learn how to make your very own bicycle wheel windmill. This completely recyclable creation which can easily be made from that old bike that's just been rusty away. Put it to good use and make this great eco-friendly windmill. Step by step you'll learn exactly what to do to make this windmill spin.

How To: Ollie on a skateboard, for beginners

It takes most everyone a long time to do an ollie but once you have it done it happens all the time. When first starting out it is a good idea to learn the technique in the grass or on some carpet so the board doesn’t roll around. It’s also a good idea to fully learn the ollie in place before you start doing it in motion. Next is foot placement, have your front foot right behind the front bolts on your skateboard and you back foot on the tail. When you press the back foot into the ground lift...

How To: Understand the basics of food safety in cooking

"Foodborne illnesses are responsible for more than 75 million illnesses, more than 230,000 hospitalizations, and approximately 5000 deaths each year in the United States." In this six-part video lesson, learn about the basics of food safety in a commercial food enviornment. In the first video, three types of contamination are gone over as well as how improper handling can allow food to become dangerous to your patrons. In video two, learn about proper holding times and temperatures, and what ...

How To: Kill gnats

In this video, Sbirdboi will explain how you can get rid of a gnat infestation. First, you must identify what kind of gnats they are, as this determines the best ways in dealing with them. He will explain three common types of gnats, their habits and where they tend to lay their eggs. After teaching you about the kinds of gnats, you will learn what steps to take to kill the gnats, and prevent them from coming back. You will also learn tips of ways you can attract gnats and subsequently kill t...

How To: Sack out and desensitize a horse

In this video tutorial from thinklikeahorse you will learn how to Sack out and desensitize a horse. It is about removing fear from the horse and not creating fear. By this the horse learns not to react instinctively to its fear. This also enables you to read your horse. You first got to look for things that create different kinds of noises that you can use to sack out your horse. The video demonstrates various kinds of tools made out of waste cloth, plastic bags tied to sticks, rope, whip etc...

How To: Draw Japanese waves for a tattoo

In this video tutorial, viewers learn how to draw Japanese waves for a tattoo. In this video, viewers observe different ideas and elements for wave designs. Viewers learn different techniques. To draw a design for a tattoo, viewers should sketch out their image and experiment different designs. The materials used in the video include: tracing paper, pencil and a Micron 08 pen. This video will benefit those viewers who enjoy sketching images, art and would like to learn how to design tattoos.

How To: Make salmon sushi

Love sushi but have no idea on how to make it? Watch this quick instructional video and learn how to make mouth watering salmon sushi. Its simple to make and takes a few ingredients with salmon and white rice being the main ingredients you will quickly be able to create this sushi. Learn the right way of cutting the salmon for the perfect sushi and learn the techniques it takes to accomplish making a salmon sushi roll that will make you look like a pro.

How To: Remove tanlines in Photoshop

In this Photoshop tutorial, learn how to use the software program to remove tan lines from a photo subject. To complete this editing process in Photoshop, follow the steps in this tutorial to learn how to utilize a layer mask, eye dropper tool, and adjust colors. By following the steps in this Photoshop tutorial, you can tan the parts of a subject's skin by learning how to blend colors within the software program so that someone comes out with a more even skin tone.

How To: Caveman on a skateboard

Come along with Melvin the Nerd as you learn to do "the caveman" on a skateboard. His charming personality, hilarious mannerisms and speech are fun to watch as well as educational. Learn this simple trick in just a few steps by jumping up with one foot, pulling the board under your feet and quickly leaping onto the skateboard. In just a few minutes you'll impress your friends with your new tricks and have had a great laugh while learning.

How To: Play "Mr. Brightside" by The Killers on guitar

If you're looking to learn and play another great song on the acoustic guitar, this video is for you! The song you're going to learn is called "Mr. Brightside" by The Killers. You will use the C, G, B, F, Am7 chords. Practice them a lot, and don't practice what you already can do, practice what you can't do! Please watch this how-to instructional video to learn how to play the chords, also to see the strumming technique and style.

How To: Play "Fake Plastic Trees" by Radiohead on guitar

In this acoustic guitar video lesson from TboneWilson1978, you will learn how to play the song "Fake Plastic Trees" by Radiohead. He starts you out by showing which chords you need to know to get started on learning the song, and demonstrates how to finger each of them. He then moves on to the progression of the chords through the song in the verse, and the chorus of the song, stopping at each to explain the chords and their progression.

How To: Make Pakistani bbq-style chicken tikka

Learn how to make BBQ Chicken Tikka without actually using a BBQ! Learn what ingredients you will need, proper preparation steps, and cooking techniques. Learn the importance of the BBQ net in order to enhance dish for the fullest flavor! Video provides examples on garnish ideas to allow you to send out your perfect plate. If you follow the steps in this video you will learn to create an authentic Pakistani dish that will be perfect for social gatherings or for a quiet family dinner.

How To: Play "Yesterday" by The Beatles on piano

Learn to play the classic Beatles tune "Yesterday" on the piano in minutes! This video will teach you how to play the classic Beatles tune "Yesterday," so that others can sing along. You'll start in the Key of F for the intro, and move along with the video, following the easy-to-learn fingering patterns that the instructor gives. With a minimal knowledge of piano, you can learn to play this song and have fun singing along! This instructional video will have you playing the piano in no time!

How To: Add mood lighting in Photoshop

In this video tutorial brought to you by photoshopuniverse, you will learn how to apply mood lighting to images in Photoshop. This is achieved by applying an adjustment layer, called a gradient map, which allows you to adjust the color of the light in an image. You will learn how to access the gradient map from the adjustment layers menu, how to apply the gradient map, then overlay the new layer and fine tune the gradient to create more dramatic looking images.

How To: Remove noise from a photo in Photoshop

In this video by Photoshop Universe we learn how to reduce noise in a photo in Adobe Photoshop. First we learn that there are two types of noise in a photo, luminance and color noise. Next we learn that reducing noise is balancing act, as we take away noise we also lose some detail of the image. Finally the author goes over the 3 steps it takes to reduce the color noise that can be present in photos. Using these methods we learn that we can quickly clean up images that have noise in them in P...

How To: Do three balloon science experiments

This video describes how to perform a three balloon science experiment which is a good way for children to learn scientific principles and could make a good science project for school. In this video one will learn key elements of each project and the logic behind the fun. For example in the first experiment one learns about air pressure and how changes from hot to cold cause amazing effects. Overall this video is simple and useful for anyone who would like to teach, entertain or help children...

How To: Do a Nike Go Long soccer drill w/ Klaas Jan Huntelaar

Nike Bootcamp brings you this soccer training video. Learn how to Go Long with this pro soccer drill. It’s that laser-guided pass in the dying seconds of a game that can make the difference between ninety deadlocked minutes and three vital points. Watch Klaas Jan Huntelaar’s masterclass in grasscutting distribution and you’ll soon learn one of Nike Bootcamp’s most valuable lessons: master Go Long, and you’ll go far. Brush up on those soccer drills with this soccer training video from Nike Boo...

How To: Create comments in PDFs with Adobe Acrobat 9 Pro

Acrobat 9 Pro is an essential tool for creating, reviewing and sharing comments with others you work with. In this video you will learn about commenting PDF files and the methods for including others in your review process with Adobe Acrobat and Adobe Reader. Learn how to use comment tools and review cycles in Acrobat 9 Pro as well as how to collaborate via email or Acrobat.com and share pages.