|
Microsoft Office Development and Consultancy |
| Home | | | Excel | | | VBA | | | C# | | | Finance | | | Tools | | | Newsletter | | | Feedback | | | Contact |
| Excel > Functions | < Previous | Next > |
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| Expand | - | Getting Started |
| Step By Step | - | New Functions in 2013 |
| Step By Step | - | New Functions in 2010 |
| Step By Step | - | New Functions in 2007 |
| Step By Step | - | Nesting Functions |
| Step By Step | - | Editing Functions |
| Step By Step | - | AutoSum |
| Step By Step | - | Counting Functions |
| Step By Step | - | Lookup Functions |
| Step By Step | - | VLOOKUP Function |
| Step By Step | - | HLOOKUP Function |
| Step By Step | - | MATCH Function |
| Step By Step | - | INDEX Function |
| Step By Step | - | CONVERT Function |
| Step By Step | - | AGGREGATE Function |
| Step By Step | - | SUBTOTAL Function |
| Step By Step | - | SUBTOTAL Function - Hidden Rows |
Function Categories |
| Complete List | - | Cube - These are used to extract data from Analysis Services cubes. |
| Complete List | - | Database - These are used to analyse, count, add and filter data stored in lists or databases. |
| Complete List | - | Date and Time - These are used for entering and calculating dates and times. |
| Complete List | - | Engineering - These are used to handle complex numbers, conversions and measurements. |
| Complete List | - | External - These are used to retrieve data from external sources. |
| Complete List | - | Financial - These are used for depreciation, accrued interest, annuities, rates of return and future values. |
| Complete List | - | Information - These are used to identify the contents of cells and determine any errors or blanks. |
| Complete List | - | Logical - These are used to perform conditional analysis and apply logical conjectures to your data. |
| Complete List | - | Lookup and Reference - These are used to locate references and specific values within tables of data. |
| Complete List | - | Maths and Trigonometry - These are used for rounding, ranking, analysing trends and to calculate probabilities and logarithms. |
| Complete List | - | Statistical - These are used for standard deviation, distributions, square roots, average, median. |
| Complete List | - | Text - These are used for entering, searching, replacing and manipulating text strings. |
Advanced |
| More Details | - | Distribution Functions |
| More Details | - | Double Minus Operator |
| More Details | - | Advanced Techniques |
| More Details | - | Version Changes |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
| More Details | - | Knowledge Base - Numerical |
| More Details | - | VBA Code |
Shortcut Keys |
(Alt + = ) - Inserts the SUM function (AutoSum). | ||
(Shift + F3) - Displays the (Insert > Function) dialog box. | ||
(Ctrl + A) - Displays the formula palette after you type a function name. |
Options |
(View tab, Zero values) - This determines if empty cells contain a zero or not. This will affect the value returned from some worksheet functions (e.g. AVERAGE). |
Related Sections |
| GoTo | - | Dates & Times |
| GoTo | - | Formulas |
| © Better Solutions Limited 10-May-2013 | Top |