Subscribe in a readerExcel Headlines
My very own list of news on Excel, gathered from various sources!
This site
| Excel opstart problemen pagina bijgewerkt De pagina is bijgewerkt voor de Excel versies 2007 en 2010. Mon, 22 mar 2010 08:40:00 GMT |
| New article: Importing Text Tiles In An Excel sheet If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't set up how it gets imported. The text import wizard does not start for these file types. What if you have the situation where you get files with similar structure, which need the same text import settings over and over? How do you import the data from those files into the same worksheet each time, without having to re-define the import settings over and over again? I'll tell you. Thu, 11 Mar 2010 09:00:00 GMT |
Daily Dose Of Excel
By Dick Kusleika (et al)| PowerPivot – Part 4 of 4: A geographic visual display of 18 million US Census records Part 1: http://www.dailydoseofexcel.com/archives/2010/02/26/powerpivot-part-1-of-4/ Part 2: http://www.dailydoseofexcel.com/archives/2010/02/27/powerpivot-part-2-of-4-prepping-the-census-data/ Part 3: http://www.dailydoseofexcel.com/archives/2010/03/02/powerpivot-part-3-of-4-conditional-shape-colors/ In this tip I discuss integrating the result of a PowerPivot analysis of a large data set (18 million records) into a geographic map using a method I call “Conditional Color of Shapes.” For a version in a page by itself (i.e., not in a scrollable iframe as below) visit [...] Thu, 18 Mar 2010 22:00:00 +0000 |
| Charting House I was watching a DVR’d episode of House recently and I became aware that the amount of show between commercials was changing as the show went on. The commercials were getting closer together. Then at the end, a long run of show between the last commercial and the credits. I did what [...] Tue, 16 Mar 2010 13:00:47 +0000 |
The Ken Puls Blog
By Ken Puls| The danger of being out of date… Tonight I discovered that my site had been hacked… as it turns out I was running an old version of Wordpress and there was some injection code fed into a security vulnerability. I’ve upgraded to the latest version, which has cured that issue, but in the process some things seem to have occurred: I’ve [...] Thu, 05 Nov 2009 06:37:40 +0000 |
| WinAutomation Winners Sorry folks, I intended to post this yesterday, but I’ve been having issues posting to my blog from Word. Somehow it’s just stopped working. I have a full post ready to go, but it’s just not publishing for some reason, from either Word 2007 or 2010. It would seem to indicate that the issue is [...] Fri, 30 Oct 2009 03:31:45 +0000 |
.NET & Excel
By Dennis Wallentin| The COM Shim Wizard for VS 2010 is available Misha Schneerson has now made the Shim Wizard for VS 2010 available for download. What should be noted is that the new version is not officially released by Microsoft and it’s not officially supported. For more information please see COM Shim Wizards for VS 2010. In view of the fact that VSTO is getting better and better for [...]  Sat, 20 Mar 2010 11:33:46 +0000 |
| Preserve Size and Location of Windows Forms – Part I Introduction To preserve size and location of Windows Forms are in many ways a common service towards the end users. In this first part I will take a closer look into how we can remember theses settings between the sessions for standalone applications in VB.NET. In part two and last article I will discuss it for [...]  Fri, 19 Mar 2010 12:28:22 +0000 |
PTS Blog
By Jon Peltier| Charting Breakdown of Ads in a Television Show Dick Kusleika’s a fan of House, and so am I. Last week in Charting House, Dick analyzed the commercial breaks in an episode that he’d recorded for later viewing. Dick’s first cut at the data was a stacked bar chart, which basically tracked the segments of actual show and commercial breaks in sequence through the [...] Mon, 22 Mar 2010 05:09:24 +0000 |
| Crosstab Heat Map Heat maps are a popular way to display varying values in a two-dimensional display. The heat map may be an actual geographic map with regions colored differently according to some variable, for example, population density or electoral results. I showed such maps, also called cartograms or choropleths, in Redrawn Electoral Maps and An Undistorted Election [...] Wed, 17 Mar 2010 07:00:02 +0000 |
Contextures Blog
By Debrah Dalgleish| Calculating Rank in Excel This article was going to be about sorting in Excel, because Jim Cone just sent me the latest version of his Special Sort add-in. So, I hauled one of the big, dusty Excel books off my shelf, to see if there were any scintillating sorting secrets to uncover. Under Sorting, I saw “rank calculations” [...] Mon, 22 Mar 2010 04:02:00 +0000 |
| Number the Visible Rows in Excel AutoFilter When you use an Excel AutoFilter to filter a list, usually the count of visible records appears in the Status Bar, at the bottom left of the Excel window. (Note: If the Status Bar shows Filter Mode, instead of the record count, you can use one of the workarounds shown here – Status Bar [...] Fri, 19 Mar 2010 04:02:00 +0000 |
Professional Office Developers Association's Blog
By various Authors An error has occured while trying to process http://feeds.feedburner.com/ThePodaBlog?format=xml
Please contact web-master.
Putting You & I Back Into Office 2007 UI
By Patrick Schmid| Outlook 2010: 7+ Home tabs Outlook 2010 has 7+ tabs labeled Home. Let me introduce them to you (none of them were taken with an Exchange account; apologies for the varying screen resolutions): Mail Mail - IMAP Note: Quick Steps don’t show in the technical preview for IMAP due to a bug Mail - RSS Calendar Calendar - List view Contacts Tasks Notes Journal Sun, 02 Aug 2009 11:36:47 +0000 |
| Computer woes Part of the reason why it has been quiet on the RibbonCustomizer front is that the mainboard of my main computer (a good old Gigabyte mainboard with an AMD 64) died after years of faithful service. Unfortunately, replacing my computer with a brand-new Core i7 based machine became a nightmare on its own. Used to the [...] Tue, 28 Jul 2009 12:11:16 +0000 |
Microsoft Excel on MSDN
By various Authors| Change charts, represent +/-, and count the Mondays between 2 dates Bill Jelen has been running the MrExcel podcast for years now. For those that haven’t heard of it, it’s a frequently updated video podcast that teaches you Excel, showing everything from the basics of the fill handle to advanced tips around charting, and everything in between … including some recent tricks with linked pictures. Since there’s a lot of great information in his videos, we thought that a weekly (or so) wrap-up of his podcast would be a nice thing to add to the blog. If you have ideas for more community showcasing & interaction please send me an email via the link at the top of the blog. Here’s a recap of some recent MrExcel videos: 
Episode 1181: Learn how to create a dropdown that allows you to change the chart displayed on your worksheet, without code! 
Episode 1182: Bill Jelen and Mike Gel Girvin show you how to visually present statistical values (+/-) in a cell. Episode 1185: Mike and Bill get together again and tackle counting the number of Mondays between two dates. Bill and Mike had great ways of solving the problems, would you do it a different way? Check out these and many more Excel videos at http://www.mrexcel.com Tue, 16 Mar 2010 20:30:00 GMT |
