Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed

Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Visit our Amsterdam Excel Summit

Speed up your file

The best tool to optimise your Excel model!
Home > English site > Headlines

Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

The Amsterdam Excel Summit 2015: Great content!
Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early bird discount period with an additional week. So register before March 1st 2015 and receive the 50 Euro discount!
Mon, 23 Feb 2015 14:40:00 GMT
Updated article: Working with Circular references in Excel
In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!
Wed, 11 Feb 2015 09:30:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
The Amsterdam Excel Summit 2015
Hallo! Na het enorme succes van vorig jaar, hebben we besloten opnieuw dit unieke evenement te organiseren: The Amsterdam Excel Summit Excel Experts Van Wereldklasse Een absoluut unieke groep Excel MVP’s zal in april 2015 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVP’s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken! Hoor het direct van de makers van Excel Iemand van het BI team van Microsoft zal tijdens dit evenement presentaties verzorgen, dus als je wilt weten welke kant het op gaat bij Microsoft Excel, zorg dan dat je erbij bent! Programma We hebben … Continue reading
Mon, 26 Jan 2015 16:28:42 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

An error has occured while trying to process
Please contact web-master.

The Ken Puls Blog

By Ken Puls
Combine Multiple Excel Workbooks in Power Query

I got a comment on a previous post today, which made me realize I’d promised this but never posted it.  So let’s look at how to combine multiple workbooks together in Power Query, providing they have the same format.  Yes, … Continue reading

The post Combine Multiple Excel Workbooks in Power Query appeared first on The Ken Puls (Excelguru) Blog.

Wed, 25 Feb 2015 14:00:00 +0000

.NET & Excel

By Dennis Wallentin

An error has occured while trying to process
Please contact web-master.

PTS Blog

By Jon Peltier
Select Data to Display in an Excel Chart With Option Buttons

The Problem A member of the MrExcel forum wanted to know about using form controls to select columns from a data table to populate a graph. Essentially he wanted his users to be able to choose between two charts, one comparing their scores to district and regional scores, the other comparing their scores to the top 20%. […]

The post Select Data to Display in an Excel Chart With Option Buttons appeared first on Peltier Tech Blog.

Tue, 17 Feb 2015 08:00:28 +0000

Contextures Blog

By Debrah Dalgleish
Resize Excel Comments With Macro

Occasionally, for reasons unknown to anyone other than the centuries-old trolls who live in underground tunnels at Microsoft, Excel comments resize themselves. They get really wide, or narrow, and become almost impossible to read.

To fix this problem, there is a macro on my website, written 13 years ago by Dave Peterson, which resizes comments in a selected range. It changes each comment to AutoSize, and calculates the area of the AutoSized comment. Then, it sets a specific width, and calculates the height, from the area and the width.

Recently, someone asked if there was a better way

Continue reading Resize Excel Comments With Macro

Thu, 26 Feb 2015 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Catching a comet with Excel Power Map

The recent news that the Rosetta spacecraft made the closest approach ever to the Comet 67P inspired the Power Map team to plot the trajectory of Earth, Mars, Comet 67P and Rosetta—by visualizing their paths through time.

The post Catching a comet with Excel Power Map appeared first on Office Blogs.

Thu, 26 Feb 2015 17:00:25 +0000