Posted by .
Comments

Today we decided to move to Office 365 from previously using Google Apps (Mail, Calendar, Docs) & Microsoft Office Desktop & Box.net for storage.

The impetus to make the move came from this great article: From Google Apps to Office 365: Why my company ditched Google

For us it boils down to:

  • We are passionate Microsoft users and developers since forever
  • B2B image: Going with “Microsoft Exchange / Office 365″ just sounds more corporate and serious than free “Google Apps” where you and your data “are the product” and pay with advertising
  • History & Cost: But we started using Google Apps when Gmail was miles ahead of outlook.com and the entire apps suite was free for up to 50 users
  • Ecosystem: Our clients all use the Microsoft applications, chances are they will keep using Microsoft even when using Cloud Apps
  • Drive & Docs:
    • the attribution of files to accounts + permissions drove us crazy (now using box.net + Google Docs for real-time collaboration)
    • We depend on Microsoft Office and Googles integration of Microsoft Documents into Drive /
  • Both systems will have flaws

The rough plan we made is

  • Sign up Office 365
    • Test Word & Excel for Google Docs like real time collaboration
  • Make 365 Play with our IOS / Android phones
  • Migrate
    • Email
    • Calendar
    • Contacts
    • Google Drive
    • Box.net (Files)

I’ll follow up with blog posts as we go along.

Posted by .
Comments

Some people are using spaces to increase the distance between a bullet point and its text. That’s perfectly fine as long as things don’t get copied together. Then there’s a very high chance you will end up with some bullet points with and some without space:

Example

Finding this inconsistency on long presentations can be tedious work. This is where SlideProof comes into play (Try SlideProof). By checking your presentation for errors, inconsistent number of spaces between bullets and text can be easily spotted. By default, fixing would choose the number of spaces that appear most often (in the screenshot example that 0 spaces).

If you want, you can also choose the number of spaces manually by expanding the warning and clicking “Take this” on a different number of spaces.

Example2

Posted by .
Comments

Am0

Summary

How does it happen?
  • Accidently select a shape and later touch the cursor key
  • Accidently drag them with the mouse or – more probably – by swiping over the touchpad
  • When using copy and paste a lot (during collaboration)
Why is it bad?
  • Distracts audience
  • Undermines credibility (attention to detail)
What’s the solution?
  • Manual: Reset layout via Ribbon Menu (Home > Reset Layout)
  • Manual: Move shapes back in place via mouse/cursor
  • Automatic: SlideProof

Detail Description

When creating presentations in PowerPoint it’s quite common to accidently move a placeholder like a title or content without noticing. This might easily happen, for example, when a shape is selected and one accidently touches the cursor keys or by dragging them while brushing over the touchpad & mouse. When working in a team the chances are even higher that somebody breaks the deck’s layout this way.

In the past the only way to recognize the error is by manually reviewing the presentation over and over again. For example by printing it in order to flip from one slide to another and spot the transitions where the shape jumps in position ever so slightly. The catch, even if one does not find it the moved placeholders, chances are high the audience will recognize them later.

Aw1

But let’s assume the best case and the moved shape was spotted beforehand – How can it be fixed? Either execute the “Reset Layout” command in the Home Ribbon Menu or move it manually. Both manual methods are cumbersome and have to be repeated for every slide that contains moved placeholders.

With SlideProof one click is enough to check the entire presentation for this type error of moved placeholders. With just another click the placeholders are moved back into position and the audience will focus on what’s most important: Your content, not the form.

Get SlideProof now to fix accidently moved placeholders and many other inconsistencies in your PowerPoint Presentations.

Posted by .
Comments

It took some time until we implemented assignment of Custom Shortcuts from within the KeyRocket Shortcut Browser. The feature is now available in our frontier version and will be released for all users in about one week.

1. Open the Shortcut Browser by pressing Win+Shift+K
2. Search for the action you want to assign
3. Press the wrench to assign a shortcut
4. Press the shortcut and finish with Enter
5. Here you go: Your custom shortcut

AssignCustomShortcut

Posted by .
Comments

Did you ever want to change a particular shortcut to something else in Microsoft Excel? Jackson, one of our latest customers wanted to use Ctrl+Enter instead of F2. Unfortunately you can’t do that directly in KeyRocket yet. But I can definitely see how you want something like that if you are a keyboard enthusiast.

