Microsoft Releases fix for Service Pack 14.1.0

by rhyttinen on April 26, 2012

Office2011 Microsoft Releases fix for Service Pack 14.1.0

Microsoft has just released Microsoft Office for Mac 2011 version 14.2.1. This update addresses some issues, especially with Outlook, that the recent Service Pack (14.1.0) created.

Chose Help > Check for Updates from any Microsoft Office application to run the AutoInstaller or you can download the update from Microsoft’s Web Site

Before you install the Office for Mac 2011 14.1 Update, make sure that the computer is running Mac OS X v10.5.8 or a later version of the Mac OS X operating system.

For a detailed description of the update, click HERE

{ 0 comments }

How to Set a Default Chart Type in Excel

by rhyttinen on March 20, 2012

If you find yourself using the same chart type over and over, you can set the default chart type in Excel to the chart type you prefer.  This way, you don’t have to waste time drilling down to find your desired chart type each time you want to insert a chart.

To Set a Default Chart Type:

  1. Select the data that the chart will use.
  2. Click the Insert tab on the Ribbon and select the desired chart type to create the chart.
  3. Click the chart to select it.
  4. Click the contextual Design tab under Chart Tools on the Ribbon.
  5. Click the Change Chart Type button on the Type group.
  6. Click the chart you want to use as the default chart.
  7. Click the “Set as Default Chart” button.
    Change Chart Type Dialog box
  8. Click OK.

Once you have set a default chart type, all you need to do from this point forward is to select your data and click the dialog launcher on the Charts Group of the Ribbon. Your default chart is automatically highlighted in the  Insert Chart dialog box.

Dialog Launcher on the Charts group of the Excel Ribbon

Applies To:  Excel 2010, Excel 2007

{ 0 comments }

Mac OS X Lion Courseware Released

March 13, 2012

Courseware for Mac OS X Lion is now available in our courseware library.  For a preview of the first three chapters, click HERE

Read the full article →

How to enter alternative currency symbols in Word

February 21, 2012

Most US keyboards only contain one currency symbol that you can enter:  the dollar ($) symbol.  You can however, enter additional currency symbols from the Symbol dialog box: click the Insert tab on the Ribbon, click the Symbol button and then More Symbols from the Symbol button menu. This however, can be a tad time-consuming [...]

Read the full article →

How to Move or Copy Data in Word and Outlook without using the Clipboard

February 15, 2012

Did you know that you can move and copy items without using the Clipboard?  This is to say, you can move and copy data without removing the existing clipboard item.  I personally use this trick quite often and you might find it handy as well, depending on your workflow. To Move an Item Select the [...]

Read the full article →

PowerPoint 2011 Level 1 Courseware for Mac Available

February 14, 2012

We have just released Microsoft PowerPoint 2011 for Macintosh – Level 1 and it is now available for download in our Courseware Library.  Mac OS X Lion is forthcoming.

Read the full article →

How to Add a Shortcut Key to a Command in Word 2010

February 10, 2012

You no doubt know that there are keyboard shortcuts assigned to many of the commands in Word.  For instance, pressing Ctrl + B applies bold formatting to selected text.  But did you know that you change the keyboard combination for commands or add keyboard shortcuts to commands that do not have them?  This can come [...]

Read the full article →

How to Navigate Sheet Tabs in Excel

February 7, 2012

Just a short tip today.  I’m always on the lookout for new keyboard shortcuts and I stumbled upon this one just recently.  You can easily move through your open Sheet tabs in Excel using the Ctrl + Page Up or Ctrl + Page Down keystroke combination. Ctrl + Page Down will move you through the [...]

Read the full article →

Using Multiple Outlook Windows

February 3, 2012

If you find yourself switching back and forth between two views – such as calendar and mail, for example – you might want to consider keeping each view open in a separate window, which you can then arrange side by side.  I personally find that this greatly simplifies my work flow as I can easily [...]

Read the full article →

Share an Outlook calendar via E-mail

February 1, 2012

Outlook allows you to share the details of your calendar by E-mail.  This can include appointments for today, tomorrow, the next 7 days, next 30 days or during a specific date range.  You can even e-mail someone your entire calendar!  The calendar is saved as an iCalendar file which your recipient can easily import into [...]

Read the full article →