Udemy – Excel Skills For Modelling

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.
Overview
Section 1: Introduction and objectives
Lecture 1 Introduction
Section 2: Excel Shortcuts for modelers
Lecture 2 Basic shortcuts - part 1
Lecture 3 Basic shortcuts - part 2
Lecture 4 Shortcuts to the Menus
Lecture 5 Menu shortcuts Exercise
Section 3: Model design and Set-up, and Date formats
Lecture 6 Model Design and Set-up
Lecture 7 Dates in Excel
Section 4: Using $ and Named Ranges
Lecture 8 $ Introduction and Exercise
Lecture 9 $ Exercise Debrief
Lecture 10 Using Named Ranges in Excel
Section 5: Simple IF statements in Excel
Lecture 11 IF Statements introduction
Lecture 12 IF exercise - debrief
Section 6: Mixed references in Excel - an exercise to bring it all together
Lecture 13 Mixed reference exercise briefing
Lecture 14 Mixed references - exercise debrief
Lecture 15 Mixed reference exercise debrief with Named Ranges
Section 7: Logical Problem solving and Embedded IF functions
Lecture 16 Logical problem solving introduction and illustration
Lecture 17 Exercise debrief and Solution strategies
Any finance professional involved in using or building financial models.,You may have just started out in a finance career, or just be wanting to make a head-start, ready for your banking interviews.,You may be self-taught in Excel, or with no experience at all and, Excel, being so expansive, you don't know where to start!

Homepage

https://www.udemy.com/course/excel-modelling-skills/