Spreadsheets

How to Create a Pie Chart in Microsoft Excel

By joshcrank

0 comments

Pie charts are among the most commonly used and helpful forms of data presentation. With Microsoft Excel, it’s very easy to create your own pie graph using your own data and labels. Just follow these brief, simple steps to make yours... more »

How to Create a Simple Report in Excel

By dahawe

0 comments

Using Excel you can create a simple report that you can use in many different ways - to summarize data, make a chart, show grouping, filter data and sort data. Beginners often do these separately but it is actually easier using a report format ... more »

How to Create a Workbook in Excel 2007

By eHow Computers Editor

0 comments

Excel gives you a couple of options to create a workbook. You can use a template or you can create your own workbook. Templates are workbooks that are already created and you modify them to your own specifications. Depending on your needs, you ... more »

How to create an excel template

By JackBas

0 comments

Do you have a worksheet that you use a lot. Are you always copying it and pasting it into now workbooks. Save time by making it a template... more »

How to Create an Exploding Pie Chart in Excel

By eHow Computers Editor

0 comments

In Microsoft Excel 2007, you have the option of creating an exploded pie chart when you create a pie chart. If you choose to create just a 2-D pie chart, you can explode the pie chart after you have created it. This is a very simple process that ... more »

How to Create Conditional Formats in Excel 2007

By eHow Computers Editor

0 comments

In previous versions of Excel, a user was able to create conditional formats on a limited basis. Microsoft Excel 2007 extends this conditional formatting to separate functional utility. The utility makes creating these objects easier and the ... more »

How to Create Excel 2007 Custom Properties

By eHow Computers Editor

0 comments

Excel's file properties also are known as metadata. They contain information about the file such as author, subject, title and other keywords that identify the documents or topic. You can use metadata to easily organize your documents by ... more »

How to Create Lists in AbiWord

By eHow Computers Editor

0 comments

Creating a numbered list of documents is of great help when there are complex documents or files that need detailed description. AbiWord, a free word processing program, offers this function. It can update the numbering of the list when items are ... more »

How to Create Lists in Excel

By eHow Computers Editor

0 comments

Use a spreadsheet program like Excel to create lists. Create lists in rows or columns that you can manipulate with ease. The following directions will help you create lists in Excel. A list in Excel is a collection of data grouped together... more »

How to Create Macros in a Spreadsheet

By eHow Computers Editor

0 comments

A macro is a recording of keystrokes and mouse actions. Macros save you time, rather than having to repeat the same task repeatedly, you only have to do it once and the macro will then repeat it for you. The following will explain how to create a ... more »

How to Create Macros in Excel

By eHow Computers Editor

0 comments

Excel contains an automated tool, called a macro, which can be used to perform common, repetitive tasks. A simple macro can be set to record keystrokes and mouse clicks when a user is performing a task, such as entering and organizing a list of ... more »

How to Create New Table Style in Excel 2007

By eHow Computers Editor

0 comments

Spreadsheet programs are enormously helpful in organizing data. Microsoft Excel is one of the top programs for analyzing and managing information. The 2007 version provides quick styles for formatting tables. You can also create new custom table ... more »

How to Create Sequences in Excel

By dahawe

0 comments

You know how sometimes you need to enhance or create Excel data with common sequences such as months, days of the week, or another sequence? You can do this easily using only two things - common sequences build into Excel, and a special part of ... more »

How to Create Styles in Excel 2007

By eHow Computers Editor

0 comments

Microsoft Excel 2007 offers an array of pre-set styles. If, however, you want a style that is not already included in the Cell Styles gallery, you can easily create your own styles. This also works if you have formatted cells whose formatting you ... more »

How to Create Tables in Abiword

By eHow Computers Editor

0 comments

AbiWord is a program designed to create tables of different shapes and sizes. Tables and graphs can make a document easier to read by condensing important material into a format that is easy to understand. Follow the instructions below to create ... more »

How to Customize a Toolbar in Excel

By eHow Computers Editor

0 comments

Microsoft Excel is one of the most used programs we have available to us. Many people, however, find that some of their most often used commands are not readily available. If this is the case with you, simply customize your toolbar to include ... more »

How to Define a Table in Excel 2007

By eHow Computers Editor

0 comments

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The ... more »

How to Define Criterion for an Excel Table

By eHow Computers Editor

0 comments

If you need to analyze your Microsoft Excel tables for database functions or other types of table analysis, you will need to first define the criteria you are going to use. Defining single or multiple criteria will help you determine what cells ... more »

How to Delete Cells in Microsoft Excel

By eHow Computers Editor

0 comments

Excel is a highly customizable and generally user-friendly spreadsheet application. However, when you enter a lot of data and suddenly discover you've created some cells you don't need, you are faced with the challenge of removing the cells ... more »

How to Edit a Print Screen Into Excel

By Sharon Slayton

0 comments

Learn how to do a print screen and paste it onto an Excel spreadsheet. Then learn how to edit your pasted picture. Learn what you can and cannot do with a screen print in excel... more »

How to Edit Data in Microsoft Excel

By eHow Computers Editor

0 comments

Microsoft Excel is the most frequently used spreadsheet software. You can use Microsoft Excel for making lists, keeping track of your addresses and numerous other tasks. Microsoft Excel is easier to use than a word processor when you are going to ... more »

How to Edit Macros in Excel

By eHow Computers Editor

0 comments

A macro is a Visual Basic tool that can be used in Excel spreadsheets. It uses a series of commands that you enter in Visual Basic code that will quickly perform the task you have created it for. This is a great benefit when there are tasks you ... more »

How to Edit the Contents of a Spreadsheet Cell

By eHow Computers Editor

0 comments

You can use spreadsheets for many purposes, such as keeping your time when you work at home, keeping a list of addresses for your friends and relatives and making a list of things to do. The advantage of a spreadsheet over a word processor is the ... more »

How to Enter and Change Data in Excel 2007

By eHow Computers Editor

0 comments

To get started working in Excel you need to enter data. What data you enter depends on what you want to do with the spreadsheet. If you were working on an address book, you could be entering names and addresses or you may want to make a budget, ... more »

How to Enter Data in Excel 2003

By eHow Computers Editor

0 comments

Data entry (putting information into the cells of a spreadsheet), is the most important aspect of using Excel 2003. Follow these steps to enter data into a cell in Excel 2003... more »

Check Out All Categories

Articles in Spreadsheets