Home
Tax
Sub-categories
Personal tax
Business tax
HMRC & policy
Business tax
VAT: Rule change for service charges
HMRC & policy
PAC takes HMRC to task
HMRC & policy
New law on voluntary tax returns backdated
Practice
Sub-categories
Practice strategy
General practice
Skills
Practice strategy
Taxathon: The hippo who stole Christmas
General practice
The ghost of accountant’s Christmas past
Practice strategy
What to buy an accountant for Christmas
Business
Sub-categories
Financial reporting
Management accounting
Finance & strategy
Financial reporting
The Ashleyfication of the High Street
Finance & strategy
Accounting for labour: The future of pay and work
Finance & strategy
What skeletons lurk in your company’s closet?
Tech
Sub-categories
Accounting software
Practice software
Excel
Tech pulse
Tech pulse
What we learned at FinTech Connect
Tech pulse
Sage sacrifices short-term growth for cloud shift
AccountingWEB Software Reviews
Any answers
Sub-categories
Latest questions
Most recent replies
Most liked questions
Ask a new question
Time out
Accountants on the 'Spectrum'
Tax
property available less than 105 days per year
Tax
Putting a stop to the last minute demands
Community
Sub-categories
Industry insights
Blogs
On The 7th Day Of Christmas Rudi Gave To Me...
AAT
AAT for Maria
On The 6th Day Of Christmas Rudi Gave To Me...
Hot topics
Sub-categories
Software reviews
Making tax digital
IR35
Software reviews
Does Sage online calculate flat rate VAT correctly
Software reviews
Sage sacrifices short-term growth for cloud shift
Software reviews
Software Reviews: Accounts production goes cloud
More
Resources
Podcasts
About AccountingWEB
Advertise on AccountingWEB
Terms of use
Privacy policy
Contact us
Got a question?
Search
Enter your keywords
Enter your keywords
Login
Register
Tech
Excel
Excel
EiB wants to improve, not replace Excel
5th Dec 2018
1 comment
28th Nov 2018
comments
Power BI: Working with Excel budgets or forecasts
Modelling tips and tricks
1st Nov 2018
comments
Modelling tips and tricks: Things are LOOKing UP
Modelling tips and tricks
24th Oct 2018
10 comments
Modelling tips and tricks: Has INDEX met its MATCH
Advertisement
Modelling tips and tricks
11th Oct 2018
9 comments
Lookout for VLOOKUP and HLOOKUP
Modelling tips and tricks
12th Sep 2018
1 comment
New data types and the FIELDVALUE function
Trending
Practice strategy
What to buy an accountant for Christmas
Excel
Five flaws in Excel Tables - and how to fix them
Excel
EZ guide to PivotTables – Why PivotTables?
Excel
How to make formatting 'stick' in Excel pivot...
Excel
EiB wants to improve, not replace Excel
Excel
Modelling tips and tricks: Has INDEX met its MATCH
Modelling tips and tricks
29th Aug 2018
comments
Modelling tips and tricks: Flagging IF
Register now
Join the online community for today's professionals
Sign up for AccountingWEB NOW
Popular resources
16th Oct 2018
How to protect your client data
SmartVault
12th Nov 2018
How your clients can drive referrals - webcast
MyFirmsApp
5th Dec 2017
FRS 105 handbook for accountants and their clients
CaseWare
24th Sep 2018
How to generate more business from your website
PracticeWeb
11th Oct 2018
The fintech future of the modern accountancy firm
Soldo
22nd Aug 2018
4
Power Query techniques: Grouping
In his latest Power Query editor tutorial, Simon Hurst tackles the grouping option that allows you to generate a summary table from a...
14th Aug 2018
1
Modelling tips and tricks: Phantom links
As a professional modeller, FCA and Excel MVP Liam Bastick highlights some of the more useful functions for financial modelling and Excel...
15th Nov 2018
Do you choose to use CHOOSE?
Welcome to our series of applied tips and tricks in Excel for accountants and financial analysts wherever you may be. As a professional...
1st Aug 2018
2
Using OFFSET for depreciation
Welcome to a new series of applied tips and tricks in Excel for accountants and financial analysts wherever you may be. As a professional...
Unleash the Power BI
18th Jul 2018
comments
Power BI and cash flow: Delivering information
Power Query techniques
12th Jul 2018
comments
Power Query techniques: Conditional columns
Advertisement
Modelling tips and tricks
11th Jul 2018
comments
Using OFFSET for scenario analysis
Modelling tips and tricks
2nd Jul 2018
1 comment
Formulae referencing current worksheet
25th Jun 2018
35 comments
Spreadsheets: Professional competence and due care
13th Jun 2018
6 comments
Will the native pivot function change Excel use?
Modelling tips and tricks
7th Jun 2018
comments
Modelling tips and tricks: Number formatting
5th Jun 2018
How to deal with unstable Excel workbooks
Modelling tips and tricks
29th May 2018
comments
Modelling tips and tricks: Revising forecasts
10th May 2018
comments
The EZ guide to IF(): Part two
10th May 2018
1 comment
ICAEW Excel tips: Looking back
30th Apr 2018
3 comments
An accountant's guide to Excel PivotTables
Advertisement
Show more
