ICAEW.com works better with JavaScript enabled.

Excel Community round up - April 2021

Author: David Lyford-Smith

Published: 05 May 2021

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?

Other blogs

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.


Excel community

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.