Please note javascript is required for full website functionality.

Blog

Challenges: Final Friday Fix: November 2018 Challenge

30 November 2018

Welcome back to the Final Friday Fix! This month, we are going to draw inspiration from the Excel team’s Ask Me Anything session earlier this month and look to Reddit to find a challenging question. (No cheating by going there to look for the answer!)


Power BI Blog: Power BI Gateway

29 November 2018

Welcome back to our Power BI blog series! This week, we’re going to finish the process of automatically refreshing data, using the Power BI Gateway.


Power Query: Different Standards

28 November 2018

Welcome to our Power Query blog. This week, I look at the differences in the way that the ‘Standard’ button works on the ‘Transform’ and ‘Add Column’ tabs.


Power Pivot Principles: Introducing the IN Function

27 November 2018

Welcome back to our Power Pivot blog. Today, we discuss the IN function, one of the several logical functions in Power Pivot.


A to Z of Excel Functions: The DVARP Function

26 November 2018

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


VBA Blogs: Going Through the Visual Basics – Part 14

23 November 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog takes a look at iteration control structures.


Power BI Blog: Using OneDrive and Setting up Automatic Updates - .xls Files

22 November 2018

Welcome back to our Power BI blog series! This week, we’re going to continue the process of setting up our dataset to automatically update from a file on OneDrive.


Power Query: Merge Columns vs Merge Columns

21 November 2018

Welcome to our Power Query blog. This week, I look at merging columns to show that not all ‘Merge Columns’ options are born equal.


Power Pivot Principles: Introducing the DATEADD Function

20 November 2018

Welcome back to our Power Pivot blog. Today, we introduce the DATEADD function.


A to Z of Excel Functions: The DVAR Function

19 November 2018

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


Newsletter