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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
In this Computers & Programming video tutorial you will learn how to hide and lock folders in Windows. When you want a private folder that you don’t want any one else to open and see. You will need this feature. For this open a new folder. Open the folder, right click on it and go to ‘customize’. Then select ‘change icon, click on a blank icon, click OK and ‘apply. Now you will see that your folder icon on the desk top will disappear; only the name will be visible. Now rename it with a small ...
Activate/Use iPhone 3G and 3GS with Go Phone Prepaid SIM Card:1. Eject the SIM tray using a pointy (thin) object.2. Firmly, insert the Gophone SIM card to the SIM tray (which got ejected from the iPhone).3. Insert the SIM tray along with SIM card into the iPhone.4. You will be able to notice that a new symbol pops up in the iPhone (which symbolizes SIM Card inserted).5. Create and send a new message to your Secondary mobile.6. You will be able to observe that, your other (Secondary) mobile ge...
Chainmail is a classic accessory. It is a symbol of strength, royalty and the famous uniform of a knight. This two part tutorial will show in depth how to make the 4 in 1 pattern. This is the first basic pattern in chainmail, but with practice you will soon be maikng 6 in 1 and 8 in 1.
In this video the tutor demonstrates the magnifier tool of Microsoft Windows 7. If the size of text is very small on your screen and you are facing difficulty reading it you can use the magnifier tool to resize the text to read it clearly. You can change the resolution but this makes the LCD screen look blurry. So to do this go to the Start Menu and select the Magnifier tool. Now there are two buttons with minus and plus symbol on them. Click the plus button to magnify the screen around that ...
Here in this video we are about to see how windshield wiper fluid is being changed. Open the car and look for the symbol which is on the cap of the reservoir. Remove the cap. Now pour the wiper fluid into the reservoir. The wiper fluid used varies from deicer to detergent. People tend to use the water which might turn bad once the temperature drops below a certain degree. So the water freezes ultimately the system stops making it a useless one. So the fluid is filled till it reaches the top o...
Its a bit of a manual process but Neal walks us through it pretty well. First copy the tweet you want tweeted, than click the reply button, than before the @ symbol type "RT " for Retweet, and than leave a space after the user name and then paste the tweet after the user name. After this all you have to do is update in order to send the Retweet out into your feed. You have to make sure not to go over the amount of characters allowed in the Retweet.
This educational math video describes the steps necessary to solve an equation involving absolute values. "Absolute value" refers to the magnitude of a quantity and is always expressed as a positive number. You can think of absolute value as the distance a number would be from zero if plotted on a number line. Positive 17 and negative 17 both have the same absolute value because both are 17 units from zero on a number line. Because of this, all absolute value problems have two answers, one wh...
This is a video walkthrough of Salamun Bridge in Killzone 2. This includes cheats, glitches and quick play strategies. This game is an FPS.
The Charleston was a dance invented in the 1920's in Charleston, North Carolina. Although the Lindy Hop developed from this popular swing dance, today the Charleston is an important dance in Lindy Hop dance culture.
Invented in 1896 at the Waldorf-Astoria hotel in New York City, this is America's most famous fruit salad. One taste of this crunchy, juicy, sweet, and tangy salad, and you'll know why it's such a favorite.
A puzzle origami invented by Piet Hein and diagrammed by Sebastian M. Kirsch. It’s a fun toy to kill time, and takes about 10 minutes to assemble. It’s composed of 7 different pieces made out of strips that look like those in Tetris. You can also make 6 pieces which would make it easier to assemble.
This neat little trick was invented by my wife after watching me core apples one day. You could adapt it for a number of other things as well.
This clip will teach you everything you'll need to know to draw the dreaded Connection Interrupted symbol in the Call of Duty: Black Ops Emblem Editor.
In this clip, you'll learn how to recreate the iconic high-voltage hazard sign as your Call of Duty: Black Ops playercard emblem. Learn how to create a electrocution risk symbol in the Black Ops Emblem Editor!
In this clip, you'll learn how to recreate the iconic radioactive hazard sign as your Call of Duty: Black Ops playercard emblem. Learn how to create a radiation symbol in the Black Ops Emblem Editor!
This clip will teach you everything you'll need to know to make a custom, graffiti-style anarchy symbol playercard emblem in the Call of Duty: Black Ops Emblem Editor.
Learn how to draw and use a yin-yang as your playercard emblem with the Call of Duty: Black Ops Emblem Editor!
Radical expressions are those in which the radical symbol (under root sign denoting the square root or the nth root) is present (either multiplied or added). Solving these is a bit tricky, but involves similar algebraic maneuvers in a different way.
In this video, we learn how to write and say "I love you" in Mandarin Chinese. Start out by saying "wuh" then "I" and then, "knee". Say each of the different parts individually at first. Then, say all of them together in one entire word. From here, you will have said "I love you" in Chinese! To write this, follow the writing that is on the screen and learn how to write out the different symbols that are included in this language. Once you understand this, you can start to learn more basic con...
In order to use PowerPoint to create your resume, you will need to select "page setup", in order to change from landscape to portrait. Insert a text box in the center of the page and type your name in it. Next, click on the "format" tab. Next, select your alignment from the alignment center.
In this video tutorial, viewers learn how to draw the black Spider-man in Adobe Photo-shop. Begin by drawing the shape of Spider-man and then scan it. Now extract the ink from the white page. Then change the ink from black to white. Make the background black. Then fill the entire figure of the character in black color, using the pencil tool. Now create a blue layer over the entire image. Add white to the eyes and center spider symbol. Finish by adding details and a spider web in the backgroun...
This next tutorial takes place in the hit game, Transformers: War for Cybertron. The achievement is called Grimlock Smash! and it requires you to find and destroy all 25 Decepticon symbols throughout the Autobot campaign.
Doves are peaceful symbols of the spiritual rebirth that Easter centers itself on, and are springtime animals that herald the coming of a new season. Celebrate these cute springtime birds by crafting an origami dove.
In algebra, "order of operations" essentially means solving first for exponents or roots, then multiplication, division, addition and subtraction. The steps for the order of operations also require attention to mathematical grouping symbols, such as parentheses and brackets. 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 footst...
iPhones aren't perfect. They can have problems just like every other electronic mobile device. One thing that happens frequently with iPhones is freezing. If you're iPhone becomes frozen, how do you fix it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to safely reset a frozen Apple iPhone.
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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).
Some people believe that it is disrespectful to fold your American flag the wrong way. In this tutorial, avoid any confusion and learn how to properly fold your flag for storage or display.
This how-to video shows you how to use the text substitution feature in Mac OSX. This will make it easier for you to type symbols and fractions. It can also be used to create shortcuts for texts that you use on a regular basis. Go to apple and system preferences. Click language and text and select the text tab. You will see some substitutions already created. To add a substitution, click add and type the text you want to replace. Press tab to add the text you want to replace it with. Save thi...
When you tag someone in your Facebook status, you can show everyone activities you are doing together! This is incredibly simply, simply type the @ symbol when writing your status. Your Facebook account will immediately prompt you; showing you different people on your friend's list. It will also ask if you want to tag groups or events in your status. As you keep typing the name, simply select the friend, group or event you wish to tag. Now, your status update has a link to this person, group ...
Tut Teacher shows that if you're going to edit alot of pictures, learning to change your eye color in Photoshop is helpful.Go to Photoshop and open "human eye", zoom in and it gives more room to work with. First, go to your lasso tool, hold down and click. You can click and drag or click along the outside edge. Set to 6 pixels, more or less depending on the image. Make sure you don't click on scanner..it'll make the image go crazy. Keep clicking along the edge there'll be a symbol on the circ...
The tank man tango is a dance choreographed to commemorate the massacre at Tiananment Square. All you need to do it is a couple of bags and your dance skills. Let the instructions in this video do the rest for you.
This video shows the method on how to Retweet web sites using Twitter. The website used on this video is Dream Systems Media. First, choose an interesting topic to tweet. Highlight and copy the entire tweet. Second, using either of the following codes: RT, rt, R/T or retweet, and the ‘@’ symbol; paste the tweet previously copied. Check if the tweet contains the name of the site and the URL. Third, place your comment inside the parenthesis following the tweet. Last, click the update button and...
In this how-to video, you will learn how to create a lucky charm. It is a symbol of good luck among the Irish. You will need a baking sheet, green polymer clay, a paper clip, pencil, and a key ring. Roll three one inch balls from the clay. Shape them into the clover leaves. Next, put them on a baking sheet and stick the pointed ends together. Set a paper clip in the center and flatten a piece of clay to seal the paper clip in. Draw lines in the center of the leaves with the pencil. Bake it ac...
This is a video montage of Facebook emoticons while Metallica plays loudly. The website Facebokemoticons presents Facebook shapes, symbols, smileys, and emoticons that are available for download off their website for free. They demonstrate the various keystrokes for smile , wink, tongue, curly lips, kiss, grumpy, glasses, sunglasses, upset, confused, shark, gasp, Pac-man, squint, devil, unsure, frown, cry, Chris Putnam, robot, heart, angel, Kiki, and penguin. Then, they show a close-up of eve...
The video below describes how to enable the battery percentage on iPhone 3GS, which will show up right next to the battery icon in the status bar up top.
In this video the instructor shows how to do temperature conversions using y = m*x + b. Now if Celsius is represented by the variable C and Fahrenheit is represented by the symbol F, you can replace then in the previous equation in place of the variables x and y giving you the equation C = m*F + b. Now to solve for the values of the constants m and b you need to have values of two sample temperatures in both Celsius and Fahrenheit. Take the first sample and substitute in the above equation gi...
In this tutorial the instructor shows how to solve percent equations. The general form of a percent equations is that a is b% of c. As there can be three kinds of variables a, b, c, the questions involving percent equations can be of three types having one of the three variables unknown. These kind of percent statements can be solved easily by setting up an equation. So, to convert percent statement into a equation replace the unknown term with n, the 'is' term with equals sign and the '%' si...