My very own list of news on Excel, gathered from various sources!
RefTreeAnalyser 2.0 has just been updated. I have added an option to report all unique formulas in your workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Thu, 23 Oct 2014 16:45:00 GMT
|Celebrating my MVP award: Discount offer|
Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. I got re-awarded! To celebrate that I am offering a 3 day 50 percent discount on RefTreeAnalyser. From October 8, 2014 to October 10, 2104 you receive 50 % off of the list price when you enter this coupon code: MVP2014 Head over to my website now and download the tool, you can try it for free!
Tue, 07 Oct 2014 09:30:00 GMT
|Weer een jaar MVP|
Hallo allemaal! Ieder kwartaal maakt Microsoft bekend wie de gelukkige ontvangers zijn van hun Most Valuable Professional Award. Een MVP award geldt voor een jaar, dus voor een kwart van de MVPs is 1 oktober een spannende dag. En ik heb de award weer gekregen!! Om dat te vieren bied ik een 3 dagen durende kortingsactie aan op mijn Formula auditing tool: RefTreeAnalyser Vanaf 8 oktober 2014 tot en met 10 oktober 2104 ontvang je 50 % korting op de tool als je deze couponcode invoert tijdens het bestelproces: MVP2014 Haast je naar mijn website en download de tool, je kunt deze gratis uitproberen! Groetjes, Jan Karel Pieterse www.jkp-ads.com
Tue, 07 Oct 2014 07:28:25 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|Refresh Power Query With VBA|
When Iâ€™ve finished building a solution in Excel, I like to give it a little polish, and really make it easy for my users to update it.Â The last thing I want to do is to send them right clicking … Continue reading
Wed, 22 Oct 2014 13:00:00 +0000
|Articles about installing softwares from SamLogic|
I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable. Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important […]
Wed, 13 Aug 2014 09:55:33 +0000
|Pivot Tables in Microsoft Excel: Links|
This introduction has been contributed by Debra Dalgleish, Excel MVP.Â Contextures, Copyright Â© 2014. All rights reserved. Debra Dalgleish, Excel MVP since 2001, is the author of three books on pivot tables, published by Apress. She shares Excel tips, tutorials, and videos on her websites, www.contextures.com and www.pivot-table.com. Web Sites Peltier Tech Blog – Pivot […]
Mon, 06 Oct 2014 08:15:51 +0000
|Excel Chart Compares High and Low Scores|
Last weekend, I helped someone who needed a chart for a fantasy football league, to show the highest and lowest win/loss scores for each week. To help explain what it should look like, they posted a picture of a hand drawn chart, similar to the picture below.
By the way, I created the sketch in Excel, by using the Marker option, in the Artistic Effects. Who knew that Excel was so artistically talented?Set Up the Data
The win/loss data was set up with a separate column for each week, and rows for the win and loss highs
Continue reading Excel Chart Compares High and Low Scores
Thu, 23 Oct 2014 04:01:00 +0000
|Microsoft sponsors the Financial Modeling World Championships for Excel power users|
ModelOff, the Financial Modeling World Championships for Excel, is a fun and educational international competition for students and professionals. This year, Microsoft continues the tradition of sponsoring this exciting event.
The post Microsoft sponsors the Financial Modeling World Championships for Excel power users appeared first on Office Blogs.
Thu, 23 Oct 2014 17:53:04 +0000