Saturday, January 15, 2011

Living and Breathing Excel

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:


History of Excel Part 1

History of Excel Part 2 Tags: ,,

Saturday, January 8, 2011

Advanced Font Ligatures in Word 2010

I remembered demonstrating Garbriola aesthetics in a class and promptly lost my reference. Here is the how to.

in reference to: (view on Google Sidewiki)

Managing your Styles

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

PowerPivot demoes on YouTube

Good ol' Bill Jelen shows PowerPivot with 1.8 million records. Other PowerPivot videos on the right vertical panel in YouTube. He shows the automatic match without needing to write VLOOKUP.

in reference to: YouTube - PowerPivot Mashup (view on Google Sidewiki)

Wednesday, January 5, 2011

We're seldom all satisfied

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)