Tag Archives: Office 2010

CustomUI Editor Part II

Add your own icons to your own ribbon

In this post i will show you how easy it is to add your own icons to your own ribbon in Microsoft Office. For this example i will use a Word document but you can just as easy make this in Excel and PowerPoint. In earlier posts i wrote about the custom UI editor. This insanly great tool for creating your own ribbons in Microsoft Applications. So that will be the tool i am using in this post. You can download the custom ui editor tool here.

The example i am creating here is a simple Word document with a custom tab with custom icons.

First make a word document which you want to use for this example. I will call it: Custom Icons. The custom UI editor tool was last updated for 2010 but to show that you can easily use this for 2013 documents i created a 2013 Word document. So the document is created, saved in a location and we are good to go. You can click on the various images to see enlargements!

Open the CustomUI editor

The next step is to open the custom ui editor. Choose open en locate your document to which you want to add a custom ribbon. For my example i created an empty Word document with no fancy stuff attached. A plain word document. Next step is to choose a type of ribbon you want to add. For this example i’ll choose a custom tab.

CUE_I CUE_II

Now with that in place you will see that de custom ui editor has presented you with some sample XML in de code window. This is the code you have to modify later on. We will first add our own icons attached to the document. For that i will add some sample icons i have stored on my pc.

CUE_III CUE_V

these are the icons i have added to my ribbon:

CUE_IV

The first time i added some icons this way i was a little startled because i did not see anything happen. You have to click the plus sign to actually see that the icons are added to the document.

CUE_VI CUE_VII

Ok, we have the document, we have the icons all we need to do now is modify the existing xml which was created when we chose custom tab at the beginning. If you are like me and you don’t want to typ to much you will use copy / paste. There’s nothing wrong with that but remember that all the buttons should have unique id’s in order for the ribbon to be created. So copy paste and rewrite the id’s for every button. Als modify the imageMSO part. imageMSO is an internal reference to existing icons from Microsoft Office. Because we are using our own icons you have to reset this option to image=”iconname here” (where iconname here is the name of your custom icon!).

CUE_VIII

The last step we have to do is to check if our ribbon will actual show up in our document. For the sample i have set two icons to large and three of them to normal. This will give you the next output:

CUE_IX

Yep there it is, my very own tab in my ribbon with my very own icons! Wow how cool is that. All done with the custom ui editor!


Pitfalls
Is there anything else i should know before i start taking these steps or will it always work. The only thing you have to remember is adding icons this way the only restriction you have is the size of the icons. In the sample i created here i added icons which have a size of 48X48 pixels. You will just have to test what the maximum size is for adding it to your tab. My advise? stick to 48 x 48 and smaller. That size fits perfectly!


Happy customizing 🙂

Collaboration – Many hands on One Word Document

Would it not be great if you could collaborate in a word document – at the same time – with your colleague. This would be like having four hands working on one document. You already know that this is possible in the latest Word versions. Many people ask me if this does not give any issues if two persons are editing the same paragraph at the same time. Yes it does and it can be resolved. In this blog post I will try to explain how two people can work together on the same document without messing up the same paragraph. HandsOn


Let’s get started! First step: we start Word and open a document. Second step is to ask to co-worker to open the same document. For this example i have asked my colleague Wendy to open the same document. Just to show you that two people are working on the same document i will add some screens here. Scenario: we opened the same document which is stored on a SharePoint document library.

collaborate_I collaborate_II


The two images above show us that two people are editing this document at the same time. The first image shows that there are two people active, the second image shows who that second person is. If you have Lync integration this is a great feature because you can just as easily start a chat about your editing session here!
I asked Wendy to edit a specific paragraph in this document. I will edit the same paragraph in this document making sure we are working on the same paragraph. Wendy added some sentences to the paragraph (in Dutch). I also added some sentences to the same paragraph. When one of the editors clicks save the other will be notified that updates are available.

collaborate_V collaborate_VI


Now because we are editing the same paragraph one might wonder what the final result will look like. Well first of you do get a warning that two people are editing the same paragraph. You then have the opportunity to view the changes the other made. You can then approve one or the other.

