Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Speed up your file

The best tool to optimise your Excel model!
Home > English site > Headlines

Excel Headlines

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

This site

The Amsterdam Excel Summit 2015: Registration is now open!
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. Make sure you register!
Thu, 22 Jan 2015 10:15:00 GMT
Registratie geopend: Excel VBA voor Financials V2
Excel VBA voor Financials versie 2; Een twee-daagse Excel VBA cursus (20 en 26 mei 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Tue, 30 Dec 2014 13:05: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
Please contact web-master.

The Ken Puls Blog

By Ken Puls
Creating a VLOOKUP Function in Power Query

Tonight I decided to actually follow through on something I’d been musing about for a while:  building a full fledged VLOOKUP function in Power Query.  Why?  Yeah… that’s probably a good question! Replicating VLOOKUP’s exact match is REALLY easy in … Continue reading

The post Creating a VLOOKUP Function in Power Query appeared first on The Ken Puls (Excelguru) Blog.

Wed, 28 Jan 2015 14:00:00 +0000

.NET & Excel

By Dennis Wallentin

An error has occured while trying to process
Please contact web-master.

PTS Blog

By Jon Peltier
Floating Bars in Excel Charts

Floating bars can be used to plot many types of data sets. (“Bars” in this usage means “bars”, as Excel calls horizontally oriented bars, as well as “columns”, as Excel calls vertically oriented bars.) In a waterfall chart, floating bars (usually vertical) show how contributing factors affect a cumulative total. In a Gantt chart, horizontal floating bars along […]

The post Floating Bars in Excel Charts appeared first on Peltier Tech Blog.

Mon, 26 Jan 2015 08:00:45 +0000

Contextures Blog

By Debrah Dalgleish
Football Fun in Excel

This Sunday is Super Bowl XLIX – the last one that will start with "XL".  Next year, it will be Super Bowl L – that doesn't exactly roll off the tongue!

In 2011, I showed how you can use the ROMAN function in Excel, to change a number into a Roman numeral. That year, they were playing for the 45th time, which was XLV.


Other Football Functions

There are other Excel functions that sound like they could be used in a football game. Here are a few, and I'm sure you can think of others:


Continue reading Football Fun in Excel

Thu, 29 Jan 2015 05:03:00 +0000

Microsoft Excel on MSDN

By various Authors
The Office you love is now on your Android tablet

At Microsoft, we are working hard to reimagine the Office experience for a cloud-first, mobile-first world. On January 21st we previewed versions of Office for Windows 10 fully optimized for touch and mobile devices. Today, we are proud to announce the general availability of Word, Excel and PowerPoint for Android tablets.

The post The Office you love is now on your Android tablet appeared first on Office Blogs.

Thu, 29 Jan 2015 08:00:19 +0000