Financial Modelling Excel Masterclass

DESCRIPTION
This course is directed at experienced Excel users who are wanting to take their spreadsheets to a new level. You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use.

Day 2 builds on the foundation set in Day 1 and steps everything up a level by combining techniques to build more sophisticated spreadsheets. It also contains a number of real world exercises that participants an take away to use in their everyday work. On Day 2 you will learn how to:

• Adding Comments
• Excel Tools for doing quick Financial Analysis
  
  • Dynamic Charts
• Logical Functions
• Dates
  
  • Dealing with US Dates
  • Grouping Dates
  • Years
  • Months as a number
  • Month by Name
  • Days of the week
  • Week of the year
  • Week starting
  • Date Functions
  • Useful Date Hotkeys
• Advanced Filters
  
  • Using Advanced Filters
  • Removing all Advanced Filters
  • Applying an Advanced Filter
  • Working with Filtered Data
  • Manipulating Filtered Data
  • Totalling fields within a filtered database list
  • Creating Subtotals
  • Removing Subtotals
• Pivot Tables
  
  • Understanding Pivot Tables
  • Creating Pivot Tables
  • Dropping data into Pivot Tables
  • Modifying data and refreshing Pivot Tables
  • Grouping data within Pivot Tables
• Financial Functions in Excel
  
  • FV
  • PV
  • PMT
  • Rate
  • NPer
  • Financial Function Exercises
  • Loan Calculator
• Depreciation
• Protecting your work
• Print Areas
• Ratio Analysis
• Using Gridlines
  
  • Changing the colour of the Gridlines
  • Turning off the onscreen Gridlines
  • Printing Gridlines
• Hiding and Displaying Cells
  
  • Hiding Columns
  • Hiding rows
  • Displaying hidden Columns
  • Displaying hidden Rows