Excel Community articles

Exclusive Excel Tip of the Week #417 - Custom data types

Article
26 Oct 2021

Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re going to look at expanding data types with our own custom ones. For a refresher on normal data types and how they work, check out TOTW #384.

Exclusive Power Query versus VBA – part 2

Article
25 Oct 2021

Please note that this is article aims to demonstrate a range of Power Query techniques and is not intended to be used to perform any actual tax calculations, which are often subject to a range of additional considerations.

Exclusive Excel Tip of the Week #416 - PivotTable layouts

Article
19 Oct 2021

This week, we have Creator post in which we’re taking a look at some options for how to lay out your PivotTables.

Exclusive Achieving the impossible: reversing text with Power Query

Article
15 Oct 2021

As a follow up to a recent article on reversing text with Excel Simon shows another, potentially more straightforward method using Power Query.

Exclusive Microsoft forms: analysis automation on surveys created in minutes

Article
14 Oct 2021

Whether its employee feedback, customer satisfaction, post meeting surveys, Forms are very handy.

Exclusive Exploring Charts (Graphs) in Excel - 9: Colours, shadows and graphics (adding clarity not unnecessary use of options). Adding backgrounds.

Article
12 Oct 2021

With the plethora of chart options available it is all too easy to get ‘carried away’ and as mentioned in blog 5 there is a balance between medium and message. We also mentioned that in a pole of FDs that were asked to vote on their least favourite Excel feature, it was 3-D charts that topped the list. In the words of A.S.C. Ehrenberg “a Chart is a means of making results clear and memorable” and thus clarity is the primary objective

Exclusive Excel Tip of the Week #415 - Spreadsheet Competency Framework - Five years on

Article
12 Oct 2021

This week, we have a Basic User post in which we are looking at just what I mean each week when I start my blog by saying “a Basic User post”.

Exclusive Power Query versus VBA – part 1

Article
11 Oct 2021

Please note that this article aims to demonstrate a range of Power Query techniques and is not intended to be used to perform actual stamp duty calculations, which are subject to a range of additional considerations.

Excel Community September 2021 round-up

Article
05 Oct 2021

Here are all the new Excel articles and webinars from the Excel Community in September 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 #414 - Select Case and stamp duty revisited

Article
05 Oct 2021

This week, we have a Developer post in which we’re looking at a VBA coding option for situations where we have multiple paths to go down – Select Case. We’re going to be comparing and contrasting this with the more common If-Then-Else structure, which we covered back in TOTW #141. We’ll use the same example we did back then: stamp duty land tax.