Please note javascript is required for full website functionality.


Power Query: Setting an Example

27 September 2017

The new feature ‘Column from Examples’ essentially pulls together a number of Power Query functions into one place, so it’s very user friendly.

A to Z of Excel Functions: The CONFIDENCE Function

25 September 2017

Do you need more CONFIDENCE in your Excel files?...

A to Z of Excel Functions: The CONCATENATE Function

22 September 2017

IMPORTANT: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function (see the last functions blog). Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on.

Power Query: In Your Face(book)

20 September 2017

Whilst much of the data I deal with comes from workbooks and databases, it can be useful to pull in data from other sources. There are a number of sites traditionally associated with business, but social media sites like Facebook are becoming more accepted business channels due to their high usage and range of users...

A to Z of Excel Functions: The CONCAT Function

18 September 2017

More and more users are migrating to the Office 365 subscription model and with that comes great power, well Excel 2016 anyway. And some versions of Office 365 Excel 2016 are getting six new functions to play with. The roll-out started in late February 2016 and continues to this very day.

A to Z of Excel Functions: The COMPLEX Function

15 September 2017

Imagine this complex function. This function converts real and imaginary coefficients into a complex number of the form x + yi or x + yj, where i or j denotes the square root of -1....

Power Query: Custom Built Functions

13 September 2017

Last week, I looked at how to access and test the built-in Power Query functions. There are occasions, however, when I am repeatedly using the same logic, and I want to store it in a custom function of my own. Let’s take a look....

ModelOff Sydney

11 September 2017

This week in Sydney, ModelOff hosted their Global Training Camp, featuring speakers from Microsoft and several other companies, including our very own Tim Heng.

Weird Little Traps: Excel Going Wrong from Day 1…

8 September 2017

While our VBA blog series takes a little hiatus (it’s coming back soon, we promise!), we thought we’d share with you a problem that raises its ugly little head from time to time.

Power Query: a Function Function

6 September 2017

My blog comes of age this week as it hits the big 4-0! I am feeling quite empowered, so that gives me an idea! In M-Powered, I described how to get to a description of the functions that can be used in M code to manipulate data by accessing the Microsoft help pages. There is however another way to get to the functions. Let me show you....