Excel

Excel

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

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

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

Resources

Guide

Sponsored

A step by step guide to starting your own practice

This guide covers the key questions and decisions you need to consider when starting up an accountancy firm, and shares eight success stories.

Start your own practice_front cover

Guide

Sponsored

MTD ITSA: Use the delay to fix your compliance

thomson reuters mtd delay guide cover

New

Guide

Sponsored

An accountant's guide to a brilliant website

Moneypenny and PracticeWeb guide - Small changes stack up: An accountant's guide to a brilliant website

Guide

Sponsored

New AML rules: What you need to know

TaxCalc AWEB AML Guide

Guide

Sponsored

Be prepared for the new tax year basis rules

Tax year basis resource - AccountingWEB & Intuit Quickbooks

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

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

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

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

Excel

12th Aug 2020

ABC of Power BI: ‘D’ is for Date

by

Use Microsoft Power BI to synch reports to your business cycles

Pages