Virtual Meetup: Programming and Problem Solving in Excel – an example in 2 parts financial modeling world cup

by Krabihometownbt1
banner



Excel is a versatile piece of software and has a lot of the characteristics of a programming language. The techniques used to build financial models can also be applied to solve other problems using Excel. By exploring the use of Excel for recreational problem solving we can often develop or pick up new techniques and methods that prove useful in traditional modelling situations.

During this session, join two financial modelling experts and recreational Excel modelling enthusiasts Dan Mayoh and Diarmuid Early as they walk through their contrasting approaches to solving a well-known TV game show game by using Excel in a programmatic way.

The game show Letters and Numbers (Australia) / Countdown (UK) / Des Chiffres et des Lettres (France) includes a ‘Letters’ game where 9 letters are chosen in a (partially) random manner, and contestants have 30 seconds to create the longest word they can from these 9 letters that is in the dictionary. Dan and Diarmuid will present their own approaches to modelling this game in Excel – starting with a text file of the complete list of Collins Scrabble Words (2019), each has built a spreadsheet that takes a 9 letter input and outputs the longest possible words that can be made from the inputs. Dan and Diarmuid will each use different Excel modelling techniques and explain their thought processes behind how they approached the modelling problem.

★ Download the resources here:
★ Join us for more virtual meetups: www.plumsolutions.com.au/meetup

Images related to the topic financial modeling world cup

Virtual Meetup: Programming and Problem Solving in Excel – an example in 2 parts

Search related to the topic Virtual Meetup: Programming and Problem Solving in Excel – an example in 2 parts

#Virtual #Meetup #Programming #Problem #Solving #Excel #parts
Virtual Meetup: Programming and Problem Solving in Excel – an example in 2 parts
financial modeling world cup
See all the latest ways to make money online: See more here
See all the latest ways to make money online: See more here

You may also like

2 comments

Joseph McDaid 12/09/2021 - 9:28 Chiều

Fascinating seeing the different approaches! Great spreadsheet problem solving Dan and Diarmuid.

Reply
Stefyu Thechosenone 12/09/2021 - 9:28 Chiều

No Links for the files ?

Reply

Leave a Comment