Log in
Sign up
Subscribe to Newsletter
Search
Search
Menu
Tax
Personal tax
Business tax
HMRC & policy
Practice
Practice strategy
General practice
Skills
Business
Financial reporting
Management accounting
Finance & strategy
Business
sponsored by
Tech
Accounting Software
Practice Software
Excel
Tech Pulse
Tech
sponsored by
Resources
Ebooks
Podcasts
Industry Insights
Software Reviews
Small Business Accounting
Practice Management
Making Tax Digital
See All Categories
Any answers
Latest
Most Recent replies
Most Liked
Opinion
Search
Search
Subscribe to Newsletter
Tech
Excel
Excel
Excel
Spreadsheet tips and tutorials to boost your knowledge of the world’s favourite accounting tool.
Subscribe for the latest Excel tips and tutorials Newsletter
Enter email address
*
Enter email address
Sign up
12th Nov 2019
New views for Power Query
5th Nov 2019
1 comment
Dynamic Arrays vs legacy array formulae
30th Oct 2019
Do not be scared of Power BI
Advertisement
16th Oct 2019
Death of data tables and PivotTables?
2nd Oct 2019
Can you learn Power BI in a day?
Trending
Business tax
VAT: Getting a pizza of the action
Personal tax
Unreasonable behaviour: Taxpayer fine increased
Personal tax
IHT: Unintended consequences of a shared home
HMRC & policy
What the tax policies will mean for your clients
Finance & strategy
Christmas presents for accountants: 2019 edition
2nd Oct 2019
Dynamic Arrays and #SPILL! errors
Newsletter updates
Join your peers and be in the know
Get all the latest tax, compliance, business and practice news from AccountingWEB.
Subscribe here
Popular resources
1st Nov 2019
3 Ways to Frictionless Finance
Celonis
14th Nov 2019
Succession planning: Is now the right time?
Capium
23rd Oct 2019
Get the latest tax tips with Rebecca Benneyworth
Netax
3rd Dec 2019
The complete guide to websites for accountants
PracticeWeb
29th Aug 2019
How to improve your accountancy practice
SmartVault
19th Sep 2019
1
Introduction to Dynamic Arrays
Excel is moving on. Yes, we’ve had Power Pivot, Power Query/Get & Transform and Power BI, but Microsoft’s Calc Intelligence team has...
18th Sep 2019
2
Useful features of XLOOKUP
This article considers a number of the most useful features of XLOOKUP. For an introduction to the new feature, click here . XLOOKUP can be...
3rd Sep 2019
XLOOKUP and XMATCH: Two new X-Men for Excel
Let’s take a look at the new addition to the LOOKUP family. I so wanted it to be called FLOOKUP but it was not to be… Ask anyone and they...
31st Jul 2019
Modelling tips and tricks: Range names
Welcome to our series of applied tips and tricks in Excel for accountants and financial analysts wherever you may be. In this article, Liam...
18th Jul 2019
4 comments
Microsoft Teams emerges as rival to Slack
20th Jun 2019
How to avoid mistakes in cell referencing
Advertisement
19th Jun 2019
1 comment
Modelling tips and tricks: SUM things to consider
22nd May 2019
1 comment
Care with modifying numbers
4th Apr 2019
3 comments
Power BI: Why would you, when you have Excel?
22nd Mar 2019
Microsoft adds picture capture to Excel 365 app
9th Jan 2019
What’s new in Excel 2019: New charts and visuals
3rd Jan 2019
What’s new in Excel 2019: PivotTable updates
14th Dec 2018
3 comments
What’s new in Excel 2019: Functions
5th Dec 2018
1 comment
EiB wants to improve, not replace Excel
28th Nov 2018
Power BI: Working with Excel budgets or forecasts
1st Nov 2018
Modelling tips and tricks: Things are LOOKing UP
Advertisement
Show more
