Who else wants to know the secret to Excel Formulas?Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today
Some of you will already know that Microsoft is currently testing the next version of Office… called Office 2010. Whilst it is not available in the shops yet, diagnosis yours truly has been helping out the folk at Microsoft to find bugs, skincare quirks, hemophilia or other annoying things in the product so you don’t have to.
The best part about me helping to test the product is that I am going to start sharing with you some of my favourite parts of Office 2010 â€“ and start publishing some Office 2010 help, tips, tricks and tutorials so you can hit the ground running once the product is released sometime in the near future. Excited? I thought you might be! So here we go â€“ my first post on Office 2010!
Blogging from Word 2010
Whilst this post has so far introduced you to the new Office 2010 content that will be published on The New Paperclip shortly, it is also my first test of the blogging feature in the Word 2010 Technical Preview. To be honest I never really used the feature in Word 2007 â€“ I have been a fan of Windows Live Writer and have used that very successfully for a number of years â€“ I thought I would bite the bullet and see if Word 2010 cuts the mustard.
In particular interest to me is how Word 2010 will manage posting categories, tags, images, text formatting, post scheduling and more. So let’s take a look at my first blogging experience with Word 2010.
To write a blog post in Word 2010
The first thing you need to do open up the new blog post template! Click on the Office button in the top left hand corner of the Word 2010 screen. In the menu that appears, click “New”, and then select “New Blog Post” from the available templates gallery. Then all you need to do is click “Create” and you are almost on your way!
Linking to your blog provider
TheNewPaperclip.com and all my other blog based publishing enterprises run on the WordPress engine â€“ which Word 2010 links into incredibly well. The first time I opened the new Blog Post template in Word 2010, a dialog box appeared asking me to register my blog provider. (Note, you can access this dialog box any other time by going to the “Blog Post” tab in the ribbon, clicking “Manage Accounts” and then clicking “New”). I selected WordPress, typed in my website details, username and password, and within seconds Word 2010 was successfully talking to my blog. The first thing I noticed here that was different to Windows Live Writer is that Word 2010 did not download my blog theme so I can see exactly how the content will look when published as I write it. Not necessarily a bad thing as far as I am concerned, but you may disagree.
Creating the content
No matter what tool you use to create your blog posts, the content is the most important part. And realistically the tool you use has nothing to do with the quality of the content. That being said, the blogging tool you use has a lot to do with your productivity and how you present the information you want to include. This is where Word 2010 comes into its own.
The standard stuff you would expect is all there â€“ with the same familiar shortcuts you would use in Word normally. You want bold? Select that text and CTRL+B it!
This is what I really like about using Word 2010 for blogging. The new “Screenshot” feature will be incredibly useful for when I am creating content for TheNewPaperclip. Here is a great example â€“ at the moment I have a copy of PowerPoint 2010 running in the background. In the past my workflow would be to switch to PowerPoint, take a screenshot using the Print Screen button on the keyboard, open up MSPaint, paste the screenshot, resize or crop to my liking, save the image, switch back to Windows Live Writer, insert that image I just saved, and then do some finite resizing and positioning.
In Word 2010, all I need to do is click on the “Insert” tab in the ribbon, click the “Screenshot” button, and then select the screenshot of PowerPoint 2010 that Word has already generated for me in the gallery. This automatically drops the screenshot into the blog post, and now all I need to do is crop and resize using the standard word “Picture Tools Format” tab. And the best part is I can use all those funky picture formatting styles to add the perfect border to the screenshot! Like this one…
<Note â€“ after publishing this post I realised that my picture upload settings were wrong â€“ so you can’t see how awesome this PowerPoint 2010 Screenshot actually looks â€“ with reflection and everything! Oh well â€“ managing Word 2010 blog account picture upload settings sounds like a great post for later on!>
To add Alt Text to the image I just inserted into the blog post â€“ just right click on the image, select “Format Picture…”, click on “Alt Text” and type text that is appropriate.
Categories and Tags
Inserting categories was a breeze. I just clicked “Insert Category” from the blog post tab on the ribbon. I could select from the categories that already exist on the blog (like “Level 200 â€“ Regular User”), and I could also create a new category â€“ in this case “Word 2010”. Tags are a different story though â€“ on the face of it I can’t see any way to include them â€“ I am guessing there is a plugin required.
Which one came first â€“ the chicken or the egg? Well the first time I publish a post using Word 2010 will be this one, so I can’t tell you exactly what the experience was like until I have actually posted it! That being said there are two publishing options I can see in the ribbon â€“ the first is to publish a draft to your blog engine, and the second is to publish a final post. Speaking of which, I might publish this post now, and then try out the “Open Existing” feature to see if I can edit the post later on with a few more thoughts about at the process.
Hopefully see you on the flip side!
’till next time!
<Content added after the original post was published â€“ using the “Open Existing” post feature in Word 2010>
Ok â€“ that was pretty painless. Only issue I encountered was that I had my picture upload settings all wrong, so none of the images came through â€“ but that is pretty easily fixed. The one big disappointment was that there was no scheduling feature like I am used to in Windows Live Writer â€“ but again I am sure there are some ways to get around that â€“ like posting drafts to WordPress, and then adding a step to the workflow where you log into WordPress and schedule them from the administration console.
All in all, I feel that Word 2010 might be my choice from now on for blog writing and editing. As long as I get those picture upload settings right (problem exists between keyboard and chair!)
If you follow @thenewpaperclip on Twitter (or @paulwoods â€“ the guy behind The New Paperclip), information pills
you would have known that I was presenting at TechEd Australia the past week.
My session (with Microsoft Australiaâ€™s Andrew Lowson) was titled â€œPersonal Productivity for the IT Proâ€ and was one of the level 100 sessions in the Office System track.
It was never meant to be a deep dive â€“ simply a session to highlight some quick productivity wins you can get simply by getting to know the tools you already have in front of you â€“ in this case, Microsoft Office.
The best part of the session was that about about half way through we handed it over to the audience and started crowd sourcing productivity tips. It was obvious that there are some very smart, very passionate people out there â€“ and plenty of knowledge was shared
For those of you who could not make it to TechEd, or are unable to access the session I delivered via your TechEd Online subscription, whilst on site at the Gold Coast Convention Centre I did record a TechTalk just for you.
Titled â€œThe Productivity Mythâ€, this interview with Alistair Speirs from Microsoft Australia will give you a taste of what the session was all about.
If you want to read more about â€œThe Productivity Mythâ€ â€“ check out this blog post.
Looking forward to seeing you all at TechEd next year!
â€˜till next time!
One of the interesting statistics I looked into when preparing for my presentation at Microsoft TechEd Australia 2009 was how many people make use of the shortcut keys in Office.
One of my favourite resources for fun facts like that is Jensen Harris. Those of you who have dug a little deeper into Office 2007 would recognise that name â€“ he is the guy responsible for the new Ribbon user interface.
In his presentation at MIX 08, for sale
he brings up a few statistics which really shocked me (and I am paraphrasing here):
- Only around 50% of users use the Ctrl+C shortcut to copy (which means 50% of folk use the menu!)
- Only around 27% of users use the Ctrl+S shortcut to save (which means 73% use the menu!)
- Only around 2% of users use the Ctrl+O shortcut to open documents (which means around 97% of users donâ€™t!)
Anyone thinking what I am thinking? There is a huge opportunity here to increase productivity of Office users across the board, simply by working with users to identify what shortcut keys have the biggest impact, and helping them to master them.
Now there are two ways to go about that. The first is probably the most pervasive already â€“ lists of shortcut keys. You can find them anywhere, simply by Googling (or Bingâ€™ing) â€œWord Shortcut Keysâ€. People download them, print them out, and put them on their desk beside their computer.
But what happens when you have a list of shortcut keys?
1) You donâ€™t learn them, you just refer to them
2) You donâ€™t actually work through the shortcut keys to understand what they are capable of
3) You are probably less productive when you take into account the time it takes to look up the shortcut key every time you use one!
The second way is to work through a learning program which helps you understand the impact of, remember, and give you confidence to use key shortcut key combinations when you need to.
How many learning programs like that exist? None.
Well until nowâ€¦
I have put together a audio course called â€œFive days to Word 2007 shortcut masteryâ€. Now this isnâ€™t for everyone. If you are comfortable with your list of shortcuts that you refer to all the time â€“ then great! If it works for you then there is no reason to even think about enrolling in this course.
On the other hand, if you still struggle with remembering, or understanding what shortcut keys are available in Word 2007, then this course is exactly what you are looking for.
Before you askâ€¦ no, it isnâ€™t free. But this is the kind of specialist training that you canâ€™t really find anywhere else at the moment, and it has the potential to help you save hundreds or even thousands of dollars in lost productivity yourself.
Want to learn more â€“ visit www.shortcutcourse.com.
â€˜till next time!
When helping my coworkers, I’ve found that most of them use the mouse because they can find what they’re looking for in the menu (pre 2007 versions) more easily. They feel it’s easier than having to remember the keyboard shortcuts. Many times they don’t understand what I mean when I tell them to ctrl-c, s, etc. or even if I tell them to right click, they’ll just look at me and say “Huh?”. I guess there are those meant to be shortcut users and those that aren’t.
Lots of quite experienced people don’t even set up paragraphs with an indent (I’m a writer and it’s needed for print publishing). They us the tab or line spacer.
I’m a fan of shortcuts, and hate the ribbon, actually.
But don’t remember all of those I’ve used if I don’t use them often.
As PS – Thanks for saying upfront your shortcut sourse isn’t free. I get annoyed at sites that offer goodies or say “free download” and then you find it’s only free for a limited time or not all, but not until you’ve wasted time filling in forms!
This course sounds intriguing, but I wouldn’t be willing to pay for it, but then in my profession I probably don’t need it (Microsoft Application Trainer).
As for HOW people use commands, you are obviously very pro-shortcut key and very anti-menus in your approach to using applications. Jensen’s statistic that says 50% of users don’t use Ctrl+C for Copy doesn’t mean 50% use the Edit menu. It means that 50% either use the Edit menu or right-click or click the toolbar button. Having said that, I wouldn’t be surprised if maybe 25-30% DID use the Edit menu. Morons.
I see how people do things every day. In an Excel or Word course I’ll say: “select such and such and copy it” but unless it’s a basic course I won’t say HOW to copy it, I’ll just let them do it (or not do it in some cases). It’s true, many people go Edit, Copy or File, Open or File, Save. Unbelievable. How much time are they wasting? No-one knows Alt+Tab either or Windows+E or even Ctrl+Z!! Ctrl+Z! How can anyone not know Ctrl+Z!
As for the lists of shortcuts, I give out sheets of shortcut keys for people to hang on their wall next to their PC, but I hope that they don’t refer to it EVERY TIME they want to use one. If you are refering to a list – it is not a shortcut, people!
They Ribbon adds a whole new angle to the whole “How To Choose a Command” dilemma. I like it. But I do use a good deal of shortcuts, too. And most of the old shortcut, still work in Office 07.