collaborate_IV collaborate_VII


The images above show the warnings / information i receive about the state of the document. I decide to apply the changes by clicking save. Word responds with a following notice:

collaborate_VIII


Word tries to explain that there is a conflict in the same paragraph. Luckily for us it does give us an option to resolve it. So i click the resolve button on the warning. I am presented with the document and a taskbar where i can view the conflicts. When checking i see the the conflicts are minimal. We haven’t touched each others sentences but just added information in different places. So i accept all the changes and click resolve.

collaborate_IX collaborate_X


So we now have a document with changes made by two people. But what if i don’t want to take the risk of someone editing my paragraph while i am working on it? There is always the risk that a co author is editing the same sentence you are just working on. This is where the next option comes to the rescue. I will change the same paragraph again but without taking the risk that Wendy will edit the same sentences. This time i select the specific paragraph and right click the mouse. A popup menu presents me with the one option i am looking for right now: block authors.
When i choose this option the other co worker will see something specific happen in their document. The name of the other author will pop up next to the paragraph telling the co worker that this paragraph is now bocked for editing.

collaborate_XV Collaborate_XII


I can adjust any text in the paragraph without risking my sentences being edited by other co autors! I asked Wendy to take the risk and try to edit a sentence in that specific paragraph while i blocked it. The message is clear (although in Dutch) it states: This change is not allowed because the section is locked. Rock on… my paragraph is save!

Collaborate_XIII


So whenever you want to co author a document take the necessary steps to make sure you are not editing each others paragraphs. So how can you tell you are save? Well i have another image for you right here:

collaborate_XIV


So collaboration really has taken the next step. It is possible to co author a document at the same time. If you have Lync integration a chat is right there to assist you even more. No more mailing around and asking co workers to look at the attached documents. Review live and make adjustments at real time. That’s what we call collaboration!

Next time i will take a closer look how this collaboration stuff works in PowerPoint and Excel.

For now Happy collaborating 🙂

May The Force Be With You

MOS 2010 Bootcamp

Now is the time to plan that extra time to get certified. You are just a couple of certs away of becoming a MOS Master. My company has a special bootcamp set up just for you. The last week of July 2012 is the time to join MOS 2010 bootcamp. We will prep you for all the necessary exams to become MOS specialist in Word, Excel, PowerPoint and Outlook 2010. This will be no picnic because in one week all those apps will be on the agenda. So who is this bootcamp for anyway? We’ll as one might understand you need to have working experience with the applications mentioned above. Why? Simple you can not get certified in something you haven’t used before! So the target audience are Information Workers already familiar with the applications. If you have the necessary experience and are up for the challenge we will guide you through the process of becoming MOS certified!

The Next Step
What is the next step if i get MOS certified? What if i am already certified and want to become MOS Master? Well then MOS Master 2010 Bootcamp is the one you are looking for! This one is scheduled for the first week of August 2012. For this bootcamp we are looking for Information Workers who are ready for the next step. To become Mos Master one needs to complete the Excel Expert, Word Expert exams with the additional PowerPoint and Outlook regular exams. Remember they don’t call these exams Expert exams for nothing. This means that we are looking for users who have the necessary skills to go beyond the standard functionality of Word and Excel. But boy does this give you a great feeling once you have mastered all the certifications and you get presented the additional MOS Master certificate 🙂

Target Audience
Our company is based in the Zoetermeer in the Netherlands. Does this mean that i can’t join the party? Well no everyone can join the party but we are focussing on Ducth Information Workers. If you are not from the Netherlands and you are interested in following our bootcamp then just send a mail to my company. State that you are interested in following the bootcamp and i’ll see if I can come up with a plan to satisfy our international audience. This means that there might be an additional bootcamp being scheduled based on request. How cool is that.

So there is only one thing to do and that is to visit our website to download that bootcamp information factsheet and register. This will be in Dutch. You want this one in English as well? Just pop a mail to the mailaddress you’ll see on our website.

Summerschool and Bootcamp Info can be found here: Summerschool and Bootcamp (if the link is broken or doesn’t work let me now pls).

Happy bootcamping and become one of the MOS Masters of the Universe 🙂 May the force be with you.

