AI & Tech

How to reference formulas in the same Excel worksheet

When it comes to crafting the most effective spreadsheets, modellers are wise to remember that less can be more.

Data holds the answer, but finance finds it

One expert says financial professionals must think beyond numbers, and having solid interpersonal and problem-solving skills is key.

Digital-only banks? Asia-Pacific consumers say ‘yes’

Mobile-centric consumers prefer digital channels, and digital-only banks will gain ground, Forrester survey says.

How fintech changes a management accountant’s job

Technologies used in the financial services industry are altering the ways finance departments work.

Upskilling for the digital age

The rapid adoption of technology in the workspace requires financial professionals to enhance their critical-thinking and related skills.

How to properly date an Excel model

A formula-based approach can allow spreadsheet modellers to build a full financial time series from just three lines of data.

What digital transformation teaches finance leaders

Professionals at DBS Bank, Tricor, and Roche realised it’s not solely about technology, and offer tips for success.

IT shifts its role amid new tech adoption

The role of IT within organisations is changing as the adoption of cloud and internet of things technologies continues to transform business capability.

Weak links: Third-party vendors and cyberfraud

Companies need new strategies for dealing with third-party vendor cybersecurity risk as automation and cloud computing complicate vendor chains.

Why finance must become a data steward

A data governance and compliance expert explains how AI capabilities and new regulations push the collection of personal information to a higher level of risk.

Blockchain vendors need to focus on buyers’ needs

A report finds that businesses are looking for market clarity before adopting enterprise blockchain platforms.

MOD-elling periodic transactions in Excel

Spreadsheet modellers can use the MOD function to obtain residuals and handle calculations at regular time intervals.

Talent strategies for the digital age

Technology is changing the way we work, but most organisations have not refreshed their leadership development, job designs, or rewards system. Here are strategies to attract and develop talent in the digital age.

Making sense of micro-targeting

How can companies make the most of rapidly evolving marketing opportunities?

Lessons from a finance system implementation

The finance director of a 500-employee home care provider in the UK reveals what the company learned putting in a new accounting platform.

Find the real value with this Excel technique

Learn the spreadsheet skills necessary to determine pre-tax cost of equity and net present value for assets, businesses, and more.

Tips for complying with GDPR, avoiding big fines

Close to half of European companies are noncompliant or unsure about their compliance with the EU’s General Data Protection Regulation. Here are tips to help catch up.

Delivering AI ‘explainability’

There is a consensus building that AI decision-making needs to be transparent and explainable, an FCA executive said at a recent London conference.

In focus: The next frontier

Here’s an interactive graphic from Reuters detailing where we’ve been in space, where we may be headed, and the role of private companies in building satellites and rockets.

How to reference formulas in same Excel worksheet

Spreadsheet modellers should take care to remove unneeded mentions of the current worksheet name.

AI & Tech

Most Read