Pivot Tables in Excel

An incredibly basic introduction to creating Pivot tables in Excel. 

(more…)

Tags: dataanalysis, excel, microsoft, pivottable

Setting up a macro in Word to paste unformatted text

As a developer, I frequently need to copy and paste code into Microsoft Word documents, but often want to remove the formatting in the process.

This post explains how to set up a macro, and associate it with a keyboard shortcut, to do the equivalent of Edit -> Paste Special -> Unformatted Text. I have tested it on Word: Mac 2011.

(more…)

Tags: keyboard, keyboardshortcuts, microsoft, productivity, shortcuts, word