Head Office Search Results

How To: Sum & count with array formulas in Microsoft Excel

Looking for a primer on how to create and work with array formulas 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 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use letters to dial on your BlackBerry

This helpful video explains how to use letters when dialing on a Blackberry. Many companies have words in their phone numbers so Darci Larocque shows us how to dial those letters. All you have to do is go to the call log, and hold the key in, and type in whatever word you are trying to dial. She also shows us another tip: if you are calling an office and you need to enter in someone's last name, you can do that the same way. Blackberry users should definitely view this video.

How To: Bake carrot cupcakes with cream cheese frosting

In this culinary how-to from the Food Network's Ellie Krieger, you'll learn how to bake delectable, almost-healthy carrot cupcakes using whole carrots, lemon zest, canola oil, brown sugar, two eggs, 3 quarters of a cup of whole wheat pastry flour, 1/2 cup all-purpose flour, 1 teaspoon of baking powder, 1/2 teaspoon of cinammon, 1/4 teaspoon of nutmeg and a 1/4 teaspoon of salt.

How To: Fold an origami two-cup pencil holder

This how-to video show you how to make an origami two-cup pencil holder. The narrator explains that you will need one eight and a half inch by 11 inch piece of office paper. This video show everything you need to know from folding every single predrawn line and reversing them, to all the precise folds necessary to create this pencil holder. If you follow the meticulous instructions showed in this video you can create your own two cup pencil holder using origami techniques.

How To: Make a newspaper tree

The Professor of Silliness returns with some paper. Watch this instructional video to make a tall tree out of newspaper. You need an old newspaper, masking tape, and scissors. Simply lay out the newspaper pages from end to end and tape them together. Then roll it up at a diagonal, starting from one corner, and pack i it into a compact tube. Use tape to keep the tub intact Use the scissors to cut vertical lines half way down the newspaper tube. Pull out the inner most layer and turn your recyc...

How To: Budget w/ ledger sheets in Microsoft Excel: Mac 2008

Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Microsoft Office for Mac team shows you just how to manage your finances with pre-formatted Ledger Sheets in this how-to video.

How To: Use Table Styles in Microsoft PowerPoint: Mac 2008

Sure, you can make boring tables inside PowerPoint 2008 for Mac, but who wants to add that dull element to their slideshow presentations? Nobody! Tables can be more than just numbers, they can be eye-catching and visually striking. The Microsoft Office for Mac team shows you just how to create great-looking tables by using Tables Styles in this how-to video.

How To: Share slides in iPhoto albums in PowerPoint: Mac 2008

Not everybody in this digital age has PowerPoint, whether on Windows or a Mac. But at least Mac users can find other ways to share their PowerPoint presentations with other Mac users via iPhoto. PowerPoint 2008 for Mac makes it easy to share your slideshows. The Microsoft Office for Mac team shows you just how to share PowerPoint slides as an iPhoto album in this how-to video.

How To: Use the new features in Microsoft PowerPoint: Mac 2008

If you've used PowerPoint in the past, you're probably used to version available on Windows, but you can do even more in PowerPoint 2008 for Mac. There are tons of new features that slideshow builders will love, but sometimes you can never know about them unless someone tells you about them. The Microsoft Office for Mac team shows you all the great features in this how-to video.

How To: Create and edit head morphs in the Dragon Age Origins toolset

Creating the NPCs (non-player characters) that fill your world is just as important as the story itself! Creating the atmosphere and setting the tone of your characters are incredibly important, and if the stock NPC looks just aren't doing it for you, then try using head morphs in the toolset! In this video you will learn how to do head morphing in the toolset and where to find each of the options and edit your NPC's together.

How To: Draw a bemused lion head for beginners

Simba from "The Lion King" couldn't have done it better himself. In this video tutorial you'll learn how to sketch out a very realistic lion head held in a bemused expression. Whether you love lions or find them frightening, drawing this lion head is an excellent way to gain knowledge of anatomy and how it affects different poses.

How To: Make a cheap corpse head prop for Halloween

Dr Kreepy, Halloween crafter, shows how to obtain a rotting head without killing someone! For this project, you will need a skull, paintbrushes, liquid latex, black spray paint, brown paint, and cotton balls. Watch this video prop-making tutorial and learn how to make a cheap corpse prop head for Halloween.

How To: Dissect a pigs head and eye

Check out this anatomical video on a pigs head. This swine is sure to teach you all you need to know for your biology class. The science of a pigs head isn't too far off from ours, so pay attention. If you don't want to do the cutting with that scalpel yourself, than just watch this video tutorial, so you don't have to get your hands dirty.

How To: Origami a pig head

Learn how to make an origami pig head. When doing this, instead of using the ordinary square origami paper you need a rectangular paper, so just cut the square in half in order to make an origami pig head.

How To: Draw male heads with Otis College of Art & Design

This video begins with various examples of male heads being shown from different angles. The artist begins by drawing the outline of the eyes and eye brows with little definition. The outline of the head is then created to give the male head it's size and shape. by using a ruler the distance in between eyes, nose and lips are created then drawn more precisely. The video shows various different ways to shade the male faces features to give realism. The last part of the drawing that is covered ...

How To: Tune a drum head on a drum set

Tune a drum? It's possible! Every drummer has a specific way they want their drum set to sound. And the way a drum sounds depends on how the drum head has been adjusted. This video demonstrates how to tune your drum and make it sound exactly the way you want it.

How To: Prank a coworker with an upside down full coffee cup

Office pranks have a long and distinguished history. You've probably seen this one before, but in case you haven't, this video will show you how to do the upside-down coffee cup prank. Simply take a full cup of coffee, place it on the desk of your victim, place a piece of paper flat on top, then carefully flip the cup onto the desk and remove the paper. The cup will be upside-down, full, on the desk. The only way to remove it is to soak oneself with coffee, as your victim will most likely do.