Favourite Guest Search Results

How To: Name cell ranges and use names in formulas 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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Create charts and set up pages for analysis in 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 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...

How To: Add conditional formatting to data bars/icons in 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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...

How To: Work with Microsoft Excel's LOOKUP 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:

How To: Create a savings plan with Excel's FV & PMT functions

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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...

How To: Create a budget with formula inputs 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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...

How To: Use comparative operators & logical formulas in 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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...

How To: Use text functions (TRIM, PROPER, SUBSTITUTE) in 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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...

How To: Speed up calculations with custom Excel formulas

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.

How To: Create simple math formulas in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to create math formulas in MS Excel using addition, subtraction, multiplication, division, exponents, and parentheses. See how 2+2*2 is not equal ...

How To: Use relative & absolute cell references in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...

How To: Work with cost & selling price markup in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.

How To: Calculate markup on selling price in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 50th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for markup on selling price in MS Excel.

How To: Solve for rate of change in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 29th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for rate, amount of change and rate of change.

How To: Round to the penny or dollar in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 9th installment in his "Excel Business Math" series of free video lessons, you'll learn about when you must use the ROUND function in Excel. Round to the penny or dollar with this free video lesson.

How To: Add and subtract numbers with Excel's SUM function

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 10th installment in his "Excel Business Math" series of free video lessons, you'll learn how to add and subtract using the SUM function.

How To: Do multiple regression with MS Excel's LINEST function

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 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...

How To: Create a contribution margin income statement in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.

How To: Create an array constant from cell values 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 10th installment in his series of Excel array formula series, you'll learn how to create an array constant from values in cells. This is a great trick that can save tons of time when you want your array stored in memory.

How To: Build confidence intervals & test hypotheses in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...

How To: Find confidence intervals without the sigma in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Use Microsoft Excel 2007 for statistics

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Play "You and I" by Ingrid Michaelson on ukulele

Want to play the Ingrid Michaelson's "You and I" by Ingrid Michaelson on your ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "You and I" ...

How To: Make sticky toffee pudding

Celebrity Chef Phil Vickery teaches in this video how to make a British favorite dish: sticky tofee pudding. This tradition dish is served warm and in often during the winter. Phil soaks the dates in boiling water and baking soda to bring out more of their flavor for the dish. While the dates are soaking, he starts creating the sponge part of the cake. With basic ingredients combined, he creates his sponge cake in a way more like a batter than your tradition method of making a sponge cake. Ne...

How To: Play "The Charleston" by James P. Johnson on a ukulele

Want to play "The Charleston" by James P. Johnson on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's also a wonderful way to add to your repertory of songs. For more information, and to get started playing "The Charleston" on your...

How To: Take microwave shortcuts when cooking potatoes

Want to make your family a filling and healthy dinner but are short on time? No problem! In this tutorial, learn how to cut your cooking time in half by using the microwave. Potato expert, Patty Mastracco, shows you how to make your favorite potato dishes in less than 20 minutes using your microwave. Potatoes are delicious, healthy and filling and make great last minute dinners.

How To: Create a video playlist in YouTube

This is a video tutorial that pertains to the website youtube.com. It is showing its audience how to successfully make a video playlist on youtube.com of all of their favorite videos so that they can be on continuous play. The first step is to open up youtube.com. Next you should go to your youtube.com channel and begin to make your own playlists. To make a playlist for your page you need to go to the edit playlist information and then fill out the form. Then you can add the appropriate video...

How To: Mix a classic or fruity Long Island iced tea cocktail

Long Island Ice Tea is one of the most famous cocktails known around the world. To make one, first fill a glass with ice. Then pour about 20 milligrams of gin, 20 milligrams of white rum, 20 milligrams of tequila, 20 milligrams of vodka, and 20 milligrams of your favorite clear liquor. Add the juice of half a lemon (about 20 milligrams of lemon juice). Using a cocktail shaker, shake the cocktail about 3 or 4 times. Put a strainer over a glass filled with ice, and pour the cocktail in up to ab...

How To: Make your own DIY lip balm or lipstick

In this video, we learn how to make homemade lip color with palette. First, start off with a mixing bowl and a small amount of Vaseline. Pick any type of color you want, whether it's blush, eyeshadow or foundation, add this to the Vaseline. Mix this together using a small spatula. You can add more colors as you desire to get your wanted colors. Make sure the color is mixed well and is well-blended together. When you're finished, test the lip color out and apply it to your own lips. To save it...

How To: Pack a backpack for Europe as a male traveler

Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...

How To: Get Kesha inspired messy loose scrunched waves

Are you a fan of the hot new pop icon Kesha? This video will teach you how to create her loose scrunched waves look. This instructional video requires you to use both a flat iron and blow dryer. The first step is to put volume product into the hair before blow drying it completely dry. Next, part the hair off to the side, making sure to not use your natural part line. Third, section off the hair into manageable strips. Then, place the strip into the flat iron and bend the hair around the iron...

How To: Teach your toddler the days of the week

In this video from modernmom, Nancy Stone, a parenting coach teaches how to teach your toddler the days of the week. There's a few simple and easy tips to do this. Music and songs are some favorites. Also rhyming things with the days of the week is a great idea. Or make a calendar and have them trace the letters. Another example is to speak to them and say things like on Saturday we don't go to school and Sundays we go to church. Another thing to say is when they wake up work in the day of th...

How To: Make your own organic lip balm

This video shows the viewer how to make their own organic lip balm. This is a good idea as many commercial lip balms contain preservatives designed to preserve the balm – these preservatives can have detrimental effects. The ingredients used are 2oz of bee’s wax and 1oz of coconut oil. Grate the bee’s wax into a Pyrex boil, add the coconut oil and lower the Pyrex bowl into a saucepan of water. The water should be at a low heat. Gently stir the mixture until it has melted. Allow the mixture to...

How To: Put the basic components of makeup on your face

Very friendly and fun to listen to. She does recommend her favorite products, but also adds that any product you choose should work just fine. Her #1 rule is to always moisturize before applying make-up. Then she moves to her eyebrows and then to concealer (which she says is up to you whether or not you want to use concealer). She shows how to make it so the concealer doesn't show, and then moves to eye primer and texture eyeshadow. She is humorous on her opinion on texture being a must have....

How To: Make delicious homemade donuts

Lexi and her chef father are going to show you how to make your very own homemade donuts. All you are going to need to create your donuts are a frying fan, thongs, frosting, vegetable oil, and any kind of packaged biscuits. First, you are going to take the biscuits poke a hole in the middle and then round them off so it's even. Once that's done you'll be ready to fry the dough but make sure the oil in the pan is between 365-375 degrees. After you drop the dough in the hot pan, you'll only nee...

How To: Make & decorate a vintage celebration cake

This video teaches the secrets of making and decorating a vintage celebration cake. First bake your favorite cake, apply cream over it and get it ready to decorate. Start by using green icing color pipe and design some vines on the cake. Now with violet icing color design the grapes by making beads and make some leaves with a big green icing tip. Use buttercup yellow icing color and make a leaf border all around the cake.

How To: Cut a fresh mango

Sarah Dussault gives us instructions on how to appropriately cut her favorite fruit, the mango. -There is a huge seed where the pit is, so first you want to cut off the sides. -Take one side and cut into a grid pattern. -Now you can simply pop the cubes of mango off and eat them. -Be careful, the skin of mangoes contain similar oils to those found in poison ivy. -Take the other side of the mango and cut into slices and then peel the skin off. This is another technique for cutting mangoes. Jus...