Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Aggregating Aggravating Worksheets in Other Workbooks

3 May 2017

Though this may sound similar to last week’s blog, in many ways this method has just as much in common with One Folder, One Query...

Read more


Monday Morning Mulling: April Challenge

1 May 2017

On Friday, I stated that a positive integer (whole number) is said to be prime if only two different numbers divide it: one and itself.

Read more


Final Friday Fix: April Challenge

28 April 2017

Are You in the Prime of Your Excel Knowledge?

 

A positive integer (whole number) is said to be prime if only two different numbers divide it: one and itself.

Read more


How do I Install Power Query?

27 April 2017

Every month we welcome new readers to our website and newsletter, so a very common question we get is, “…I see you mention a lot of useful things with Power Query. I have Excel, but don’t seem to have Power Query – how do I get it?”...

Read more


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...

Read more


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?).

Read more


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...

Read more


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!..

Read more


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.

Read more


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.

Read more


Newsletter