Generous Tipping Search Results

How To: Calculate subtotals 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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM function.

How To: Work with date functions (TODAY, NOW, DAY) 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.

How To: Record absolute and relative macros in MS 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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.

How To: Find and use VBA code 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 54th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to find, download and use VBA code in your MS Excel projects.

How To: Force a function to becom an array 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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...

How To: Work with Microsoft Excel's order of precedence

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 24th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn see exactly how Excel calculates/evaluates formulas including things like intersections, unions, negation, text operators and comparative operators. Knowing the o...

How To: Value assets & analyze cash flows 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 50th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to value an asset as well as perform discounted cash flow analysis with the Excel functions PV, NPV & XNPV.

How To: Run advanced VLOOKUP queries 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.

How To: Set data up for sorting & filtering 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Fix common Excel spreadsheet problems & errors

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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Import different types of data 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...

How To: Work around the 1-rule data validation limit in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

How To: Update inventory records by formula in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Use the UPPER & EXACT functions in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.

How To: Average with the MONTH function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 90th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see a complicated average calculation with multiple criteria using the MONTH function on a date field. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Apply conditional formatting to a row 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 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Fly fish with poppers

In fly fishing if you want to achieve the right popping motion, you need to make sure that you hesitate whenever you bring the line back and forth. There are some other important tips to watch out for as well. To find out what they are, check out the tutorial above on how to fly fish with poppers to understand the right way of doing it and the wrong. Enjoy!

How To: Control your rodent problem

Don't let all those pesky rodents overrun your house and ruin your home environment. A serious rodent infestation can be a major strain on even the most amazing homes. This video from Ask the Exterminator is full of helpful tips that will show you how to get rid of those rodents for good.

How To: Sew ballet shoes

Every new pair of ballet shoes needs their elastics sewn on to fit the individual personally. In this video, learn a few tips on sewing in the elastic and satin ribbons with help from a ballet expert: Lynda DeChane-Audette is the founding artistic director of the South Florida Ballet Theater and was born in Boston. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Hold her hand

Every guy's there... You're taking a stroll with a girl you like and you want to grab her hand, but find your own claming up and getting sweaty! Yes, it's a bit nerve racking doing it for the first time: hand holding that is. Luckily, your Wing Girls are here to help! Get tips on how to get to the hand holding stage with the advice of these two young dating & relationship gurus.

How To: Look like a model for real women

Are you sick of being the regular girl, do you get lest in pictures of Tyra, Giselle, or Kate? You want to go from that regular girl to looking exacting like a top supermodel? In this video, you'll go step by step in helpful tip and techniques on how to go from basic to super glam. So enough doubting yourself feel the million bucks you deserve to feel like.

How To: Use data forms in Microsoft Excel 2003 or 2007

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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data form in both Excel 2003 and 2007 as well as how to add a button to Excel's Quick Access toolbar.

How To: Create red and gold acrylic nails

To create red and gold acrylic nails start by prepping a sanitizing your finger nails and applying the tips. after you have trimmed you nails to the desired length apply primer to you nail bed. With your brush gently apply the gold glitter to the tip of you nail and brush downwards toward your nail bed. Apply your red glitter the same way under your gold glitter. With your brush create what Jennisse calls a smile under the glitter to your liking. Cover your nail evenly with a thin layer of pi...

How To: Get ripped fast for guys with a slim tone

This video workout is aimed at skinny guys who want to get ripped. Some tips for weight training are to train less than 45 minutes at a time, focus on compound movements, try to get 5% stronger every two weeks, don't do more than one or two forced reps, and split your workout into 3 days for various body parts. To gain muscle mass, eat about 15 times your current body weight in calories, including 1-1.5 grams of protein per pound. Eat twice as many carbs as protein, high quality fats, and nut...

How To: Curl short hair and make it stay

In this video Jessieka gives us tips on how to keep curls in our hair after we use an iron. She gives us helpful tips, like after styling, if you don't wash your hair for two days the curls and style will keep better because of the oils. In this tutorial she uses a Revlon curling iron and some styling mouse before starting so it will hold better. Then she parts out her hair in sections, holding them in place with clips, and starts to curl. After she curls all the hair section by section, she ...

How To: Stay slim and fit

Isn't it everybody's dream to stay slim and fat? This video will help boost your self-confidence and will give you tips on how to stay slim and fit. Anne Saccone is of the opinion that green tea with lemon helps her to maintain and manage her weight. She has it about eight times a day. Other food that helps in weight management are cereal with semi-skimmed milk, wholemeal bread, natural yogurt, cottage cheese, boiled egg etc. She advises not to be obsessed with food and to count calories but ...

How To: Use apostrophes on a BlackBerry

In this video Darci Lorocque from Swirl Solutions gives a very handy and useful tip for Blackberry users. She says that you don't have to type apostrophes while you are sending text messages or emails or using Blackberry messenger. The apostrophe is automatically typed by the Blackberry. So for example if you want to write the word "Don't", you will simply type "Dont" in your Blackberry and as soon as the space button is hit the apostrophe will be added automatically.

How To: Recover deleted podcasts on iTunes

Veronica Belmont from Tekzilla shares a tip for finding lost podcasts without unsubscribing and resubscribing to the feed. To do this by a simple keyboard combo fist close the disclosure triangle so that the individual episodes are hidden, then hold down the 'Option key' in Mac or 'Shift' in Windows and toggle the disclosure triangle as shown. The iTunes feed will refresh and all the past episodes will reappear. Combine this with the "Get All" button to find lost podcasts.

How To: Design a professional looking resume

In this video, groddin99 describes the correct way to write a resume and fashion a cover letter. Groddin99 knows the importance of a clean and formatted resume, and he gives advice and tips on formatting your resume properly, and how to list your previous jobs and your skill set. He also explains how inappropriate it is to draw pictures on the margins of the paper your resume is printed on. Groddin99 has written many books on this subject, and with his tips, you can write and fashion an attra...