Wiki Home

Clarkson ITT Wiki logoThe Clarkson ITT Wiki is a reference library that includes technical reference materials and articles, tutorials and lessons on the use of Excel, Power BI and Visual Basic for Applications for modelling, analysis, reporting and dashboarding.  It includes articles on PowerPoint and Word on subjects that are relevant to financial professionals' work related to these subject areas.

It is integrated with our subscription program - The Learning HabITT - and some of this content forms part of the Learning Pathways  provided by that program. A part of the wiki is accessible to the public, some is available free of charge to those with a subscription to our site, and some of the content is available only to alumni of our courses and subscribers to The Learning HabITT.

The sections below describe the various elements of the wiki and provide links to index entries for those parts of the wiki. All articles within the wiki are tagged, and clicking on the tags will display a list of related articles. The articles may also be searched using the search box at the top of each web page on this site.

Ready Reference iconReady Reference

A set of tables providing quick access to key technical information on shortcuts, format codes, operators, function information.
 

FROSTED Checklist iconFROSTED Checklist

A checklist of critical elements in building robust and transparent models and analyses in an easy to remember acronym.
 

Nuts and Bolts iconExcel Fundamentals

Short written and video articles presenting fundamental technical knowledge about Excel data, formatting and formulas.
 

Excel How To iconExcel How To

Short written and video articles that demonstrate how to undertake common tasks in modelling, analysis and presentation.  It also includes quick tips on how to fix common problems and to set options in Excel .

Function Reference iconExcel Function Reference

Technical information on the use of Excel worksheet functions, their arguments, return values, value types,errors returned and troubleshooting tips.

Category Indexes
Clarkson ITT Wiki logoWiki Index by Category

The category tags listed in the category list provide access to lists of articles tagged by subject area.

Function Reference iconFunction Index by Category

Technical information on the use of Excel worksheet functions, their arguments, return values, value types,errors returned and troubleshooting tips.

Clarkson ITT builds & delivers
expert training, in classrooms
& online, for professionals in
finance, funds management &
accounting - developing their
skills in modelling and analysis.

Contact

+61 2 9871 0399
PO Box 104
West Pennant Hills NSW 2125
Australia
Clarkson ITT Company page