# Summing

### 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 ...more

### How To : Kali Is Your New Pet; The Ultimate Guide About Kali Linux Portability.

Did you know Kali 1.0.8? You probably did, and you probably know about the EFI boot option that has been added. That's a very interesting new feature because it allows Kali to be easily booted on Mac too, and every EFI-supported device. First three preview lines gone? As alw ...more

### 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 ...more

### How To : Write a logarithm as a sum or difference of logarithms

This video shows the method to write a logarithm as a sum or difference of logarithms. The square root of the term given is taken out as half according to the rule. Then the numerator and denominator is divided into product of factors. This is broken into the difference of num ...more

### How To : Write a sum/difference of logarithms as a logarithm

To write the sum or difference of logarithms as a single logarithm, you will need to learn a few rules. The rules are ln AB = ln A + ln B. This is the addition rule. The multiplication rule of logarithm states that ln A/b = ln A - ln B. The third rule of logarithms that deals ...more

### 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 ...more

### 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 ...more

### Advanced Exploitation : How to Find & Write a Buffer Overflow Exploit for a Network Service

While our time with the Protostar VM from Exploit Exercises was lovely, we must move on to bigger things and harder challenges. Exploit Exercises' Fusion VM offers some more challenging binary exploitation levels for us to tackle. The biggest change is that these levels are al ...more

### 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 i ...more

### 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. Pa ...more

### How To : Multiply & sum arrays with Excel's SUMPRODUCT

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 37th installment in his "Highline Exce ...more

### 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, clic ...more

### 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 : 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 ...more

### How To : Calculate sums in standard form

When a number is expressed in the form of x multiplied by 10^y such that, x < 10 and y is an integer, the number is said to be in standard form. Standard form of expressing numbers finds its use in scientific and statistical fields. This video demostrates how to express, as we ...more

### 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 vide ...more

### How To : Sum the elements of an array for Java programming

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBostonian will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to how to ...more

### 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 Chinese Dim Sum black bean ribs with Kai

Watch this cooking video tutorial so you can learn to make Chinese black bean ribs. You can find this dish in Chinese Dim sum restaurants everywhere. You will need spare ribs, salt, sugar, cornstarch, garlic, black beans, soy sauce, sesame oil, and oyster sauce.

### How To : Sum the 3 largest or smallest values in a set in Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel array formula seri ...more

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

Learn how to play "Pieces" by Sum 41, an acoustic guitar tutorial. Follow along with this demonstration, lyrics here: I tried to be perfect But nothing was worth it I don’t believe it makes me real I thought it’d be easy But no one believes me I meant all the things I said I ...more

### 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 Cla ...more

### 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 belong ...more

### 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 nu ...more

### How To : Spike your hair like Sum 41

If you want to spike you hair like Sum 41. You should get some Got 2 B hair gel. First, you need to make sure your hair is dry before you sure you use the gel. Next, put a handful of the gel in your hands and slick the gel through your hair. Make sure you spread the gel around ...more

### 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 o ...more

### How To : Sum lookup items 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 320th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

### 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 th ...more

### 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 Int ...more

### How To : Sum & count with array formulas in Microsoft Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula seri ...more

### How To : Make dumpling dim sum

This cooking demonstration shows you how to make dumpling dim sum. To prepare this dish you need ground pork, beef, chicken or mixed seafood, garlic salt, sesame oil, sugar, hoisin or oyster sauce, egg, black pepper and shredded vegetables. First put the ground pork into a cer ...more

### 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 : 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 interm ...more

### 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 thi ...more

### How To : Reversing and Analyzing a Runtime Crypter

What's up guys? Welcome to a sort of general walkthrough on how one might approach a reversing and analysis on a crypted malware. This is by no means a universal technique so don't assume that this will occur in every scenario, it's more of a demonstration than anything really ...more

### 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 eve ...more

### How To : Sum only certain items in Microsoft Excel with SUMIF

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 13th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

### 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 interm ...more

### 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 ...more

### 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 condi ...more

### 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 rev ...more

### How To : Sum year-over-year sales from daily data 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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to build a ...more

### How To : Sum year over year sales using MS Excel's 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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

### 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 ...more

### 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 sup ...more

### How To : Use the beauty of dim sum eating

Robert Kowalski on why the Chinese practice of dim sum - eating small bits at a time - is beneficial for heart health.

### News : Reflection Challenge:SUN tri sum shot with my lg cookie

just clubbed my three shots:no editng other than that by using the orange the sun is created by me and the reflection of it as a red tennis ball can be seen in my Acer lcd screen(made by focussing red light on the orange nad two polo pills placing on it to create the tennis b ...more

### How To : Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM onl ...more

### How To : Carry numbers when adding in basic arithmetic

Need to know how to carry numbers when adding in basic mathematics? Learn how. 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 ...more

### How To : Sum and average statistical data within 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

### How To : Sum the values from many cells to a single Excel cell

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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

### How to Hack Wi-Fi : Get Anyone's Wi-Fi Password Without Cracking Using Wifiphisher

Welcome back, my tenderfoot hackers! Do you need to get a Wi-Fi password but don't have the time to crack it? In previous tutorials, I have shown how to crack WEP, WPA2, and WPS, but some people have complained that cracking WPA2 takes too long and that not all access points ...more

### How To : Create Beautiful, Aesthetic Houses in Minecraft - Part 1

Aesthetic Houses: What are they? If you've played Minecraft for some time now, you most surely know how hard it is to build a great looking house to live in, that meets both your vision of your dream house and expectations for functionality. This brings us to the definition: ...more

### How To : Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more

### Hack Like a Pro : Hacking Samba on Ubuntu and Installing the Meterpreter

Hey, hackers! Now that you've hacked/owned your first "box" in my last article, let's look a little closer at another great feature of Metasploit, the Meterpreter, and then let’s move on to hacking a Linux system and using the Meterpreter to control and own it. Why Meterprete ...more

### How To : Create Concentric Circles, Ellipses, Cardioids & More Using Straight Lines & Circles

Using only a circle and straight lines, it's possible to create various aesthetic curves that combine both art and mathematics. The geometry behind the concentric circle, ellipse, and cardioid dates back centuries and is easily found in the world around us. From an archery tar ...more

### How To : Hate Math? These Mental Tricks Will Have You Multiplying Faster Than Einstein Ever Could!

2 + 2 = 4. That's about as much math as I can handle without a calculator on a daily basis. I literally hate doing math more than anything in life, mostly because I'm not good at it—and I hate doing things I'm not good at. So, when I come across a cool math trick online that ...more

### How To : Find the Percent Given Two Numbers

Whether you're shopping for deals, need help with a little math, or any number of other occasions, it's a valuable skill to know how to quickly figure out a percentage given two numbers. Let's say you're shopping and you come across a pair of shoes that are normally \$45, but ...more

### The Fastest Way to the Top : How to Build a Redstone Elevator in Minecraft

Welcome to Minecraft World! Check out our tutorials, post to the community corkboard, and come play on our free server! The workshop this past Saturday was focused around making a Redstone Elevator, and everyone joined in and made their own versions—all very cool and creative ...more

### How To : How & Why You Should Make Your Own Protein Powder

Protein powder is a fad in the same way that Justin Bieber's music is: you either love it, or you hate it. Everyone I know has a strong opinion about protein powder, ranging from "daily necessity" to "utterly useless." The funny thing about protein powder is that these opinio ...more

Prev Page

• Hot
• Latest