Excel tips

Spreadsheet tips and tutorials to boost your knowledge of the world’s favourite accounting tool.

Excel

15th Aug 2023

ABC of Power BI: ‘O’ is for ODBC

by

Connectivity | accountingweb | ABC of Power BI: ‘O’ is for ODBC

Excel

19th Apr 2023

ABC of Power BI: ‘N’ is for Negative Numbers

by

ABC of Power BI: N is for Negative Numbers | accountingweb

Excel

2nd Nov 2022

ABC of Power BI: ‘M’ is for Model

by

ABC of Power BI: ‘M’ is for Model | accountingweb

Excel

2nd Nov 2022

Excel retains lead in race of the cash apps

by

Positive spreadsheet numbers on a computer screen

Excel

26th Oct 2022

Excel is your ideal FP&A tool

by

A businessman looking through a telescope

Excel

26th Oct 2022

The MTD tech approach: Spreadsheets

by

Richard Sergeant

Computer displaying the XLS Excel file suffix

Excel

5th Oct 2022

ABC of Power BI: ‘L’ is for lifetime learning

by

ABC of Power BI: ‘L’ is for lifetime learning | accountingweb

Excel

17th Aug 2022

ABC of Power BI: ‘K’ is for KPI rethink

by

KPIs

Excel

11th Aug 2022

Spreadsheet supremos Excel in world championships

by

Financial modelling world cup screenshot of participants

Excel

3rd Aug 2022

ABC of Power BI: ‘J’ is for Journals

by

Journal

Excel

29th Jun 2022

ABC of Power BI: ‘I’ is for Iterate

by

Sales charts

Excel

22nd Nov 2021

Identifying Duplicate Values in Excel Lists

by

Spreadsheets and graphs on a desk

Excel

3rd Nov 2021

ABC of Power BI: H is for historic balance

by

A digital stock market tracking graph

Resources

Guide

Sponsored

VAT Reverse Charge – A guide for accountants

In this whitepaper, we untangle the confusing web of VAT reverse charge, including its many applications and rules. Written by VAT expert Jason Croke.

New

Sage & AccountingWEB - VAT reverse charge whitepaper

Guide

Sponsored

The practice innovation handbook

AccountingWEB & Xero special editorial report - Practice innovation handbook

Guide

Sponsored

Audit challenges and the role of technology

Thomson Reuters audit challenges whitepaper cover

Guide

Sponsored

A step by step guide to starting your own practice

Start your own practice_front cover

Guide

Sponsored

How accountants can stay on top of the VAT updates

Sage & AccountingWEB co-branded whitepaper - VAT updates in 2023: Penalties, registration and VAT on imports

Excel

6th Oct 2021

Catch up with latest accounting tech at Live Expo

by

Meet with a huge range of exhibitors at AccountingWEB Live Expo - image of people at an exhibition

Excel

24th Sep 2021

ABC of Power BI: G is for gross profit

by

A concept of data visualisation

Excel

1st Sep 2021

Is it time to move away from spreadsheets?

by

Spreadsheets

Excel

19th Aug 2021

Excel’s flock reaches 500 LAMBDAs

by

Spreadsheet

Excel

12th Aug 2021

HMRC Excel tax calculator signals policy weak spot

by

Tax data

Excel

11th Aug 2021

Turbocharge your trial balance with Power Query 3

by

Business document report on paper and tablet with sales data and financial business growth graph.

Excel

14th Jul 2021

Microsoft revamp hits Excel, Word and PowerPoint

by

Maddy Christopher

Microsoft

Excel

14th Jul 2021

Turbocharge your trial balance with Power Query 2

by

Sheets with numbers and financial charts

Industry Insights

View all Industry insights

The latest insight from leading brands in accounting

Stay up to date with the latest updates from within the industry.

Read more

Konsolidator

28th Dec 2022

Data Visualization and Analytics in Excel

Konsolidator

21st Jul 2022

Why you're falling behind if you're using Excel

Konsolidator

28th Feb 2022

Two misconceptions about moving finance to cloud

Konsolidator

16th Feb 2022

Excel consolidation: is it still efficient?

Excel

18th Jun 2021

Move over VBA, Microsoft Office Scripts are here

by

Web-based Excel Office Scripts offer similar functionality to old desktop Macro Recorder

Excel

17th Jun 2021

Turbocharge your trial balance with Power Query

by

Turbo-charge

Excel

19th May 2021

Excel tip: Creating similar charts side by side

by

A picture of a spreadsheet used for budgeting and planning

Excel

20th May 2021

Quick fixes for Excel #N/A lookup and MATCH errors

by

Excel #N/A lookup errors fixed

Excel

12th May 2021

How Causal plans to eradicate Excel spreadsheets

by

Causal vs Excel

Excel

14th Jan 2021

ABC of Power BI: F is for Forecast

by

Forecast

Excel

28th Oct 2020

ABC of Power BI: E is for exchange rate

by

Foreign currency exchange rate on digital LED display screen

Excel

30th Sep 2020

Microsoft adds even more new data types

by

Liam Bastick looks at the new data types in Excel

Excel

9th Sep 2020

Working with new data types

by

Abstract spreadsheet image

Excel

2nd Sep 2020

Spreadsheet error halts £150m children’s hospital

by

Maddy Christopher

Royal Hospital for Sick Children, Department of Clinical Neurosciences and Child and Adolescent Mental Health Service

Excel

25th Aug 2020

Creating the new data types in Excel

by

Excel

19th Aug 2020

Two new data types in Excel

by

Budget planning

Pages