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

Update to Flexfind
Updated: Flexfind. Improved selecting objects.
Thu, 21 Apr 2016 08:50:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved the off-sheet references report to include tables and range names.
Fri, 8 Apr 2016 15: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
Pass Parameters to SQL Queries

One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic. Someone asked a question in the forum on the topic, so that finally inspired me to write … Continue reading

The post Pass Parameters to SQL Queries appeared first on The Ken Puls (Excelguru) Blog.


Thu, 28 Apr 2016 23:56:41 +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
Peltier Tech Charts for Excel Upgrade – April 2016

Peltier Tech Charts for Excel has been updated to Build 3008 3009, on 11 April 2016 17 April 2016. If you are using an earlier build and you want to update to 3008 3009, send me an email. Note: A minor bug was added in Build 3008 and an old bug was supposed to be […]

The post Peltier Tech Charts for Excel Upgrade – April 2016 appeared first on Peltier Tech Blog.


Tue, 12 Apr 2016 13:00:20 +0000

Contextures Blog

By Debrah Dalgleish
Use Running Total to Compare Years in Excel

If you're analyzing sales data from year to year, you can make a line chart that shows each month's sales. That lets you see if there were any months with big differences, and shows how sales went up and down over the year. Another option is to use a Running Total to compare years in Excel. It's quick and easy to set up with a pivot table and pivot chart.

Show Monthly Totals

The quickest way to summarize the annual data is with a pivot table. In the example shown below, the sales date has been grouped by month

Continue reading Use Running Total to Compare Years in Excel

The post Use Running Total to Compare Years in Excel appeared first on Contextures Blog.


Thu, 28 Apr 2016 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors

An error has occured while trying to process http://blogs.office.com/b/microsoft-excel/rss.aspx
Please contact web-master.