Spreadsheets

Microsoft has developed countless software programs that have their own proprietary file extensions. While the list has grown over time, most people ignore the extensions until they have trouble...

Microsoft Excel can show and calculate time based on decimal numbers or hours, minutes and seconds. Decimal clock time ranges from 0 to .99999, which represents 12:00 a.m. to 11:59 p.m. Excel...

When you are keeping track of the number of hours that you are working, you can use a spreadsheet program like Microsoft Excel to automatically convert regular time to time clock time. To do this,...

A pivot table is a summary and analysis function most commonly used in Microsoft Excel. When collecting data in spreadsheets, pivot tables are used to sort, count, total and categorize the data...

One of the biggest roadblocks to making the switch from a Microsoft Windows or Mac operating system to Linux is the availability of the Microsoft Office suite of productivity applications. In...

User defined functions, such as formatting, multiple cell calculations and text manipulation, can be created in Excel to supplement the built-in library of functions. Once created, they can be...

If you have a group of people you need to contact quickly and easily, make a phone tree. This lets the work of contacting everyone in the group be spread out among the group members. In this...

The STC file extension is used for certain spreadsheet template files. As with all unknown file types, make sure you scan it with your anti-virus software before attempting to open.

Microsoft Excel is a convenient software to use for data analysis. Various tools and features are available to create customized reports and data models. Formatting various cells is fairly simple....

It has happened to everyone at one time or another. You are working with Microsoft Excel 2007, and you can't figure out how to carry out a particular task. You have several options available to...

If you are dealing with the transition between Microsoft Excel 2003 and the 2007 version then you are probably pulling your hair out trying to find all of the features that you have grown...

As you work with Microsoft's Excel application, you may want to know how to perform advanced tasks such as making a drop-down box that displays multiple selections to choose from. This function is...

Microsoft Excel is a spreadsheet program designed to make routine calculations automatic. By adding simple coding, called functions, you can program Excel spreadsheets to quickly add, multiply and...

A clearly organized visual aid often makes complex data easier to grasp and conceptualize. It is often easier to explain a point or concept when the data is compiled into a chart or graph. Charts...

How to enter data into an Excel worksheet is an art that must be mastered to get maximum benefit from your work because the processing of data can begin only after the data entry.

Need to add a column or row of data in an Excel spreadsheet but don't know how? Here is a simple, easy way how to use the Autosum function - so you don't have to sit there and add up all the...

Microsoft Excel allows you to create spreadsheets with tables, charts and filtered data. To make your spreadsheet easier for others to use, create drop-down boxes. This will help users entering...

Made by IBM, Lotus was one of the first widely-available computer spreadsheet programs and is still available for purchase today. The Lotus 1-2-3 program creates files with an easily recognizable...

Microsoft Excel is a program included in the Microsoft Office suite. Microsoft Excel is designed to work with spreadsheets consisting of columns and rows. Excel allows you to perform various...

A tab-delimited text file is one way that databases and other information-processing applications store data. Each tab separates the value relating to one entity (or record), while each line...

Excel, the spreadsheet program that is part of Microsoft's popular Office software package, is a favored tool for managing, analyzing and reporting economic data. With its user-friendly features,...

There are many tools available to users in Microsoft Excel. All versions of Excel prior to Excel 2007 had these tools available through the Menu Bar. In Excel 2007, the Ribbon Bar replaces the...

It is likely that if you work on a spreadsheet software program, it is some version of Microsoft Excel, which is considered the industry standard for spreadsheets. Excel's powerful formulas and...

Microsoft Excel is the most widely used spreadsheet program worldwide. While the basic functions are simple to use, beginners may still need assistance to get comfortable with the software. Also,...

Microsoft Excel, the incredibly popular spreadsheet program, is used around the globe and has been considered the standard for many years. The program is one of the most powerful applications of...

Microsoft Excel files can contain thousands of cells filled with data. When you combine this information with graphics, such as charts and graphs, as well as ever-expanding links to other...

Most commonly, spread sheets keep track of data. Spread sheets are particularly useful for accounting, which consists primarily of numbers. However, everyone can use a spread sheet for an address...

Microsoft Office offers a broad range of software to increase productivity in business or home work environments. Excel 2007 is the spreadsheet component of Microsoft Office Suite. Microsoft...

Microsoft Excel is the business standard for creating spreadsheets. Although Excel was originally designed for Microsoft Windows, Microsoft created a version of Office that can be used on iMacs...

Microsoft Excel spreadsheets are sometimes accompanied by PowerPoint files, especially during meetings or for presentations. Combining a spreadsheet and PowerPoint presentation allows you to show...

Microsoft Excel is the most popular spreadsheet program in the world. It is used by people in many different occupations for a wide variety of reasons. One of the top reasons Excel is so well...

Sometimes you don't want to print an entire spreadsheet workbook. You only want a certain section or just one page of a large workbook. You don't have to print the entire workbook---there is to a...

Here's a handy reference for how to enter the standard equation for radioactive decay in Microsoft (R) Excel.

The file extension XLT is used for the Microsoft Excel template file type. A template is a handy document that has already been formatted with the functions most used to make document creation easier.

Microsoft Excel is a widely used spreadsheet program, but it can be much more than that for accountants, tax advisers and other financial professionals. Accountants can use the advanced features...

The green-bar paper that was used in the past with many computer printers was a favorite of accountants and others that needed to read large amounts of data. This was because the alternating green...

Add-ins are programs that offer additional commands and features to Microsoft Office Excel. Some popular add-ins include the Analysis ToolPak, the Solver Add-In, the Conditional Sum Wizard, Euro...

Many people use Excel spreadsheets to keep track of their bank account balance. Taking that concept one step further, I will show you a technique to keep track of your bills. If you are like me,...

Excel, a much-used spreadsheet software program, lets users create professional-looking documents for various needs, such as a simple personal address book or a detailed chart at work. With a...

Microsoft Excel is a useful tool for monitoring the amount of calories you burn and consume on a weekly basis. After inputting your specific calorie information for each day of the week, you will...

Every company has an organization chart that depicts who the employees are and what their position is in the firm. Organization charts help internal and external stakeholders understand the...

Microsoft Excel 2003 is a powerful tool for creating spreadsheets, budgets, inventory lists and much more. Those who master this widely used program can expect to find themselves in high demand,...

Microsoft Excel is a spreadsheet program used to calculate and format data. Besides the pre-defined formulas, developers and users can create their own formulas, using scripting or program code....

If you have an Access table in a file, you may want to export it to an Excel spreadsheet. This is beneficial for small businesses or individuals who have the information stored in a database but...

Microsoft Excel can autofill a sequence of sequential data such as weeks, months, year and other consecutive numbers. Excel can also autofill a pattern of numbers. You can tell Excel the...

The 2007 edition of the Microsoft Excel spreadsheet program added several extra features and streamlined many of the menu screens. Unfortunately it also hid many of the more advanced features that...

The Autofill function in Microsoft Excel is a useful tool that can save you lots of time typing in certain kinds of data. The data includes days of the week, months, and numbers. This type of...

This How-To will walk you through a brief tutorial that will give you the basic skills acquired to name a Cell or Range in Excel 2007 for Windows.

Using world population census data as an example, learn how to efficiently graph data in a line graph using Microsoft Excel 2007. A video intended to accompany these instructions can be found at:...

Microsoft's Excel is a spreadsheet software program that allows you to create tabular data organized in columns and rows. These electronic ledgers have an unlimited number of uses, from preparing...