Enter Searches Search Results

How To: Make an animation with a batch file

CtrlFormula teaches you how to make an animation with a batch file. Before you begin you must know that sending batch files over the internet is risky, so keep that in mind. You create a new .txt file and type in: @echo off. Hit Enter twice and type in: echo loading. Then hit Enter once and type: ping localhost -n 2 >null. Hit Enter once and type in: cls. Copy and paste this structure three times. For each loading you see you have to add another dot at the end, so the animation will slowly go...

How To: Delete a Yahoo account

Learn how to delete your old Yahoo or Yahoo mail account in simple steps. First open your web browser and enter the web address for Yahoo to open it. Now log into your account using your Yahoo username and password. Go the account termination page, confirm your account termination and enter code give. Finally press 'Yes' and enter your password . Now your Yahoo or Yahoo mail account will be deleted.

How To: Play "Enter Sandman" by Metallica on an electric guitar

Want to play Metallica's "Enter Sandman" on guitar? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and its chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing this Metallica song on your own guitar, watch this video tutorial.

How To: Do more effective searches on Google

Google is the most powerful search tool in all the land, and there are all sorts of setting to tweak and tricks to use that can make your search results better and more relevant to you. This video features Google Webmaster Help video personality Matt Cutts outlining some tips and tricks for getting better answers to your Google queries, including changing the boolean of your search.

How To: Validate data with dynamic VLOOKUP functions in 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Use the quick search box on Android cell phones (2.0)

Searching your phone just got easier with Google's Android operating system for your cell phone. With the Android Quick Search box feature, you can easily search your phone or the web, right from the home screen. It even provides you with search suggestions while you type. Watch this video tip to see how to easily search both your phone and the web with Quick Search box.

How To: Use Boolean logic for AND & OR formulas in MS 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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...

How To: Hack Google Search to find things more quickly

Though the Google home page may appear simple, its search tool is anything but. This quick clip from the folks at CNET TV demonstrates a number of the search engine's most obscure and most useful features, all certain to help you to find your desired information more quickly. For specifics, and to get started using these great search hacks yourself, give this guide a look.

How To: Password protect minimized apps in Windows

Have you ever had to close an application with private info in order to let someone else use your PC? LockThis! is a windows application that lets you secure individual programs without the hassle of having to save your progress and closing the program. To use LockThis! just hold the control key and click on the application that needs to be locked and simply enter your password on the dialog that pops up and your done. Now anyone can use your pc without you having to look over their shoulder....

How To: Run Kali Linux as a Windows Subsystem

Kali Linux is known as being the de facto penetration-testing Linux distribution but can be a pain to use as an everyday OS — even more of a pain if that means carrying around a second laptop or the constant frustration of using the finicky Wi-Fi on virtual machines. But there's another option: installing a Kali subsystem on your Windows computer as a convenient compromise.

How To: Navigate Hands-Free Using Voice Commands

Google Maps, in conjunction with the Android operating system, is a powerful tool for navigation that is often underutilized. While it's no secret that it can get you to wherever you're going and back, some of you might not know that you can use Google Maps without even having to touch the screen. Not having to touch your display means you can concentrate on other things, you know, like driving or eating that jelly-filled donut.

How To: Unlock Your Android with a Secret Sequence of Volume Key Presses

Yes, they're called volume keys, but they can do much more than adjust your volume. With minimal effort, you can do some amazing things with these physical buttons, like secretly record videos, toggle on your flashlight, scroll through pages, control your music, and much more. And while using them to wake your screen is useful, let's take it a step further and show you how to use them to completely unlock your device, even if the screen is off.

How To: Change the Default Save Location of Screenshots in Mac OS X for a Cleaner Desktop

While my desktop is usually neat and organized, it quickly fills up with screenshots each and every day. Usually, I end up putting them in a folder or just trash them, but why not make the entire process of taking and organizing screenshots easier by changing their default save location? With the help of Terminal, I'm going to show you how to change the default save location of screenshots to anywhere you want in Mac OS X.

How To: "Find & Replace" Text Directly in Your Web Browser

I'm sure you've been there—halfway through typing something out, you realize that one word you've been using more than any other has been misspelled. Perhaps it's a single word, acronym, or line of code that you find yourself typing quite often at work, but this one requires complicated hand gymnastics that you'd simply rather not perform over and over again.

How To: Open a New Gmail Account

Gmail is a free, advertising-supported email service provided by Google. Users may access Gmail as secure webmail, as well as via POP3 or IMAP4 protocols. Gmail initially started as an invitation-only beta release on April 1, 2004 and it became available to the general public on February 7, 2007, though still in beta status at that time. The service was upgraded from beta status on July 7, 2009, along with the rest of the Google Apps suite.

How To: Make a new menu in Joomla

In this video, we learn how to make a new menu in Joomla with Chad. First, log into your Joomla account and go to the menu button. Click on "menu manager", then you will click on the "new" link. After this, enter in the unique name, title, description, and module title in the appropriate boxes. Once you do this, click "save", and now go to the menu items icon under the links menu. Now, go to "new", then "external link". Enter in the menu item details in the appropriate boxes, then add in the ...

How To: Install Google Chromium OS on your Mac or PC

First download the virtual box, download it for Mac and install it. Now download the Chrome OS and extract it. Now launch your virtual box and click new. A "create new virtual machine" wizard will open, click next, put the name of the OS and choose Linux in operating system and Ubuntu in version now click next. Now give memory atleast 1000 MB and click next. Select "use existing hard disk" and tick the "boot hard disk" and choose the OS file by clicking the folder icon next to it, click add a...

How To: Enter Excel data into cells with drop down menus

In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...

How To: Create drop down menus in Excel

In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...

How To: Set up the calendar in MS Project 2007

In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...

How To: Build and use array formulas in Microsoft Excel

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.

How To: Change your Hotmail password

In this how-to video, you will learn how to change the password to your hotmail e-mail account. This will be useful if someone knows your password or it is not unique enough to be safe. First, go to your web browser and log in to your hotmail account. Once you are in, go to the options bar and click more options. Next, go to view and edit your personal information. Click on change next to your password. Enter your old password and then enter your new password twice. Click save to change the p...

How To: Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...