My very own list of news on Excel, gathered from various sources!
RefTreeAnalyser 2.0 has just been updated. Improved placement of pictures of far-away cells. 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.
Wed, 06 Nov 2013 12:30:00 GMT
RefTreeAnalyser 2.0 has just been updated. Visualisation colors can now be changed. 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, 01 Nov 2013 16:15:00 GMT
|Broncellen van formules|
Hallo, Wie herkent dit niet, je hebt een lastige formule en je wil snel kunnen zien welke cellen door de formule gebruikt worden. Excel biedt hiervoor een ingebouwde tool voor genaamd “Broncellen aanwijzen”. Dit levert (als er ook verwijzingen naar … Continue reading
Tue, 29 Oct 2013 16:10:09 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|From TXT files to BI solution|
Several years ago, when Power Pivot first hit the scene, I was talking to a buddy of mine about it. The conversation went something like this: My Friend: â€œKen, Iâ€™d love to use PowerPivot, but you donâ€™t understand the database … Continue reading
Tue, 26 Nov 2013 18:00:00 +0000
|Add-in Express Series for Excel Beginners|
Add-in Express have published a great number of interesting articles for Excel beginners. To be more specific, Excel beginners who use their All-in Framework .NET to create COM Add-ins, RDTs and Functions Libraries (XLLs and UDFs). Here is the link to the first article in the series: http://www.add-in-express.com/creating-addins-blog/2013/09/23/excel-addin-development-application-base-objects/ Enjoy! Kind regards, Dennis
Tue, 19 Nov 2013 17:51:06 +0000
|Funny Math in Wall Street Journal Pie Charts|
This is a quickie to describe a mathematical disconnect I encountered last week. While my wife and daughter were shopping in the mall, I hunkered down in the mall Starbucks with the Wall Street Journal. I never read the Wall Street Journal unless I’m hunkered down in a coffee shop. Anyway, after doing the crossword […]
Thu, 31 Oct 2013 08:00:12 +0000
|Show Input and Error Messages in Excel|
With data validation, you can control what is entered in a cell, and prevent invalid data. I usually use drop downs, to create a list of options for people to choose from.
Sometimes a list isnâ€™t the best option, and I have to use one of the other data validation settings.Enter a Number
There are several other things that you can allow in a cell, instead of a list, such as whole numbers or dates. In this example, the cell will only allow whole numbers.
After you select from the Allow drop down, one or more boxes
Continue reading Show Input and Error Messages in Excel
Thu, 05 Dec 2013 05:01:00 +0000
|Invitation to the New York Finals of the 2013 Excel Financial Modeling World Championships|
After two challenging online rounds among more than 3,000 international competitors, ModelOff 2013--the Excel Financial Modeling World Championships--has announced its 16 Finalists.
This weekend, these 16 Excel experts will assemble in New York to test their Excel modeling skills and compete for the $30,000 first prize. You're invited to attend the ModelOff Live Finals at Microsoft's New York offices on Sunday, December 8 (3-5pm). Read on for details......(read more)
Thu, 05 Dec 2013 12:00:00 GMT