Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The FORECAST Function

19 August 2019

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


VBA Blogs: Dynamically highlight entire row and column

16 August 2019

Welcome back to the VBA blog! This week we are going to expand our learning of how to highlight selected cells in a worksheet from last week.


Power BI Blog: New Transform - Split Column by Positions

15 August 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at a new transformation in Power BI: split column by positions.


Power Query: That Makes (Intelli)sense

14 August 2019

Welcome to our Power Query blog. Today, I look at the Intellisense features available in Power BI’s Power Query (Get Data).


Power Pivot Principles: Dynamic Ranges for Rolling Averages

13 August 2019

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept first introduced in a previous blog and show you how to include a dynamic selection range to a rolling average measure.


VBA Blogs: Dynamically Highlight the Row

9 August 2019

Welcome back to the VBA blog! This week we are going to expand our learning of how to highlight selected cells in a worksheet from last week.


Power BI Blog: New Filters Pane

8 August 2019

Welcome to this week’s Power BI blog series. This week, we’re going to look at Power BI Desktop’s new Filters pane.


Power Query: Step Back and See

7 August 2019

Welcome to our Power Query blog. Today, I build a function to add a column to a table.


Power Pivot Principles: Introducing the LASTDATE Function

6 August 2019

Welcome back to our Power Pivot blog. Today, we show you how the LASTDATE function work.


A to Z of Excel Functions: The FLOOR.MATH Function

5 August 2019

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


Newsletter