Spreadsheets October 2012 Archive

Once you are done with a drop down list, or you want to move it to a new location, it can easily be removed from a worksheet . And it is ... Read More

Another option when creating a drop down list is to store the list data in a separate workbook. Doing so allows the list data to be used in a number of ... Read More

Excel Drop Down List© Ted French A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data ... Read More

Stop Invalid Data Entry in Excel© Ted French Excel's data validation options can help prevent user errors by restricting what data is allowed in specific cells in a worksheet. In addition, error ... Read More

Excel Charts in PowerPoint© Ted French Excel graphs or charts can be added to other Microsoft Office programs such as PowerPoint. Adding charts to your presentations is an easy and eye ... Read More

Excel Bar Graph Tutorials A bar graph or column chart is one of the most popular types of charts used in Excel. They are commonly used for showing comparisons between data, ... Read More

Sparklines are tiny charts that fit into a single cell in a worksheet and they are intended to give you a quick look at trends or changes that may not ... Read More

Excel Drop Down List© Ted French Since entering data into a spreadsheet is probably the most commonly performed operation in Excel, There are a number of built in tools and features ... Read More

Excel MATCH Function© Ted French The MATCH function, one of Excel's lookup functions, can be used to find the exact position of data in an Excel database or list. ... Read More

VLOOKUP is one of Excel's most used functions. It is limited, however, to using a single lookup criterion when trying to find information in a data table. We can get around ... Read More

A multiple cell or multi cell array formula is an array formula that is, as the name suggests, located in multiple worksheet cells. How it works is the same formula ... Read More