Exclusive
How to review a spreadsheet
- Article
- 16 May 2022
This series of six blogs will explore the Excel Community 2021 publication ‘How to Review a Spreadsheet – Reduce the risk that your spreadsheet gives you the wrong answer’.
Exclusive
Working with Power Query – solving even more business problems
- Article
- 12 May 2022
A great deal can be achieved in Power Query just by using the editor interface and allowing Power Query to create each formula line for us. However, understanding how to make simple edits in the formula bar can extend what Power Query is capable of. We will use the example of entering a value in a cell in an Excel worksheet to filter a transaction table by date. The example also shows how to make a value from a single worksheet cell available in the editor.
Exclusive
Excel Tips and Tricks #443 - Next level FILTERing (The FILTER Function)
- Article
- 11 May 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s Creator post we’re looking at the FILTER function, which remains a relatively recent and underutilised addition to Excel. Given it opens up more sophisticated filter options than the standard drop-down filters, it’s time to change that.
Exclusive
New dynamic array functions – be careful what you wish for
- Article
- 08 Apr 2022
First of all, we'll cover the usual warning about Excel updates that are still in preview. They will initially only be available to those who have opted in to the more reckless update channels such as the Beta Channel and, as we saw recently with the XLOOKUP() function, they might change between the preview stage and eventual release.
Exclusive
Excel Tip of the Week #439 - Power Pivot - Creating a running total
- Article
- 29 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we’re going to look at how to make some more unusual types of measures in Power Pivot. If you want a refresher on how Power Pivot measures work, check out TOTW #369 for the lowdown.
Exclusive
Blog 084 - Dynamic Lookups
- Article
- 25 Mar 2022
This time, we take a familiar modelling scenario and, er, “extend” it.
Exclusive
Excel Tip of the Week #438 - Power Query: Creating custom functions
- Article
- 22 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we are taking a look at how to create your own custom functions in Power Query.
Exclusive
Multiple Excel Tables in a single worksheet – avoiding Cell Clash
- Article
- 17 Mar 2022
I have been working on a project recently for which I wanted to include a set of refreshable Excel Tables in a control worksheet to highlight exceptions in the underlying data. Generally, the best way to avoid Tables clashing with each other as they expand and contract is to keep them on their own, separate, worksheets. In this case, I wanted to create a single workbook that would highlight potential errors at a glance, and the Tables concerned were only likely to generate a few rows each. The following examples demonstrate some of the considerations involved.
The Excel community has produced an extensive list of helpful tips and tutorials including its 'Excel tip of the week' series.
Exclusive
Excel Tips and Tricks #443 - Next level FILTERing (The FILTER Function)
- Article
- 11 May 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s Creator post we’re looking at the FILTER function, which remains a relatively recent and underutilised addition to Excel. Given it opens up more sophisticated filter options than the standard drop-down filters, it’s time to change that.
Exclusive
Excel Tips and Tricks #442 - Revisiting Screenshots
- Article
- 25 Apr 2022
In this article we're going to explain the various ways to create an image of an Excel spreadsheet, or just part of it.
Exclusive
Excel Tips and Tricks #441 - Under the (Easter) Bonnet: What’s an XLSX file anyway?
- Article
- 13 Apr 2022
In this article we talk about Excel file types and explore the inner workings of an XLSX file.
Excel Tip of the Week #440 - How to get better at Excel
- Article
- 05 Apr 2022
Over the past nine years, I have typed those words many times, opening each of the four hundred and thirty-nine previous TOTWs. But I am leaving ICAEW for a new role – in fact, I will have left already by the time you read this article – and so after a long run, it’s time for this series to come to an end, at least for now.
Exclusive
Excel Tip of the Week #439 - Power Pivot - Creating a running total
- Article
- 29 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we’re going to look at how to make some more unusual types of measures in Power Pivot. If you want a refresher on how Power Pivot measures work, check out TOTW #369 for the lowdown.
Exclusive
Excel Tip of the Week #438 - Power Query: Creating custom functions
- Article
- 22 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we are taking a look at how to create your own custom functions in Power Query.
Exclusive
Excel Tip of the Week #437 - Revisiting dynamic arrays
- Article
- 15 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re taking a timely second look at the biggest change to Excel formulas in recent years, the nifty dynamic array formulas.
Exclusive
Excel Tip of the Week #436 - Trimming excess space redux
- Article
- 08 Mar 2022
Hello all and welcome back to the Excel Tip of the Week! This week we are taking a deep dive into a very annoyingly necessary data cleaning task – removing excess spaces.
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. You also have the option to Join the Tech Faculty, where Excel Community membership is included.
