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 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
In this how to video, you will learn how to crack a WPA encrypted wireless network. To do this, you will need the Air Crack package for Linux. First, disable the wireless adapter and enable monitor mode. Next, identify the channel in the wireless network and Mac address. Once you have this, you can listen to the traffic coming to and from this point. Wait for the handshake or disconnect something in order to force it to reconnect. From here, you are ready to perform the attack. With any encry...
This is a video tutorial that is showing its audience how to set up your own VPN client on your Mac computer. The first step in setting up a VPN client is to go to your system preferences on your computer. Next select network and then select the plus button and type in that you will be making a VPN network. Next you should select the type PPTP and enter your server name. Then you can click on create and it will create a new network for you. Next you should enter your service address and your ...
This video shows you the method to find if someone else is using your Internet connection. There are two methods for this. The first method involves opening the start menu and click on 'Run'. Type cmd in the text box which opens as a result of clicking on 'Run'. Type NET VIEW at the command prompt. This will show all people using your network. The second method involves going to Start menu. Go to Connect to and Show all connections. Click on My network places. Click on 'View workgroup compute...
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
In this video tutorial, viewers learn how to connect an Xbox360 with wireless internet. Begin by connecting your computer to a wireless network. Click on the Start menu and select Control Panel. Go to Network and Internet, and select Network and Sharing Center. Under Tasks, click on Manage network connections and select your wireless connection. Right-click on the connection and select Properties. Go to the Sharing tab and check both the sharing options. Now click OK. This video will benefit ...
Parallelogram is a quadrilateral in which both pairs of the opposites are parallel. To find the area of a parallelogram first draw the diagram of a parallelogram. Parallelogram can be further divided into squares and rectangles. To calculate the area of both of these kinds of parallelograms multiply the length of the parallelogram with its height. In general the area of a parallelogram in obtained by multiplying the base of a parallelogram with its altitude. In square and rectangle cases, the...
This video demonstrates how to make a catapult out of popsicle sticks. For this project, you will need the following: 7” rubber bands, a box of popsicle sticks, a hot glue gun, a Dixie cup, and tape.
This wordless video shows how to draw a staircase in 3d. Start by drawing the steps in one dimension. Extend two lines at the top of the stairs the width you want the steps to be. Draw another line between them to make a square. This creates a landing. Draw two lines downward and parallel to the steps from the line at the top of the stairs. This will create a rail and a second base. Then extend lines from each jut of the one dimensional steps, stretching the lines alternately to the base and ...
This is a short, very fast paced (6x normal speed) demonstration of how to arrange a floral and green head table piece. The 54 seconds shows the designer how to complete an arrangement from beginning to end. It is difficult to see what the shape of the base is, but it is fresh flowers going into the design. The designer places long greens into the center of the base, adding some long white stemmed flowers. Red carnation heads are then placed around the base along with some additional greenery...
A video to help calculator users find the natural logarithm (log base e, or "ln") and standard logarithm (log base 10, or simply "log") of any number using a TI-83 calculator (works for any issue of the TI-83 calculator or even a TI-84 calculator). Turn on your calculator. To find the natural log of a number, press the "ln" button (the third button from the bottom left), enter the number you want to find the natural log of, press the ")" (closed parenthesis) button, then press enter. The same...
If you're designing a website but are uncomfortable slicing your interface up and reassembling it with CSS, or if you'd like to add easter-egg content to your site, then an image map might be a good option. And with Dreamweaver, the process is simple.
This video shows you how to easily find the area of a parallelogram and the area of a triangle. The first part of the video teaches you how to find the area of a paralellogram. The area of a parallelogram is BxH, where B is the base and H is the height. The height is obtained by drawing a perpendicular line from one corner to the base. The second part of the video teaches you how to find the area of a triangle. The area of a triangle is (BxH)/2, where B is the base and H is the height. That's...
In this video the instructor shows how to solve logarithmic equations. To solve a logarithmic equation, the first thing you have to do is try to get one logarithmic term if possible. To subtract two logarithmic terms use the formula Log (a) – Log (b) = Log (a/b). Now to get rid of logs, perform exponentiation of the base. Exponentiation of the base is raising a number to the power of the logarithmic term where the number is the base of the logarithmic term. Here the value turns out to be the ...
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Julie teaches the secrets of creating tiger print nails inspired by Rihanna. You will need: a base coat, top coat, nail polish of gold, black and copper colors. First apply a base coat of your choice to the nails and let it dry. Now apply a gold color nail polish on the base coat. Use a copper color nail polish and fill in the tip of your nails as shown. Now use a black color nail polish to draw the tiger stripes. Start drawing a triangle and end up with a line in crooked directions to get ti...
In this tutorial the author shows how to draw a rectangle with given base b and height h values. First she uses a ruler to draw a horizontal base line of b cm. Now she uses a protractor and marks a 90 degree angle at one end of the line, then draws a straight line of h cm which is the height of the rectangle. Now she finishes the remaining part of the rectangle by drawing similar lines of the other sides. This video clearly explains how to draw a rectangle given the values of its base and hei...
Want to access files from multiple computers at work or home? An expert from PC Remedies explains how to set up a Home Group network on Windows 7 systems. Includes a how-to of setting up your location, and managing the set-up wizard. Finally maximize your current resources by networking your work and entertainment files, as well as hardware such as printers. The excellent video gives you an exact snapshot of what you can expect to see on your own Windows 7 system. Includes advice on setting u...
Check out this video to learn how to get MMS on iPhone 3G for T-Mobile on 3.0 firmware. This works on T-Mobile's Network only!
This video tutorial shows how to get MMS on iPhone 3G for Tmobile on 3.0 or 3.0.1. Not that this works on T-Mobile's Network ONLY
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to obscure your OS fingerprint.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to map networks with Spiceworks.
GetConnected host Mike Agerbo talks to Jamie Brigden about installing the Mac OS X operating system on a Windows-based Dell Mini 9 Netbook. The Dell Inspiron Mini 9 Laptop Netbook is a hot item these days with its portability, so why do Apple users have to be left out to dry?
This is a walkthrough of Halo Wars so you can beat it before your friends do. This is the first chapter of Halo Wars for XBOX 360. Check it out, a cheat walkthrough from Mahalo Gaming.
After finishing up your paint job, you're going to want to clean the paint of your brushes and rollers to save money on replacement. Depending on the paint you used, either oil-based or water-based, you're going to need either water or turpentine to clean off the paint. Watch this video home improvement tutorial and learn how to clean paint off of paint brushes and rollers.
In this clip, we're going to be talking about how to massage away a headache. There are certain different types of headache. So after you've asked your body where the headache is specifically, if it's on the left side or on the right side, if its starting from the base of the neck, maybe even the shoulders, then that way it will gear you to where you need to be a little bit more specifically. Try massage for headache relief. Learn to treat headaches with massage in this health how-to video.
Humus is healthy and vegetarian and is mostly eaten as an appetizer. This cooking how to video tutorial shows you how to prepare a simple base recipe for hummus. Serve it as a snack, for dinner, with pita bread or other breads.
Backstreet Boys Black and Blue album cover is the inspiration for this smoky eyed look. The cosmetic products used to create this makeup effect are a blue eyeshadow base, a blue eyeliner, a blue eye pigment, a blue eyeshadow, a navy eyeshadow, a black eyeshadow base, and a black eyeshadow. Watch this video makeup application tutorial and learn how to do a black and blue Backstreet Boys album cover inspired eye makeup look.
This video shows you how to apply your natural food-based dye, set your dye, and remove your dye. Perfect for an arts and crafts project or a handmade fashion statement!
Watch this cooking tutorial to learn how to make coconut soup which is also know as tom kha gai. For this dish, you can either stir fry your meat or boil the coconut cream first.
Here's a Halo 2 trick for playing multiplayer Capture the Flag. Learn how to get the flag quickly and get blasted out of the base so you get a greater chance of getting it back to your base.
SEO specialist Aaron Wall shares tips on using date based search filters to help you improve your search engine optimization knowledge.
A good stain and varnish can add shine and luster to any piece of wood furniture. Check out these simple steps for staining wood. You will need a painter drop cloth, 2 or 3 1 inch foam brushes, fine grit sandpaper, tack cloth, couple of towels or rags, oil base wood stain and oil base satin varnish.
Watch the lab rats as they breakdown their way of choosing the right mp3 player for you. Maybe its based on flashram or harddrive, the choice is based on your use. These guys explain how they work and what criteria to use to choose the one thats right for you.
So you want to know what that person who is always on their phone is up to? If you're on the same Wi-Fi network, it's as simple as opening Wireshark and configuring a few settings. We'll use the tool to decrypt WPA2 network traffic so we can spy on which applications a phone is running in real time.
Complex shell scripts can be implanted into photo metadata and later used to exploit a MacBook. In addition to obfuscating the true nature of an attack, this technique can be used to evade network firewalls as well as vigilant sysadmins.
Although Niantic is already an augmented reality startup unicorn thanks to the success of Pokémon GO, the company has reportedly captured yet another round of funding.
Now that the iPhone XS is officially available for pre-order, Verizon and Apple are giving Snapchat users the opportunity to win the device through an augmented reality scavenger hunt rather than forking over $1,000 for one.
