AI & Tech

Excel: How to reference a row dynamically

Excel MVP Liam Bastick explains the OFFSET(COUNTA) function combination, used for dynamic lookups.

Using open-source data to manage risk

The biggest benefit from the integration of open-source, nonfinancial data into decision-making could be to businesses’ risk registers.

6 technology tips to enhance finance business partnering

Start with an overall goal, understand tech’s capabilities, and benefit from collaborations that cloud-based tools allow.

EU looks to alleviate cyberthreats; IASB publishes proposed taxonomy amendments

Here is a roundup of the latest developments in the financial reporting world, with an update on the IASB’s taxonomy amendments.

Serious cyberattacks on the rise, report shows

The number of organisations hit with cyberattacks is rising, according to a new report focused on US and UK businesses.

Excel: Broken y-axis charting

Breaking the y-axis on a chart can be a useful way to display data, but the technique should be used with discretion, says Excel MVP Liam Bastick.

Using data to improve employee retention

Finance professionals are using data analytics to address employee attrition and turnover costs.

How to LOOKUP the data you want to find in an Excel range

Many options exist to search for data in Excel, but what do you do if the data is in a range?

5 steps to a digitalised reporting dashboard

Take steps to transform data into actionable insights by using a business intelligence tool, choosing new data sources, and creating an interactive dashboard.

Are you telling a story with data? You should be

A data and management consultant shows how to turn valuable information into a compelling narrative for the people you want to reach.

Identify external links in Excel without using VBA

Take a LINKS function stored as a defined range name and Transpose it via dynamic arrays.

‘Cybercrime is big-game hunting now … you need to be prepared’

The number of cyberattacks is rising. What do boards need to know from executives to protect companies?

Excel: Simple prorating over time

Excel MVP Liam Bastick provides a formulaic solution to the common financial modelling issue of how to correctly prorate amounts over time.

UK executives expect a quantum leap for quantum computing

Nearly half of UK executives with a working knowledge of quantum computing believe the emerging technology will have a significant impact by 2025, according to the results of an EY survey.

Exploring 14 new Excel functions: Part 2

In this second of a two-part article, Excel MVP Liam Bastick introduces you to new functions that shape and resize arrays.

Exploring 14 new Excel functions: Part 1

In this first of a two-part article, Excel MVP Liam Bastick introduces you to one group of functions that manipulate text and another group that combine arrays.

UK to regulate stablecoins, develop NFT with the Royal Mint

The government is looking to bring stablecoins into the UK payments network and develop a nonfungible token and a “sandbox” for financial market infrastructure.

Digital opportunity: Insights from Germany

Management accountants can help maximise value for businesses through cross-functional team working and systematic cost/benefit analyses of digital requests.

5 ways finance can drive cybersecurity preparedness

Management accountants can be invaluable in addressing cybersecurity risk.

New cybersecurity rules proposed for EU bodies amid global concerns

Governments are on high alert, anticipating Russian cyberattacks in retaliation for sanctions.

AI & Tech

Most Read