Cup of tea? Well a cup of CHAR won’t help you…

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

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.

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.

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

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

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

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

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

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