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 Habit  - 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 Habit .

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.

Quick Fixes iconQuick Tips and Fixes

Short written and video articles presenting solutions to common issues which are simple and easy to implement.

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.

How To iconHow To

Short written and video articles that demonstrate how to undertake common tasks in modelling, analysis and presentation.

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.

How To iconVBA Fundamentals

Short written and video articles presenting fundamental technical knowledge about VBA, the programming environment and working with the object model..

VBA How To iconVBA How To

Short written and video articles that demonstrate how to undertake common tasks in programming in VBA.

Learning Pathways iconLearning Pathways 

A set of study guides to assist the user in traversing the materials provided in the Wiki and in The Learning Habit .