Tech News articles

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…

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’.

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.

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.

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.

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.

This time, we take a familiar modelling scenario and, er, “extend” it.

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.

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.