See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel 2010 video tutorials, you'll learn how to apply conditional formatting to cell data bars.
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 and Mr. Excel, the 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX formulas.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
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 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 5th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use relative and absolute cell references to save time when writing formulas.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deliver a sheet tab name to a cell!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 93rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to create a Gantt cell chart.
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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.
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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.
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 341st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions together to retrieve a cell reference that the OFFSET function can use for its reference argument.
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 very first installment in their series of digital spreadsheet magic tricks, you'll learn how to build your spreadsheet smartly, so it updates automatically by creating formulas with cell references!
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 271st installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the DATEDIF function to add formatting to a cell based on the content of a different cell.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
See a quick way to get out and underneath the map on the Splinter Cell: Conviction Demo game for the Xbox 360. It's really easy to get Sam Fisher down under, so watch this video walkthrough so you can recreate the map glitch yourself. There's sure to be plenty more glitches in the actual SCC game, so this is just a tease.
Go to DJTUTOR computer where you can download the latest firmware for free. Once downloaded you need to either burn it to a CD-R or use a USB key. Unzip the file and download it to a fat formatted USB key with nothing else on it. The firmware upgrade consists of two files. Eject any disks from the MEP and remove any USBs and make sure the unit is turned off. Next insert your USB key and push and hold USB 1 and USB 2 and turn on your unit. The MEP will then tell you when the firmware is comple...
This simple video teaches "how to find the area of a rectangle" in a very simple way. Area is the amount of squares inside a two dimensional shape.
In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...
This is a great way to charge your phone if you ever loose your car charger. Simply splicing a USB cable with an adaptor for your cell phone will create a homemade charger that can easily hook up to your computer and charge your cell phone.
Outside mount cell shades are easy to install. This Home & Garden how to video you will learn how to install them. Installing outside mount cell shades is so easy all you need is a screwdriver.
Cells in Numbers '08 are the same as in Excel. Basically, they are where you store your data. This tutorial will show you how to use the different functions of cells.
If you want to block your cell phone number for all calls, this is the video for you. Learn to block not just one call, but all further calls with the push of a few buttons. Now no one will be able to see your cell phone number.
Specialized cells in the lining of the gut may provide a key to preventing an infectious brain disease caused by misfolded proteins.
This video will show you how to tether your Samsung Messager 2, (the MetroPCS phone) to your PC to use as a modem for internet access. This will allow you to use your cell phone as your internet connection point, meaning you'll connect to the net for the cost of your cell phone's data plan. You will need your Samsung USB cable, a PC with Windows 2000 or higher, all current drivers for your phone and PC, and you will also need to head here to get the Samsung PC Studio program. This is part 1 o...
Samimy is at it again. And this time, his ingenuity has tackled a clever way to take something old and broken and restore it to something new and useful. What are we talking about? Modding a broken hard drive and some busted cell phones into a useful rechargeable USB / solar-powered light, which also acts as a portable mobile charger.
The iPhone has always has one very big problem: that it is tied to AT&T. AT&T is a terrible network, and many iPhone users out there are probably dying to switch network but keep their awesome phone. Well now they can! This video will show you how to unlock you jailbroken iPhone 4, 3GS, or 3G using a program called Ultrasn0w, leaving it ready for use on any cell carrier in the country. Except Sprint, they don't have SIM cards.
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.
One of the greatest things about Google's Android operating system is the ability to "long press" on your cell phone. The android platform is full of many surprises and features, and this is just one of them. Long press (or 'touch and hold') is a nifty feature that reveals additional functionality on your Android-powered phone, like long pressing a picture to edit or share it, and download pictures from webpages, and get more options on your email.
Sending e-mail on the go is a must these days. People seem to be working 24/7, don't they? If you've recently bought a new HTC Magic cell phone, this tutorial will show you exactly how send an e-mail from your phone to anyone, just like you would on a computer. This is a very handy feature and is easy to access.
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09.
This video will explain what you need to do to successfully download and install the Gingerblur rom for a Motorola ATRIX cell phone. Watch this video if you are interested in flashing this ROM to your Android smartphone. Using ADB is optional in this install.
This is a great gift idea for anyone on your gift list this holiday season who has an iPhone, iPod or Droid. Crochet a cell phone pouch for their smartphone! This tutorial is for someone who is already familiar with the basics of crochet.
Set custom ringtones and alert sounds on a Motorola Citrus WX445 cell phone! This brief, unofficial guide from the folks at Wireless Zone will teach you how it's done. For all of the details, and to learn how to use custom ringtones (or, if you like, ring tones) on your own Google Android smartphone, take a look.
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
In this video tutorial, we learn how to navigate and use the basic functions and features of the Verizon LG Octane VN530 cell phone's built-in camera. Whether you own a LG Octane phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
In this video, we learn how to subtract decimals. If you can subtract using basic numbers, then you will be able to subtract decimals. First, you will line up the tens and the other units of the numbers. Once this is finished, you will start to take away the top number from the bottom number. Borrow from the number to the left if you need to, then write down what you are left with on the bottom. Once you come up with your number, make sure you place in the decimal point where it goes. All you...
