Category Archives: Office 2010 English

Backup and Restore Your Office 2010 Ribbon And Quick Access Toolbar

As we all know in Microsoft Office 2010 we are able of customizing the Ribbon and the Quick Access toolbar. We can create our own Tab with all the commands that we use most, and we can add commands that we use more often on the Quick Access toolbar. Isn’t it a shame though, that we have to customize them all over again, if we work on a new pc, or new laptop.

Thankfully, we can save the customizations that we have made on the Ribbon and on the Quick Access toolbar on a file, and then import them in Office 2010 on another computer.

01

Below I will describe how this can be done. Be aware, that we can only save the customizations for one Office program at a time. For the example below I will be saving the customizations in Excel. The exact same steps are required for the other Office programs.

First of all we must press the File tab in order to go to backstage view. From the drop down menu that appears we must select the category Options at the bottom of the drop down menu as we can see in the image below.

02

Once the Excel Options dialog box appears, from the left we select the category Customize Ribbon as shown below. We can also click the Quick Access Toolbar. Whichever we choose all the customizations from both the Ribbon and the Quick Access Toolbar will be exported.

03

At the bottom right corner of the Customize Ribbon screen, the area named Customizations is located. We then click on the Import/Export drop down list, and from the drop down menu that appears we select the command Export All Customizations as we can see in the image below.

04

The File Save dialog box appears, where we navigate where we want the file to be saved, and then enter a name. Finally we press the Save button. We notice in the image below the extension of the file is .exportedUI (user interface).

05

We have successfully exported the customizations of our Ribbon and Quick Access Toolbar. Now, we can import it on any other computer that we want to.

In order to import the customization of our Ribbon and Quick Access Toolbar, we must follow the same steps as mentioned above.

Select the File tab, from backstage view to select the category Options. From the Excel Options dialog box we select the category Customize Ribbon or Quick Access Toolbar, and from the bottom of the window we select the Import/Export drop down list and from the drop down menu that appears we select the command Import Customization File as shown in the image below.

06

The File Open dialog box appears, where we navigate in order to locate the file, and once selected we press the Open button.

07

Once we press the Open button, a warning dialog box appears, asking us if we want to Replace All Existing Ribbon And Quick Access Toolbar Customizations For This Program? We then select Yes, in order for the customizations to imported.

08

We then press the OK button from the Excel Options dialog box in order to return to Excel.  That is it!!! All the customizations are imported.

09

Be aware, that when we import a customized file for the Ribbon and the Quick Access Toolbar, all adjustments that we had made previously to them will be lost.

The same procedure stands for all the other Office 2010 programs.

You can also check the video below, describing the steps in order to Import/Export all customizations of the Ribbon and the Quick Access Toolbar.

Office 2010 “Getting Started” Screensaver

Don’t know so much about Office 2010 yet? Still trying to learn it? Searching around the web for tips and tricks on how things can be done?

The solution is right in front of our computer screen. All we have to do is to download the Office 2010 “Getting Started” Screensaver. What does it do? This free screensaver downloads short 60-90 seconds tips from Office.com, and shows them when we are not using our PC. This way we get tips that help us using Office 2010, even when we are not working on our PC.

Also, say that we are intrigued by a particular tip; a simple click will take us to a web page, where we can view the video again, watch similar ones, or even read an article to learn more.

Just click the button below in order to download the Office 2010 Getting Started Screensaver.

00

Once downloaded, we have to run ScreensaverSetup.exe in order for the installation to begin. We will be prompted to install Microsoft .NET Framework 4.0 Full, in case it is not already installed. We just press the Install button to continue.

01

After Microsoft .NET Framework 4.0 is installed we are prompted to with the License Agreement, which we accept and then press the Next button in order for the Office 2010 Screensaver Install Shield Wizard to run.

05

That’s it the Office 2010 Screensaver is installed.

Depending on our settings in the Control Panel, the next time that we will not be using our computer the Screensaver will run, informing us with useful tips and tricks as demonstrated in the video below.

If we want to change the settings for the Office Screensaver, we must go the Control Panel, category Appearance, Screen, and Change Screensaver.

The Screen Saver Settings window appears, where we press the Settings button as shown below.

09

The options for the Office 2010 Screensaver settings are shown in the image below, where we can change the Notification Settings and the Transparency of the desktop alerts.

