Recent Course Feedback: “I loved it!  The best course I have ever attended, excellent value for money and I learnt more in the first hour in his course than I have learnt in other Excel courses together. Will recommend actively to others!” – Natasha (Consultant for Finance) 28/9/2009 “I felt the course was very good value for money and I was pleasantly surprised how relevant it was to me.  Was very willing to adapt the course to our specific needs and wishes so flexibility was very welcome.” – Paul (Project Developer) 28/9/2009

Financial Modelling Excel Masterclass - Day 2 Course Outline

DURATION	1 Day
PREREQUISITES	You need to have high end Intermediate or Advanced Excel Skills, including the topics covered in the Excel Levels 1-3 courses and Level 1 of the Excel Masterclass.
COURSE OBJECTIVES	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.
COURSE DATES	Alternatively, buy a book or e-book here. Day 2: Weekday Thu, 16-Feb-12 09:30 - 16:30 £325.00 +VAT Weekend Sat, 18-Feb-12 10:00 - 16:30 £325.00 +VAT Evening Mon, 19-Mar-12 and Tue, 20-Mar-12 18:30 - 21:30 £325.00 +VAT Weekday Thu, 22-Mar-12 09:30 - 16:30 £325.00 +VAT Weekend Sat, 21-Apr-12 10:00 - 16:30 £325.00 +VAT Weekday Tue, 24-Apr-12 09:30 - 16:30 £325.00 +VAT Weekend Sat, 19-May-12 10:00 - 16:30 £325.00 +VAT Weekday Tue, 29-May-12 09:30 - 16:30 £325.00 +VAT Evening Mon, 18-Jun-12 and Tue, 19-Jun-12 18:30 - 21:30 £325.00 +VAT Weekday Mon, 25-Jun-12 09:30 - 16:30 £325.00 +VAT Weekday Fri, 13-Jul-12 09:30 - 16:30 £325.00 +VAT Weekend Sat, 21-Jul-12 10:00 - 16:30 £325.00 +VAT Weekend Sat, 18-Aug-12 10:00 - 16:30 £325.00 +VAT Weekday Wed, 29-Aug-12 09:30 - 16:30 £325.00 +VAT Evening Mon, 17-Sep-12 and Tue, 18-Sep-12 18:30 - 21:30 £325.00 +VAT Weekday Wed, 26-Sep-12 09:30 - 16:30 £325.00 +VAT Weekend Sat, 20-Oct-12 10:00 - 16:30 £325.00 +VAT Weekday Mon, 29-Oct-12 09:30 - 16:30 £325.00 +VAT Weekday Wed, 14-Nov-12 09:30 - 16:30 £325.00 +VAT Evening Mon, 26-Nov-12 and Tue, 27-Nov-12 18:30 - 21:30 £325.00 +VAT Evening Wed, 19-Dec-12 and Thu, 20-Dec-12 18:30 - 21:30 £325.00 +VAT Weekday Tue, 25-Dec-12 09:30 - 16:30 £325.00 +VAT Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £650.00 +VAT Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

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