Subscribe in a readerExcel Headlines
My very own list of news on Excel, gathered from various sources!
This site
| 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 |
| Update: RefTreeAnalyser 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 |
Excel Experts Nederland
Excel Expert Nederland Blog| 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 |
Daily Dose Of Excel
By Dick Kusleika (et al) An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
The Ken Puls Blog
By Ken Puls| 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 |
.NET & Excel
By Dennis Wallentin| 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 |
PTS Blog
By Jon Peltier| 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 |
Contextures Blog
By Debrah Dalgleish| 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 AGGREGATEThe first advantage is that AGGREGATE has 19 functions, compared to SUBTOTAL's 11 functions. Ignore Errors with AGGREGATEAnother 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 |
Microsoft Excel on MSDN
By various Authors| New server release: Spreadsheet controls in Office 2013
Tue, 14 May 2013 18:59:00 GMT |
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.