You’ve probably heard business people talking about ‘models’ in Excel.  But, the truth is, only the minority of Excel files are actually ‘models’.  That’s because models have specific properties that we explore in part 2 of the Excel Basics course.

Excel ‘Modelling’ refers to connecting cells together in Excel in terms of input, process and output to express a real-world relationship.  That sounds pretty complex, right?  But you’ve probably used Excel models already in your career.  A simple budget planner, for example, consists of inputs (expenditure / income), processes (calculations of monthly totals) and outputs (end-of-year profit / loss figure).

In part 2 of Excel Basics, we focus on Excel’s ‘Big Five’ modelling formulae with the aim of developing the key skill of spreadsheet modelling.  Along the way, we’ll try out these useful formulae, learn the important practical skill of working across sheets, and explore cool advanced conditional formatting techniques.  Let’s get started!

Session Titles And Learning Outcomes