Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes categories for tags associated with Wiki and course articles.  It is intended to make it easier to trak down articles associated with a specific body of knowledge.  These are not the same as the function categories used in Excel, but a more flexible arrangement that makes it easier to find a function by its purpose.

Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT  and only those to which you have access will be listed.  You may need to login to see all the articles available to you.
 

  • Array Manipulation Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of functions and techniques to manipulate arrays. This includes resizing and reconfiguring them, or extracting some of their contents for use in other calculations.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Conversion and Text Formatting Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for value type Conversion and for formatting values as text strings.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Data Type Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Data Type functions, related to the web and enterprise powered data referencing function.  A separate section deals with functions and formulas related to identifying Value Types.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Date & Time Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for working with and calculating Serial Date and Serial Time values.  This includes deriving information about a date or time.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • DCF Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Discounted Cash Flow (DCF) functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Error Handling Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of error handling functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Information Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for deriving information about cells, worksheets and workbooks.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Logical Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Logical functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Lookup Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Lookup functions.  Those functions which are used to lookup values, but which return references rather than values, are found in the Reference Functions category.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Matching Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Matching functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Math Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for mathematical operations and standard calculations.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Ranking Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for Ranking of values.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Reference Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of functions that return References to ranges and functions that return information about ranges, such as their size and location.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Regression Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of functions that can be used for Regression analysis, including the ETS function series that can forecast values, allowing for seasonality.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Rounding and Truncation Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for Rounding and Truncation of values, and dealing with the products of division.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Statistical Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for statistical analysis of sets of values.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Summary Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for deriving Summary values for data sets.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Text String Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the Text String manipulation, formatting and output functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Value Type Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for identifying Value Types.  A separate section deals with functions and formulas related to the web-powered Data Type functions.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

  • Volatile Functions

    Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on volatile functions and formulas.

    Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.