Course Overview
This course explores how dynamic arrays have reshaped Excel and made it Turing complete, with its liberal use of LET, LAMBDA, eta lambdas etc. LET invites complexity but reduces memory requirements, LAMBDA allows you to build anything, and dynamic arrays make it easy to quite literally extend your ideas and your way of thinking, creating a financial model in the process. Discover how to expand your ideas and streamline your modelling process using Excel’s cutting-edge capabilities.
What you will learn
Through a dynamic array of best practice tips, tricks, functions and features, this course shows you how to revamp and reinvent your financial models with Excel 365. Recreate your development kit in this brave new world. Learn how to create robust, scalable, financial frameworks tailored to your needs.
Course Structure
Delivered: Online, enrolment for 12 months.
Course prerequisites: While there are no entry requirements, a basic understanding of Microsoft Excel and accounting is recommended.
Assessment: Yes (Quizzes)
Outcome: A completion certificate is issued by SumProduct upon successful completion of the course.
Digital badge: You’ll be eligible for a digital badge, issued by FINSIA and Credly, available upon request.
Enrolment information: Your details will be shared with SumProduct within 1 business day of enrolment.
SumProduct will process your enrolment within 2 business days of receiving this information and will provide login details to access your learning via email. For any assistance, please contact our team at education@finsia.com.
FINSIA member exclusive
FINSIA members enjoy a 10% discount on SumProduct’s suite of online courses.*
*This discount has been applied to the member pricing displayed.
