Resources
Industry Insights
Software Reviews
Login
Register
Home
Tax
Sub-categories
Personal tax
Business tax
HMRC & policy
Business tax
PAYE checklist for 2019-20
HMRC & policy
HMRC blitzes BBC presenters with IR35 tax demands
Making Tax Digital easy for you.
Practice
Sub-categories
Practice strategy
General practice
Skills
General practice
Do you report criminal activity?
General practice
Podcast: April anti-money laundering mayhem
General practice
Is sponsorship a good investment?
Business
Sub-categories
Financial reporting
Management accounting
Finance & strategy
Financial reporting
FCA launches investigation into Wasps RFC
Finance & strategy
Does naming and shaming actually work?
Finance & strategy
Power BI: Rolling 12 months and YTD
Tech
Sub-categories
Accounting software
Practice software
Excel
Tech pulse
Tech pulse
Software Reviews
Practice software
Software Reviews
AccountingWEB Software Reviews
Any answers
Sub-categories
Latest questions
Most recent replies
Most liked questions
Ask a new question
Tax
Adding client to HMRC Agent account
Tax
Tax treatment of personal expenditure in ltd co
Business
Options to finance share buy-backs?
Community
Sub-categories
Industry insights
Blogs
What is Artificial Intelligence and Why It’s...
Offering cloud technologies to improve payroll...
Want To Create More Content For Your...
Hot topics
Sub-categories
Software reviews
IR35
Making tax digital
Fintech
Software reviews
Software Reviews
Software reviews
Forecasting tools prosper in uncertain times
Software reviews
Best online software for PayPal transactions ?
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
Tech
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
Email
*
Email
Sign up
4th Apr 2019
3 comments
Power BI: Why would you, when you have Excel?
22nd Mar 2019
2 comments
Microsoft adds picture capture to Excel 365 app
What’s new in Excel 2019
9th Jan 2019
What’s new in Excel 2019: New charts and visuals
Advertisement
What’s new in Excel 2019
3rd Jan 2019
What’s new in Excel 2019: PivotTable updates
What’s new in Excel 2019
14th Dec 2018
3 comments
What’s new in Excel 2019: Functions
Trending
Business tax
PAYE checklist for 2019-20
Business tax
R&D claim: How to get a quick decision
HMRC & policy
Has direct recovery of debts objectives been met?
Business tax
Directors: Payment as consultants didn’t save tax
HMRC & policy
HMRC blitzes BBC presenters with IR35 tax demands
5th Dec 2018
1 comment
EiB wants to improve, not replace Excel
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 Apr 2019
MTD checklist: Get ready for the first submissions
Capium
1st Apr 2019
Tax tips: Loan Charge update
Capium
8th Apr 2019
How to break MTD into manageable steps
Intuit QuickBooks
14th Feb 2019
The bookkeeper's guide to the virtual galaxy
SmartVault
11th Mar 2019
Tax tips for buy to let landlords
Capium
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...
11th Oct 2018
9
Lookout for VLOOKUP and HLOOKUP
Welcome to our series of applied tips and tricks in Excel for accountants and financial analysts. As a professional modeller, FCA and Excel...
Modelling tips and tricks
12th Sep 2018
New data types and the FIELDVALUE function
Modelling tips and tricks
29th Aug 2018
Modelling tips and tricks: Flagging IF
Advertisement
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
13th Jun 2018
6 comments
Will the native pivot function change Excel use?
Advertisement
Show more
