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 â€“ The IF function|
In my last post I talked about useful text functions, and how they differed between Excel and Power Query. Today weâ€™re going to look at another compare/contrast scenario, but this time itâ€™s going to be the IF function. Critical background … Continue reading
Wed, 27 Aug 2014 16:15:51 +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
|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 20140825|
There is a free app available for Excel (2013 or Online version), that lets you create 8 different chart types, including some that arenâ€™t standard Excel charts, such as box plots. The app is called XLMiner Data Visualization, and itâ€™s created by Frontline Systems, which also makes the Solver add-in.
If you log in to your Microsoft account, you can download and install the app from the Microsoft Store. Then select data, and the chart appears in the appâ€™s window. In the screen shot below, you can see the box plot chart that I created, in just a few seconds.
Continue reading Excel Roundup 20140825
Mon, 25 Aug 2014 04:01:00 +0000
|The Garage Series for Office 365: Whatâ€™s new in the world of apps for Office?|
This week hosts Jeremy Chapman and Richard diZerega explore what’s new in the new world of apps for Office. They look at the top 5 new features including amazing content apps for PowerPoint, Excel APIs for formatting, content apps for Access, mail APIs for body and attachments and compose mail apps. Watch as Richard masterfully demonstrates all of this along the way. Last week we caught up with Jeremy Thake…
The post The Garage Series for Office 365: What’s new in the world of apps for Office? appeared first on Office Blogs.
Wed, 23 Jul 2014 19:40:31 +0000