Learning to EXCEL with NACM: Part 1

General Information

3-Part Webinar Series

$129 for Individual Webinar
$300 for 3-Part Package

Registration Includes: One telephone and web connection at one physical location

In this three-part webinar series, we will cover advanced
excel topics and show you how best to utilize this powerful tool.

Monday, April 25th at 3pm ET

Part I- Development of Credit Analytics using the advanced functionality of MS Excel

• Familiarize attendees with the process of Credit analysis and necessary data prerequisites
• Importing Data tables from AR ledgers and Creating tables using Pivot tables
• Advanced Excel Date, Lookup and Logical functions to develop sophisticated formulas - nested functions
• Advanced Charting Objects

Monday, May 16th at 3pm ET

Part II - Development of Credit Reporting Objects That integrate Risks.

• Development of Sophisticated Reporting Objects with Predictive Capability
    -Trend Analysis
    -Calculating DSO
    -Customer Payments Trends
    -Forecasting Methods
• Development of Credit Risk Portfolio Matrix to Enhance Credit Assessment
• Automating Monthly Credit Management Reports

Monday, August 15th at 3pm ET

Part III - Development of Wide-Ranging Credit Management Dashboards Using MS Excel.

• Dashboard Design and Object Selection
• Continue with Dashboards
• Development of Decision Support System in Excel
• Development of an Optimal Credit Policy Using Credit Analysis

Speaker Bio:

Suleman Qureshi is a credit management professional and experienced financial controller with his Master’s degree in business administration and flair of multiple IT accreditations. He has enjoyed working across the Middle East, Africa and Europe on a variety of Receivable Management, Project Financial Controlling and Customer Business Controlling challenges on complex telecommunication projects. He has focused on the training and development of teams in the areas of personal development, offshore communications, receivable management and advanced Excel training recognized by the CFO community globally.

Suleman has a special interest in building blogs to share knowledge, best practices and support with devising customized solutions for complicated situations. He strongly believes in maximizing profitability by efficiently blending IT and business controlling.

Handouts | Evaluation