Spreadsheets

When programming Microsoft Excel functions, you can use a language called Visual Basic for Applications (VBA). VBA is a stripped down version of the Visual Basic programming language. It's...

The IF function is one of the most useful and commonly used functions within Microsoft Excel. It allows you the ability to create up to seven (7) different responses in Excel based on information...

A .xls (Excel) file cannot be converted to a .asc file because there is no conversion software available at the current time. However, there is roundabout solution to the issue.

Correlation measures the strength of association between quantitative variables, usually in the form of a correlation coefficient. The value of a correlation coefficient, symbolized by the Greek...

Multiple regression analysis is an advanced statistical technique that uses more than one predictor, or independent variables, to examine the effects on a single outcome, or dependent variable....

Displaying the percentage of values in a chart makes it easier to compare data. You can put a percent into a pie chart by using Microsoft Excel. Thanks to the built-in formulas, you won't have to...

Microsoft Excel is used to calculate, analyze and share data. You can import data into Excel, or enter it manually and format your spreadsheet with specific borders, shading, cell size and number...

Microsoft Excel 2007 is a spreadsheet software that can assist you in creating charts, graphs, and other visual presentations to accompany your data. Microsoft MapPoint 2010, which was designed to...

I use Excel to surf the Internet all the time to extract information from hundreds or thousands of web pages and/or download files. I've downloaded thousands of free font files and music files at...

In Microsoft Excel, you have the ability to reuse formulas in multiple cells. For example, a company gives you a 20 percent discount for your office supplies when you use a purchase order. You...

Credit card companies make money by levying a finance charge on borrowers. Finance charges are derived by applying a periodic interest rate to the customer's account balance. (The periodic...

This tutorial will teach you how to make a basic pivot table in Excel. A pivot table allows you to modify data in a table and to automatically compute mathematical formulas.

Microsoft Excel is a spreadsheet software and is a part of the Microsoft Office suite of business-oriented software. Excel workbook comes with three worksheets by default, although you can add as...

PivotTable reports in Microsoft Office Excel provide a quick method to summarize data for analysis and decision making. You probably already have all the data you need on your home or work...

Are you struggling to graph the AP and MP curve on Excel. At one time I also had problems trying to graph the curves on Excel. After investing time and energy, I figured out how to graph AP and MP...

VBA is used in Excel to create macros which automate tasks that would normally be done manually. Conducting these tasks manually can be time consuming and cumbersome. Many times users need to copy...

Box plots, also called box-and-whisker plots, are useful for visualizing data using their five-number summaries. A five-number summary of a data set is typically the minimum, maximum, median,...

Images can make your Microsoft Excel spreadsheets more attractive. Backgrounds are often used to show a business logo or a template. Clip art and drawn images help illustrate points or draw...

Microsoft Excel provides many tools and features to help you create a comprehensive worksheet. For instance, you can add a scroll bar that allows you and other users to scroll through data quickly...

Excel, the spreadsheet program in the Microsoft Office software package, is popular among businesses, educators, college students and others for data storage, management and analysis. Excel's...

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...

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,...

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...

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...

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:...

Timelines are excellent resources for work meetings, personal goals or family reunions. Learn how to create a timeline using Microsoft Excel, a program readily available on many personal and...

The "Match" function in Microsoft Excel VBA (Visual Basic for Applications) procedures finds a match within a range of cells and prints it to the spreadsheet. The function is useful when entering...

Microsoft Excel 2007 is significantly different from previous versions of Excel. Companies are under financial crunches making formal training on 2007 out of the question for many. With some...

A template field is a type of format layout for Microsoft Access databases. Template fields are a predefined layout of data. For instance, if you have a list of customer first names, last names...

If you use Excel 2007 a lot, you may have noticed when you work with a large file, Excel sometimes creates automatic backups of the file you are working with. These files often save themselves to...

Planning and creating a budget can be tiresome, especially if you don't know where to begin. Microsoft Excel can help you plan a budget for any occasion. Whether you're planning your monthly...

Microsoft Excel 2007 is a powerful tool for managing large amounts of data. Part of the beauty of Excel is the flexibility users have to manipulate the text in the worksheet. Wrapping text in a...

Microsoft Excel allows you to quickly create bar graphs to study and share data. Excel graphs can include a few rows of data or an entire spreadsheet of detailed information. You can format the...

The Paste Special feature in Microsoft Excel gives you the power to perform a variety of little-known functions. From creating connected formulas and performing mathematical operations to...

When programming in VBA, you may find it necessary to retrieve the address of the cell selection for the code. For instance, if you need to change the font color, the selection address of the cell...

A complete catalogue of a museum's artifacts is worthless if the curator, archivist, or researcher cannot use the catalog to find specific items of interest.

The Excel program is one facet of the Microsoft Office software suite. Excel is a spreadsheet solution that allows you to group lists of data together, such as client lists or product costs, and...

A pie chart can be made in Microsoft Excel by typing in data, clicking on "Insert Chart" and selecting "Pie," which can be displayed in a flat view or a 3D view. Create a pie chart with data with...

In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "Sum." Add several pieces of data together in Excel with help from an employee of an IT...

Microsoft Excel is a interactive digital spreadsheet application that is included in the Microsoft Office 2007 package, the latest Windows version of Microsoft Office. The application is easy to...

Mr. Turtledove wrote this article - he uses a spreadsheet for everything from the family budget to keeping track of his favorite team's statistics. He's been doing this since the early 1990s, so...

You will learn how to take a list of names or really anything and put them in a random order using Microsoft Excel. This could be used for generating schedules for work different on a weekly basis.

The VLOOKUP function is very powerful function in the Microsoft Excel application. And it can be easy to use if you follow these steps! The function allows you to compare one column of...

Do you have a spreadsheet that you want to add hours and minutes together to get a total time? Find all your answers below by following these simple steps

Pivot Tables are an advanced function of Microsoft Excel. If you create or download reports at work using Microsoft Excel, then knowing how to create a pivot table will help you to summarize and...

Microsoft Excel 2003 allows you to create conditional formulas that perform tests on the data in a spreadsheet and return a value based on the results of the test. The main functions used in these...

Calculating the "P" (Project) Value in Excel, helps you to foretell shopper trends, inventory supply needs or predict sales revenues. One technique used to calculate this value is the "Forecast"...

A macro is a set of functions and commands that can be recorded and played back in Microsoft Excel. Macros are convenient for anyone who must perform the same task over and over in their work. If...

If you have ever wanted to play flash games at work, but the firewall blocks them, here is your answer.