Spreadsheets

By triciagoss

0 comments

Excel offers several options for different types of charts or graphs. A “bubble chart” is an attention-grabbing graph that can be used if your data has three data series, such as product name, cost and number sold. Follow these steps to create a ... more »

How to Create a Function in Excel VBA

By Keith Johnson

0 comments

In programming, a function is a small program that receives and manipulates data, returning a result in the process. And Microsoft Excel has plenty of built-in functions, such as SUM, COUNT and MAX. But did you know you can create your own ... more »

How to Create a Macro in MS Excel to Paste Formulas Only

By Melody

0 comments

I am a serial formatter. Any time I whip up the most basic spreadsheet, I add borders, sometimes shade cells, bold and center headings, bold totals, and format numbers. The proper formatting not only gives a professional touch, but also can ... more »

How to Create a Quiz in Excel

By eHow Computers Editor

0 comments

Excel is a great program for creating spreadsheets and tracking information, but it is also useful for creating quizzes. Making question and answer quizzes is a good way to improve on your Excel skills while having a bit of fun... more »

How to Create a Simple Timeline with Excel

By eHow Computers Editor

0 comments

Timelines are useful in showing events as they occur over a period of time. Excel is a great tool for creating simple timelines, thanks to a Microsoft Office template available at Microsoft.com... more »

How to Divide Cells in Excel

By eHow Computers Editor

0 comments

Excel spreadsheets can be used to perform such basic tasks as adding, subtracting, multiplying and dividing numbers in cells. Excel relies on formulas for these mathematical operations. These formulas can be created manually or automated and ... more »

How to Format a Toolbar in a Spreadsheet

By eHow Computers Editor

0 comments

Toolbars in spreadsheets are very standardized and sometimes do not contain the icons which you would like to use. The easiest way to correct this is to format the toolbar to the icons that you do use. This is much easier than having to go to the ... more »

How to Insert Identical Information Into Several Excel Worksheets

By eHow Computers Editor

0 comments

Microsoft Excel organizes its spreadsheets into tabbed workbooks, with each tabbed page an individual spreadsheet. Occasionally, you'll want to insert information from one worksheet into another, such as when you have several worksheets handling ... more »

How to Make PivotTable Reports in Excel

By eHow Computers Editor

0 comments

A PivotTable report is an interactive table that extracts, summarizes and organizes data automatically. Making a PivotTable in Microsoft Excel allows you to make comparisons, analyze information, find patterns and see trends. A PivotTable may ... more »

How to Move Between Worksheets

By eHow Computers Editor

0 comments

Spreadsheets are the greatest invention. You can do many things with them like cataloging your games or books, accounting and keeping track of work. You need to know how to manage your worksheets so you can be more efficient. Following the steps ... more »

How to Plan for Retirement With Excel Plan Sheet Pre-Made

By designervcu

0 comments

This is a great tool to organize your information, see your net worth to date and help with setting up your will for yourself and to help your loved ones... more »

How to Set Margins in Excel

By eHow Computers Editor

0 comments

A margin refers to the amount of space between the content on your page and the edge of the page you print. Microsoft Excel automatically sets your top and bottom margins at 1 inch left and right at .75 inch and header and footer at .5 inch. You ... more »

How to set up an basic excel spreadsheet

By vdcohn

0 comments

Step by step instructions regarding how to set up an excel spreadsheet... more »

How to Subtract Cells in Excel

By eHow Computers Editor

0 comments

Subtraction is one of the basic processes performed when creating and analyzing data involving numbers. In order to subtract cells in an Excel spreadsheet, the user can create a formula manually or use the SUM function... more »

How to Summarize Data in Excel

By eHow Computers Editor

0 comments

There are several ways to accomplish a single task in Microsoft Excel. Three different ways to summarize the data on your spreadsheet quickly and easily are listed below. Assume you have a dataset of "Customer," "Date," "OldSales," "NewSales" and ... more »

How to Use a Do While Loop in Excel VBA

By Keith Johnson

0 comments

If you want to master Excel VBA programming, you must master the Do While loop. The Do While loop allows you to repeat code only if certain conditions are true. And without this powerful piece of syntax, most complex VBA programs wouldn’t be ... more »

How to Use Conditional Formatting in Microsoft Excel

By eHow Computers Editor

0 comments

Microsoft Excel is a powerful tool used for many different activities and projects. From keeping up with finances to maintaining up-to-date advertising schedules, Excel often exceeds user expectations. Knowing how to utilize the program's full ... more »

How to Use Conditional Formatting Rules in Excel

By eHow Computers Editor

0 comments

Setting a conditional formatting rule in an Excel spreadsheet means that you have set a rule to format certain cells that meet the conditions of the rules you have set. For example, you may wish to highlight all the amounts above $1 million to ... more »

How to Use Excel Shortcuts for Formulas

By eHow Computers Editor

0 comments

Almost every Microsoft Excel spreadsheet will use formulas. It is extremely useful to learn shortcuts when using these formulas to help this process go much faster. These are easy to learn and fun to use. Basic knowledge of Microsoft Excel is ... more »

How to Use Excel Shortcuts with the Control Key

By eHow Computers Editor

0 comments

Excel is a powerful tool that has many keyboard shortcuts available to its users. The Control key is one of the most powerful keys to use for shortcuts and is signified by “Ctrl” on the keyboard. This key is usually placed on both the right and ... more »

How to Use Excel's Average Function

By eHow Computers Editor

0 comments

Excel's Average function returns the arithmetic mean of its arguments. In mathematics, an average may be any measure of central tendency. In common use, however, the term "average" usually refers to the arithmetic mean. The following steps will ... more »

How to Use Excel's Cell Function

By eHow Computers Editor

0 comments

Excel's Cell function provides information on the contents, formatting and location on the specified cell. This function will return information on the upper-left cell if a range of cells is specified. If no cell is specified, Cell will use the ... more »

How to Use Excel's Choose Function

By eHow Computers Editor

0 comments

Excel's Choose function returns a value from a list of arguments based on the specified index number. For example, this might be used to convert a number between 1 and 7 to the days of the week. The following steps will show how to use Excel's ... more »

How to Use Excel's Code Function

By eHow Computers Editor

0 comments

Excel's Code function determines the numeric representation for the first character in the specified text string. This value is determined by the character set being used. This will be the Macintosh character set for Macintosh computers and the ... more »

How to Use Excel's Count Function

By eHow Computers Editor

0 comments

Excel's Count function counts the cells with numbers and the numbers in a list of arguments. It also can be used to count the entries in a numeric field in an array or range of numbers. The following steps will show how to use Excel's Count function... more »

Check Out All Categories

Articles in Spreadsheets