My very own list of news on Excel, gathered from various sources!
|Updated: An MSForms (all VBA) treeview.|
Our All VBA treeview control for Office has been updated to build 024. We have now included properly working examples for Word and Access!
Mon, 20 May 2013 14:10:00 GMT
RefTreeAnalyser 2.0 has just been updated. Now you can change the hotkeys. People who are using version 2 will be automatically prompted for this update. 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, 03 May 2013 14:00:00 GMT
|Over Felienne Hermans|
Felienne Hermans is de eerste ‘Excel-doctor’ van Nederland, in januari 2013 promoveerde zij op het analyseren en visualiseren van de kwaliteit van Excelsheets. Als mede-oprichter van InfotronÂ zet zij deze methode nu in de markt en daarnaast is ze verbonden aan … Continue reading
Wed, 06 Feb 2013 12:16:35 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|Giving PowerPivot a Keyboard Shortcut|
When I was down at Microsoft for the MVP Summit, I suggested that, as the â€śother most powerful part of Excelâ€ť that PowerPivot, like the Visual Basic Editor, should be given itâ€™s own keyboard shortcut.Â Since Alt + F12 is currently empty, and since itâ€™s right next to the VBEâ€™s Alt + F11 shortcut, it [...]
Wed, 03 Apr 2013 14:00:00 +0000
|Commercial Plugins for LiveCode Community Edition|
Recently RunRev decided to also release their cross-platform development tool, LiveCode, Â as open source. For semi-developer and hobbyist this option Â allow them to develop customized solutions for all present platforms, including Android and iOS. The catch is that all customized solutions must be released under the open source rules, i.e it’s not possible to protect […]
Mon, 13 May 2013 23:02:00 +0000
|Announcing: Peltier Tech Chart Utility|
After months of development, and weeks of frantic testing and fixing and documenting, it’s finally here: The Peltier Tech Chart Utility Six weeks ago I promised that it was coming. I thought it was two weeks away, but I kept thinking of ways to improve it, and I kept finding those last little dumb things [...]
Mon, 15 Apr 2013 03:55:46 +0000
|Sum a Filtered List with AGGREGATE Function|
The SUBTOTAL function is great for calculating totals on a filtered list in Excel. Unlike the SUM function, SUBTOTAL ignores the values in rows hidden by the filter, and can even ignore manually hidden rows, so the total includes only the visible cells.
A new function, AGGREGATE, introduced in Excel 2010, is similar to SUBTOTAL, and has a couple of advantages.More Functions in AGGREGATE
The first advantage is that AGGREGATE has 19 functions, compared to SUBTOTAL's 11 functions.Ignore Errors with AGGREGATE
Another advantage is that AGGREGATE can ignore errors, as well as hidden rows. You can
Continue reading Sum a Filtered List with AGGREGATE Function
RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Sum a Filtered List with AGGREGATE Function Please visit the Contextures page on Facebook
Tue, 21 May 2013 04:01:00 +0000
|New server release: Spreadsheet controls in Office 2013|
In April, we released 2 important new spreadsheet management server-based applications to complement the desktop spreadsheet management features we introduced with the release of Office 2013. Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help you manage the use of spreadsheets and Access databases. Read on to learn more....(read more)
Tue, 14 May 2013 18:59:00 GMT