Skip to content Skip to sidebar Skip to footer

Excel Skills for Modelling

Excel Skills for Modelling

Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.16 GB | Duration: 2h 39m

Learn essential Excel before starting our Financial Modelling Best Practice course

What you’ll learn
Learn essential Excel skills needed to build flexible, dynamic financial models
Learn and apply keystroke shortcuts to speed up Excel efficiency
Understand the logical design structure of an Excel model to make life easy
Learn and apply Excel ‘dates’ formula to structure flexible timelines in models
Learn and apply the fundamentals of $ in cell referencing and the IF function
Download and practice Excel skills with included exercises and tutor debriefs

Requirements
No Excel experience needed – this course covers essential skills for beginners.

Description
If you are self-taught Excel, or not used it at all before, where do you start? This foundation program will teach you essential skills for getting going with financial modelling. It covers the fundamentals you need – from model design and layout, using date timelines and efficient formatting through to the proper use of $, Named Ranges and the most frequently encountered Excel function: the IF statement. You will also look at logical problem solving where there are multiple outcomes: using embedded IF statements. When you are happy with this, you’ll be able to quickly progress through our full Financial Modelling course. Course contentIntroduction and course content – an intro to model building in Excel Excel keystroke shortcuts – for navigation, menu access, speed and efficiencyModel design and layout, including date timelines – how to set up models and efficient, consistent formatting to make them easy to readUsing $ to anchor cell references, and using Named Ranges as an alternative to add clarity and logic to your formulaeUsing the IF statement for key decision making in models – and applying this to a downloadable exerciseApplying your skills to a typical mixed-reference problem – dealing with multiple variables but keeping formulae consistent across rowsLogical problem solving with embedded IF statements for independent variables – what to do when there are multiple outcomes to consider, each input being independent.

KECSELROFFOERFDMODELINGAFTGEESEKDILER

 

you must be registered member to see linkes Register Now

Leave a comment