Log in
Sign up
Subscribe to Newsletter
Search
Search
Menu
Tax
Personal tax
Business tax
HMRC & policy
Tax
sponsored by
Practice
Practice strategy
General practice
Skills
Practice
sponsored by
Business
Financial reporting
Management accounting
Finance & strategy
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
17th Jan 2020
Power BI: How to reduce your model footprint
15th Jan 2020
21 comments
Three in spreadsheet equals Fife Council calamity
13th Dec 2019
Power BI basics: Two ways to remove old data
Advertisement
12th Dec 2019
Dynamic Arrays: 15 months later
11th Dec 2019
Introducing DataDear to the world of data fluidity
Trending
HMRC & policy
Tax witch conjures curse for returns filer
Business tax
Cricket club caught out by charitable VAT rules
HMRC & policy
No reasonable excuse for agent’s blunders
Excel
Power BI: How to reduce your model footprint
Personal tax
Phantom returns haunt tax season
Tech pulse
Data: Friend or foe?
12th Nov 2019
New views for Power Query
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
10th Dec 2019
How to optimise your practice workflow
TaxCalc
10th Jan 2020
Five “Must Haves” for AI-powered Spend Auditing
AppZen
15th Nov 2019
AccountingWEB's Buyer's Guide to FreeAgent
FreeAgent
14th Oct 2019
Accounting for future: 5 firms share strategies
FreeAgent
17th Sep 2019
AccountingWEB's Buyer's Guide to Xero
Xero
5th Nov 2019
1
Dynamic Arrays vs legacy array formulae
Prior to this new functionality, if you wanted to work with ranges, you used to have to build array formulae, where references would refer...
30th Oct 2019
Do not be scared of Power BI
Unlike ourselves, Power BI is completely rational. An unexpected answer is simply a symptom that you need a better understanding of your...
16th Oct 2019
Death of data tables and PivotTables?
If the “final” versions of Dynamic Arrays highlighted here do not change drastically once they become generally available, there will be...
2nd Oct 2019
Can you learn Power BI in a day?
Like most questions to do with Power BI, the answer is “it depends”. It depends on what you mean by “learn”. If all that you want to do is...
2nd Oct 2019
Dynamic Arrays and #SPILL! errors
19th Sep 2019
1 comment
Introduction to Dynamic Arrays
Advertisement
18th Sep 2019
2 comments
Useful features of XLOOKUP
3rd Sep 2019
XLOOKUP and XMATCH: Two new X-Men for Excel
31st Jul 2019
Modelling tips and tricks: Range names
18th Jul 2019
4 comments
Microsoft Teams emerges as rival to Slack
20th Jun 2019
How to avoid mistakes in cell referencing
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
Advertisement
Show more
