Most Valuable Professional

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

Subscribe in a reader

Subscribe to our mailing list

* indicates required
Newsletter Archive

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

Link posted to Andrew's Excel Utilities
Today I posted a link to one of the most comprehensive sets of Excel productivity tools I have ever seen: Andrew's Excel Utilities
Tue, 07 Apr 2015 08:30:00 GMT
The Amsterdam Excel Summit 2015: Last minute discount
Our event is coming real soon now and we're very much looking forward to it. We have outstanding speakers and excellent content, so everything is lined up to make this a superb Excel event. To entice the undecisive Excel lovers to make up their minds and subscribe after all, we decided to make it even more attractive to attend. As of March 27st, 2015 we offer a € 200 last-minute discount per attendee for both days and € 100 for one day! Register now at and meet us on April 13th and 14th in Amsterdam.
Fri, 27 Mar 2015 08:20: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
Use Dynamic Ranges in Power Query

This was a great question that came up in my M is for Data Monkey session at the Amsterdam Excel summit:  Can we use dynamic ranges in Power Query? If I recall correctly, this was asked by Gašper Kamenšek, after … Continue reading

The post Use Dynamic Ranges in Power Query appeared first on The Ken Puls (Excelguru) Blog.

Wed, 15 Apr 2015 09: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
Removing Recent Colors from Microsoft Excel

Recent Colors When you customize a color and apply it to an object in Microsoft Office, the color is stored as part of the Office file, and presented in a “Recent Colors” category on the various colors dropdowns. Up to ten of these custom colors are displayed, with the most recent at the left of […]

The post Removing Recent Colors from Microsoft Excel appeared first on Peltier Tech Blog.

Mon, 16 Mar 2015 20:07:25 +0000

Contextures Blog

By Debrah Dalgleish
Excel Roundup 20150420

IN this week's roundup, you'll learn about arrays and array formulas, see how to speed up macros, and many more tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

1. Contextures Posts

In case you missed them, here are the articles that I posted recently:

If you leave numbers in the default General format, Excel will automatically round them. For more control, apply a different number format, or a custom format. For a humorous peek at what other people are saying about spreadsheets, read the

Continue reading Excel Roundup 20150420

Mon, 20 Apr 2015 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Take control of data with Excel’s business analytics tools

Today, businesses are required to understand a growing amount of data to drive effective business decisions and remain competitive. Many specialized business intelligence and analytics solutions are entering the market to take advantage of this trend with most requiring installation of new data systems or new training of employees to learn new tools. Excel may already have the business analytics tools you need to drive the information analyses and data-driven…

The post Take control of data with Excel’s business analytics tools appeared first on Office Blogs.

Mon, 20 Apr 2015 08:30:57 +0000