Here are all the new Excel blogs from the Excel Community in April 2024.
Webinars
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community and ICAEW members.
Check our list of upcoming webinars or refer to the latest newsletter to see what is planned for the rest of the year.
Excel Tips & Tricks
Excel Tips & Tricks #489 – the basics of charts in Excel part 2: Combo charts
This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
Other blogs
Top 12 Excel Combinations: 10. SUMPRODUCT SIGN (Multiple Conditions with OR)
In the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers SUMPRODUCT SIGN (Multiple Conditions with OR).
Simple but effective, part 2
This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
IRR, XIRR & MIRR – What are they? When to use them?
IRR is commonly used to help make project investment decisions. In this article, Mark Proctor returns to explore the use of the IRR function in Excel and potential alternatives.
Finding the missing link – Edit links enhanced
Links to cells in other workbooks are a frequent cause of confusion. It can be particularly difficult to track down some of the more elusive ways in which one spreadsheet can be linked to another. A Find Next command available as part of an enhancement to the previous Edit Links command might now be able to help.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
Archive and Knowledge Base
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.
