 |
|
 |
Microsoft Excel Functions and Formula Tutorials
You use formulas in your Excel worksheets to calculate results from the data stored in the worksheet. When data changes, those formulas calculate updated results with no extra effort on your part. Excel provides a number of different ways to build formulas, letting you craft them by hand or point-and-click them into existence. Here, you'll learn about all of these techniques.
| Total: 29 | Showing: 15 | Page 1 of 2 |
 |
|
|
 Microsoft Excel / Functions and Formula Learn how to fill a range with a particular value or formula, what is fill handle, create text and numeric series with AutoFill and create your own AutoFill list. Site: excel.brainbell.com
|
||
|
|
Report |
|
|
 Microsoft Excel / Functions and Formula In this tutorial, we calculate the depreciation of an investment by using the SYD function, which returns the sum-of-years' digits depreciation of an asset for a specified period. Site: excel.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A logical operator is one used to perform a comparison between two values and produce a result of true or false. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A date is a number that represents the number of days that have elapsed from a set period in history. Learn how Microsoft Excel uses natural numbers to represent a date. Site: www.functionx.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 / 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 An expression is a combination of values and symbols used to produce a new value. To do this, there are different types of values involved in an expression. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A step by step tutorial with screenshots on how to do scenarios with different factors in excel. Site: barrelofcrafts.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Learn how to use VLOOKUP in Microsoft Excel. Once you've mastered the concept see how to use it in your models and what to watch out for. Site: www.auditexcel.co.za
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula If your spreadsheet needs to access constantly updated data, or if you need to access services hosted on another computer, Excel's Web Services support will enable you to get connected. 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 / Functions and Formula Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool transforms simple HTML tables into Excel spreadsheets. Site: www.brainbell.com
|
||
|
|
|
|
|
|
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 If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell. Site: www.usd.edu
|
||
|
|
|
|
|
|
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 A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets since the early days of Lotus 1-2-3. Site: excel.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Likewise, we can also insert rows. With the row label (number) selected you must choose the Row from the Insert menu. Again this will insert a row before the row you have selected. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula This tutorial describes CountA function. This will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
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 FrontPage|
|