How To: Multiply column times row with Transpose in MS Excel
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
This video tutorial from SoldierKnowsBest presents how to install Snow Leopard operating system on your Mac computer.
This video demonstrates how to stain a white sheet of paper and make it look antique. You'll need two tea bags (an extra one if the other tears open. Place the paper to be stain on a tissue or newspaper to avoid a mess. Take half a tumbler of hot water and dip a tea bag until the color becomes dark orange. Take out the tea bag and gently wipe all over the sheet of paper and also dab gently on the applied parts for a darker stain in some regions to look natural. Repeat this process by turning ...
This video takes us through a process of speeding up our internet connection using OpenDNS.com. Open the webpage and go to solutions and click on the icon open the DNS page and it lists computer or router, she selects computer and list of operating system is listed, she selects vista. She goes to start and selects control panel, click on view network status and connection, in that select view status and then click on properties and on the networking page, go to internet protocol version 4 and...
In this Lynda video tutorial, learn how to use FileMaker Pro 10 software to create databases with pre-made templates. FileMaker offers these templates in a package called Starter Solutions. To access these options, click open FileMaker. Then, go to New Database under the File menu. Click the option "Create a database using a Starter Solution." The templates are grouped according to the nature of their use. Some are for the home, while some are for business. All you do is open the template you...
This video tutorial instructs you on what a key logger is and how to make a key logger which records your computers key strokes for later review. There are software or hardware based key loggers that intercept the connection between the keyboard and computer. Hardware key loggers consists of a micro controller for data logging. Software key logger is a script that runs in the background then processes and saves the key strokes to a text file. To make a key logger you'll need to know a program...
Running out of costume ideas for your next Halloween? How about a tutu-clad ballerina, french maid, pirate or fairy? Or if you're brave enough, why not wear a tutu to the supermarket? ThreadBanger shows us how to make a tutu out of an old petticoat, some tool, and ribbon... This project takes a while to complete, but once done, you'll be the bell of the Halloween ball! And isn't that worth any amount of sewing?
ThreadBanger pays homage to the movie "Fame" by showing us how to make the perfect "80's-tastic" duffel bag out of old umbrellas. With this thrifty idea, you will need a few umbrellas (broken is fine), scissors, a square pattern, a sewing machine, a zipper, and anything handy that will work as a strap. Use your new custom duffel bag to carry all your leotards or dance shoes in, or make a statement on your way to the video store to rent "FAME!"
ThreadBanger's Decor It Yourself show us how to "do it yourself" when making a wine rack using just scrap wood and old belts. At a great size, it's easy to store and great to give as a gift. Looking to fill that wine rack and don't know where to begin? In the later half of this video, the gals from ThreadBanger take us wine tasting and give advice for your next wine shopping excursion.
New to Windows? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to protect Windows from viruses without an antivirus software.
If you've ever wanted to learn how-to transform yourself into a skunk here's the perfect opportunity. In this 2 part special, Infinity Circus shows us how-to make a skunk hoodie. Not a hoodie out of a skunk, not a hoodie for a skunk, but a hoodie that makes you look like a skunk.
Need a pinata for Cinco De Mayo or special occasion? This week Meg of Decor It Yourself shows you how with some simple house hold materials. Piñatas are a fun Mexican tradition, and are as easy to make as any paper mache project. Check out this how-to video to get ready for your next fiesta!
A customized body form will allow your sewing projects to fit you perfectly. Need a body form but dont have the cash for one? Well this video episode of Threadbanger Projects shows you how to make a replica of yourself using your old scraps,some packaging tape and an old christmas tree.You'll have to see it to believe it!
This video tutorial series shows you how to use the Yahoo Maps AS3 API in Adobe Flex 3. This new API gives you the ability to place Yahoo maps directly into Adobe Flex 3. Mike Lively Director of Instructional Design at Northern Kentucky University will be taking you through this tutorial.
If you're new to DreamCoder for MySQL, one of the first things you may want to know how to accomplish is how to import data to a remote MySQL database. Happily, this tutorial will walk you, step by step, through the process. Take a look!
In this screencast, Tubemogul's very own Mark Rotblat explains to us how to export your data on the web.
In this video from faintstarlite we learn how to jailbreak an iPhone 3GS step by step for beginners! Your iTunes needs to be running 3.0 and you must use a windows computer. Plug in your iPhone to your computer. Go to purplera1n.com and download the program. Your iPhone will now reboot and it will load up with the Purple Rain icon. Now click on the Freeze icon and install Cydia which then allows you to download programs on your iPhone. You will need this to download ultrasnow which unlocks yo...
This is a very simply process. Pick any app and press down on it. Soon an X will appear in the upper left hand corner. All Iphones have certain default apps, which cannot be removed. These apps will not get an X. The apps will start vibrating. Decide which apps you want to remove and touch the X. You will get a message saying that the certain app is being deleted, as is all of the apps data. The message will say "delete" or "cancel". Once you hit delete you will get a message, which will ask ...
In this tutorial, we learn how to make a decadent sweet potato pie with Food Network's Dave Lieberman. First, you will need to go to the store and pick out your sweet potatoes fresh from the produce section. Once you have these, you will wrap them in foil and roast them in the oven until they are soft to the touch. After this, you will crush up graham cracker squares and combine with melted butter and brown sugar to create the crust. After pressing this down on the pie tin, you will bake it i...
It's like magic. Creating a .LOG file has never been easier. And all you need is Notepad on your Windows PC. After creating this LOG file, Notepad automatically inserts the current date and time after the last line. Check it out. If you've ever wondered about LOG file types, this Notepad trick is must.
In order to unwrap and object and export it in Blender, you will need to import and object in blender, by go to "file". Click on "import". Click on "wavefront". Then, go to the parent directory. Select the object, by right clicking. Then, go into edit mode via the drop down menu, underneath the object. When your "normals" are visible and facing the right direction.
The My Computer section of most PC computers is an absolute mess, especially if you're trying to navigate someone else's computer. Why not take advantage of this fact by pulling this awesome prank on one of your data-loving friends? The video above will show you how to make a folder invisible and then hide it on their computer, making the chances of them finding it without knowing that you've pranked them slim to none. Just make sure you're there to watch you victim freak out afterwards! That...
Most of the videos that you'll find on the internet from sites like youtube are probably flv format. There is now a handy new tool that you can use to convert those flv files and burn them onto a DVD, it's called Replay Converter. As the start the program up you'll see a button that says 'add file'. Using this you can add files to the program's queue. Put a blank DVD into your DVD burner beforehand. Now with the files in the queue, tick the 'Burn to CD/DVD' option. You will have the option to...
This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
Jordan Patterson the Cheap Geek has made a video showing you the steps to sync your contacts and calendars on three mobile devices together, the iPhone, a laptop running Windows, and a Mac running OS X utilizing a few downloaded programs and Google Calendar. First he shows you how to sync calendars on the Apple computer, by downloading a program from Google code called collaboration code, and then running it. After putting in his g-mail account information, he tells the program which calendar...
This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
This how to video shows you how to change your computer registration on a computer. First, go to the start menu and select my computer. Right click it and choose properties. You will notice a registered to name. This is what we are going to change. First, go to start and select run. Type in Regedit and click okay. This program will open. Go to HKEY_LOCAL_MACHINE and Software. Scroll down and find Microsoft. From there, scroll down and find Windows NT. Open it and select Current Version. On th...
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
This video tutorial shows how to open a port for torrent downloading on your computer. Click Start menu, type cmd command in Search area. In cmd window type ipconfig and press Enter. Remember or write down your IP adress. Type exit and press Enter to close cmd window.
How to sync your iPod to more than one computer
In this how to video, you will learn how to calculate the polygon area in ArcMap. First, open the program ArcMap. Next, go to the left column and right click it. Select attribute table. From here, go to options and click add field. Type in Area and click double. Next, right click area at the top and select calculate geometry. Next, select area disabled. Exit the windows. Next, click the red icon at the top and select data management tools. From here, select project. At the top drop down menu,...
For creating a custom avatar first you need to go to the website FACE YOUR MANGA. There you can find an option named click create to start. Then you click on the create button. Then select male or female. Then you will get a default dude. you can see options like face, nose, eyes, mouth, ears etc on the right side. You can give colours according to your wish. And make whatever changes you want. Once you are done click finish and you will find a pop up box saying that yu are about to download ...
This video tutorial from noxad presents how to backup and burn games for Nintendo Wii game console.To setup game transfer from computer to your console you'll need any type of SD memory card. In this tutorial it's Lexor 1 GB SD card.Insert SD card into your computer card reader. Autoplay window will open, asking what action you want to perform. Select Open folder to view files.You can open SD card manually from My Computer window. (Start button-Computer).Make sure your SD card has folder name...
In this video you will learn how to manually white balance a Nikon camera using the Ba-lens. Paul Franklin explains in a few simple steps. First take the lens cap of the appropriate size and put it on the lens. Then go to the camera and set the meter to spot meter he says its important because it measure the amount of light going through the little dome as he shows. Once you've set it all you need to find the white balance button. Then scroll through the icons until you reach preset. Then hol...
Video demonstrates tutorial of how to hide the logical drive icons in Windows. In the demonstration there is two partitions C and D and also there is a DVD drive, DVD Rom and DVD Writer. Here drives C, D and F from My computer is going to be hidden with help of utility called “No Drives Manager”. If you don’t want your young ones to access some of your important data you can hide it. It will just be hidden. This means if go to the address bar and types the name of the drive you can go to that...
The video describes how to Jailbreak & Unlock your 1st generation iPhone 2G version 3.1.3 and Jail breaking iPhone 3G on version 3.1.3 using Redsnow. The person says that the first and foremost thing to do is to update or restore your iPhone to 3.1.3 version and also remove the SIM from the iPhone. Then you have to download two files from the video description, then launch Redsnow. Then you have to browse the 3.1.2 file that was downloaded already and click on open and then on the next button...
In this beginners video, the instructor shows how to use Word 2007 by opening, closing, and saving documents. When you open the Microsoft Word software with out any documents, the window looks gray indicating the same. There is an office button present in the top left corner of the window through which you can access various options. Click on it, and select the open button which brings up the open dialog box. Now, you can browse through your computer and select any Word document to be opened....
This video shows us how to burn files to a disc using Windows Vista. Insert the blank disc in your computer's recordable disk drive. Autoplay will automatically appear. Choose "Burn Files to disc using Windows". Click next when "Burn a disc" dialog box appears. Empty folder window appears. Choose files that you want to copy and drag them to the window. For example, if you want to copy a photo, click Start menu and open the Pictures folder. Select photos and drag them to the window. Photos are...
This is a step by step tutorial how to Partition & resize your hard drive with EASEUS. To resize hard drive Open EASEUS Partition Manager. Click on the drive you want to resize. Then click Resize/Move. Go to the end and left-click with your mouse dragging in the direction you want to go. In the display you can see the size that's being created. When you have the size drives you want, just stop and click OK. If you shrunk one drive you can now create a new drive using the unallocated space. Th...
Ever hear of SmillaEnlarger? It's a small graphical tool (based on QT) to resize, especially magnify bitmaps in high quality. Check out this video tutorial on how to back up and restore data easily on Ubuntu Linux.