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
Excel
Excel
20th Sep 2019
35
Any Answers
DD/MM/18 in Excel
By
Constantly Confused
Assistant Boondogler
By accountingcpd.net |
19th Sep 2019
What is Power Query
As an accountant, you will know that organisations often have vast quantities of data stored in Excel. Sometimes, this data is in the form of lists...
19th Sep 2019
1 comment
Introduction to Dynamic Arrays
18th Sep 2019
2 comments
Useful features of XLOOKUP
13th Sep 2019
2
Any Answers
O/Topic - excel formatting
By
kiwilondon99
By Real Asset Management |
4th Sep 2019
10 Tips: Spreadsheets and Managing Fixed Assets
For any organisation, having an accurate and robust asset register that shows the location, value and condition of assets can help ensure that...
3rd Sep 2019
XLOOKUP and XMATCH: Two new X-Men for Excel
By BTCSoftware |
30th Aug 2019
BTCSoftware release Excel update for BTCHub
BTCSoftware has released an update for the BTCHub MTD for VAT Excel template. The updates are: Flat Rate Scheme – this capability has been added...
Advertisement
By accountingcpd.net |
9th Aug 2019
Excel Errors and how to solve them quickly
At one point or another, we've all had to spend valuable time clicking between various Excel sheets to find a hidden error. These can be hard to spot...
By accountingcpd.net |
6th Aug 2019
Spreadsheet risks and how to avoid them
Computerised spreadsheets have been around for decades and have continued to evolve with the development of technology. The way people use...
By AccountsIQ |
6th Aug 2019
Still using Excel for Consolidation?
If you are completing month end accounting processes in Excel to produce consolidated accounts, this process is likely to be inefficient and take too...
By accountingcpd.net |
31st Jul 2019
Spreadsheet errors and how to avoid them
It's just a spreadsheet, what can go wrong? Typing a "2" instead of a "1", led to 10,000 too many tickets being issued for a synchronised swimming...
31st Jul 2019
Modelling tips and tricks: Range names
26th Jul 2019
4
Any Answers
Excel - Looking up values using two criteria
By
[email protected]
Show more