Sold Out

Spreadsheet Modelling Best Practice (10am-3pm) - course request

Event Information

Share this event

Date and Time

Location

Location

Friends Who Are Going
Event description

Description

Due to limited numbers (10 per course), the Analyst Network will confirm whether you have a place

Morning module: spreadsheet modelling – the theory:

  • Identify your audience & the output
  • Ease of use, Future-proofing, Structure, Audit, Maintenance;
  • Document) Separation, (iii) Consistency, and (iv) Modularity
  • Inputs; calculations; outputs;

Then after lunch: spreadsheet modelling – the practice:

  • Keyboard shortcuts: (i) Navigation, (ii) Selection, (iii)Formula inspection, and (iv) Ribbons;

  • Building good formulas – design for longevity;

  • Masks, flags, markets, switches, etc. (use of logic formulas – AND, OR, NOT);

  • Data validation for user input;

  • Range names (inp_; calc_, etc.);

  • Conditional formatting;

Share with friends

Date and Time

Location

Save This Event

Event Saved