Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Aggregating Aggravating Worksheets

26 April 2017

I begin in a workbook that contains three worksheets. Each of the worksheets has been populated with a table of expenses information...


A to Z of Excel Functions: the CELL Function

24 April 2017

With our A t Z of Excel Functions series, you could argue we have been trying to make a soft CELL (get it?).


Unhiding and Unprotecting Sheets

21 April 2017

Today, we’re going to look at a common application of VBA involving a range of skills that we’ve gone through...


Power Query: Calendar Creation – Going for Dates

19 April 2017

As I described in Calendar Creation – Preparing for Dates building a calendar using Power Query is a collaboration between Excel and Power Query. Read this article to find out how!..


A to Z of Excel Functions: the CEILING.PRECISE Function

17 April 2017

Do you know where your CEILING is precisely?? If not, this function won’t help you.


For Loops

14 April 2017

Last week, we showed you how to declare variables. This week, we’re going to use a variable to create a loop. Let’s introduce the For loop.


Power Query: Calendar Creation – Preparing for Dates

12 April 2017

Building a calendar using Power Query is a collaboration between Excel and Power Query...


A to Z of Excel Functions: the CEILING.MATH Function

10 April 2017

This function sounds like something you calculate whilst swinging from the chandeliers...


Declaring Variables

7 April 2017

One of the most useful things you can do in VBA is to store values in the program’s memory, so that you can use it in the future...


Power Query: Excel(lent) functions

5 April 2017

Over the last few weeks I have shown some of the tasks that can be achieved with M language and functions. Today I look at how to replicate some familiar Excel formulas.


Newsletter