Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Monthly Archives: August 2014

Subscribers: How to Assign Macros to your Ribbon & QAT in Excel 2013

Posted on by Posted in Subscribers Excel 2013

You use macros in Excel? You would like to have them handy like the macros you used to assign to toolbars in earlier iterations of Excel?  Well guess what?  You can still have them at your fingertips in Excel 2013! You can assign a macro to a custom tab on your Ribbon or a custom

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: Summer is Winding Down

Posted on by Posted in Carol's Ramblings 1 Comment

It is late August and I am finally having a small vacation at the beach.  This time of year is usually a bit melancholy for me.  One season is grinding to a halt and the other is about to begin.  So in a few weeks time I will be happy again, looking forward to Autumn, while right now I begin to mourn the end of Summer.  Silly isn’t it?  But it is who I am and that’s just how it is!

I have had a very nice and fun filled summer.  I have spent lots of quality time with my grandchildren and have been busy knitting for babies that have not yet made their appearance.  I am also currently busy knitting sweaters for cool Autumn days and crotcheting blankets for little ones to snuggle under on cold Winter nights. I think I may try my hand at knitting a shawl as well if I have time.  I like a shawl round my shoulder of a cool evening.

How about you?  What have you been doing all summer?

My borrowed words of wisdom for this month are :

Use what talents you possess;

the woods would be very silent if no birds sang

except those that sang best…Henry Van Dyke

Never try to be someone or something you aren’t.  You are you!  You were made to be special and unique so use the talents you possess and leave the world a little better for it.  It doesn’t seem like anything gargantuan at the time, but trust me, any small thing you do and do well, makes a much larger ripple in the pond of life than you think.

Below, is a photo of a small sweater and booties I have knitted for the daughter of a friend of mine who is about to bring her son into the world.  It was a lot of fun to knit and I am anxiously awaiting a picture of him wearing it.

Fair Isle Sweater and Booties

Now I am working on a sweater for my two youngest grandchildren.  Busy, busy, busy!!

I hope this finds you well…

Carol

Subscribers: Print Color Worksheets Without the Color in Excel!

Posted on by Posted in Subscribers Excel 2010

Many times we use color in our Excel worksheets to bring them more easily to the viewer's attention. We want to make certain data stand out for various reasons. The problem lies in when we print these worksheets. If you have a color printer,  it will use up your expensive color and if you do

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: Add Useful Research Apps Directly to Word 2013

Posted on by Posted in Subscribers Word 2013

Word 2013 has many new features, but one that I like best is the ability to add useful apps directly into Word and the rest of the Office Suite. Apps is really a misnomer because it is research resources that I am referring to, something to confirm a fact in your writing or an explicit

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

Subscribers: Assign Specific Sound Alerts to your Contacts in Outlook

Posted on by Posted in Subscribers Outlook 2010

Microsoft Outlook offers you many customizations to help you with your daily work and as a bonus, helps you to create an inbox that is very manageable. One of the niftier features in Outlook is the ability to assign specific alert sounds for specific contacts! Is it an essential feature?  Absolutely not! But, it is

Read More...

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!

How to Convert a PowerPoint Presentation from A Previous Version to PowerPoint 2010

Posted on by Posted in PowerPoint 2010

Although you can view and work with presentations that have been created in previous versions of PowerPoint, you may get improved performance and additional perks if you convert your older presentations to the PowerPoint 2010 (.pptx) file format.

When not converted, some features in your presentations, such as some Ribbon commands, may be disabled because some or all of your presentation content was created in a previous version that did not support those features.

If you would like to use all of PowerPoint 2010 features in your presentation, convert it!  Follow the steps below to learn how:

  1. Click the File tab on your Ribbon.
  2. On the Info tab, click Convert.

Info

Caveats:

  • The Convert command will only appear if at least of of the conditions below is met:
  • The presentation was created or saved in an earlier PowerPoint (.ppt) file format.
  • The presentation contains one or more diagrams or charts created in PowerPoint 2007 or earlier.
  • The presentation contains media objects. such as audio or video clips, created or inserted using PowerPoint 2007.
  • If the Convert command does not appear, the presentation is up to date in PowerPoint 2010.
  • After converting, you are prompted to save the converted presentation. The original presentation is not deleted. If the original is a PowerPoint 2007 presentation (.pptx), it is overwritten if you give the converted presentation the same file name and extension.