Back to all courses
Data & AnalyticsVirtual

Microsoft Excel for Banking & Financial Analysis

Master advanced Excel functions, pivot tables, dashboards and automation using practical banking and financial datasets.

Course Overview

A hands-on programme built around practical banking and financial datasets. Participants move from data cleaning and pivot tables through XLOOKUP, INDEX/MATCH and financial calculations to management reports, dashboards and the automation of repetitive Excel tasks.

Who should attend?

✦Finance
✦Operations
✦Risk
✦Audit
✦Business Analysts
✦Relationship Managers
✦Other professionals working extensively with data

Course Outline

Advanced Excel functions for business
Data cleaning and preparation
Pivot Tables and Pivot Charts
XLOOKUP, INDEX/MATCH and logical functions
Financial calculations and analysis
Data validation and error checking
Creating management reports
Dashboards and visualisation
Practical banking/financial datasets
Automating repetitive Excel tasks

Program Details

Investment

₦300,000

Per participant

Month

September 2026

Duration

2 days

Delivery Format

Virtual

Certification

Certificate of Completion

Let's Build Your Technology Capacity

Whether you need talent, delivery teams, or workforce development, Conclase is ready to support your organization.

logo

Our Services

Contact us

Nigeria 🇳🇬

No 10, Wole Ogunjimi Street, Opebi, Ikeja, Lagos.

United State 🇺🇸

1234 Innovation Drive Denver, Colorado 80202 United States

+2347052854847

+1 (720) 555-0123

info@Conclaseint.com

© 2026. All rights reserved by Conclaseint

logo