Blog

The Benefits of Combining Spark with the LAMBDA Function in Excel

For financial analysts and actuaries creating complex business logic in Excel, they may need advanced functions not available in Excel. Traditionally, analysts and actuaries have used VBA to create user-defined functions, but another option to consider is the LAMBDA function.

Auditors Don’t Like Spreadsheets – A New Solution for Employee Benefit Actuaries

As every employee benefit (EB) actuary knows, pricing employee benefits is inherently complex. Spreadsheets are the predominant tool used by EB pricing actuaries, which can create challenges at audit time.

How AI Will Change Risk Mitigation

Regulators are looking at risk not just in individual models but across a financial institution’s entire portfolio to see how well risk is really managed and are increasingly focused on how adding governance to how models interact with each other to avoid negative impact..

3 Success Stories of Converting Spreadsheets to Code

How does a business continue to operate when Excel models take months or years to code, but competitive pressure demands a quicker go-to-market strategy? ‍Here are three customer stories that show how Coherent helped convert spreadsheets for greater success.

Regulatory Watch: What Banks Should Keep an Eye On - June Update

The potential regulatory changes stemming from the recent bank failures continue to be a source of activity across multiple agencies and branches of government in Washington, DC. Coherent is committed to helping you stay in the know with our regulatory updates..

Pain Points of the Modern Actuary—And How to Solve For Them

The underlying theme in the challenges facing the modern actuary is the dependence on Excel despite its known constraints. The industry needs an actuarial transformation that enables actuaries to independently create, manage, and run scalable, automated, cloud-based models without specialized programming skills.

How to be Nimble Like a FinTech – And Win SECURE 2.0 Business

With so much opportunity at stake, traditional financial services companies not only have to worry about the government stepping in but also the risk of venture-backed fintech companies. Here's how to be nimble and win SECURE 2.0 business.

Actuary 3.0 - What Is It and How Do You Get There?

To achieve complete actuarial financial transformation, actuaries must use Excel for its intended purpose while automating other pieces of the process to bring much-needed scale, control, and governance.