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 1
Course Outline

DURATION 1 Day
PREREQUISITES You need to have high end Intermediate or Advanced Excel Skills.
COURSE OBJECTIVES

This 3-day 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.

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.

Day 1:
Evening Tue, 14-Feb-12 and Thu, 16-Feb-12 18:30 - 21:30 £325.00 +VAT
Weekday Wed, 15-Feb-12 09:30 - 16:30 £325.00 +VAT
Weekend Sat, 17-Mar-12 10:00 - 16:30 £325.00 +VAT
Weekday Wed, 21-Mar-12 09:30 - 16:30 £325.00 +VAT
Evening Mon, 16-Apr-12 and Tue, 17-Apr-12 18:30 - 21:30 £325.00 +VAT
Weekday Mon, 23-Apr-12 09:30 - 16:30 £325.00 +VAT
Evening Wed, 16-May-12 and Thu, 17-May-12 18:30 - 21:30 £325.00 +VAT
Weekday Mon, 28-May-12 09:30 - 16:30 £325.00 +VAT
Weekend Sat, 16-Jun-12 10:00 - 16:30 £325.00 +VAT
Weekday Fri, 22-Jun-12 09:30 - 16:30 £325.00 +VAT
Weekday Thu, 12-Jul-12 09:30 - 16:30 £325.00 +VAT
Evening Mon, 16-Jul-12 and Tue, 17-Jul-12 18:30 - 21:30 £325.00 +VAT
Evening Wed, 15-Aug-12 and Thu, 16-Aug-12 18:30 - 21:30 £325.00 +VAT
Weekday Tue, 28-Aug-12 09:30 - 16:30 £325.00 +VAT
Weekend Sat, 15-Sep-12 10:00 - 16:30 £325.00 +VAT
Weekday Tue, 25-Sep-12 09:30 - 16:30 £325.00 +VAT
Evening Mon, 15-Oct-12 and Tue, 16-Oct-12 18:30 - 21:30 £325.00 +VAT
Weekday Fri, 26-Oct-12 09:30 - 16:30 £325.00 +VAT
Weekday Tue, 13-Nov-12 09:30 - 16:30 £325.00 +VAT
Weekend Sat, 24-Nov-12 10:00 - 16:30 £325.00 +VAT
Weekend Sat, 15-Dec-12 10:00 - 16:30 £325.00 +VAT
Weekday Mon, 24-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 1 is the first part of a three part course on Financial Modelling with Excel.  It builds the foundation for building strong financial models.  It will cover practical application of excel's features used to solve real world cases where people work with finance.  People who would benefit from this course include:

  • People who work with financial data

  • Accountants who wish to learn to use Excel more effectively

  • Managers who want to be able to analyse financial data

  • Analysts

  • Investors

 

Outline

  • What is Financial Modelling

  • Who uses Financial Models

  • Basic Financial Statements

    • Income Statement

    • Balance Sheet

    • Cash Flow Statement

    • Compounding

    • Capitalization

  • A Few Essential tools of the Trade

    • Keyboard shortcuts in Excel

    • CTRL combination shortcut keys

    • Function keys

    • Other useful shortcut keys

  • Importing Data

    • Converting Files from Other Applications

    • Copying Data from another Application

    • Importing Data from External Sources

    • Using Database Terminology

    • Importing Data into Excel

    • Importing Text Files

    • Refreshing data from imported text files

  • Using Microsoft Query

    • Adding a Data Source

    • Creating a Query

    • Review Questions

  • Named Ranges

    • Navigating Workbooks using cells or Range names

    • Creating named Ranges based on Cell values

    • Deleting named cells or ranges

    • Using named Cells and ranges in Formulas

    • Named Formulas and Values

    • Dynamic named ranges

  • Database and List Management

    • Using the Excel database features

    • Creating an Excel database

    • Working with an Excel database

    • Assigning a database list

    • Creating an assigned list

    • Adding summary formulas to an assigned list

    • Sorting a Database

    • Adding other sort criteria

  • Using AutoFilters

    • Filtering data

    • Filtering data with AutoFilter

    • Specifying a conditional filter

    • Using the Top 10 AutoFilter

    • Removing all AutoFilters

    • Creating Dynamic Named range using Lists and Tables

  • Functions in Excel

    • Overview of Add ins

    • Using the Function wizard

    • displaying the Insert Function wizard

    • Choosing a function from the Insert Function wizard

    • Entering Function Arguments

    • Using the Formula Auditing Toolbar

    • Using the Watch Window

  • Decision Making

    • Logical Functions

    • Lookup Functions

    • SumIf and CountIf

    • Text functions

    • Dynamic Labelling

    • Using Find

    • Counting characters

    • Extracting elements of text

    • Removing trailing spaces

    • Changing the case of text

  • Date and Time functions

    • Extracting elements of dates

    • Getting today's date and/or time

    • Working out how many years between two dates

    • Functions to count the number of whole working days between dates, excluding holidays

    • Functions to state the first working day of a month

    • Data Validation - Using Lists

  • Number Formatting

    • Common Number Formats

    • Custom Number Formats

  • Using Styles

    • Creating a new style

    • Applying a style

    • Changing the formatting of a style

    • Removing a style from cells

    • Deleting a Style

  • Formatting

    • Using conditional formatting

    • Changing and deleting Conditional Formatting

    • Finding cells with Conditional Formatting

    • Copying and applying cell formatting with the Format Painter

    • Copying and applying column width or row height with the Format Painter

    • copying and applying the Format Painter in multiple locations

    • Using Text() to add an ID

  • More on Lookup Functions

    • Index and Match

    • Choose

    • VLookup and HLookup

    • Getting Excel to apply exchange rates to foreign currency Accounts

 

 

 

 

 

 

 

 

 


 

 


Home | Contact | Terms and Conditions