HOME
 

Excel for Finance Professionals

STL
Course summary
Length: 1 day
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Excel for Finance Professionals



Courses never cancelled. 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.

Suitability - Who should attend?



Excel users from finance-related roles looking to extend their knowledge of Excel in a financially driven context.

Also see all our of Excel courses London.

Training Course Content



Setting up a Financial Worksheet

Layouts of input cells and formulas
Tracing formula precedents, dependents, and errors
Common mistakes to avoid

Conditional formatting to analyse data

Highlighting alternative row/columns of data
Highlight mistakes / errors / omissions / repetitions
Using conditional formatting to create simple and effective dashboards

Working with data

Importing data; formats, field labels,
web query options (stock info)
Use TYPE to identify data type of existing cell contents
Text functions; FIND, MID,
TRIM excess space in cells
Use lookup functions to retrieve and compare data

Cashflow spreadsheets

Income and Expenditure tracking table
Create a Pivot Table
Using the Pivot Table with filters to analyse cashflow
Using a Pivot Chart to track cashflow

Financial functions

Considerations such as:
- PMT, FV, IRR, NPV
- When to use XIRR and XNPV
- Function with cashflows
- Assumptions to avoid
- APR vs APY

Reviewing financial statements

Example balance sheets, income statements, cashflow
statements and shareholders equity
Benefits of using common size statements for comparisons
Setting up common size statements; balance sheets and income
Defining key ratios to compare and updating changes

Expenses



Prices from £1484. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


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.microsofttraining.net

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 first annual U.K. L&D Report!

UK L&D Report

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