myTitle

Excel Smarter for Credit Pros

Toronto Chapter

Excel Smarter for Credit ProsTOR_1126WEB
eventThumbnailWeb Desc
CIC event

CIC Toronto Chapter · Excel Training

Excel Smarter for Credit Pros: Analyze Faster. Automate Smarter.

Six powerful Excel functions for credit and collections

Date Tuesday, November 10, 2026
Time 6:30 – 8:00 p.m. ET
Instructor Irtza Chaudhry, CCP
Price
  • Free for Toronto Chapter Members
  • Free for Toronto Chapter Students
  • $10 for Members of Other Chapters
  • $10 for Students of Other Chapters
  • $20 for Non-Members

Discover six powerful Excel functions that can simplify complex calculations, automate repetitive reporting tasks, and transform raw receivables data into actionable insights. Join us for an engaging session filled with practical demonstrations, hands-on exercises, and techniques you can immediately apply at work.

What You’ll Learn

1. TEXTSPLIT Simplify Data Extraction
Easily separate invoice numbers, payment references, and customer information from complex text.
2. CHOOSECOLS Customize Your Reports
Extract specific columns from large datasets to create focused credit and collections reports.
3. VSTACK Combine Multiple Datasets
Consolidate receivables information from different reports or business units into one dynamic dataset.
4. BYROW Automate Row-Level Calculations
Perform calculations across multiple records and streamline collections analysis.
5. LAMBDA Create Your Own Excel Functions
Build reusable formulas tailored to credit risk assessment and collections prioritization.
6. TAKE Focus on What Matters
Quickly identify top overdue accounts and create dynamic priority lists.

Practical, Hands-On Learning

Participants will work with a sample accounts receivable dataset and apply these functions to real-world credit and collections scenarios, including customer exposure, overdue balances, payment information, and collection priorities.

About the Instructor

Irtza Chaudhry, CCP

An experienced credit and collections professional specializing in Excel-based financial analysis, credit risk assessment, and reporting automation. With extensive experience delivering practical Excel training, Irtza focuses on helping professionals apply powerful spreadsheet techniques to everyday business challenges.

We look forward to seeing you there!

images/Events/chpt-event-thumb2.jpg
PD Points
PD Points icon

CCP and ACI members earn 10 Professional Development Points for attending this event.

Register
Register NowExcel Smarter for Credit ProsTOR_1126WEB