Fill Handle - Excel - Desk Top Publishing
One of my favorite features of Excel is the AutoFill feature. The fill handle is the little black square found in the lower left hand corner of the active cell. When you hover your mouse pointer over the fill handle it displays a + sign. You can ... [... more]
Bella Online |
Controlling Pagination - Excel - Desk Top Publishing
When you have a multi-page report, it may be important to control where each of the pages break. For example, you have a report that is sorted by responsibility centers and you want the report to break at the last record for each center. By ... [... more]
Bella Online |
Create a List of Cell Phone Numbers - Desk Top Publishing
Have you ever considered what will happen if you lost your cell phone? If you are anything like I am, every one of your important contacts are stored in that little device. I'll bet that you have become so reliant on the address book in your cell ... [... more]
Bella Online |
Eight Ways to Add Numbers in Excel - Desk Top Publishing
There are eight ways to add a set of numbers in Excel. Each method has a specific use and produces explicit results. Below is an explanation of each methodology including its usage and expected results. You can type numbers directly into a cell ... [... more]
Bella Online |
Excel - Arranging Multiple Worksheets - Desk Top Publishing
There are many reasons why you might want to view more than one worksheet on your desktop at the same time. Often we perform analyses on data that has an effect on results in another worksheet. Being able to view those effects at the same time ... [... more]
Bella Online |
AutoSum Function (Excel) - Desk Top Publishing
Excel provides the AutoSum function for creating equations that sum a column or row of numbers. You will find the AutoSum button on the Standard Toolbar. It is designed to "guess" at the range of data you want to sum by looking for numerical [... more]
Bella Online |
Excel Charting to Goal - Desk Top Publishing
In business, it's important to be able to track progress toward achieving your goals. We use charts to visually display the actual results of our progress. You can make a better analysis when you compare the actual results to the goals that have ... [... more]
Bella Online |
Excel Desktop - Formatting Toolbar - Desk Top Publishing
The Formatting Toolbar may be located aside and to the right of the Standard Toolbar (depending on which version of Word you are using) or directly below the Standard Toolbar. The Formatting toolbar provides one click access to frequently used ... [... more]
Bella Online |
Excel Desktop - Standard Toolbar - Desk Top Publishing
Directly below the Menu bar, you will find the Standard Tool bar. Toolbars provide one click access to frequently used commands. The standard toolbar displays commands that are generally associated with file and data manipulation such as opening, ... [... more]
Bella Online |
Excel-Types of Formula References - Desk Top Publishing
When you first begin using Excel, you give little thought as to how Excel adjusts the cell references when you copy a formula. You just know that it works, until you copy a formula that returns a result different from what you expected. Excel ... [... more]
Bella Online |
Glossary of Spreadsheet Terms - Desk Top Publishing
The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numeric values, text values, cell references, ranges ... [... more]
Bella Online |
Guide to MS Excel User Interface - Desk Top Publishing
If you are just starting out using Excel this series of articles will help you to learn the features found on Excel's desktop. This is your guide to the Excel User Interface where you will find an explanation for each of the features found on the ... [... more]
Bella Online |
