Excel for Finance Course

£149.00

Targeted Excel training for banking, finance and accounting roles. Master the skills finance employers look for, from pivot tables and lookups to financial functions, Goal Seek, Solver and macros. CPD accredited, online and at your own pace.

Product Total: 149.00
SKU: 9c838d2e45b2 Category:

Excel Built Around Finance Work

General Excel courses teach you what each feature does. This Excel for Finance course teaches you how finance teams use Excel: summarising thousands of transactions in seconds, pulling figures from one sheet into another, testing what happens when assumptions change, and checking every formula before a report goes out.

Whether you are aiming for your first role in finance or already work in accounts, banking, or analysis and want to work faster and more confidently, this course gives you practical skills you can use straight away.

Start at the Level That Suits You

The course includes Beginner, Intermediate and Advanced Excel training, so you have everything you need whatever your starting point. If you need to build your foundations first, the Beginner and Intermediate levels are there for you. If you are already confident with everyday Excel, you can skip straight to the level most relevant to you and focus on the advanced finance skills.

What You Will Be Able to Do

  • Summarise and analyse large data sets with pivot tables and pivot charts
  • Pull figures together from different sheets with lookup functions such as VLOOKUP
  • Build formulas that copy correctly, using absolute references
  • Use IF, nested, array, date, time and financial functions with confidence
  • Test assumptions and forecasts with Goal Seek, Solver, scenarios and data tables
  • Find and fix errors with formula auditing
  • Present results clearly with business charts, sparklines and conditional formatting
  • Save time on repetitive tasks with macros

Course Syllabus

Alongside the finance-focused content below, the course includes full Beginner and Intermediate Excel levels, which you can use or skip depending on your experience.

Data and Presentation

  • Business charts and advanced charts
  • Sparklines
  • Formatting, tables and conditional formatting
  • Sorting and filtering
  • Working across multiple worksheets and views, and freezing panes

Formulas and Functions

  • Formulas and absolute references
  • Lookup functions
  • IF and nested functions
  • Array functions
  • Date and time functions
  • Financial functions

Analysis and Modelling

  • Pivot tables and pivot charts
  • Goal Seek and Solver
  • Scenarios
  • Two-variable data tables
  • Templates

Accuracy and Automation

  • Error detection and formula auditing
  • Introduction to Macros

Is This Course Right for You?

This course suits you if you work in, or want to move into:

  • Banking and financial services
  • Accounting and finance teams
  • Financial or business analysis
  • Any role where you handle large amounts of numerical data
  • If you are involved in data analysis and data manipulation

It is also ideal preparation if you have an interview or assessment centre coming up where your Excel skills will be tested.

No previous Excel experience is required. Beginner and Intermediate levels are included in case you need them, and if you already know the basics, you can skip ahead to the advanced content.

Studying Online with Souters

You study on an interactive learning platform developed by a Microsoft Learning Partner. Each lesson is hands-on: you complete practical exercises, and a built-in virtual tutor highlights any mistakes and shows you the correct method, so you learn by doing.

  • Start the day you enrol
  • 6 months to complete the course and online assessment, with extensions available
  • Access to the course modules for 12 months, to use as a reference at work
  • Study from anywhere, on your own schedule
  • Certificate and first assessment included in the price

Your CPD Certificate

This course is CPD accredited. When you complete it and pass the online assessment, you receive a CPD-accredited certificate from Souters, a Microsoft Certified Academy, to add to your CV and show employers your Excel skills.

Buying Licences for a Finance Team

Want to upskill your whole finance team? You can buy multiple licences, and group discounts are available. Each person gets their own login and works at their own pace. Organisations can pay by invoice.

Request a Group Quote.

Take Your Finance Skills Further

Souters specialises in finance training and Microsoft Office. Pair your Excel skills with one of our finance courses:

Frequently Asked Questions

Do I need any Excel experience?

No. The course includes Beginner and Intermediate levels in case you need them. If you are already confident with Excel, you can skip straight to the advanced finance content.

How is this different from the Advanced Excel Course?

The Advanced Excel Course covers only the advanced level. Excel for Finance includes Beginner and Intermediate levels as well, and focuses the advanced content on the tools finance professionals use most, such as financial functions, modelling with Goal Seek and Solver, and auditing formulas.

Will this help me with an Excel test at interview?

Yes. The course covers the Excel skills finance employers most commonly test, including pivot tables, lookups and formulas.

How long do I have to complete the course?

You have 6 months to complete the course and online assessment, and this can be extended. You keep access to the modules for 12 months.

Can I buy the course for my team?

Yes. You can order multiple licences, and group discounts are available. Contact us for a quote.

Is the course accredited?

Yes. It is CPD-accredited, and your certificate is included in the price.