10

How it works? They have coded the screensaver so it pulls videos from an RSS feed. With this way, the tips are always fresh (we have to be online though).

When we go back to our computer and dismiss the screensaver a small popup alert appears at the bottom of our screen, saying that we can click on it to learn more, as shown in the image below.

11

How To Find Office 2003 Commands In Office 2007 And 2010

Are you still looking for commands in Office 2007 and 2010? New to the ribbon interface of Office 2007 and 2010? Miss the menus of Office 2003, and you can’t get around the new versions of Office?

Don’t worry!!! Microsoft has made an interactive guide to Office 2007 and 2010. This guide helps users to learn their way around the ribbon. It is pretty simple to use. All we have to do is to start the application that we want to practice on, and then select a command from the old interface. A tooltip window will appear, showing us how to find this command in the new Office version.

In order to start our practicing we must follow the below link:

http://office2010.microsoft.com/en-us/word-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-HA101794130.aspx?CTT=5&origin=HA010370239#_Toc256784678

Once the link is activated, we are transferred to the Microsoft Office 2010 web page. We navigate in the page, until we find the area Use An Interactive Guide To Find My Commands. Under that area, we can get started with the Interactive Guide by clicking on any of the following icons as shown in the image below:

Word-Excel-Outlook-PowerPoint-Project-Access-InfoPath-OneNote-Publisher-Visio

00

In order for the guides to work, we must have Silverlight installed; otherwise we will be prompted to install it.

Once the guide has started for the application that we had chosen to we press the Start button as shown in the image below.

01

Once the guide has started, we see the old interface of Word. We then select a command that we want to find out where it is located in Word 2010, as shown in the image below. A tooltip window appears, telling us where this command is located in Word 2010.

03

When we click on a command, the Word 2010 interface appears showing us where the command that we had selected is located, as shown in the image below.

03a

Below are listed some examples from different applications.

Excel 2003

05

Excel 2010

05a

Outlook 2003

06

Outlook 2010

06a

PowerPoint 2003

07

PowerPoint 2010

07a

Once a command is select we can always press the Try Another Command button in order to return and to select a different command.

We can always install the guides to our computer, so we can access them even when we are not online. We select the guide that we want to install, and then from the top right corner of the guide we press the Install button as we can see below.

08

The Install Application window appears, notifying us where we want the locations of the shortcuts to be installed. We then select between the two options and press the OK button.

09

We can also download Office Reference Workbooks, which show us how to access each item that was in Office 2003 in Office 2010.

Follow the link below and download the Office Reference Workbook that is needed.

http://office2010.microsoft.com/en-us/templates/CL101817133.aspx

In the image below we can see the Outlook guide, showing us where each of Outlook 2003’s Main Menu commands are located in Outlook 2010.

11

Microsoft also has interactive guides for Office 2007 users, at the following address:

http://office.microsoft.com/en-us/training/guides-to-the-ribbon-use-office-2003-menus-to-learn-the-office-2007-user-interface-HA010229584.aspx

Below I have started the guide for Microsoft Office Excel 2007.

12

Below is a screenshot of the Microsoft Office Excel 2007 interactive guide.

13

You can also check out the video below, demostrating on how to use the Microsoft Office 2007 and 2010 Interactive Guide.

Microsoft Office 2010 Interactive Guide

Search Commands

We all know that there is a command somewhere for something that we want to do in a Word document, an Excel spreadsheet, or a PowerPoint slide, but we can’t just remember where that command is located. Additionally, we waste a lot of time searching for that command, command that we don’t even remember in which Tab it is located.

Thankfully, we don’t have to worry anymore and waste any of our precious time, because the Microsoft Office Labs team has created the Search Commands. What do we do with the Search Commands? We simply type in the command that we are looking for with our own words and the command appears right in front of us. That simple‼!

What does it need to work?

  • Windows XP or later editions.
  • Office 2007 or Office 2010 32 or 64 bit.
  • Only available in the English Versions of Office.
  • Works with Word, Excel and PowerPoint only.

We can download Search Commands from the following address:

http://www.officelabs.com/searchcommands#

Let’s see now what can we do with this very useful tool. First of all, we have to visit the address I mentioned above in order to download it. Once we have downloaded it, we start the installation and we accept the terms of use in order to proceed the installation, as shown in the image below.

