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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Trainings

Excel VBA Masterclass (English)
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: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 121. We have improved performance on a number of areas and added a way to report detailed statistics of multiple files.
Mon, 02 Oct 2017 17:05:00 GMT
New tool: Table Tools
I have added a new add-in to my site called Table Tools. This add-in makes your daily life with Excel tables a little simpler!
Wed, 20 Sep 2017 08:30:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Renumbering Arrays in Code
I’ve got this bit of code where I’m listing table fields that I’m going to eventually Join into a SELECT statement. [crayon-59e5f89461aa1014429722/] As you can see, I needed to add a new field in position 1. Now I’m faced with renumbering the rest of the array. Terrible. So I wrote this: [crayon-59e5f89461aab534253166/] Now I can […]
Sat, 14 Oct 2017 17:38:55 +0000

The Ken Puls Blog

By Ken Puls
Data types vs formats

One of the common questions I get in live courses, blog comments and forum posts is a variant of, “How do I format my data in Power Query or Power BI?”  The short answer is that you don’t, but the … Continue reading

The post Data types vs formats appeared first on The Ken Puls (Excelguru) Blog.


Wed, 11 Oct 2017 18:45:51 +0000

PTS Blog

By Jon Peltier
Chart VBA Examples

Chart VBA Samples I answered a few questions on Stack Overflow this morning, and before I deleted the test workbook, I thought I’d share a few of the chart VBA procedures. All of these have to do with applying fill colors to Excel chart series. Reverse Default Colors In the first example, from VBA Code […]

The post Chart VBA Examples appeared first on Peltier Tech Blog.


Wed, 11 Oct 2017 14:34:46 +0000

Contextures Blog

By Debrah Dalgleish
Happy Spreadsheet Day 2017

Happy Spreadsheet Day 2017! You’ve been waiting all year for this special day to arrive, I’m sure, so what will you do to celebrate today? How Did Spreadsheet Day Get Started? Here at Contextures,...

The post Happy Spreadsheet Day 2017 appeared first on Contextures Blog.


Tue, 17 Oct 2017 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Microsoft SharePoint recognized as a Leader in Gartner Magic Quadrant for Content Services Platforms

Gartner has recognized Microsoft as a Leader in the Content Services Platform Magic Quadrant for 2017—a further indication of Microsoft’s commitment to content services capabilities.

The post Microsoft SharePoint recognized as a Leader in Gartner Magic Quadrant for Content Services Platforms appeared first on Office Blogs.


Tue, 10 Oct 2017 16:00:35 +0000