Displaying 1-10 of 295 results
Excel Tips and Tricks #447 – Rounding Errors Revisited
- Article
- 28 Jun 2022
Hello all and welcome back to Excel Tips and Tricks! For this tip, we have a General User post exploring the quirks of the Excel calculation engine, why sometimes it can mean that rounding errors are introduced into your data, and what you can do about them.
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.
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.
Displaying 1-10 of 295 results