HOME
 

Excel for Finance Professionals

STL
Course summary
1 day
409 - 485 GBP excl. VAT
English
Professional Training
Next available date: 25/08/2020 09:30 - Online courses
Course Dates
Online courses
25/08/2020 09:30  (English)
409 GBP
London
24/11/2020 09:30  (English)
485 GBP
23/02/2021 09:30  (English)
485 GBP
25/05/2021 09:30  (English)
485 GBP
STL courses

Excel for Finance Professionals

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... Gain best practice techniques in pulling financial information into Excel, common pitfalls to avoid when using key financial functions and some useful presentation tips. The opportunity to use example financial statements such as cashflows and look at common size statements.; ; You may also be interested in our VBA courses.


STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

Suitability - Who should attend?

Excel users from finance-related roles looking to extend their knowledge of Excel in a financially driven context.This course is a part of a wider portfolio of our Excel courses London.

Training Course Content

Setting up a Financial WorksheetLayouts of input cells and formulasTracing formula precedents, dependents, and errorsCommon mistakes to avoidConditional formatting to analyse dataHighlighting alternative row/columns of dataHighlight mistakes / errors / omissions / repetitionsUsing conditional formatting to create simple and effective dashboardsWorking with dataImporting data; formats, field labels, web query options (stock info)Use TYPE to identify data type of existing cell contentsText functions; FIND, MID,TRIM excess space in cellsUse lookup functions to retrieve and compare dataCashflow spreadsheetsIncome and Expenditure tracking tableCreate a Pivot TableUsing the Pivot Table with filters to analyse cashflowUsing a Pivot Chart to track cashflowFinancial functionsConsiderations such as:- PMT, FV, IRR, NPV- When to use XIRR and XNPV- Function with cashflows- Assumptions to avoid- APR vs APYReviewing financial statementsExample balance sheets, income statements, cashflowstatements and shareholders equityBenefits of using common size statements for comparisonsSetting up common size statements; balance sheets and incomeDefining key ratios to compare and updating changes

Expenses

List price £499 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel for Finance Professionals.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.stl-training.co.uk


Request information

Find out more about this Excel for Finance Professionals course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here