Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The LOWER Function

10 December 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the LOWER function.


Power BI Blog: New Page and Bookmark Navigators

9 December 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at two new built-in navigators.


Power Query: Selective Staffing Part 7

8 December 2021

Welcome to our Power Query blog. This week I look at an example that considers values that can be marked as included or excluded.


Power Pivot Principles: The A to Z of DAX Functions – CALENDARAUTO

7 December 2021

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at the CALENDARAUTO function.


A to Z of Excel Functions: The LOOKUP Function

6 December 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the LOOKUP function.


A to Z of Excel Functions: The LOGINV Function

3 December 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the LOGINV function.


Power BI Blog: New Format Pane

2 December 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Format pane in Preview.


Power Query: Selective Staffing Part 6

1 December 2021

Welcome to our Power Query blog. This week I look at another method to solve my second inclusion example.


Power Pivot Principles: The A to Z of DAX Functions – CALENDAR

30 November 2021

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at the CALENDAR function.


Monday Morning Mulling: November 2021 Challenge

29 November 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Newsletter