01

Once the installation has finished, the last step of the wizard appears, where it informs us of the successful installation and where the Search Commands can be found, as we can see in the image below. Once it is completed we just press the Finish button.

03

If we start one of the three applications that I mentioned above (Word, Excel and PowerPoint), we will see that a new Tab has appeared in our Ribbon named Search Commands as we can see below. To search for a command we just click into the Search pane and type in the command that we are looking for. At the right of the Search pane all the relative commands with our key word will appear.  All we have to do then is to select the command that we were looking for.

04

Further down I will describe two examples of each application:

Word

In the Search pane I have started to type in the word Mail”, and while I am typing, at the right the commands that are relevant with “mai” appear. I notice that 66 commands have been found, and in order to see the rest I must press the Next button.

05

In the image below I have started to type in “Print”, and straight away all the commands that have got something to do with the word “Print” appear. Again here, we see that we have 21 results, so we have to select the Next button in order for the other commands to appear. Once Iwe have found the command we are looking for, we just select it and do what we wanted to do with it.

06

Excel

In Excel we will have to type in the whole word of the command that we are looking for and at the end to press the Enter key in order the commands to appear. In the Search pane I have typed in the name of the functionConcatenate” and I have pressed the Enter key, and straight away the specific command appears at the right.

07

In the image below I have typed the name of the “Consolidate” command, I have pressed the Enter key and at the right the relative commands have appeared.

08

PowerPoint

In the Search pane I have started to type in the word “Animation” and immediately all the commands that are relative with the key word have appeared at the right, where we just select the one that we need.

09

In the Search pane I have started to type in the word “Insp” (inspect) and immediately all the commands that are relative with the key word have appeared at the right, where we just select the one that we need.

10

Below you can see a video on how to use the Search Commands in Word, Excel and PowerPoint:

Music by: Peter John Ross – Dreams of Sand

Announcing Service Pack 1 for Office 2010 and SharePoint 2010

At TechEd that is been held in Atlanta, they announced that Service Pack 1 will be available for both Office client suites and SharePoint Server products at the end of June. At the same time the language versions of Service Pack 1 will be also available. Service Pack 1, at first will be accessible as a manual download from Microsoft Update and Download Center, and later on will be available as an Automatic Update. With Service Pack 1, each Office Product and each Server capability area will have changes.

There will be a lot interesting changes and in the list below you can read the most significant ones. In the list there are things that couldn’t be done previously, and things that have been improved from the original release.

  • The Use Presenter View option in PowerPoint behavior is going to be changed to display the slide show on the secondary monitor. (Use Presenter View option is a way to view our presentation with speaker notes on one computer and at the same time the audience views the notes-free presentation on a different monitor)
  • The issue in Outlook where Snooze Time wouldn’t reset between appointments, it is now fixed.
  • The Word Web Application extends printing support to Edit Mode.
  • We would be able to insert Charts in Excel Workbooks with the use of Excel Web Application.
  • Support will be available in Search Server for PPSX (Microsoft Office Open XML Format Presentation Slide Show) files.
  • We would be able to Preview an Attachment in Outlook Web Application (only with Exchange Online).
  • For the languages: Canadian English, French, Swedish and European Portuguese the Proofing Tools will be improved with suggestions.
  • Synchronizing scheduled tasks from Project Professional with SharePoint task lists.
  • There will be Office Web Applications support for Chrome.
  • SharePoint’s’ Server Backup and Restore functions will be improve.
  • Visio fixes scaling issues and arrowhead rendering errors with SVG export.
  • Integrated community content in the Access Application Part Gallery.
  • Better alignment between Project Server and SharePoint Server browser support.
  • Internet Explorer 9 “Native” support for Office Web Applications and SharePoint.
  • Visio Fixes scaling issues and arrowhead rendering errors with SVG export
  • Office client suites using “Add Remove Programs” Control Panel, building on our work from Office 2007 SP2.

Office and SharePoint 2010

RH2: Clippy’s Second Chance

RH2: Clippy’s Second Chance

clippy

