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

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
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the formula report
Mon, 18 Sep 2017 15: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)
Applications Settings v2
I made a new version of my Application Settings addin as per Sébastien’s comments in my last post. As you can see, there are new settings for the following. Application.Iteration Application.MaxIterations Application.MaxChange In the case of the last 2 settings, you’ll notice that there are Set, Reset and Save buttons. This is how they work, […]
Sat, 02 Sep 2017 04:30:11 +0000

The Ken Puls Blog

By Ken Puls
What is with Excel Tables and the Data Model

What is with Excel Tables and the Data Model?  Believe it or not, this is not the question I started with today, it was actually "which is faster; loading from CSV files or Excel?"  My initial results actually brought up … Continue reading

The post What is with Excel Tables and the Data Model appeared first on The Ken Puls (Excelguru) Blog.


Thu, 07 Sep 2017 17:58:48 +0000

PTS Blog

By Jon Peltier
Interactive Formatting of a Chart Series with a Cell’s Color

A user of my Peltier Tech Charts for Excel 3.0 asked recently whether this program could perform interactive formatting of all series 2 in a set of charts to the same color. Well, my program does many things, but it can’t do this. Such a highly specific feature is hard to support in a general […]

The post Interactive Formatting of a Chart Series with a Cell’s Color appeared first on Peltier Tech Blog.


Tue, 05 Sep 2017 13:00:40 +0000

Contextures Blog

By Debrah Dalgleish
Compare Pivot Table Values As Percentages

As you know, pivot tables are a quick and easy way to summarize a huge table of data in Excel. With just a few clicks, you can create totals for thousands of rows of...

The post Compare Pivot Table Values As Percentages appeared first on Contextures Blog.


Thu, 21 Sep 2017 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Personal finance—lessons learned from an online shop

Mastering personal finances can often start with something as simple as holding a garage sale or opening an online shop. Keeping track of what it takes to manage sales helps you figure out what’s needed to make sure your own finances stay in order.

The post Personal finance—lessons learned from an online shop appeared first on Office Blogs.


Wed, 20 Sep 2017 16:00:53 +0000