Spreadsheets

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.

Bar graphs can make data contained in a worksheet easier to understand. Whether you are a consumer or a business person, you might need to analyze the increases or decreases of information quickly...

Spreadsheet programs allow users to create tables of numerical data that can be processed through user-defined equations. There are a number of spreadsheet programs available, including one that...

Microsoft Excel is the leading spreadsheet program on the market. It's efficient, powerful ability to manage, organize, filter and sort through large amounts of data makes it a popular and...

Creating a new spreadsheet can be time consuming. Oftentimes novice users spend hours formatting, researching formulas, and getting the sheet to behave exactly as desired. If you would like to...

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

Microsoft Office is a package of software programs used for word processing, spreadsheets, databases, and presentations. There are a number of files associated with Microsoft Office, including...

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

Microsoft Excel is a powerful and popular spreadsheet program with a variety of different tools and filters that allow it to easily be used for multiple purposes. Besides calculations and...

This Excel trick is wonderful for tracking a child's age, the number of days/months/years since a milestone like a marriage, or a whole host of other applications. It's simple to do, and you...

Whether they are used for home or business purposes, spreadsheets can be extremely powerful tools. One of the most valuable utilities is the ability to easily replace the contents and the...

Excel is a spreadsheet application that allows you to add, subtract, multiply and divide figures within other cells. The minus function is used to subtract cells. It also can be used within a cell...

If spreadsheet data is for charting purposes, the referencing data set must be set up in a certain way in order for the chart or graph to be displayed correctly. But if the data has already been...

Microsoft Excel is multifaceted, versatile software that can be used for many functions. The built-in features of Excel make it a very good tool to manipulate and analyze data. Stock market data...

Spreadsheet software like Microsoft Excel designates rows and columns in two ways. In A1 reference style, rows are labeled with numerals (1, 2, 3 ... ) and columns with letters (A, B, C ... ), so...

Microsoft's popular Excel program has data analysis capabilities that include conducting regression analysis with dummy variables. Dummy variables are categorical variables numerically expressed...

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

If you are reading this you are probably looking for a quick and easy way to make your Microsoft Word document into a PDF. Read on for details on how to do this easily!

I know this should be an extremely easy task, but obviously you couldn't figure out how to rename a module in the VBA editor either. It took me forever to figure out how to rename a module and so...

The comma separated values, or CSV, format is used by all spreadsheet programs and is a nearly universal means of transferring data among incompatible programs, such as two different email...

When creating a list in Excel, you may want to merge two columns or cells. This allows you to create longer columns without the overflow into other Excel columns. When cell text overflows into...

This Excel trick is wonderful for tracking the time remaining till a birth, wedding, graduation, vacation, or other milestone, or for tracking your progress toward a goal date. It's also great...

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

Spreadsheet programs allow users to organize numbers into rows and columns, to perform calculations and create graphs and charts from data. There are a number of spreadsheet programs available for...

You can customize Microsoft Excel with add-ins that enable compatibility between Excel and non-Microsoft software applications. Add-ins for Lotus applications such as Notes, Connections, Sametime...

Microsoft Excel is a powerful spreadsheet application that provides the tools you need to import, create and present data effectively. For example, you can arrange one cell, row, column or entire...

Created by IBM, Lotus 1-2-3 is a software program that allows users to create spreadsheets. A number of files are associated with Lotus 1-2-3, including .wk4 files.

For many people, spreadsheets are more than something used occasionally at work; they are a part of everyday life. Spreadsheet programs such as Microsoft Excel are commonly used to help people...

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

Lastname, Firstname M Lastname Jr., Firstname M Otherwise known as last name first, first name last. Do you have a list of names like this one above and want to split apart the last name, first...

Being a Human Resources professional, you administer data entry tests to a vast number of potential employees. Often, you must remove data from the spreadsheet to administer the next test. This...

The QPW file extension is used by Quatto Pro, a spreadsheet application which is a part of Corel WordPerfect Office. If you have been sent a QPW file by someone running WordPerfect Office rather...

Ms-excel is a spreadsheet progam which comes along with ms-office software. The other softwares include Lotus 123, and open office. Out of which excel is the most preferred one to maintain data....

A Z-score, used in statistics, is the measurement of the number of standard deviations a number is above or below a mean. Z-scores are sometimes referred to as "standard scores" and "Z-values."...

Microsoft Excel 2003 presented their most powerful spreadsheet tools to date. Excel 2003 provided more options than prior versions, such as formatting, a wider variety of supported Visual Basic...

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

Waterfall charts represent a set of data that impacts a single derived number. It's a visual aid to show how numbers relate to each other. That's according to Databison, who state that a good...

For any business, creating a production plan can be challenging. Using a spreadsheet such as the popular Microsoft Excel 2007 can simplify the task by performing complicated mathematical functions...

Produced by Microsoft, Excel is a computer software program that allows you to create spreadsheets or tables of data that can perform calculations. One of the files associated with Excel is the...

Including a chart on a website or in a presentation is a great way to convey information dealing with numbers quickly. While a large grid of data can be confusing and difficult to process...

Create a spreadsheet to organize different sets of data or arrange them side-by-side for comparison. A Microsoft Excel 1997 or 2007 spreadsheet lets you calculate variables with data in various...

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

Microsoft Excel is a spreadsheet program that can serve a variety of purposes, from keeping a list of names and addresses to balancing a bank account and performing complex calculations. Because...

If you use Microsoft Excel, chances are you have found the redo button in the top left corner of the screen. Redo is typically used when a user changes their mind after pressing undo. However,...

One of the most popular spreadsheet applications is Microsoft (MS) Excel, a software program that is typically bundled with Microsoft Office. With Excel you can quickly and easily analyze and...

Microsoft Excel is often used in accounting. Excel provides you with the tools you need to perform basic and advanced calculations. You can keep ledgers, manage finances, import and export data...

Microsoft Excel provides shortcuts to frequently used tasks on toolbars. Toolbars can be edited to add or remove buttons. Since each toolbar item is in the form of a button, toolbars are sometimes...

Creating and planning a budget is made easier by creating an Excel spreadsheet. You can create categories for your expenses. Set limits for each category so you know what you can spend. Create...

Microsoft Excel is often used to calculate measurements and lengths. Once you know the conversion factor, you can easily create formulas to convert one measurement to another. For instance, you...

Microsoft Excel is a software program that allows you to create spreadsheets, charts and graphs for business or personal use. Microsoft Exel produces different types of files with different...