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

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

Nieuw artikel: curves fitten met de kleinste kwadraten methode
Als je (net als ik, voordat ik Excel specialist werd) ingenieur bent, dan heb je waarschijnlijk het nodige aan experimeteerwerk gedaan. Vaak heb je dan een methode nodig om je meetresultaten te fitten met een kromme. En als je een echte ingenieur bent, dan heb je ook al een goed idee wat de soort vergelijking is de theoretisch bij je metingen zou moeten passen.
Wed, 12 Apr 2016 07:50:00 GMT
Nieuw artikel: Een klasse om VBA performance te meten
Ik ben er eindelijk aan toe gekomen een artikel te vertalen. Dit artikel beschrijft een methode om eenvoudig de performance van je VBA routines te meten.
Tue, 17 May 2016 07:50:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Tref ons op de 10e Excel Experience Day!
Vrijwel al onze Excel Experts zullen op de 10e Excel Experience Day als spreker fungeren. Dus als u ons wilt ontmoeten (en -wellicht- spreken over toekomstige projecten), dan is dat een uitgelezen gelegenheid! Dus schrijf u nu in en tref ons 10 december in Burgers Zoo! Jan Karel Pieterse
Wed, 04 Nov 2015 16:47:27 +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
Keep The Most Recent Entry

This week’s post was inspired by a question in my Power Query help forum.  The poster has a set up data, and needs to keep the most recent entry for each person from a list of data. Background I never … Continue reading

The post Keep The Most Recent Entry appeared first on The Ken Puls (Excelguru) Blog.


Wed, 25 May 2016 13:00: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
Paired Waterfall Chart

The Paired Waterfall Chart I came across a new (for me) style or waterfall chart last month, which I call the paired waterfall chart. It is designed to show how an investment fund’s total holdings, comprised of stocks or other vehicles and cash, changes during a time period, based on changes in value of its […]

The post Paired Waterfall Chart appeared first on Peltier Tech Blog.


Thu, 12 May 2016 13:00:21 +0000

Contextures Blog

By Debrah Dalgleish
Excel Lookup With Two Criteria

If you need to get a product price in Excel, you can use VLOOKUP or INDEX/MATCH to get the price from a lookup table, based on a product code. But what if you have two pieces of information, such as a product name, and a size, and you want to find the price based on that information? How can you do an Excel lookup with two criteria?

Use INDEX and MATCH

A few years ago, I posted an example that shows how to check multiple criteria with INDEX and MATCH. There is a lookup table with columns for product

Continue reading Excel Lookup With Two Criteria

The post Excel Lookup With Two Criteria appeared first on Contextures Blog.


Thu, 26 May 2016 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Office 365 news roundup

Learn how Microsoft is making Office 365 more accessible and easier to use, and catch up on the recent news about Office 365. Enjoy!

The post Office 365 news roundup appeared first on Office Blogs.


Fri, 27 May 2016 19:00:00 +0000