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.
Nick from Greyscale Gorilla demonstrates how to create a very simple spinning logo animation. Using Cinema 4D, Mograph, and Random Effecter, Nick combines different textures and camera angles for a rich, slick finished product.
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.
Sure, there's six steps, by why are there eight videos? Well, why don't you just keep reading, or watching?
These are assembly instructions for a simple Knex gun with trigger
Sometimes simple is the best way to do it, and what is simpler than green beans? Well, they aren't THAT simple, but the concept is easy to grasp. Green beans can make a fantastic side dish to any meal if you know how to cook them right. In this video, chef Jason Hill introduces you to a simple, but delicious green bean recipe with garlic and shallots.
Want to turn on Mac OS X's simple Finder feature? It's easy! So easy, in fact, that this Apple accessibility guide can present a complete walkthrough of the process in just over a minute and a half. For details, as well as to get started enabling the Simple Finder interface yourself, watch this helpful how-to.
Golden girl Jennifer Aniston never skips a fashion beat on the red carpet (maybe because she 9 times out of 10 wears black, which we know is never not flattering?), but when she stepped foot onto the red carpet last year at an event, she once again started a "Rachel" hair trend.
MatttChapman shows you how to add a simple dutch tilt to your filmmaking bag of tricks. Tripods conventionally only pan and tilt, but this trick adds an extra dimension. All you need is a tripod and a camera! It's just a matter of messing with the base plate to get this simple dutch angle.
Need a little help with your new Adobe Photoshop graphics editing program? Working with Photoshop can be a bit tough if you don't know what you're doing, so instead of getting out the books, check out this 'no nonsense' video tutorial to learn how to create a simple folder in Adobe Photoshop. Photo manipulating and editing is always tricky, so just watch to see how to create a simple folder, for beginners.
See how to make a simple laser communicator with KipKay and MAKE Magazine! Find out how to secretly shoot your voice across the room in stealth mode on the beam of a laser! Kipkay loves his lasers! A simple laser communication device is the perfect way to talk across the room.
Simple Syrup is used in many drinks as a sweetner and is incredibly easy to make. Ingredients: 1 glass sugar
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...
If you're constantly writing money amounts using rupees, which is the basic monetary unit India, Pakistan, Nepal, Seychelles, and other South Asian and East African countries, then you'll be relieve to know that there is a font you can use to create the rupee symbol in any word processor on your computer.
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.
Forex— what is it? Any investor could tell you a complicated description of what Forex is, but the basics of the FX currency markets is— an over-the-counter financial market for trading currencies. The foreign currency exchange market has no central exchanges like the stock market and little regulatory oversight. With this beginner’s guide, learn the trading basics.
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...
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.
