Class Taught Search Results

How To: Use the TRANSPOSE & FREQUENCY array functions in Excel

hether 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 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.

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: Teach your dog the perfect "STAY"

This is the most important thing that a dog should know. In this video will learn the fundamentals of how to begin to teach this. It is by no means entirely conclusive to the training that is involved in teaching stay. Tab with his German Shepherd "Solea" demonstrate the do's and don't when training your dog to "stay". You'll also learn the importance of this command for the dogs safety.

How To: Create a bouncing ball animation in Flash

The bouncing ball animation in Flash is usually the first assignment covered in an animation class because it demonstrates some of the most basic principles of a line across a stage. This trick is quite easy to learn and this tutorial will take you through all of it, step by step. Once you master this animation, you will find it much easier to create more complicated ones.

How To: Find the perimeter of a parallelogram

One thing that you will need to know in order to pass Geometry is how to find the perimeter of a parallelogram. Parallelograms are quadrilaterals with two pairs of parallel sides. It is not difficult to find their perimeter, but you will need to know a few steps. Check out this video for tips on how to do this in your math class and ace that big test.

How To: Find the area of a rectangle

The area of a rectangle is the basis for all geometry. You will need to know how to do this in order to better understand other objects. This video tutorial will show you the formula for area of a rectangle and how to use it. Don't be confused in math class anymore.

How To: Find the volume of a regular pyramid

In this video, you will learn how to find the volume of a regular pyramid. Finding this volume is one of the basic steps in high school geometry. This tutorial will show you all of the steps and equations you need to solve this problem and soon you will be heading straight to the top of the class!

How To: Use the ratio formula to find coordinates of a point

This video is recorded in a mathematics class room. It is very clear by the sound and picture. The faculty here is explaining that the ratio between two numbers can be found using various formulae and methods. For example, 3:1 is the ratio between p and q. Likewise he explained the other formulae and methods.

How To: Find r-value & equation of regression line w/ EL531W

Need a little help in your Statistics class? In this statistics tutorial hosted by The Free Math Tutor, a demonstration of how to use the Sharp EL531W calculator to find the correlation coefficient (r-value) and the equation of a regression line is given. Want some more practice? For exercises and answer sheets, go here.

How To: Render with Mantra in Houdini 9.5

The 3D animation program Houdini is automatically bundled with Mantra, Houdini's production-class renderer. In this masterclass, developer Mark Elendt shows you some of the latest features of Mantra including PBR (Physically Based Rendering) and the new volume rendering architecture. He will also review the process of rendering with different rendering engines in Mantra. See how the rendering engine works.

How To: Origami MIT's mascot brass rat

MIT's mascot, though called a brass rat, is actually a beaver. With the huge cost of the class rings, every MIT student (and those who didn't make it in) can make their own for just the cost of a square piece of paper. Watch this video origami tutorial and learn how to fold MIT's mascot the brass rat beaver out of a piece of paper.

How To: Calculate your GPA

In order to calculate your cumulative average (GPA), you need to know the value of the grades you receive. The grades you receive in your classes are based on the grading scale of each instructor in your classes. Your cumulative average is the resulting value of all of the grades.

How To: Make an edible plant cell model for biology class

Science fairs are some of the most creative moments during the elementary school period. Not only are you able to research a topic of interest, but you also have try to find various ways in which to showyour scientific results. In this case, you'll find out how to make an edible plant cell model for an easy science fair project of for biology class. It's easy to do and will surely attract the attention of your teacher and others. Enjoy!

How To: Practice standing yoga poses

This fitness how to video discusses a few standing poses that might work for tight hamstrings and hips. Ask any non-yogi office worker to sit down on the floor and cross his legs, and 9 out of 10 times, his knees will be way off the floor and his back will be hunched up like Quasimodo. If your hips are really tight, your average yoga class will only help you make small gains. In order to double or even triple your progress, keep going to class, but take ten minutes each day and practice the p...

How To: Work with common and preferred stocks 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, the 62nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to work with common and preffered stocks in MS Excel.

How To: Calculate the value of a preferred stock 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, the 62nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a preferred stock.

How To: Calculate stock value based on the value of future dividend cash flow in 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, the 61st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock based on the present value of a future dividend cash flow.