Exclusive
Excel Tips and Tricks #446 – Desktop vs Online
- Article
- 21 Jun 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s General User post it’s time to answer the question I often find myself asking – what actually is the difference between the Excel Desktop and Online versions? I’ve done the digging, so you don’t have to…
Exclusive
How to review a spreadsheet part 1
- 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.
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 #446 – Desktop vs Online
- Article
- 21 Jun 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s General User post it’s time to answer the question I often find myself asking – what actually is the difference between the Excel Desktop and Online versions? I’ve done the digging, so you don’t have to…
Exclusive
Excel Tips and Tricks 445
- Article
- 10 Jun 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s Basic User post it’s time to get collaborative. If two or more people are working on a spreadsheet at the same time, filtering can be a headache. This tip looks at the solution – Filter (or Sheet) Views.
Exclusive
Excel Tips and Tricks #444 - Revisiting XLOOKUP
- Article
- 24 May 2022
Hello all and welcome back to Excel Tips and Tricks! For today’s General User post we’re revisiting another must-use Office 365 function, XLOOKUP. While we have covered XLOOKUP a few times, including in the “Tip of the Week Live” webinar earlier this year and our comparison of lookup functions in TOTW #391, you can never have too much of a good thing, right?
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.
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.
