Microsoft Excel for Finance
Our brand new course takes a practical hands-on approach to developing your excel skills and enhance efficiency while learning how to manage finances. The course covers spreadsheet functions, techniques and formatting to support you to build upon managing your finances.
Please note not all of the content below will be covered. If you have any topics you would like in the course, please ensure you express this when booking.
How to calculate a ratio
How to score / rank stocks / funds
How to analyse a portfolio
How to chart an indicator (technical analysis)
How to manage and store large amount of data
What is analysis
Drop down menu
How to build a model
Some useful shortcuts
Primary key / unique identifier / field / record
Create an add-in
Create a template
How to map data
Functions: SUMIF, COUNTIF, MAX, MIN, AVERAGE, CONCATENATE, LEFT, VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, OFFSET, LEFT, TODAY, ADDRESS
Summarising checks (tab)
Text functions – Len, Right, Find, etc
Use of the camera
You will leave with course with an advanced knowledge of excel and finance modelling. We intend for this to increase your employability as well as your personal finances.
This course is an instructor-led group course.
Course Dates: 13th May
Course Time: 1pm – 5pm
Please note the time may extend depending on the demand of Course Content.
Fee: £10 per person. Payment must be made to confirm book. Please use the donate section below to make payment.
Open to the General Public.