Grouping Icon Above Group Rows in Excel
The default setting is to have the grouping icon below the grouped rows. But you can switch things and have the icon at the top of the grouped rows. (more…)
Grouping Measures in Power BI
It is considered best practice to use Measures for all your values in Power BI reports and dashboards. One way to make it easier to find Measures is to group them together. (more…)
Free Webinar Recording – Excel Yourself 2019
In December 2019 I reviewed four of my articles from 2019 plus some new content. The detailed pdf manual and example file can be downloaded using the button below. Content listed below the video. Download Materials CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. https://vimeo.com/379919236 This year’s webinar includes a new logic function IFS how to do…
Creating Groups for Power Queries in Excel
Once you start to use Power Query you may find yourself with quite a few queries in the one file. To make it easier to control them you can use groups to keep similar queries together. (more…)
Excel Sort within a Sort
Did you know you can sort by colour in Excel? Did you know you can sort ascending or descending within that colour? I was asked a question in a recent webinar and in answering I found out that you can sort within a sort. (more…)
Applying a standard custom format in Excel
One of the most common custom number formats used in Excel is the mmm-yy format. As an example this format displays all the dates in January 2019 as Jan-19. This format is used in most reports, budgets and financial models. There is quicker way to apply it than using the Format Cells dialog. (more…)