My very own list of news on Excel, gathered from various sources!
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and added formula block highlighting. 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.
Fri, 20 Jun 2014 15:50:00 GMT
|Commenting has been fixed|
I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.
Mon, 02 Jun 2014 06:30:00 GMT
|The Amsterdam Excel Summit|
Een unieke kans! Beste Excel liefhebbers! Is Excel de eerste en laatste applicatie die u iedere dag gebruikt? Wilt u uw Excel vaardigheden verbeteren en tips krijgen van de absoluut beste Excel experts ter wereld? Dan is dit unieke evenement iets voor u! Excel experts van wereldklasse Een absoluut unieke groep Excel MVPâ€™s zal in mei 2014 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. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u … Continue reading
Sun, 16 Feb 2014 19:54:42 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|Power Query Security Woes|
Recently Iâ€™ve been working on automating a business process for a client. Itâ€™s become a really interesting project that uses a mix of Excel tables, Power Query, Power Pivot and VBA, as well as a WinAutomation script. Before I talk … Continue reading
Mon, 21 Jul 2014 15:05:34 +0000
|Free ApressOpen eBook: Office 365|
I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog. Apress have a series of books that are made available for free. The series is Â named ApressOpen eBooks […]
Tue, 13 May 2014 17:31:55 +0000
|Peltier Tech Advanced Chart Utilities for Mac|
The Peltier Tech Advanced Chart Utilities for Mac is here. Over the past monthÂ a month, I’ve converted the Advanced Edition of the Peltier Tech Chart Utility so that it works on a Mac as well as in Windows. I’m pleased that every feature from the Windows version has made it into the Mac version, though […]
Tue, 08 Jul 2014 06:10:06 +0000
|Excel Roundup 20140714|
Are you using Power Pivot or any of the other Power BI tools in Excel 2013? If youâ€™re not sure where to start, there is a new series on the Power BI blog, that will help you dive into the new BI and visualization features.
The series outline is here, and it will have links to all the articles, as they are added to the blog. The first article is Getting Started with Power Query â€“ Part 1, and it features the 15-minute video shown below. Youâ€™ll need Excel 2013, and the article has a link to download the Power
Continue reading Excel Roundup 20140714
Mon, 14 Jul 2014 04:02:00 +0000
|Webinar: Understanding the Excel Data Model|
The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, guest host Owen Duncan teaches us how Excel Data Models provide lightning fast data analysis and visualizations. Need a 30-second sneak peek?Â Here’s a 30-second trailer perfect for sharing in social media. What you will learn What an Excel Data Model is How to get data into a Data Model How to create relationships…
Mon, 14 Jul 2014 19:16:30 +0000