AI & Tech

Excel tips: Top 4 functions to improve efficiency in 2022

Excel MVP Liam Bastick talks about XLOOKUP, SUMPRODUCT, OFFSET, and MOD functions, limitations of the spreadsheet software, and his wish list of changes for Excel.

Excel tips: Power Query, LAMBDA function, and why Excel is still relevant today

Excel trainer Liam Bastick discusses the most common mistake accountants make when using Excel, whether Excel is outdated, and the new LAMBDA function.

Summing a dynamic range in Excel with XLOOKUP

Accountants often want to sum data, such as year-to-date costs and rolling budgets, for a period of time. Excel XLOOKUP makes the process simpler.

CFOs’ work on data analytics reaps exciting results

Once they have the data strategy, technology, and skills in place, finance leaders are finding they can use analytics to improve almost any aspect of the business.

What makes a good data strategy?

Figuring that out is essential in a business world now awash in digital information that must be collected, analysed, and interpreted.

Best practice to limit ransomware damage

Companies are reinforcing their prevention and detection efforts amid a surge in cyberattacks.

Technology’s ethical challenge

CIMA President Paul Ash, FCMA, CGMA, says new technology offers ethical challenges to the accounting profession that cannot be sidestepped.

Crypto curious? What to know before accepting digital payments

They can help lower transaction fees, but plenty of due diligence is still required.

The tech dividend

For digital transformation, workforce investment is a priority, says Andrew Harding, FCMA, CGMA, chief executive– Management Accounting at the Association of International Certified Professional Accountants.

Game on

Companies are pouring ad money into esports sponsorships and in-game advertisements to reach consumers who prefer gaming over movies and music.

Ask the expert: Blockchain

Amy Park is a US Audit & Assurance Blockchain & Digital Assets partner and in Deloitte’s National Office Accounting & Reporting Services.

What 4 experts say about the role of finance in a digital business model

Turning technology-enhanced insights into value-generating strategy creates competitive advantage.

3 steps to ensure effective cybersecurity budget allocation

With the number and complexity of attacks increasing, cyber defence spending should focus on its impact and be proportionate to the threat.

Insurers wary of providing cyber coverage amid ransomware surge

Cybercriminals are switching their targeting of healthcare facilities and municipalities to manufacturing and logistics companies.

CFO priorities: How COVID-19 rewrote the list

A focus on financial controls, moving to cloud-based applications, and supporting digital transformation and hybrid working are on CFOs’ priority lists.

6 steps to become a finance data ‘translator’

Even if you’re not a programmer or a coder, you can be a strategic go-between in your organisation.

Extracting images from Excel

How to get a large number of graphs, charts, and other pictures quickly out of a worksheet.

Why CFOs are taking on supply chain digitisation

The pandemic is one of several factors playing a role in the push for a more digital approach to optimising supply chains.

International Podcast Day special: The best of the FM podcast

The FM magazine podcast is truly global, with hosts and speakers from around the world. To celebrate International Podcast Day, hear insights from this compilation of 2021 episodes.

Microchips and the global supply chain

Take a look at the microchip shortage and the disruption it is causing in manufacturing.

AI & Tech

Most Read