Looking for a guide on how to enter data into nonadjacent cells in MS Excel 2010? This clip will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned professional looking to become better acquainted with the features and functions of Excel 2010, you're sure to benefit from this free video software lesson. Take a look.
Learn how to find a location by entering its coordinates . This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.
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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.
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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter function.
Looking for a primer on how to create and work with arrays 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 very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by 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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks in Microsoft Excel.
In this video tutorial, viewers learn how to hack the flash game, Palisade Guardian 2: Modern Combat with Cheat Engine. Begin the game by entering your name and play the first level. After that, open up Cheat Engine and select your internet in the process list. Change the Value Type to Double and Truncated to Rounded (default). Enter in the value of your cash and press First Scan. Then buy something to lower your cash and enter in your new value. There should be only 1 address. Check the froz...
The video shows users how to change the boot sequence in a computer with an older AMI (American Megatrends, Inc.) BIOS to boot from the CD/DVD drive. This is required, for instance, if you need to reinstall an operating system, or fix a corrupted windows installation by running Windows Setup from the installation CD. Users should first enter the BIOS setup by pressing the delete key when prompted shortly after powering the computer on. Once the Bios Setup screen has loaded, users may navigate...
Welcome back, my budding hackers! In this series, I have been trying to familiarize you with the many features of the world's best framework for exploitation, hacking, and pentesting, Metasploit. There are so many features, and techniques for using those features, that few pentesters/hackers are aware of all of them.
Welcome back, my hacker novitiates! Often, to hack a website, we need to connect to and exploit a particular object within said website. It might be an admin panel or a subdirectory that is vulnerable to attack. The key, of course, is to find these objects, as they may be hidden.
Spotlight, Apple's selection-based search system, received a major facelift on Mac OS X Yosemite. Packed with dozens of new features, such as a central search window and increased app suggestions, the reworked Spotlight was a breath of fresh air.
If your facebook account was hacked by someone and you really want it back this tutorial would help you get it back.
The video shows you how to calculate capital budgeting with a Texas Instruments BA2+ financial calculator. Capital budgeting will help you determine cash flows for given investments for a certain number of years in the future, thus helping you determine if the investment is worthwhile. The buttons you will use are the CF (cashflows) button, the NPV (net present value) button, and the IRR (internal rate of return) button. The video uses the example of a $10,000 investment that will return $5,0...
In this tutorial, we learn how to create and edit tasks in MS Project 2007. Before you begin, you need to set the start date by going into project information and changing the start date and end date. After this, type in your first task name, then enter in the information that goes with it. After you have entered this, press the check mark to set it up. After this, enter in the other task names that you need to specify in your project. When you are finished, you will need to save this onto yo...
In this tutorial, Shawn Powers shows us hot to update ISOs with Zsync. First, download and install this, then type in "i" and enter in the c file. Then, enter the http address where the zsync file lives, and press enter. After this, it will download the file and compare it to your 'c' file. You can also use a desktop CD as a seed and use the change for an alternate CD if you prefer. When finished, exit out of the program and you will be done. This will save you bandwidth and only take a few s...
To open the body of an HTML first open the HTML document, to do so write an open bracket, then html, the close the bracket. Next press enter. Type another open bracket, then type the word body, then type a closed bracket. Next press enter again. Now you can type an open bracket, then a backwards slash. Next type the word body again. Now type a closed bracket. Press enter once again. Now type another open bracket and then type html. Then type a closed bracket. Now you have just opened and clos...
This how-to video is about how to use command prompt to view the blocked websites at school. This step by step instruction will help one to open the blocked websites at school.
This instructional video shows you how to make a RSS ("Really Simple Syndication") feed using the free program RSS builder. RSS is a script that can be put up on a website that other users can subscribe to in order to get notified when the website gets updated. The xml code behind creating RSS feeds is explained. The code should be entered as shown and the file should be saved as "feed.xml" and upload it to a web server. Go to the URL mentioned, download and install RSS builder. Launch the pr...
Welcome back, my novice hackers! Previously in my "Spy on Anyone" series, we used our hacking skills to turn a target's computer system into a bug to record conversations and found and downloaded confidential documents on someone's computer. In this tutorial, I will show you how to spy on somebody's Internet traffic.
If you're a Twitter user, it's a safe bet to assume that you've used a hashtag. On all social networking sites that have the capability, such as Instagram, Facebook, and Google+, the pound (#) symbol is used to mark and designate specific keywords or topics in order to make it effortless for users to connect with one another.
It's good to password-protect your PC to make sure that your personal files, folders, and important documents are safe and can't be modified without your permission. Though, entering the password all of the time before using your computer might frustrate you.
In this video, we learn how to set up a Weebly website. This can be used to build a complete site with multiple pages. First, go to Weebly and enter in your information under the sign up now text. Next, click the sign up button and enter in the Captcha phrase. After this, title your new site and continue on until you see the tabs at the top of the screen. Elements, designs, pages, and settings will all be listed. Go through the designs until you find one you like, then settle on that. Once yo...
If you have trouble emptying your trash on your Mac computer, you will need to launch the Terminal first, in order to begin troubleshooting the issue. The trash will often fail to accept items, if it believes that a program or object is in use. Move the application that you can't delete onto your desktop. Add a line of code to the terminal. Add the application to the code, by dragging it to the code. It will ask for your code. Enter your password. Press enter. You will need to use a Sudo code...
In this tutorial, we learn how to get started out on Twitter. First, you will need to go to the main website and sign up by entering in your personal information. After you do this, you will be asked to enter in your other e-mail addresses to see if your other friends are on Twitter as well. After this, you can change your settings to change the icon that shows up on the site. Next, you will be able to start to follow people and enter in what you want your tweet to say. Go through the differe...
In order to unlink your Google account and your YouTube account, you will need to go to Google. Click on My Product. Then, click on Edit. Next, click on "Close the account and delete and all services linked to the account". Check the box that says YouTube. Scroll down to the password box. Enter your YouTube password. Next check both boxes. Then, click Delete Google Account.
In this tutorial, we learn how to get started on Twitter. First, log onto Twitter, then click on the "join" button towards the bottom. On the next page, enter in your username you want, as well as a password and your email address. After this information is entered, click on the sign up button. next, you will be able to enter in your other social networking emails, so you can see if your friends from there are using Twitter. For the next step, you will be brought to your home page, where you ...
Prepare two video clips which are on entirely the same scene or spot. Shoot the first video clip so that the actor enters and leaves the scene from the left. Then, shoot the second video clip so that the actor enters and leaves the scene from the right. On your Sony Vegas Pro application, layer both video clips together. Create a rectangular mask on the first video to indicate which part of the scene should only be shown. Add a little bit of feather effect so that the first video will blend i...
Garmin is a popular and trusted brand of GPS devices. In this video, learn how to enter destinations and perform other basic tasks with a Garmin Nuvi 750. This video shows you the Nuvi 750 but all of the instructions should also work with other Garmin models. GPS is fantastic for traveling to new destinations, getting out of a lost situation and finding unknown places faster.
In this video we learn how to crack WPA using Back Track. The first step is the boot into Back Track using a VMware Virtual Machine Image. Next you need to open a shell console. In the console you will type "airmon-ng" and press enter. This does a check to find the wireless guard interface name. Next, type "airodump-ng wlan0" and press enter. This will tell it what wireless card to use and scan for wireless networks. You are looking for the one that comes up WPA. Copy the MAC address then typ...
My Blackberry TV demonstrates how to protect your Blackberry device with a password. Protecting your Blackberry with a password will help to stop people from accessing your personal information on your device. From the home screen, press the Blackberry menu key. Then, select the options choice. Next, scroll down to the password choice on the options menu. Select password and then select the set password button on the password screen. Enter your desired password and then press the enter key. V...
This video tutorial from ruralgeek shows how to set up and use Wippien VPN on Windows XP. First, download Wippien client from here: www.wippien.com.
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 ...
Steps to Configure Your Modem/Router are: 1. Open Network connection and click properties
This will illustrate us how to use the reverse auction site Dubli. Here are the following steps.Step 1: First of all enter the link and log onto the official website of DubliStep 2: Now you will find various options on the homepage of Dubli.Step 3: go and click the option of auction option.Step 4: The various product that are for auction will be displayed.Step 5: Search for the product that you want to auction for and enter the amount that you pay for the product and press the go button.Step ...
This video shows us how to change driving letters or directories in DOS command. Firstly go to start menu and then click on run. Then type cmd and press OK with which a DOS command cmd window will pop up. Now you need to change the directory and these is done by typing ‘cd..’ and after that press enter. Now you have changed the directory and now you need to see what’s in there and for that type ‘dir’ and press enter and this shows what’s in that directory. Now change to other directory by typ...
This video describes how to access websites that may be blocked by your school. To begin, on the desktop go to the Start menu and select Run. Type in "cmd" and hit okay to open the command prompt. If that doesn't work go to Start, My Computer, C drive, Documents and Settings, Default User (or the name of the user), Start Menu, Programs, Accessories, and finally click Command Prompt. From the command prompt enter "ping" and then a space followed by the website. The website entered will display...
This video describes how to increase battery life on most of the LG phones", for that first we have to enter into the service by typing the numbers "##77647269700" and then clicking the call button. Now it will ask for 6 digit "service code" to enter into the service. Just type "000000" as a code and it will enter into the "services" Menu and from the menu click on the "Network Select" and from that choose "Mode Preference", by default "Digital Only Hybrid" mode will be in selected. Now to sa...
Learn how you would bypass a school’s web filters so that you can go to content sites that are always blocked in examples of YouTube. Click the ‘Start’ button and then click on ‘Run’ and type in cmd and hit enter on your keyboard. This will bring up a command prompt where you type in ‘ping’ and then when that populates the next prompt you enter in the website to bring up the IP address. By entering the populated number you can get into a website from the search field of a web browser. It incl...
Similar to the "dissolving person" effect, this shows you how to make it seem as though they have entered or exited the matrix.
Learn how to enter code breaker codes on the PCSX2 Playstation 2 emulator for the PC. Entering these codes will allow you to cheat on emulated PS2 games. YOu will need to use a variety of other programs like Daemon tools to do this.
