Spreadsheets

How to Use Excel's VDB Function

By eHow Computers Editor

0 comments

Excel's VDB function stands for variable declining balance. It returns an asset's depreciation set over the specified period. It includes partial periods and the balance declines at the specified rate. The following steps will show how to use ... more »

How to Use Excel's VLOOKUP Function

By eHow Computers Editor

0 comments

The Excel function VLOOKUP stands for vertical look up. It searches for a specified value in the first column of a table. It returns the value from the same row in a specified column of that table. VLOOKUP should be used instead of HLOOKUP when ... more »

How to Use Excel's WEEKNUM Function

By eHow Computers Editor

0 comments

Excel's WEEKNUM function determines the week of the year in which a specified date falls. It returns an integer ranging from 1 to 53 inclusive to indicate that week's position within the year... more »

How to Use Excel's WEIBULL Function

By eHow Computers Editor

0 comments

Excel's WEIBULL function calculates the Weibull distribution, named after Waloddi Weibull, its creator, and is used in reliability analysis. Weibull analysis can make predictions about the life expectancy of a product, determine which product is ... more »

How to Use Excel's WORKDAY Function

By eHow Computers Editor

0 comments

Excel's WORKDAY function returns the number of work days before or after a specified date. It will not count weekends or other dates designated as holidays and frequently is used to calculate delivery times or invoice due dates... more »

How to Use Excel's YEAR Function

By eHow Computers Editor

0 comments

Excel's YEAR function returns the year of a given date. The returned year will be an integer between 1900 and 9999 inclusive. Date conversions are needed by spreadsheets because dates are frequently an essential factor in data analysis. The ... more »

How to Use Excel's YEARFRAC Function

By eHow Computers Editor

0 comments

Excel's YEARFRAC function determines the fraction of the year separating two specified dates. It is typically used to calculate the fraction of a year's worth of benefits or obligations that should be assigned to the specified period... more »

How to Use Excel's ZTEST Function

By eHow Computers Editor

1 comments

Excel's ZTEST function returns the one-tailed probability of a z-test. This is the probability that the sample mean will be greater than the observed mean. The ZTEST function is used for hypothesis testing when the sample observations come from a ... more »

How to Use Find and Replace in a Spreadsheet

By eHow Computers Editor

0 comments

When you have a spreadsheet with hundreds of records, "Find" and "Replace" are invaluable tools. They can be used together or separately. They can be used to find records in a range as well as in the whole spreadsheet. The following will help you ... more »

How to Use Formulas in Excel

By eHow Computers Editor

0 comments

An Excel formula is one of the many time-saving features in the software program. Formulas help to automate the calculations that a user specifies and, once created, they can be used as many times as needed. One of the most important features of ... more »

How to use goal seek function in EXEL

By JackBas

0 comments

Shows and gives an example of how to use the Goal Seek function in EXCEL 2003. Goal seek is a useful tool in excel for when you know what the answer should be but you do not know the variable to get it. I pretty much goes through your functions ... more »

How to Use Microsoft Access

By Strat777

0 comments

~ Myspace.com/fallenshortrocks ~ This will help with those who are having trouble starting out on Microsoft Access. It is a great program, just a little complicating at first. Good luck!.. more »

How to Use Photoshop In Better Way With These Secret Tips

By jaindinu

0 comments

This article will help you in learning the photoshop hidden secret tips.It is proven that by using software shortcuts can boost up productivity. Here are some secret Photoshop shortcuts. Well, what I mean by "secret" is that these ... more »

How to Use Security Features in Excel

By eHow Computers Editor

0 comments

Microsoft Excel has security features to help protect your spreadsheets from a number of potentially harmful events. Newer versions of Microsoft Excel even have security measures designed to keep your computer safe. Password protected ... more »

How to Use Simple Formulas in Excel

By eHow Computers Editor

0 comments

Whether you need an intricate spreadsheet for your business or a simple report for the booster club at school, Excel software fits the bill. To really leverage the software, take advantage of the many pre-built formulas it contains. You'll find ... more »

How to Use Special Characters in Excel Formulas

By eHow Computers Editor

0 comments

There are five special characters that are commonly used in Microsoft Excel 2007 workbooks. The special characters all serve different functions to make sure that Excel correctly understands your formula. Keep reading to learn what these special ... more »

How to Use SPSS to Analyze Data

By chinne01

0 comments

Many have never heard of SPSS but if you are a college student there will come a time when you will have no choice but to learn it and learn it quickly. SPSS is a very effective and efficient way to analyze data. Data can be a number of things ... more »

How to Use Subtotals in Excel 2003

By eHow Computers Editor

0 comments

If you have many numbers to crunch, subtotals can save time and make your worksheet more comprehensible. Follow these steps to add subtotals to columns in Excel 2003... more »

How to Use the Excel Chart Wizard

By eHow Computers Editor

0 comments

Charts and graphs are pictorial representations of data. They are useful for viewing, measuring and understanding the trends present in a group of data that are otherwise difficult to see. The Excel Chart Wizard is a tool that makes creating ... more »

How to Use the Pivot Table Wizard in Excel 2003

By eHow Computers Editor

0 comments

Excel 2003's "PivotTable Wizard" can organize hundreds of rows of data in seconds. The wizard will set up a pivot table in several easy steps, described here... more »

How to Use the Ribbon in Excel 2007

By eHow Computers Editor

0 comments

Microsoft Office 2007 introduced a number of significant changes to Office applications. One of the most significant changes is the "Ribbon," a new way to control some Office applications, including Word, Excel, PowerPoint and Access. The typical ... more »

How to Validate Data in Excel

By eHow Computers Editor

0 comments

In most Excel worksheets, data can be freely entered and changed without restrictions. In certain circumstances, it's more useful to allow only data that meets your requirements to be entered. You can validate data in Excel by simply restricting ... more »

How to View an Excel 2007 Spreadsheet in Excel 2003

By eHow Computers Editor

0 comments

Dedicated users of Microsoft programs such as the Microsoft Office Suite, which includes Excel, enjoy the ease of use and the features that these programs provide. However, they may find it tedious to keep up with the regular release of updated ... more »

How to Write an Excel VBA Program

By Keith Johnson

0 comments

Microsoft Excel Visual Basic for Applications (VBA) is pretty easy to learn. And with a little practice, you can master this powerful programming language and add time-saving automation to all of your spreadsheets... more »

Check Out All Categories

Articles in Spreadsheets