Excel

Excel

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

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

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

Trending

Personal tax

17th Sep 2021

NIC health hike: Further complications emerge

Issues are emerging around the NIC increases due to apply from 6 April 2022 and the Health and Social Care levy due to replace that tax rise from 6...

by

NHS

Personal tax

17th Sep 2021

VAT: Filing and payment deadline warning

by

VAT

Accounting software

17th Sep 2021

Intuit adds $12bn Mailchimp to expand QBO platform

by

Sasan Goodarzi; ''Don't call QuickBooks an accounting platform'

HMRC & policy

15th Sep 2021

HMRC launches mid-sized business support team

by

HMRC

Business tax

15th Sep 2021

Corporate tax: You are not a loan

by

Solar farm

People

14th Sep 2021

ICAEW member excluded over £32,000 CIOT expulsion

by

Losing money

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

The ABC of Power BI: D is for Date

by

Use Microsoft Power BI to synch reports to your business cycles

Excel

24th Jun 2020

Excel updates: More actions with your diagrams

by

Code

Excel

10th Jun 2020

A guide to Microsoft Visio Data Visualizer

by

Excel

Resources

Guide

Sponsored

MTD for ITSA - working with landlord clients

Learn what MTD for Income Tax Self Assessment means for unincorporated rental property owners and how accountants can maximise opportunities.

MTD for ITSA cover

Guide

Sponsored

Help clients prepare for self-employed taxation

mettle

New

Guide

Sponsored

Engagement letters: From a burden to benefit

Guide

Sponsored

How to bring bookkeeping in-house

front cover

Guide

Sponsored

AML Compliance: Regulations and the five stages

the_five_stages_of_aml_compliance_smartvault_aweb

Excel

21st May 2020

Recent developments in Excel and Power BI

by

World map

Excel

8th Jul 2020

Manage, track and analyse your spending in Excel

by

Excel

Excel

12th May 2020

ABC of Power BI: “C” is for CALCULATE

by

Calculate

Excel

6th May 2020

New Excel functions: XLOOKUP and XMATCH

by

Woman working with spreadsheets

Excel

19th Mar 2020

ABC of Power BI: “B” is for bar chart

by

Bar chart

Excel

18th Mar 2020

How to solve common spreadsheet data issues

by

Spreadsheet

Excel

17th Mar 2020

Excel-based templates for successful projects

by

Anthony Stevens

Excel templates

Excel

5th Mar 2020

Working with text in Excel

by

Spreadsheet table with text

Excel

13th Feb 2020

How to detect errors in your spreadsheets

by

Number highlighted

Excel

30th Jan 2020

The importance of cleaning up data

by

vacuum cleaner

Excel

17th Jan 2020

Power BI: How to reduce your model footprint

by

Computer RAM

Excel

15th Jan 2020

Three in spreadsheet equals Fife Council calamity

by

Maddy Christopher

Spread sheet data show on tablet