Spreadsheets

How to Use an If Then Statement in Excel VBA

By Keith Johnson

0 comments

Almost all programming languages use an If Then statement--and Microsoft Excel VBA is no exception. With the If Then statement, you can have your spreadsheets take action when certain conditions are met, giving your programs the power to make ... more »

How to Use Different Shapes in WordArt

By triciagoss

0 comments

WordArt is a fun tool to use in many Microsoft Office applications. You can choose from one of the many standard WordArt shapes and layouts in the WordArt gallery. You can also alter selections by changing the shape. Read on to learn how to use ... more »

How to Use Excel Shortcuts for Charts

By eHow Computers Editor

0 comments

Making charts in Microsoft Excel is simple. It can even be simpler when a person utilizes all the shortcut keys that are available to use in this program. If a person is frequently making charts in Excel, these shortcuts can save a lot of time ... more »

How to Use Excel Shortcuts for Different Views

By eHow Computers Editor

0 comments

Microsoft Excel is ideal for many different projects. Some of these projects become very large and viewing all the data can be cumbersome when trying to filter through a mass of data. Using different views within Excel makes this process easier. ... more »

How to Use Excel Shortcuts to Edit Cells

By eHow Computers Editor

0 comments

When using Microsoft Excel, editing cells is one of the most common tasks people perform in this program. Utilizing the shortcut keys that are available to accomplish this task will make a person much faster and productive when working on ... more »

How to Use Excel Shortcuts Using the Function Keys

By eHow Computers Editor

0 comments

Function keys are one of the greatest tools a keyboard offers. They allow for many different shortcuts in different programs. Microsoft Excel is no exception. Utilizing the shortcuts available with the function keys will have a huge impact on ... more »

How to Use Excel Shortcuts With the Keyboard

By eHow Computers Editor

0 comments

The mouse was a great invention to navigate around the computer, but the keyboard is still the most efficient way to work, especially in Microsoft Excel. Literally hundreds of shortcuts exist using the keyboard. Learning to utilize keyboard ... more »

How to Use Excel to Get Organized

By eHow Home & Garden Editor

1 comments

If you're familiar with Excel, it can be a handy tool to help you get and stay organized with a number of different things. Here are just some ways you can use Excel to keep track of personal finance, food shopping, household chores and general ... more »

How to Use Excel to Publish to SharePoint Servers

By eHow Computers Editor

0 comments

Publishing Excel spreadsheets on SharePoint is an asset to many companies in business today. Posting vital information to your website the fastest, may result in immediate profits. As long as you have permission to save files on the SharePoint ... more »

How to Use Excel's ACCRINT Function

By eHow Computers Editor

0 comments

Excel's ACCRINT function calculates accrued interest on an investment that pays a periodic interest. This function's name stands for "ACCRued INTerest" and it is a member of Excel's library of financial functions... more »

How to Use Excel's ACCRINTM Function

By eHow Computers Editor

0 comments

Excel's ACCRINT function calculates accrued interest on an investment that pays a periodic interest. This function's name stands for "ACCRued INTerest" and it is a member of Excel's library of financial functions. The following steps will show ... more »

How to Use Excel's AMORDEGRC Function

By eHow Computers Editor

0 comments

Excel's AMORDEGRC function calculates the depreciation of an asset over an accounting period and prorates the asset if it is acquired in the middle of the accounting period. This function applies a depreciation coefficient that is dependent upon ... more »

How to Use Excel's AMORLINC Function

By eHow Computers Editor

0 comments

Excel's AMORLINC function calculates the depreciation of an asset over an accounting period and prorates the asset if it is acquired in the middle of the accounting period. This function is used in the French accounting system that allows for the ... more »

How to Use Excel's AveDev Function

By eHow Computers Editor

0 comments

Excel's AVEDEV function calculates the average of the absolute deviations of the specified values from their arithmetic mean. However, in statistics, the average of the absolute deviations may use any measure of central tendency to determine a ... more »

How to Use Excel's Average A Function

By eHow Computers Editor

0 comments

An average in mathematics may be any representative sample of a data set and does not indicate a particular method of calculation. Excel's Average A function calculates the arithmetic mean of the specified arguments, commonly referred to as ... more »

How to Use Excel's BESSELI Function

By eHow Computers Editor

0 comments

Excel's BESSELI function stands for "Bessel Imaginary" because it returns the solution to a modified Bessel function of the first kind for a purely imaginary number. Bessel functions have a variety of real-world applications, especially in ... more »

How to Use Excel's BESSELJ Function

By eHow Computers Editor

0 comments

Excel's BESSELJ function returns the solution to the first linearly independent solution for a Bessel function. Bessel functions have a variety of real world applications, especially in electromagnetism and heat conduction... more »

How to Use Excel's BESSELK Function

By eHow Computers Editor

0 comments

Excel's BESSELK function returns the solution to the second linearly independent modified Bessel function for a purely imaginary number. Bessel functions have a variety of real-world applications, especially in electromagnetism and heat conduction... more »

How to Use Excel's BetaDist Function

By eHow Computers Editor

0 comments

Excel's BetaDist function calculates the cumulative beta probability density function. This function is used to measure the variation of a fraction of something across samples such as the amount of time people watch television each day. The ... more »

How to Use Excel's BetaInv Function

By eHow Computers Editor

0 comments

Excel's BetaInv function is the inverse function of the specified beta distribution. Therefore, if a probability is given by BetaDist (x,…), then x is given by BetaInv (probability,…). A beta distribution is frequently used in project planning to ... more »

How to Use Excel's BIN2DEC Function

By eHow Computers Editor

0 comments

Excel's BIN2DEC function converts a binary number (base 2) to a decimal number (base 10). This conversion is frequently needed in programming because machine language is in binary, but humans use the decimal system... more »

How to Use Excel's BIN2HEX Function

By eHow Computers Editor

0 comments

Excel's BIN2HEX function converts a binary number (base 2) to a hexadecimal number (base 16). Computer programming frequently utilizes this conversion because machine language is in binary but is often represented with hexadecimal characters. The ... more »

How to Use Excel's BIN2OCT Function

By eHow Computers Editor

0 comments

Excel's BIN2OCT function converts a binary number (base 2) to an octal number (base 8). This conversion is frequently needed in computing and engineering because machine language is in binary and some character sequences are expressed in octal ... more »

How to Use Excel's BinomDist Function

By eHow Computers Editor

0 comments

Excel's BinomDist function returns the individual term binomial distribution probability. It is used to solve statistical problems where the number of tests is fixed and a test outcome is either a success or failure. The tests must be independent ... more »

How to Use Excel's Ceiling Function

By eHow Computers Editor

0 comments

Excel's Ceiling function rounds the specified number away from zero to the nearest multiple of the specified significance. It is closely related to the Floor function and frequently used on dollar amounts to prevent inconvenient pricing. The ... more »

Check Out All Categories

Articles in Spreadsheets