# 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: Minimize the sum of squared error for a regression line in statistics

Learn how to minimize the sum of squared error for regression line problems in stats. Whether you need help studying for that next big stats text or just a hand finishing your homework, you're sure to be well served by this four-part free video math lesson from Salman Khan.

### 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: Make Chinese Dim Sum pork balls with Kai

Chinese Dim Sum pork balls are an elegant dish and easy to make. You will need pork, shrimp, sugar, salt, pepper, soy sauce, oyster sauce, sesame oil, and cornstarch. Watch this video cooking tutorial and learn how to prepare Chinese Dim Sum pork balls with Thai chef Kai.

### 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: Use the Gauss Method to find triangular numbers

The first video is an elementary explanation of triangular numbers and a Gauss demonstration for the sum of the first 100 natural numbers.

### 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: Round only the total column with SUM & ROUND in 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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.

### How To: Sum only certain columns 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 297th installment in their series of digital spreadsheet magic tricks, you'll learn how to select varying columns for summing (adding).

### How To: Make fun green slime with borax and Elmer's Glue

The only thing slimier than Charlie Sheen's latest sex scandal is this super sticky and icky green slime, made with borax and some Elmer's Glue. Gain the sticky molasses of experience by checking out this science tutorial on how to whip up a batch of green goo.

### 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 dollar amounts from a column in Micrsoft 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 553rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CELL and SUMIF functions to sum Dollar and Euro amounts from a column.

### 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: Conditionally sum from varying columns in MS 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 297.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum from various columns.

### How To: Sum with three criteria by array formula in Excel

New to 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 Excel tutorial from ExcelIsFun, the 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.

### 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: Use the sum and autosum functions in Microsoft Excel

Learn how to use the sum and autosum functions in Microsoft Excel and you'll appreciate the efficiency of spreadsheets for dealing with data lists. You'll never use a calculator again!

### 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: Install Nokia's Ovi Suite on a Microsoft Windows PC

Learn how to install Ovi Suite on your PC. 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: Take photos with the Nokia C5-03's built-in digital camera

Learn how to take photos with the C5's camera. 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: Create a new email account on a Nokia C5-03 mobile phone

Learn how to set up your email account in the device. 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: Use the Ovi Contacts app on a Nokia C5 cell phone

Learn how to use Ovi Contacts on your C5! 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: 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: Save favorite destinations when using Ovi Maps on a Nokia C5

Learn how to find different places with Ovi Maps and save your favourite places. 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: Plan a trip with your PC when using a Nokia C5 mobile phone

In this clip, we learn how to create Ovi Maps routes with your PC when using a Nokia C5 mobile. 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: Synchronize Ovi Maps with a computer on a Nokia C5 mobile phone

In this clip, we learn how to synch routes when using a Nokia C5. 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.