Subscribe in a readerExcel Headlines
My very own list of news on Excel, gathered from various sources!
This site
| Update: RefTreeAnalyser (build 1.0.28) RefTreeAnalyser has been updated. I have fixed a bug regarding hidden worksheets, which could cause the tool to generate runtime errors. Do you have a license? then get this free download to 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. Thu, 26 Jan 2012 06:55:00 GMT |
| Nieuw artikel: Web paginas maken met Excel Web App mashups Met het op de markt komen van Excel 2010, heeft Microsoft ook de mogelijkheid geintroduceerd om Excel documenten on-line te bewerken, gebruik makend van de "Excel Web App". Indien je een Live account hebt, kan je een Excel 2010 bestand plaatsen op je skydrive. Iedereen die toegang heeft tot die Skydrive map, kan vervolgens dat Excel bestand on-line openen en in de browser berwerken. Tevens is het mogelijk om dat Excel bestand te integreren op iedere web pagina. Thu, 05 Jan 2012 10:25:00 GMT |
Daily Dose Of Excel
By Dick Kusleika (et al)| Tell Tale Signs There are a few programs whose output I can identify immediately. One is Quickbooks. When I get an invoice or a quote from someone using Quickbooks, I know it right away. Today, I was admitted to the Omaha West Rotary, officially making me a Rotarian. They gave me the list of members. Any guesses what [...] Fri, 03 Feb 2012 22:21:50 +0000 |
The Ken Puls Blog
By Ken Puls An error has occured while trying to process http://feeds.feedburner.com/excelguru
Please contact web-master.
.NET & Excel
By Dennis Wallentin| Best Practices Export Data to Excel If You’re a VBA Developer You should know what best practices is to export data to MS Excel. Two expressions summarize it; Microsoft ActiveX Data Object Library and CopyFromRecordset. However, if You’re a .NET developer and face a situation where You must find a solution to export data to MS Excel then there is a [...]  Mon, 30 Jan 2012 12:43:28 +0000 |
PTS Blog
By Jon Peltier| Chart Busters: What Planned Parenthood Actually Does According to Do You Know What Planned Parenthood Actually Does?, “the Susan G. Komen Foundation has announced they will stop funding Planned Parenthood for breast cancer exams and other breast-health services.” MoveOn.Org attributes this action on pressure from the Republican Party, because of their stance on abortion and on the abortion practices of Planned Parenthood. Planned [...] Thu, 02 Feb 2012 08:00:42 +0000 |
Contextures Blog
By Debrah Dalgleish| Excel SUMIFS Sum With Multiple Criteria In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria. For example, sum the orders where an account status is Active, and the number of visits is greater than or equal to 10. You can type in the criteria, but it's better to use cell [...] RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog . You can read the full article here: Excel SUMIFS Sum With Multiple Criteria Please visit the Contextures page on Facebook Thu, 02 Feb 2012 05:02:00 +0000 |
Professional Office Developers Association's Blog
By various Authors| Path and Filename Functions VBA Express has what I consider to be the ideal functions for returning file name and path from a given input string. They avoid those pesky loops which I see on a few sites. As an exercise I thought of a few more ways to do so. I didn't completely avoid loops, but I thinkContinue Reading: Path and Filename Functions » Path and Filename Functions is Copyright © The PODA Blog. All Rights Reserved. Thu, 24 Mar 2011 15:00:17 +0000 |
Microsoft Excel on MSDN
By various Authors| Excel: The Basics (Video)
In this video, the Office 911 emergency responders show a beginning Excel user how to add a table to a worksheet so she can better organize and view her data. ...(read more)Wed, 01 Feb 2012 17:38:00 GMT |
For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about 