So here is how.

  1. Download & Install Autohotkey
  2. Download this script or copy the content into your Autohotkey.ahk

    #IfWinActive ahk_class XLMAIN ; hotkeys only works in Excel
    ^Enter:: ; a hotkey, capture when Ctrl+Enter is pressed
    Send {F2} ; send the F2 key instead

  3. Adjust the mappings (refer to this list of key names)
  4. Make sure the script is loaded on startup (copy it to your auto-run folder).

A more general process for other applications is described in this Autohotkey Forum thread.

Any questions please ask!

Posted by .
Comments

We listened to our users and made our notifications less annoying by two minor changes:

  1. Size: We optimized the screen space our shortcut notifications take. This was a trade-off between looking good, read-ability and space.
  2. Move-able: Sometimes notifications overlapped always the same controls. That’s why we made the notifications move-able. Just move them with the mouse to the screen position where they should appear in the future.

Those changes are now released on our frontier version and will be available to all users in about a week.

Notification_Suggestion_01

Posted by .
Comments

Free Online PDF to Excel Converter is a reliable and hassle-free tool that, as the name suggests, converts PDF files to Microsoft Excel spreadsheets.

The tool was designed to aid Excel users in quickly and accurately turning their PDF-archived data into editable sheets. It is very helpful to math teachers and students, statisticians, project managers and anyone else in need of handy data management software.

The best thing about PDF to XLS converter, aside from being free of charge, is that it is extremely easy to use. The tool’s page provides a simple 3-step guide on how to upload a chosen PDF file, input an email address and click the “Start” button to initiate the conversion process. After a few seconds, the user receives a link to his or her downloadable, editable Excel document.

The PDF Converter provider guarantees maximum user privacy and erases all received files and email addresses within 24 hours.

convert-pdf-to-xls-online-free

Posted by .
Comments

You can now add your own, totally customized keyboard shortcuts in Excel, PowerPoint and Visual Studio with KeyRocket.  KeyRocket also includes 40 of the most requested shortcuts by default to give you a head-start.

Have you ever come across an annoyingly long or complicated keyboard shortcut in Excel or PowerPoint? With KeyRocket (Free Download) you can now use very short personalized shortcuts to trigger most PowerPoint or Excel functions.

Example:
The standard keyboard shortcut for ‘Merge Cells’ in Excel is Alt > H > M > M .
With ‘KeyRocket Custom Shortcuts,’ you can assign Ctrl+M (or any other combination you want).

MergeCells4

The best part? Creating a shortcut is as easy as pie.

How to assign a custom shortcut:

When you click a particular button often, a special KeyRocket notification appears.

  1. Click inside the suggestion box
  2. Press the keyboard shortcut combination you want to use
    (any combination of Alt, Ctrl, Shift and Numbers/Letters, even sequences. Just try!)
  3. Press Enter to “Save” your new shortcut (or click the “Save” button)

That’s it; your new Custom Shortcut is ready to go!

Notes:

  • If you picked a shortcut that is already in use, you won’t be able save and there will be a conflict indicator (read more about Shortcut Conflicts).
  • For now, KeyRocket Custom Shortcuts are available in the English versions of Excel and PowerPoint 2007, 2010 and 2013.

By the way, we’ve already added default settings for the 40 most requested shortcuts. See the full lists here: Missing Shortcuts for ExcelMissing Shortcuts for PowerPoint.

 

Related Articles:

Press Release (PDF) - ‘The Shortcuts Microsoft Forgot’ - Add your own keyboard shortcuts to Excel, PowerPoint, and Visual Studio with KeyRocket

Shortcut Conflicts – What can I do when a shortcut is already in use?

How do I remove or delete a KeyRocket Custom Shortcut?

How do I update KeyRocket to the latest version?

The Missing Shortcuts for Microsoft Excel

The Missing Shortcuts for Microsoft PowerPoint

 

Posted by .
Comments

Every advanced PowerPoint user will tell you the same story. You start out with PowerPoint and learn some basic shortcuts, getting faster and faster and more effective every day. But sooner or later, you realize there are certain mouse clicks that you just can’t get rid of, no matter how many shortcuts you learn.