It is not a sequel or a prequel to a film, but it is the sequel for Ribbon Hero. The team of Microsoft Office Labs has prepared the most anticipated sequel of Ribbon Hero with the title Ribbon Hero 2: Clippy’s Second Chance. The main character of course is Clippy, where everyone one of us remembers the animated character that used to help us in different tasks in Office and that kept us company. Character, that no longer exists anymore in the latest versions of Office.

The purpose of this sequel is for us to get familiarized with new features in the latest editions of Office, completing different tasks that are assigned to us. This way we improve our knowledge and capabilities and at the same time we are having fun.

We have to gather as many points that we can, completing tasks in Word, Excel, PowerPoint and OneNote, so we can reach to the last level of the game. Reaching at the end of the levels we will  have accomplished to help out our friend Clippy to improve his resume, because now that he is unemployed and the times are very harsh only someone who also has knowledge of Microsoft Office 2010 will have some chances do find a job.

For us to download RH2: Clippy’s Second Chance we most go the following address: http://www.ribbonhero.com/

01

After we have visited the site, we select the command Download Now, for us to download the application in order to install it.

While we run the application RHSetup.msi, a step-to-step window appears, which informs us with the progress of the installation.

03

We will have to Accept the terms of use in order to proceed with the installation. So we have to select the Accept and Install Button to proceed with the installation.

04

After the installation is completed (as we can see it is successful) we press the Finish button.

06

In order to begin with Ribbon Hero 2, we must press the Start Button of Windows, then to select All Programs and after to locate the folder Microsoft Office Labs and from there to select Ribbon Hero 2.  We can also start one of the Office Applications that I mentioned above (Word, Excel, PowerPoint, OneNote), where in the right area of the ribbon the button off Ribbon Hero 2 appears as we can see below.

43

Whatever way we use to start the application the following image appears, where we just have to press the Play button to begin the game of knowledge, but most of all for our pal Clippy.

07

Before the game begins an introductory video appears, which informs us with Clippy’s professional career and what he is up to now.

08

For example we see Clippy with a newspaper opened at the section of wanting jobs. All we have to do is to help Clippy, pressing the button Help Clippy! and let the game begin as we can see in the image below.

10

Ribbon Hero 2 consists of six different levels, levels where we must complete in order to gather as many points that we can to help our friend.

The six levels are the following:

1. The Middle Ages

15

2. Ancient Egypt

28

3. The 1960’s

31

4. Ancient Greece

34

5. The Renaissance

37

6. The Future

40

For the knowledge game to begin we just have to select a character or an image from the different levels. Moving on top of each character or image we will be notified how many points we will gather if we complete the task successfully and which application the task will be held in. In the image below I have selected the character Rat-A-Phooey, the points that I will gather will be 60, and the application that the task will be held is Excel.

17

Choosing a character starts also the corresponding application. In the image below, the application of Excel has begun and at the right of our screen the task pane has appeared mentioning the tasks that have to be done. I have already accomplished the first task that had to be done and it was to Present the data in a Pie. The second task is to Change the chart layout with one click only.

If we find it difficult to accomplish the task we can press the Hint Now button in order to get some help. Getting help though, deducts points from us.

22

If we are trying to accomplish the task the wrong way, the image below shows up informing us that we are following the wrong steps.

24

After we have completed all the tasks successfully the image below appears, where we are accepting congratulations and we just have to press the Continue button so we can continue with our game.

23

We will now have to choose a different character from the level in order to continue to gather points. When we have the necessary points that are needed to finish the level, the following image appears where we can continue if we want, just by pressing the Continue button. If we choose to continue, another video appears with other shortcuts presenting Clippy’s life.

26

Eventually, when we have finished the six levels we receive congratulations and that we have completed the game.

41

Because we pass all the levels without having selected all the characters that are in them, we can continue the game again so we can gather all the points that are available.

Once we start the game again (seeing that we have finished all six levels) the following screenshot appears notifying us what points are still available in every level that we can gather.

42

Everyone should help our friend Clippy now, in order to find his right way in life again. What are friends for anyway?

The older post that I had mentioned Ribbon Hero you can find at the following link:

http://autoexec.gr/blogs/philip/archive/2010/07/02/do-you-want-to-be-a-hero.aspx.

At the link below yo can see a video that I prepared about Ribbon Hero 2: Clippy’s Second Chance.

Author of the song: Peter John Ross of Sonnyboo.com
%d bloggers like this: