Favorite Storage Search Results

How To: Play "Hey, Soul Sister" by Train on the ukulele

Want to play Train's "Hey, Soul Sister" 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 obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing this modern pop song on y...

How To: Build and use array formulas 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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Use rounding functions & paste special values 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 28th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use Excel's rounding functions, how to paste special values – and quite a lot more besides. Specifically, this video addresses each of the following topics:

How To: Build frequency tables & histogram charts 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 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:

How To: Chart data & use Excel's SUMIFS & AVERAGEIF 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'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 to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:

How To: Use TEXT & custom number formatting 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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:

How To: Fix other people's Microsoft Excel spreadsheets

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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

How To: Use and work with tables in Microsoft 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

How To: Use the Advanced Filter tool to extract data 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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

How To: Use functions and formulas in Microsoft 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...

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...