Class Mum Search Results

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: Ski moguls

Work on turns for skiing over bumps or moguls. Learn skiing tips and techniques in this video lesson from a ski instructor. Take action: re-center on uphill foot, practice ouch, tip, drift, and flatten skis, don't rush middle of turns, and be patient. Bill, the host of this how-to video from Live Strong, is a former world-class freestyle competitor and elite coach. He is now the indoor ski simulator coach at the Aspen Club and Spa at John Clendenin's Ski Doctors. Laurie is a long-time aspen r...

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.

How To: Calculate how much you'll need for retirement in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.

How To: Become a doctor fast

In this tutorial, we learn how to become a doctor fast. There are many ways to become a doctor, including shortcuts. The first shortcut is if you just got out of high school you can take tests that will test you on knowledge you can study on your own. Just from these you can get credits which will give you extra credit without taking all the time. You can also take summer classes that will get you ahead. If you do this, you will finish your bachelor degree 1.5 years faster. Using these tips y...

How To: Write an essay for school

In this video, we learn how to write an essay for school. This is important because it will help you get into college! The main parts of an essay are: the title page, outline, body, introduction, conclusion, and footnotes. Make sure your title page has the title of the paper, the student's name, teacher of the class, and due date for the paper. For the rest of the pages, make sure you follow the guidelines that have been set by your teacher to properly write. Add in a lot of details and make ...