Sizeable Sums Search Results

How To: Add numbers with SUM and AutoSUM in MS Excel 2010

Learn how to add numbers using the SUM and AutoSUM functions within Microsoft Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the SUM and AutoSUM functions in your own Excel projects, watch this free video guide.

How To: Turn multiplication into sum

This is a handy math trick that show you how to turn a multiplication problem into a sum problem. An unusual way to perform a multiplication. You only need to be able to sum, halve and double numbers. It is not efficient, but it is rather intriguing and fun.

How To: Factor the sum and difference of cubes

Need to know how to factor the sum or difference of two cubes? Learn how with this free video algebra lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test).

How To: Quickly insert formulas in Excel

Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...

How To: Cook shu mai Chinese dim sum with Kai

If the ornate dim sum ceremony scares you, try making the delicious food at home. This recipe shows how to make this traditional Chinese dish. You will need pork , shrimp, wonton wrappers, salt, sugar, pepper, soy sauce, sesame oil, cornstarch, and cooking oil. Watch this video cooking tutorial and learn how to make shu mai Chinese dim sum from Thai chef Kai.

How To: Find the interior angle sum of a polygon

In this tutorial the instructor shows a method to compute the interior angle sum of a polygon. He gives us the formula for the interior angle sum of a convex polygon as (n-2) * 180 where n is the number of sides of the polygon. He goes and take a 6 sided polygon as an example and does the math by substituting the value of 'n' in the equation and arrives at the result. This video clearly gives the formula and demonstrates with an example of how to calculate the sum of interior angles of a poly...

How To: Find the diagonal sum in Excel

In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...

How To: Find the sum of reciprocals of complex numbers

In this tutorial the instructor shows how to calculate the sum of reciprocals of complex numbers. If you have to find out the sum of the reciprocals of two complex numbers first you will have to find out the least common multiple of the denominators. To do this multiply the numerator and denominator of the first fraction by the second complex number. Similarly multiply the numerator and denominator of the second fraction by the first complex number. Now you will have two fractions whose denom...

How To: Play "Pieces" by Sum 41 on acoustic guitar

If you want to learn how to play Sum 41 on the guitar then this how to video is the place to start. With this tutorial you can learn how to play "Pieces" by Sum 41 on the acoustic guitar. "Pieces" uses the chords D5, Bb5 (=A#5), F5, and C5. This lesson is geared towards intermediate guitarists because it assumes prior knowledge of guitar playing. Watch this how to video and you will be able to sing and play guitar to "Pieces" by Sum 41.

How To: Play "Some Say" by Sum 41

If you want to learn how to play Sum 41 on the guitar then this how to video is the place to start. With this tutorial you can learn how to play "Some Say" by Sum 41 on the acoustic guitar. The chords for "Some Say" are Bm, D, Em, G, and A. This lesson is geared towards intermediate guitarists because it assumes prior knowledge of guitar playing. Watch this how to video and you will be able to sing and play guitar to "Some Say" by Sum 41.

How To: Find the sum of an infinite geometric series

Need some help finding the sum of an infinite geometric series? See how it's done with this free geometer's guide. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Find the sum of consecutive odd integers in math

Need some help figuring out the sum of a string of consecutive odd integers? See how it's done with this free video math lesson. Need help finding the From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar...

How To: Sum a table of data by year & month in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions in an array formula.

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: Sum every nth value in Excel with SUMPRODUCT

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 466th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM every nth value using SUMPRODUCT, MOD and ROW functions.

How To: Use geometric sum to figure out mortgage payments

This video walks you through the steps of using geometric series sum to figure out mortgage payments. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.

How To: Understand compound & continuous interest

In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...

How To: Use conditional summing 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 9th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see three examples using the SUMIF function to do conditional summing.

How To: Use Excel's built-in SUM, MOD, LCM & PRODUCT functions

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 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.

How To: Use Excel date math & time formatting

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.

How To: Round to estimate sums in basic math

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to use rounding to estimate sums.

How To: Use the Nokia C5's Share Online feature

Share media with your friends, family and colleagues! The C5 is the first offering in Nokia's new "C" series of mobile phones. It runs on Nokia's Symbian OS and features a 2.2-inch screen and 3.2-megapixel camera. Want more? Search WonderHowTo's sizable collection of C5 video tutorials.

How To: Download additional maps on a Nokia C5 mobile phone

In this clip, we learn how to download additional Ovi Maps-compatible maps when using a Nokia C5 mobile phone. The C5 is the first offering in Nokia's new "C" series of mobile phones. It runs on Nokia's Symbian OS and features a 2.2-inch screen and 3.2-megapixel camera. Want more? Search WonderHowTo's sizable collection of C5 video tutorials.

Prev Page