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.

Events


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Headlines

Excel Headlines

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

This site

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added support for hotkeys using the Alt key.
Wed, 06 May 2015 17:30:00 GMT
New Excel article: Building an Add-in for Excel
Today I posted an entirely new article. It describes all the steps needed to create a basic Excel add-in.
Mon, 04 May 2015 14:10: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 http://www.dailydoseofexcel.com/feed/
Please contact web-master.


The Ken Puls Blog

By Ken Puls
Retrieve Related Tables in Power Query

As I was working on one of the assignments for our upcoming Power Query training course, it occurred to me that I’ve never blogged about this feature: how to retrieve related tables in Power Query. Retrieve Related Tables in Access … Continue reading

The post Retrieve Related Tables in Power Query appeared first on The Ken Puls (Excelguru) Blog.


Wed, 27 May 2015 18:19:00 +0000

.NET & Excel

By Dennis Wallentin

An error has occured while trying to process http://xldennis.wordpress.com/feed
Please contact web-master.


PTS Blog

By Jon Peltier
VBA: An Advanced Add-in to Open a CSV File and Create Chart with Data Specified by User

Introduction This article builds upon a previous post, VBA: A Simple Tool to Open a CSV File and Create Chart with Data Specified by User, which showed how to build the barest possible VBA procedure for opening a CSV file and making a chart from its data. This article will show how to make the […]

The post VBA: An Advanced Add-in to Open a CSV File and Create Chart with Data Specified by User appeared first on Peltier Tech Blog.


Tue, 26 May 2015 08:00:36 +0000

Contextures Blog

By Debrah Dalgleish
Excel Drop Down List Allows Invalid Entries

Drop down lists make it easier to enter data on a worksheet, and they help ensure that only valid items will be entered in the cell.

For example, in the screen shot below, the Manager column has a drop down list with 5 names. Only those names should be entered in the column.

However, if you type "Bill" in the cell (a name that isn't on the list), it's accepted in the cell, with no error alert. That could lead to problems – suddenly, anyone can be a manager!

Why It Is Allowed

There are a couple

Continue reading Excel Drop Down List Allows Invalid Entries


Thu, 28 May 2015 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Amazing business productivity through Office 365—Dynamics CRM integration

Save time with seamless integration of Microsoft Dynamics CRM Online and Office 365—email integration and folder tracking within Dynamics CRM, note sharing using OneNote, immersive Excel experiences and self-service analytics with Power BI.

The post Amazing business productivity through Office 365—Dynamics CRM integration appeared first on Office Blogs.


Thu, 21 May 2015 16:00:08 +0000