 |
|
 |
Home »
Microsoft Excel »
Functions and Formula
::
ReportRelated Tutorials
 |
|
|
|
Microsoft Excel / Getting Started We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu -- Fill and Right. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A series or collection-based function is one that operates on a group of values. The values are stored in a collection called an array. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement. In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Site: www.brainbell.com
|
||
|
|
|
|
|
 Microsoft Excel / Charts and Graphs Unlike the orderly rows of numbers and labels that fill most worksheets, charts float above your data, locked inside special box-like containers. To take advantage of these chart boxes, you need to understand a little more about how they work. Site: excel.brainbell.com
|
||
|
|
|
|
|
 Microsoft Excel / Functions and Formula Learn the basics of formulas in Excel: how to write and use them, using absolute and relative references, and using the fill handle with formulas. |
||
|
|
|
|
|
|
Microsoft Excel / General Formatting Microsoft Excel provides a faster and customized technique used to to apply a particular and user-created format that can be applied to a series of cells. As effective as that technique is, it has its own limitations. Site: www.functionx.com
|
||
|
|
|
|
|
 Microsoft Excel / Getting Started You can use the Find and Replace feature to quickly locate every occurrence of a specific string (a series of characters) in a worksheet and then have Excel actually update the cells that it finds with new text or numbers. Site: excel.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Microsoft Excel provides a series of functions destined to perform various types of financially related operations. These functions use common factors depending on the value that is being calculated. Many of these functions deal with investments or loan financing. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Macros How to create a Menu for a spreadsheet using macros. What we will do is create buttons from Macros and use our design skills to create a pretty impressive looking layout. |
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula While exporting spreadsheets as XML is useful, Excel also lets you import information this way, letting you create spreadsheets using SpreadsheetML. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Although Excel and other spreadsheet programs are the traditional interfaces for creating and reading spreadsheets, sometimes you might need to create .xls files directly from other programs. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / General Formatting A simple way to create a linking system within Excel, to create a Table of Contents. |
||
|
|
|
|
|
|
Microsoft Excel / Charts and Graphs In this tutorial you will learn how to create Pivot Tables and Reports in Excel. Site: barrelofcrafts.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|