Saturday, January 21, 2012

Microsoft Results just in - does it need another Bill


For your reading pleasure, here are excerpts from the famous Bill Gates memoes at the Seattle Times. Windows 7 hacker just noted some Microsoft results. Nothing like the heady yesteryear. The fountains of money - Windows and Office, are now down to one - Microsoft Office. Windows is selling lots but the income isn't as high.

The Server and Tools business is doing ok, the Entertainment business is doing ok. Sort of correlates to my perceptions. Server and Tools are moving Microsoft upstream to the IT Department and away from their core business supporters - the ones who buy PCs. Is the end user computing dead? Not by a long shot. But Microsoft's slice of the pie is getting smaller.

Remember, lots of gurus were predicting the death of the personal computer by the onslaught of terminals linked to servers? That didn't happen - but now it's mobile and tablet devices linked to the cloud - and that's real, not imagined. What share does Microsoft have in that? Some share of the server business (who, we, the end user don't see) and zilch in the tablet and the phone (devices that are everywhere).

Xbox? Yeah, that's ok but the console games business is terribly competitive and prone to fashion.

Will Windows 8 herald a new coming? Right now, I doubt it. Bringing "fat finger" from hand held mobile devices to the desktop is just uncomfortable - the desktop has the strength of precise pointing and a clean screen at arm's length.

Will Microsoft Office continue its monopoly? For me, yes because I am so, so used to the richness of functions that Excel, Access provide. But better and better web based office administration products are more than capable of making mindless robots out of workers.

Food for thought

Wednesday, October 26, 2011

Bullet Points in Excel

Funny how things evolve. I was leading an introductory class in Excel (yes, we still have those) and one participant wanted demoes on how to use Excel to make Standard Work Procedures - yes, no calculations, just using Excel to draw non uniform tables and grids.

One seasoned Word person noted that some of the grids could have been carried out in Word but admitted that as the grids became wider and so forth, that the Word screen would scroll and sway in a wordy kind of way compared to the grid like behaviour of Excel.

The issue with Excel heavily presented textual work is planning ahead on non uniform tables - if the smallest unit of a grid is not catered for, you can't easily split big cells into smaller cells.

Another point was the infamous bullet points in Word and PowerPoint.  Coincidentally, Debra Dalgleish just blogged about this same topic. Here's her video

The rebuttal to the Anti-PowerPoint Party

Monday, October 24, 2011

The Trouble with PDFs

A client was having some issues where Adobe Acrobat Standard and Reader would not display some pages inside a PDF document. The PDF document was composed of a mix of pages cut and pasted from several PDF documents.

Turns out that the Acrobat PDF standard is a moving target and there are multiple authoring apps (even hardware document scanners) which may or may not comply to one of the standards - there is an Appligent document that explains the issues - and yes it is a PDF document.

Anyway, I found that Acrobat Reader and Standard X (10.1.1) refused to display the thumbnails and the pages in a Version 1.6 document but free NitroPDF Reader 2 (and other third party readers) would display those pages. One work around with some files was to use the free and Portableapped PDFtkBuilder to export the file to a Version 1.4 document. Whether this corrected the malformed PDF or Version 1.4 compliances are less rigid, I don't know.

Excel Macro does SEO comparison

I was looking at Chandoo's recent blog entry - he notes that there is an Excel macro by the Search Engine People that allows you to put in keywords, your website - it then returns a list of competitor websites ranking above your website. Nice example of VBA executing HTTP calls.

Friday, August 19, 2011

The Importance of the installed Printer in Windows

Ross, one of my clients was having a heck of a time trying to make sense of "CoInitialize" Automation  errors in VBA. It happened in VBA commands for Page Setup. He had enlisted professional help in uinstall and re-install of Office. I thought about it and wondered whether Excel was behaving like Word - the existence of a proper printer setup is vital for these programs that need to calculate Print Previews or even calculate document line width and page rendering when they work. He reported back that this was indeed the case.

Whether you are using the Windows machine for long term or for a short teaching stint or short development / testing gig, make sure you install at least one good printer driver. Sometimes a light weight driver like a free Acrobat driver isn't even good enough.

Using Custom Number Formats to Highlight Chart Axis | Chandoo.org - Learn Microsoft Excel Online

Hui via Chandoo.org has written a fun article on the creative use of Number formatting to create unique charts.

Using Custom Number Formats to Highlight Chart Axis | Chandoo.org - Learn Microsoft Excel Online

He's also previously written about Data Tables (no, not the new Tables feature in Excel 2010)


Thanks Hui and Chandoo for freely sharing....

Friday, August 5, 2011

The problem with Microsoft Excel Charts

To put it succintly, Microsoft Excel charts, either work or they don't. That makes it hard to train, particularly as the learning process with charts is non linear and the user interface is non linear as well, there are several entry points to display a menu and not all entry points are obvious. This is particularly maddening considering that Excel is such a comprehensively well thought out and planned program.

For example, if you have seen several series of data points on a chart and they are drawn on different vertical scales, you have to search Excel Help (well, now, it's actually Office Help) on "secondary vertical axis"

And although it's easy peasy to use your Excel cell cursor to highlight a chartable range and press F11, again, Excel maddeningly makes glaringly bad assumptions when your proposed X axis labels are numeric - Excel assumes they are another data series. Tip: Put a leading apostrophe on your proposed X axis labels to force Excel to treat them as X axis labels. Or go the painful way of Select Chart Area > Select Data

Thursday, August 4, 2011

Tuesday, August 2, 2011

Monday, July 25, 2011

Pivot Table Tips (Part 1) « Automate Excel

I was once asked about how to deal with missing values in Pivot Tables. The questioner didn't actually word it that way, for him, the issue was that there was a category in the column axis that was turning out blank and "spoiling" the pivot table. Here's an interesting blog article. Pivot Table Tips (Part 1) « Automate Excel


Wednesday, June 22, 2011

Tuesday, June 14, 2011