Resources
Industry Insights
Software Reviews
Subscribe to Newsletter
Login
Register
Subscribe to Newsletter
Login
Register
Tax
Sub-categories
Personal tax
Business tax
HMRC & policy
HMRC & policy
R&D claims: Striking the right balance
Business tax
New guidance on building services reverse charge
Making Tax Digital easy for you.
Practice
Sub-categories
Practice strategy
General practice
Skills
General practice
How limited is your liability?
General practice
Podcast: Land tax, tory tax and unregulated agents
General practice
Bodies complain about ‘unfair’ unregulated agents
Business
Sub-categories
Financial reporting
Management accounting
Finance & strategy
Finance & strategy
The CFO's role in nailing an investment pitch
Financial reporting
Why we need an IFRS for tax
Management accounting
HMRC continues CFO tax crackdown as IR35 looms
Tech
Sub-categories
Accounting software
Practice software
Excel
Tech pulse
Tech pulse
Tech Lowdown: Automation, apps and MTD roadshow
Tech pulse
Xero slips off Power BI menu
AccountingWEB Software Reviews
Any answers
Sub-categories
Latest questions
Most recent replies
Most liked questions
Ask a new question
Financial reporting
Directors' Fees & non-resident
Tax
Memory Refresh-Are shares legally in Child's Name?
Tax
Staff costs deductibility
Community
Sub-categories
Blogs
Industry insights
AAT
Joined-up Services
R&D tax relief
Is your video game eligible for a VGTR claim?
Mobile apps
Mobile Tech is at the heart of the Digital...
Hot topics
Sub-categories
Software reviews
Fintech
Making tax digital
IR35
Software reviews
Software Reviews
Software reviews
Payroll Software recommedations
Software reviews
Alternatives to Expensify?
More
Resources
Podcasts
About AccountingWEB
Advertise on AccountingWEB
Terms of use
Privacy policy
Contact us
Got a question?
Search
Search AccountingWEB
Search AccountingWEB
Resources
Industry Insights
Software Reviews
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
Modelling tips and tricks
22nd May 2019
1 comment
Care with modifying numbers
Unleash the Power BI
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
Advertisement
What’s new in Excel 2019
9th Jan 2019
What’s new in Excel 2019: New charts and visuals
What’s new in Excel 2019
3rd Jan 2019
What’s new in Excel 2019: PivotTable updates
Trending
HMRC & policy
R&D claims: Striking the right balance
Business tax
New guidance on building services reverse charge
Business tax
Taxpayer dances to surprise VAT victory
Business tax
VAT and the welfare exemption
HMRC & policy
Potential PMs jostle for tax supremacy
Tech pulse
Tech Lowdown: Automation, apps and MTD roadshow
What’s new in Excel 2019
14th Dec 2018
3 comments
What’s new in Excel 2019: Functions
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 Mar 2019
Make the most of Making Tax Digital for VAT
Wolters Kluwer
14th Feb 2019
The bookkeeper's guide to the virtual galaxy
SmartVault
11th Mar 2019
Tax tips for buy to let landlords
Capium
10th May 2019
Managing change: Build a practice fit for growth
Wolters Kluwer
10th Jun 2019
Book your upcoming Receipt Bank webinars
Receipt Bank
5th Dec 2018
1
EiB wants to improve, not replace Excel
Paul Martin is not so much an Excel fan, as an Excel realist. Despite software company after software company trying to wish Microsoft’s...
28th Nov 2018
Power BI: Working with Excel budgets or forecasts
Hugh Johnson explains how to pivot and unpivot Power BI and Excel data and get the best of both worlds. It should be no surprise to you...
1st Nov 2018
Modelling tips and tricks: Things are LOOKing UP
Welcome to our series of applied tips and tricks in Excel for accountants and financial analysts. Professional modeller, FCA and Excel MVP...
24th Oct 2018
10
Modelling tips and tricks: Has INDEX met its MATCH
Welcome to our series of applied tips and tricks in Excel for accountants and financial analysts. Having criticised HLOOKUP and VLOOKUP...
Modelling tips and tricks
11th Oct 2018
9 comments
Lookout for VLOOKUP and HLOOKUP
Modelling tips and tricks
12th Sep 2018
New data types and the FIELDVALUE function
Advertisement
Modelling tips and tricks
29th Aug 2018
Modelling tips and tricks: Flagging IF
Power Query techniques
22nd Aug 2018
4 comments
Power Query techniques: Grouping
Modelling tips and tricks
14th Aug 2018
1 comment
Modelling tips and tricks: Phantom links
Modelling tips and tricks
15th Nov 2018
Do you choose to use CHOOSE?
Modelling tips and tricks
1st Aug 2018
3 comments
Using OFFSET for depreciation
Unleash the Power BI
18th Jul 2018
Power BI and cash flow: Delivering information
Power Query techniques
12th Jul 2018
Power Query techniques: Conditional columns
Modelling tips and tricks
11th Jul 2018
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
Advertisement
Show more
