World Class Search Results

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: 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: 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: Break dance the three-step

Want to learn how to break dance? In this video, learn the beginning-level three-step, a break dancing essential. In order to become a break-dancer, an individual needs to get into good shape through exercise, and he also needs to take dance classes. Learn more about becoming a break dancer here.

How To: Balance chemical equations properly

Confused by the equations in chemistry class? This tutorial is here to help! Clark College Tutoring and Writing Center tutors Kevin Martin and Joey Smokey explain how to balance chemical equations, providing examples and tips in this two part video series. You will definitely improve your test scores after watching this step by step program.

How To: Create a jumping letters animation in Flash

This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...

How To: Play a basic conga drum sequence

In this video are the Afro-Cuban Percussion Class at Grossmont College, with instructor Manny Cepeda to show us how to play a Meringue rhythm on the Conga Drums. He starts off with a slow beat by beat demonstration and then moves on to a faster beat. The camera changes the view so that you can see both a front and back view of him drumming. Once he has shown the basics he shows the different variations you can use and the various counts that you can start on.

How To: Make Cricut snow globe card

Cardcrazy09 teaches us how to make a Cricut snow globe card. You cut the base of the snow globe in brown cardboard. You then add a layer of white with dots and snow flakes on top. The snowman is done using the same technique - black cardboard and then a white layer on top of it. You add the carrot nose by sticking it on. When all is dry, add the snowman on top of the snow globe, in the middle of it. You add the acetate layer on top of them. The end result looks like the class on a real snow g...

How To: Make a quartile diagram (aka, box and whisker plot)

This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...

How To: Use container fields with FileMaker Pro 10

This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is a special kind of field called the container field. FileMaker Pro container field is a versatile data type in that it can store any kind of binary data. Container fields can be used to hold binary data in four broad clas...

How To: Use Pyro FX fire and smoke tools in Houdini 10

Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.

How To: Learn Calculus in 20 minutes

Did you sleep all semester in your Calculus class? Are you just waking up now to realize you have a test on Monday and that you're totally screwed? Well, luckily you can learn an entire semester worth of Calculus in just twenty minutes... or at leasts that's the hope.

How To: Warm-up with Salsa dancing & steps for kids

Fit for a Feast hosts a kids cardio workout including Salsa steps, sit-ups, jumping jacks and more. This is a great warm-up for kids on their way to sports or dance class; it can also be used for Q.D.F. (Quality Daily Fitness) at school. With a Latin American cd in your stereo and this tutorial, you're child will be working up a sweat in no time! Be sure to stretch before you begin!

How To: Hairspray dance routine with actress Tabitha Lupien

Are you a Hairspray fan? Why not learn the routine for, "Nicest Kids in Town" from one of Hairspray actors? Tabitha Lupien, who played Becky in Hairspray gives a dance lesson for a class of youngsters for Fit for a Feast, a children's video site full of kid cooking and kid fitness videos. Incorporating jazz dance, leaps, turns, and kicks, this lesson from Tabitha is sure to get your blood pumping and your body sweating! A great way to get some exercise! this afternoon!

How To: Open a Champagne bottle with class

The loud pop and a flying cork are not the goals. This video from CHOW.com shows you how to open a bottle of bubbly without showering your guests or wasting the lovely contents of the bottle. You need to have a knife to cut off the foil. Cover with a towel to keep it safe. You don't want to pull the cork. You want to twist it for the faint hissing sound. No pops here!

How To: Perform the "year game" magic card trick

What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "year game" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this year game card trick, a little mathematics goes a long way, so don't fall asleep in math class.

How To: Perform the "impossible card location" magic trick

What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "impossible card location" magic trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this impossible card location card trick, a little mathematics goes a long way, so don't fall asleep in math class.

How To: Build a steadycam for small hybrid digital cameras

Need to shoot a film for class and realized you don't have a Fisher Dolly and your cinematographer's hands are a little to shaky for what you would consider good filmmaking? Well, this video tutorial will show you how to make your very own steadycam. Check out how a nautilus design transforms into a more suitable steadycam; the gimbal is the key, and gimbals are very hard to find, especially the right one.

How To: Build stones & cinder blocks for a diorama

Build stones & cinder blocks for a diorama. Papa Tom teaches viewers how to make a building look like it is made of stone or cinder blocks using the Building and Structure Kit from Scene-A-Rama. This is super easy and tons of fun for all ages. It's great for school or class projects. Use a ruler, a fine point marker, a hobby knife, and a paint brush.

Hack Like a Pro: Python Scripting for the Aspiring Hacker, Part 2

Welcome back, my fledgling hackers! In an earlier tutorial, I introduced you to probably the most popular scripting language for hackers, Python. To become a professional hacker, you need to have some scripting skills and Python is a good choice if you want to master just one. In this latest guide, I will expand your background in Python and offer you a tidbit of Python code to whet your appetite for all of the hacking to come.