New Skills for Greater Efficiency,” Says Dania on Staff Capacity Building

In a move to enhance operational efficiency and boost its competitive edge, AG Mortgage Bank Plc has concluded an Advanced Excel and Analytics training for its employees. The training, carried out by Precepts & Mentors and facilitated by digital skills expert Onaivi Dania and Mr. Emmanuel Daniels, aimed at improving data management, financial analysis, and decision-making capabilities across the bank.

The initiative is part of the bank’s strategy to align its workforce with its vision of becoming Nigeria’s leading mortgage provider. According to Dania, the program was necessary given the critical role data plays in mortgage banking operations such as loan processing, risk assessment, and financial reporting.

“Mortgage banking is heavily dependent on data-driven insights for loan processing, risk assessment, and financial reporting. This training ensures employees are well-equipped to handle these tasks efficiently while improving overall productivity,” Dania said.

The training covered advanced Excel functionalities, focusing on key areas such as data visualization, financial modeling, automation of repetitive tasks, and real-time business intelligence. Participants learned advanced formulas like IF, VLOOKUP, and data cleaning techniques, as well as data consolidation, What-If Analysis, and finance functions to perform loan amortization schedules and interest rate calculations.

Facilitator Mr. Emmanuel Daniels played a crucial role in ensuring participants grasped the practical applications of Excel in mortgage banking. Through hands-on exercises and interactive sessions, employees from different departments—including Risk Management, Finance, Strategy, and Operations—gained skills that will significantly enhance their workflow. Mortgage Loan Officers can now calculate loan repayments and eligibility criteria using Excel formulas, while Credit Risk Analysts can analyze customer creditworthiness and track loan default risks more effectively.

The training also featured practical case studies reflecting real-life scenarios in mortgage banking. These included mortgage loan processing, risk assessment, and loan portfolio performance tracking. Participants built dynamic dashboards to monitor default rates and modeled different interest rate scenarios using What-If Analysis tools.

“The success of the training will be measured through pre- and post-training assessments, feedback from participants, and observed improvements in daily operations,” Dania noted. “This training is not just about acquiring new skills; it is about transforming how we work and driving efficiency at every level of the organization.”

By equipping its workforce with these skills, AG Mortgage Bank Plc is positioning itself for operational excellence while reinforcing its commitment to making homeownership more accessible and affordable for Nigerians.