Case Study 3: Custom Shortcuts – Insert Formula in Word 2013 With a Keyboard Shortcut

Posted by & filed under Custom Shortcuts, Development.

Note: Want your own shortcut? Mail me at  jan@keyrocket.com! Today Brendon asked whether we could give her Ctrl+Shift+F as a custom shortcut to insert an equation in Microsoft Word 2013. Luckily Word is the only Office application where you can assign custom shortcuts already. Here is how to create a custom shortcut in Microsoft Word… Read more »

Case Study 2: Custom Shortcuts – Pop-Out / Discard in Outlook 2013 With a Keyboard Shortcut

Posted by & filed under Custom Shortcuts, Development.

Note: Want your own shortcut? Mail me at  jan@keyrocket.com! Update: You can actually press Ctrl+O to Pop-Out and Escape to discard (Source). Sometimes there are these buttons you can click on with the mouse, but all you want is a nice little keyboard shortcut to keep your hands on the keyboard. Tom Ward from Viligant.IT asked… Read more »

Case Study 1: Custom Shortcuts – Unhide all Excel worksheets with a single keyboard shortcut

Posted by & filed under Custom Shortcuts, Development.

Note: Want your own shortcut? Mail me at  jan@keyrocket.com! Wouldn’t it be great if we could have custom shortcuts for the things that we do often? Here’s a prime example for such a bugger. Rob Moffat pointed out to me that he often receives financial models (excel files) that contain hidden worksheets, and went on to say… Read more »

Select filename with Hive

Posted by & filed under big data.

Since I searched for this for >5 minutes despite knowing it’s out there (I googled it before). This time I will put out this block post so others have an easier time googling. How can one select the row number or filename in Hive? That means for a query like this Select name FROM names… Read more »

Quickly testing UDFs in hive command line

Posted by & filed under big data.

For our operation ‘Overkill’ (using hadoop on our little big data is just too much fun ;-) I need to convert a date (maybe another blog post) there are lot of UDF (user defined functions) from hive to help, but i need a little testing. One thing that is really annoying with hive is that… Read more »

Microsoft Office 2013 also coming to KeyRocket

Posted by & filed under blog, Development.

I’m excited about the news from Redmond on the next upcoming release of Office 2013. Everybody can try it for free by visiting Microsoft Office 2013 Preview. It was flawlessly installed in about 30 minutes on my Windows 8 machine. From first use it felt quite solid and the new look is super clean, fitting… Read more »