Webinar
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members.
Our next webinar is on 17 June and further webinars are currently being scheduled – check our list of upcoming webinars or refer to the latest newsletter.
Excel Tips and Tricks
Excel Tips and Tricks #443 – Next level FILTERing (The FILTER Function)
Exploring the FILTER function, which opens up more sophisticated filter options than the standard filtering tools, such as dynamic filter selections and OR logic.
Excel Tips and Tricks #444 - Revisiting XLOOKUP
Refreshing the successor to VLOOKUP and INDEX MATCH, a recap of the XLOOKUP function that delivers substantial improvements to the lookup experience.
Other blogs
Excel how to: speed up formulae - using Excel tables part 2
The latest in the ‘how to’ series looks at the use of formulae within Tables, and how this can save significant amounts of time with formula entry, and also help with review.
Working with power query - solving even more business problems
Looking at how simple edits in the formula bar within Power Query can significantly enhance capabilities. In combination with storing a value from a single worksheet cell in the editor, the article walks through how a date variable can be used to dynamically filter a transaction table.
In the first of a new six-part series, John Tennent explores the practical applications of the Excel Community 2021 publication ‘How to Review a Spreadsheet’.
Archive portal – quickly see recent Excel Community posts
A look at recent developments to our Power BI-based archive portal, a one-stop shop for all previous Excel Community articles and tips, searchable by topic, author and date.
Modified Internal Rate of Return (MIRR)
Liam Bastick explores the MIRR function, a measure that potentially addresses the challenge of multiple, often conflicting, IRR measures.
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.