Display Search Results

How To: Use the LARGE and SMALL functions 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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:

How To: Adjust brightness to save battery life on an Android

The new Android enabled phones can take up a bit of power, so knowing the best way to manage your power settings is crucial in having a fully-charged cell phone all the time. The biggest key is making sure your screen brightness isn't more than it should be. Best Buy has answers. The Best Buy Mobile team explains how simple it is to adjust screen brightness to save battery life on an Android cell phone.

How To: Change the accessibility options in Windows 7

This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...

How To: Use basic functions in Excel (AVERAGE, COUNT, MIN/MAX)

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...

How To: Pin recent Excel documents to the office button menu

This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn t...

How To: Manage all your passwords on your iPhone

Mike Callahan from Butterscotch describes how to manage the passwords on your iPhone by using the 1Password app. The application costs $5.99 for the Pro version. First, you enter an Unlock Code to give you access to the app. The icons across the bottom of the screen correspond to different features of the app. The Logins icon stores your login information. The Wallet icon stores information about your credit and bank cards. The Passwords icon holds all your passwords. The Add icon allows you ...

How To: Change the font color in Word 2007

In this Software video tutorial you will learn how to change the font color in Word 2007. The default font color in Word 2007 is black. But, you can change the color of the font to just about any color that you want. Click on the ‘home’ tab of the ribbon on top of the page and you will see a small window with the letter ‘A’ in it. Click on the arrow next to it and it will display a color palette with automatic, theme colors, standard colors and more colors sections. Here you select any color ...

How To: Create titles & lower thirds in Final Cut Pro

In this how-to video, you will learn how to add text and titles to videos using Final Cut Pro. First, place a time line play head where you want the text to appear. Move the mouse to the lower right corner of the viewer window and click the add text pop up menu. Select text and the viewer will change to a black box with Sample Text in the middle. Click on the tab labeled Controls. You can edit the text in this new window. You can move the text by selecting Image and Wire Frame. This will allo...

How To: Tie the Trilobite decorative knot

Learn the right way of tying the ‘Decorative Trilobite Knot’, by watching this video. Take a rope and form two bends, as shown. Now pass each bend over a hook to form two loops at the center, resembling number eight. The free end of the rope on the right side is then passed over the lower loop of the eight, to the left. The free end of the rope on the left side is then passed under the rope, just passed from the right. Thereafter, it is passed under the lower loop of the eight, and pulled thr...

How To: Change Text Size on Your iPhone for Smaller, Bigger & Bolder Fonts

For most people, the font that Apple uses in iOS is just perfect, but some of you may think it's too big while others with poor vision may have a hard time reading it. Whether you're having a hard time seeing text on your iPhone or just want something different, there are actually three things you can do to adjust how text is viewed.

How To: Prank a Coworker or Friend by Flipping Their Computer Screen Upside-Down

The perfect way to avoid boredom at work or in the classroom is with a good old-fashioned prank, and this one is for tech-minded. In the video below, you'll see how to change your coworker's (or classmate's) computer screen to be display upside-down, which will totally freak them out when they return from lunch or the restroom. The best part is watching them try to revert it back to normal!

How To: Enable Javascript and update Flash in Firefox

If you can't watch video on YouTube. com or play online games, maybe you need to update your Flash Player and enable JavaScript. You should watch this video if you want to know how to do these. The Adobe Flash Player is the standard player used to display images, videos and flash content on the Internet. Without the flash player, you will not be able to view videos. To install: 1. Download JavaScript Flash Player. Click "Save File" when prompted to download the file to your computer. If you w...

How To: Do the Magicard trick

Want to impress some friends? This magic trick requires no sleight of hand, just a bit of setup. Using the Magicard application, you can make your iPhone mysteriously identify the card placed against it.

October 30: The OnePlus 6T — What's Rumored & What We're Hoping For

OnePlus will be releasing a new phone in the second half of 2018, specifically, an upgrade to their T-series. Over the past two years, #T versions have come out about five months after their predecessors and have included small updates that fix any problems from the previous OnePlus device. While we do know a bit about OnePlus 6T, what it could be is much more exciting.