KeyRocket to the rescue!  Voilá, here’s the list of easy keyboard shortcuts which are automatically at your fingertips with KeyRocket but aren’t available in Microsoft PowerPoint on its own:

Function Shortcut
Align Left Ctrl+Alt+1
Align Right Ctrl+Alt+3
Align Horizontal Center Ctrl+Alt+2
Distribute Objects Horizontally Ctrl+Alt+4
Align Top Alt+Shift+1
Align Vertical Center Ctrl+Alt+2
Align Bottom Alt+Shift+3
Distribute Objects Vertically Alt+Shift+4
Align to Slide Ctrl+Alt+5
Bring to Front Alt+Shift+W
Bring Forward Alt+Shift+S
Send Backward Alt+Shift+A
Send to Back Alt+Shift+Q
View – Normal Ctrl+1
View – Outline Ctrl+2
View – Notes Ctrl+3
View – SlideSorter Ctrl+4
View – Reading Ctrl+5
Increase Font Size Ctrl+Shift+.
Decrease Font Size Ctrl+Shift+X
Object – Regroup Ctrl+Shift+,

 

Please send all feedback to jans@keyrocket.com

Background: After we’d developed ‘KeyRocket Custom Shortcuts’ we realized that most users need the same ‘most frequent’ custom shortcuts. So, instead of having everybody assign their own shortcut, we decided we’d take the established industry standards and implement them as defaults.

If you haven’t already done so, be sure to get your Free Download of KeyRocket to master keyboard shortcuts and take advantage of these additional shortcuts that Microsoft forgot.

 

Related Articles:

The Missing Shortcuts for Microsoft Excel

‘The Shortcuts Microsoft Forgot’ – Add your own keyboard shortcuts to Excel, PowerPoint, and Visual Studio with KeyRocket.

Shortcut Conflicts – What can I do when a shortcut is already in use?

How do I remove or delete a KeyRocket Custom Shortcut?

 

Posted by .
Comments

TL;DR - Using a password manager with convenient auto-type and sharing allows you to pick very strong, unique passwords for all sites. We started to use KeePass to fill that role.

At KeyRocket, we care deeply about streamlining workflows. Naturally, we’re interested in password managers. Somebody recently tipped us off to KeePass and we gave it a try. In general, a password manager allows you to store all your passwords and has some kind of feature to make it easy to enter them.

Note: this is a Windows approach, not sure how this would work on other operating systems.

Less typing

Auto-Type is really easy to set up, when you create a password, just go to the Auto-Type tab, click Add and find the right window + enter wildcards for example to for twitter enter *twitter*.

That way you can open twitter.com in the Browser, select the username field and press Ctrl+Alt+A to fill your username/password.

Improved Password Security

Not needing to remember passwords allows you to use a very strong, random password for every account you have. Out of the box, KeePass generates a random password whenever you create a new entry (Ctrl+I), then select the .. to make the password visible and copy and paste it to the page where you create the account/changed the password.

Pitfalls

Problem: No access rights / groups management in KeePass
Solution: Create multiple databases.

  1. Shared file “all” – everybody in the team has these passwords, for example our twitter account
  2. Shared file “admins only” – this contains things like hosting admin passwords
  3. Personal file – only personal accounts and passwords

Obviously you can create more files if you have more different groups. One thing that is unfortunate is that you can’t drag/drop passwords easily between files, but you can use import/export instead.

Problem: How to open multiple databases automatically on Keepass Start?
Bonus: How to open them automatically without entering a password?
Solution: Create a batch file and open them with a password that is encrypted with your user account – Article

Problem: Shared password database become messy / hard to maintain.
Solution: Use Groups / Directories vigorously from the start.

Problem: Synchronization – How to keep the shared password database files in sync?
Solution: KeePass says it’s multi-user capable - unfortunately we don’t use windows server storage. Not sure how this will work, we will just try to put the files in box.net and we’ll see, our fall back will be limiting “write permission” on the files to a single user.

Problem: How to access your passwords “on the road”
Solution: There are clients available for iOS/Android on the KeePass Download Page

Please comment if you use KeePass in a team setup, I’m sure there is stuff I’ve missed and I’d love to hear it!