Financial Modelling Fundamentals

See the course schedule for this course

If you want to improve your understanding and use of Excel as an important tool to work more efficiently, then this is the course for you! This two-day interactive workshop will give your Excel knowledge a kick-start, as we work through the key functions and applications for the financial sector. This course is suitable for a wide range of participants, basically if you use Excel everyday and wonder if there are easier ways of doing things, there are and this course is the one stop shop!

The focus during the course will range from file management and presentational features to more advanced functions, including named ranges and graphs. This highly-interactive environment – you will be working on your own laptop – ensures that the knowledge is quickly absorbed, and you can take away the new knowledge in one Excel workbook.

On completion of this course you will feel more confident when working with Excel on a daily basis. This also serves as a great foundation before attending the Project Finance Modelling course.

Day one

The Excel environment

• Workbooks
• Worksheets
• Toolbars
• Menus

Working with files

• Creating/Opening
• Naming convention
• Back-ups

Excel formulas

• SUM
• IF
• AND/OR
• CHOOSE
• Fixed/Relative anchoring ($/F4)

Formatting

• Borders/Patterns
• Fonts/Colours
• Alignment/Number Formats

More efficient keyboard navigation

• Ctrl Page Up/Page Down
• Shift to select
• Ctrl+Shift to select section

Macros

• Record simple macro
• Link to button/object
• Run Macros

Review spreadsheets

• Tracing Dependents
• Tracing Precedents

Day Two

Print settings

• How to set up page breaks to
• print on one or several pages
• Adjusting zoom level
• Headers/Footers

Automated fill

• Generate list 1…10, etc

Named ranges

• Insert Named Ranges
• Modify
• Delete
• Go to Named Range (shortcut)

Graphing fundamentals

• Source data
• Different chart types
• Labels
• Number formatting
• Formatting

Grouping /outlining

• Improve the presentation of your spreadsheet
• Group lines/columns

Improve Excel settings

• ‘Edit directly in cell’
• Iterations
• VBA Toolpak

What to avoid

• Size blow-out in Excel documents
• Unprofessional graphs
• Inconsistent formulas
• Complicated formulas
• Certain types of formulas
• External links

Additional tips

• Using the drawing toolbar
• Create a graph in one key stroke!

Register now

Michael Moran
+61 2 9229 7409

Next Courses Available (see all courses) Back to Top