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.
|Tame Power Query Workbook Privacy Settings|
I recently built a cool Excel solution at work that uses Power Query to reach out and grab some weather data, then upload it into database.Â We use that data in our dashboards, as weather is pretty important to the … Continue reading
Wed, 29 Oct 2014 13:00:00 +0000
An error has occured while trying to process http://xldennis.wordpress.com/feed
Please contact web-master.
|Error Bar Ideosyncrasy|
After usingÂ Excel 2007 for a while, getting used to the idea that everything had changed and we weren’t going back to 2003 ever again, I started fooling around with charts and chart elements. I began to find lots of little changes, most of them actually good ones, even if they were implemented in a funny […]
Wed, 29 Oct 2014 08:00:30 +0000
|New Workbook Based On Old One|
It's almost Halloween, and perhaps you're familiar with the horror story that I'm about to tell you. (And there is a treat at the end of the tale too.)
One day, not too long ago, Dr. Frankexcel needed to create new workbook. Instead of building the new workbook from scratch, Dr. F had a brilliant plan â€“ open an old workbook, and use it as the base for the new file. Just open the old file, then quickly do a Save As, to create the new file, without damaging the existing one.
What could possibly go wrong? Bwaahhhaahhaa!
Continue reading New Workbook Based On Old One
Thu, 30 Oct 2014 04:02:00 +0000
|Office 365 Search is now smarter about spreadsheets|
Businesses use spreadsheets for many critical functions, such as financial reporting and investment modeling, and they need to minimize the risks that using these spreadsheets introduces. The need for strong spreadsheet management is emphasized in these stories compiled by the European Spreadsheet Risk Interest Group (EuSpRIG). Office responded to this need by introducing new features in Office 2013 to help manage the use of spreadsheets for important business functions, and…
The post Office 365 Search is now smarter about spreadsheets appeared first on Office Blogs.
Wed, 29 Oct 2014 16:00:37 +0000