Professional in Office Search Results

How To: Buy the right desktop PC for you

There are so many computers available today, from laptops to desktops to netbooks and everywhere in between. If you are considering going the stationary route, check out this tutorial. In this video, learn how to choose a desktop PC that is right for you. The experts at PCWorld will walk you through brands, capabilities and price ranges so that you can walk into your local office store with confidence and pick out your model.

How To: Remove face and body glitter with Petrilude

If you want to add a little shimmer to your evening, check out this tutorial. In this video, learn how to touch up your makeup or remove it altogether if you have used sticky glitter. You don't want to be that girl or guy in the office Monday morning who still has specks of the weekend on their face, do you?

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: Count the number of characters in an Excel cell range

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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Multiply matrices with the MMULT function in MS 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 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Use dynamic range names in Excel 2007 tables

Looking for a primer on how to create and work with names 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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Name cell ranges with relative references in MS Excel

Looking for a primer on how to create and work with names 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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

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: Build a free SSL VPN on Linux or Windows

This time on the show, bypassing restrictive firewalls with a free and open source virtual private network server for Windows and Linux that will have you connecting back to the home or office with just a web browser! Best of all? It's free! Check out this video for detailed information on how to build an SSL VPN.

How To: Make USB Christmas lights

This video covers the steps for creating USB Christmas lights. Take battery powered Christmas lights and convert them to USB powered to decorate your office. Take apart the battery casing. You have to rewire this. You also need to cut open a USB cord and do some soldering.

How To: Fold an origami paper football

This origami video shows you how to make a paper football (American rules football). This is probably one of the first folds I ever learned to make, and I don't really consider it origami... but at the same time, I thought it might be fun since the BCS football bowl games and NFL playoffs are just around the corner. So make your own paper football and have a little fun playing office football while the boss isn't around.

How To: Shoot a dolly zoom shot

The dolly zoom shot is also known as the Vertigo Effect in filming. It's that dizzying, slightly unstable camera effect you see in shows like "Glee" and sometimes "The Office." It creates audience confusion, thus forcing them to keep watching in interest.

How To: Create professional looking business promotional video

In this video, we learn how to create professional looking business promotional video. To make your video more professional, you can first make your video shorter. The shorter the better, which will get your point across more quickly. Videos should be less than a minute and thirty seconds. If you're using a web cam, don't get too far away from it. If you're using a Flip camera, use a tripod and make sure the light source is coming from in front of you. Natural lighting is also nice. Make sure...

How To: Add drag and drop to a project in Adobe Flash Professional CS5

Need some help figuring out how to add drag-and-drop functionality to your Flash project? With Flash CS5, it's easy, and this clip will show you how it's done. Whether you're new to Adobe Flash or merely unfamiliar with Flash Professional CS5, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.

How To: Go from professional to club girl with your clothes

In this video, we learn how to go from professional to club girl with your clothes. To go to work, you can wear a pencil length skirt with a tank top tucked underneath it. Over this, you can wear a cute and professional jacket that is buttoned up. When you are ready to go out, you can lose the jacket and add on a necklace for a sexy look. After this, apply matte makeup to your face and use dark eyeshadows to give your face a mature appearance and smoky eye. Applying a light lip gloss and masc...

How To: Make a professional-looking advertisement in Photoshop

Need to create an ad for your business? Learn how with this video lesson. Meet the Adobe Photoshop pen tool! Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which presents a step-by-step guide to creating a professional-quality advertisement.

How To: Set up and take a portrait with a digital camera

Taking really professional-looking portrait is a tricky business, which is why so many people are so well-paid for doing so. If you want to create similar results without hiring the professional, this two-part video will give you some handy tips for how to do it. It includes how to frame the shot, some equipment and props that you will need, and other techniques. Never pay hundred of dollars for a professional Christmas card photo again!

How To: Replace a sink trap

Instead of hiring a professional plumber, get free advice from one in this video presented by Fine Home Building. Follow a professional plumber as he shows you how to replace a kitchen sink trap. You'll learn how to layout, cut, and cement PVC pipe.