Wednesday, October 26, 2011
Monday, October 24, 2011
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.
Wednesday, October 5, 2011
Thursday, September 22, 2011
Friday, August 19, 2011
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.
Monday, August 8, 2011
Comprehensive List of Excel Keyboard Shortcuts - 97 shortcuts to boost your productivity | Chandoo.org - Learn Microsoft Excel Online
Friday, August 5, 2011
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
Wednesday, June 22, 2011
Friday, June 17, 2011
Microsoft Excel: The Program's Designer Reveals The Secrets Behind The Software That Changed the World 25 Years Ago - The Daily Beast
Thursday, June 16, 2011
Tuesday, June 14, 2011
Tuesday, June 7, 2011
Monday, June 6, 2011
Thursday, June 2, 2011
Friday, May 20, 2011
Wednesday, May 18, 2011
Tony(?) asked in class about enhancing Validation Drop Down Lists in Excel so that he could use a cascading set of three Drop Down Lists. The article hyperlink explains how to do this.in reference to: http://www.bluepecan.co.uk/excel_training_cascading_drop_down_lists_using_data_validation.html (view on Google Sidewiki)
Wednesday, April 27, 2011
"In Word 2010 choose File > Options > Advanced tab and locate the Cut, Copy and Paste group. From the Insert/Paste Pictures as dropdown list choose Square and click Ok."in reference to: http://projectwoman.com/wordpress/2011/04/permanently-fix-words-image-insert-behavior.html (view on Google Sidewiki)
Monday, April 18, 2011
Tushin Mehta explains how to resolve VBA programming issues when Excel won't exitin reference to: http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/ (view on Google Sidewiki)
Monday, April 11, 2011
Thursday, April 7, 2011
Microsoft Office Knowledgebase articlein reference to: http://msdn.microsoft.com/en-us/office/cc907897.aspx (view on Google Sidewiki)
Wednesday, March 23, 2011
Friday, March 18, 2011
Released as multiple downloads.in reference to:
Friday, March 4, 2011
A comprehensive description of incompatible featuresin reference to: http://msdn.microsoft.com/en-AU/office/cc907897.aspx (view on Google Sidewiki)
Nice to have a hub for Access as well.in reference to: http://technet.microsoft.com/en-AU/office/gg406142.aspx (view on Google Sidewiki)
This appears to be labelled as the "Springboard Series" - nevermind, it seems to be a hub of links.in reference to: http://technet.microsoft.com/en-us/office/gg605176.aspx (view on Google Sidewiki)
Wednesday, March 2, 2011
The people at the University of Reading have created this comprehensive .pdf file on the many ways one can insert a foreign character or symbol into Word 2007.in reference to: http://www.reading.ac.uk/web/files/its/Symbols2007.pdf (view on Google Sidewiki)
Friday, January 28, 2011
Wish more people knew about itin reference to: http://blogs.office.com/b/microsoft-word/archive/2010/08/09/show-me-the-style-area-pane-in-word-2010.aspx (view on Google Sidewiki)
Saturday, January 15, 2011
It’s Excel’s 25th Anniversary Year. As someone who is lives and breathes Excel, it’s great to see Excel greats from Microsoft speak. People like Charles Simonyi who gave us the Hungarian Naming Convention (and influenced not only Excel VBA but many other products) had a hand in Excel. And I remember this colleague called Mei Ling – she was into Multiplan as well – when I said why? It’s R1C1 – that’s dyslexically confusing compared to Lotus 1-2-3, Supercalc, Visicalc and now Excel’s A1 (grin). Little did I know when you program Excel in VBA, it’s often easier to think in R1C1 for cell addressing. Two videos from the Office team:
Friday, January 14, 2011
2010 is Excel's 25th anniversary and here's news from the start up daysin reference to: http://www.thedailybeast.com/blogs-and-stories/2010-12-27/microsoft-excel-the-programs-designer-reveals-the-secrets-behind-the-software-that-changed-the-world-25-years-ago/ (view on Google Sidewiki)
Saturday, January 8, 2011
I remembered demonstrating Garbriola aesthetics in a class and promptly lost my reference. Here is the how to.in reference to: http://www.howtogeek.com/howto/13484/use-advanced-font-ligatures-in-office-2010/ (view on Google Sidewiki)
I’ve been teaching more than doing recently, so this start of 2011, I am by chance, having the time to work with some documents with Word 2010. The management of Styles has been enhanced and modified to some extent. I found my favourite keystrokes to strip paragraph formatting Ctrl+Q and to strip direct character formatting, Ctrl+Space didn’t do it for me. Puzzled, I looked around at how things had subtly changed.
Really, if you are writing, you don’t want to be bothered with formatting. And yet when you cut and paste, the alien paragraphs indeed look alien. First thing is to check out the default Paste attributes:
The defaults are to keep source formatting – ask yourself whether you want to change that to Merge Formatting or to Use Destination Formatting. Sure avoids all that frustrating alien looking chunks and the obsessive compulsive behaviour in cleaning up after every Paste.
If you really need to strip Paragraph and direct Text formatting, you need to get the Style Inspector. One way to get it is to click on the Styles Pane Dialog Launcher in the Ribbon – Home Tab. Then click on the icon exposing the Style Inspector. If you are going to use it frequently, consider dragging it to the left or right so that it becomes a static vertical pane (non floating).
Then all you have to do is to place your cursor appropriately in the document and hit the Reset or Clear buttons. There are four of them in All.
Notice the Clear All button. By the way, in the Styles Pane there is a Clear All pseudo style. I did try that, it didn’t seem to deliver the goods.
Thursday, January 6, 2011
Wednesday, January 5, 2011
Here we are, Tables in Excel, in 2010, version 2 and it's got even better. But reading responses from users, people are seldom satisfied with anything, all together.....in reference to: Table Improvements in Excel 2010 - Microsoft Excel 2010 - Site Home - MSDN Blogs (view on Google Sidewiki)