Microsoft Office 365 Study Guide Coming Soon!

Get ready and prepared for your next certification!

Microsoft Press published the new and upcoming titles for May 2012. On the certification platform one stands out for the Information Worker. Next month you will be able to buy the MOS Study Guide for Microsoft Office 365. Joining the MOS Certification family this one should be on the list of to read for the coming period. Preparing yourself for the upcoming certification will give you that extra edge to ace this upcoming exam. MS Press have a good tradition in providing chapters you can read before buying this book. So keep a close eye on the MS Press blog here to see when the book gets published and when it hits the stores! Of course i will keep you posted here as well.

The Industry is Changing – Make Sure Your Skills Keep Pace

Cloud Ready

The last year has been a merry go round for the information worker. At least that’s what i have noticed visiting many clients. Not only did many companies switched to Windows 7 but at the same time the next logical step was taken and that is upgrading to Office 2010. I could not applaud them more. For me personally this means being as up to date as i possible can.

Information Workers (IW) make the jump to the cloud
Many IW i meet find the Office 2010 suite a great improvement in comparison to the old situation. Some of them use office 2010 in combination with office 365. This often leads to more questions besides the new excitement. How do i store my documents in this SharePoint thing and how to get it back again. This led me to think that many IT Pros are ready for the Cloud and prepare for the future. But what about the Information Workers, are they ready for the future? As a headstart some of them used their SkyDrive to learn about Cloud computing and find it very convenient. Not only do they get an enormous amount of free storage but they also get to know the office suite in the cloud.

Now for the SharePoint part
It is a pleasure to see that many IW are so enthousiastic about the cloud. The workplace offers SharePoint as a collaboration platform. How does this SharePoint stuff work and where can i learn about it. Some of the questions i regularly here during my consultancy hours. First we talk about what the IW already knows about SharePoint and the cloud. During the conversations it’s often the IT guy that should have given the answers. Instead he presents the user with a [site] – because that is what they asked for. The information worker now faces a dilemma. Great I have a site and i can do what ever i like with it within the given boundries. It doesn’t take long before the enthousiasme is killed because of the lack of knowledge.

Where to start
My advice for Informaton Workers who want to know more about SharePoint and cloud is to start of with a end user course. I found this one very useful:
Course 50575A: SharePoint 2010 End User
I had a couple of IW who found this a good starting point for getting ready for some serious cloud computing. No i’m not only talking about SharePoint but also things like web apps, InfoPath, Excel Webservices, PowerPivot and much more. But we have to start somewhere. If they want the next step i suggest the follwing: Course 50469B: SharePoint 2010 End User – Level II. The great advantage of following these classes is that they now know what to ask the IT guy. Another advantage is that the IT guy understands the question the IW posted 😉

Get certified
As a trainer/consultant I often have to discuss the learning plans with the decision makers from various companies. What’s in it for the company and how do we get a good return on investment. When i talk about certification they are interested because now they a tool to measure their investment. Not only that but also a goal for their employees. I like taking the path which leads to certification but i do not choose the easy path. I do encourage to take the path with the hands on experience. In my opinion the only right path. So what path to take for the information Worker when we want them to certify without them pushing them into an IT Pro certification path? My advice would be to guide the IW to the following exam:


This exam leads to [Microsoft Office Specialist (MOS): SharePoint 2010] a well deserved credit for your employee. It doesn’t take years to achieve and it will lead to employees who know what they are talking about. Furthermore they will have the capabilities to work cloud efficient and that’s what we are striving for in the future right?

For me it is of studying for the 70-667 exam because i have to keep up myself as well. It’s all hands on for me now! Some PowerShell anyone?

Happy Clouding 🙂

Free eBook: Security and Privacy for Microsoft Office 2010 Users

SecureOffice2010Yes it’s Free

You know i always signal you when there is something to get for free. This time you get a Free eBook about Office 2010 and Security.
This is the place where you can download it: download

I’d say read it because this is an important subject when using Office. We don’t think about security to much when working with Office 2010. Often the IT guys will take care of that for us. So what can you do yourself? Read it.

 

Happy Reading 🙂