Here are all the new Excel articles and webinars from the Excel Community in April 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Excel Tip of the Week
388 – Power Pivot: Filtering measures (public)
Let your users switch between showing averages and sums, or any other measures, with our handy guide.
389 – Power Query: Dropping rows and columns
Got some data that needs filtering? Automate the import using Power Query.
390 – Advanced uses of INDEX
The humble INDEX function can do more than you probably realise.
391 – Comparing the lookup functions
What really separates LOOKUP, VLOOKUP, INDEX MATCH, and XLOOKUP? Which is the best for you?
Economic life modelling
MVP Liam Bastick returns with his latest examination – different ways of modelling economic life.
Exploring charts (graphs) in Excel – Part 6: Enhancing bar charts – Creating Funnel and Tornado charts
John Tennent continues his examination of charting in Excel with some homebrew options.
Turning the tables on Linked Pictures
Simon Hurst investigates an unusual error in how linked pictures interact with Excel Tables.
Intro to Financial Modelling – Part 15: Calculation techniques – basic good practice (public)
Our series exploring the Financial Modelling Code continues, with Jonelle Johnson-Turner taking a look at how to build the formulas in your model.
Community project – rescuing the lost archive – part 4
Simon Hurst continues his exploration of the Excel Community archive using Power BI.
Splitting columns to make reporting easier
Simon turns his eye to formula and other ways of splitting data into separate columns.
This article is brought to you by the Excel Community where you can find additional extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business.