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

Carol's Corner Office

Monthly Archives: May 2020

Carol’s Ramblings

Posted on by Posted in Carol's Ramblings

Wow, we are in the middle of May already! I don’t know about you, but the days seem to meld into each other of late. And those days seem much longer to  me as well. Strange and trying times we are living in now! We can easily become distracted, distressed or depressed. I know I miss seeing and hugging my grandchildren something awful at times, especially holidays. So what I try to do when it seems the entire world is spiraling out of control, is try to place my focus on what I CAN control.  I can keep a positive attitude. I can make masks to help folks who do not have any. I can make little gratitude bears and give them to my local grocery. I can make healthcare hero bears and give them to front line workers in hospitals and doctor’s offices.  And most importantly, I can make sure I follow the rules for social distancing, staying at home except for necessities, and wearing a mask when I do need to venture out.

I’m not trying to tell YOU what to do – I’m just sharing what has helped me during this pandemic we are experiencing. I find that if I do something for someone else, it not only helps them, but it also helps ME. I have made all  manner of stuffies for my grandchildren that I can give to them once we can be together again. It gives me great joy to do that. I also like to day dream about getting together with all the special people in my life when we can safely do so again.

So cheer up, put a smile on your face, adjust your crown, and remember – nothing lasts forever – we WILL get through this and come out the other side the better for it.

Try to enjoy the warmer weather and try to remain positive and hopeful and let the people you care about, know it.  Until next time, be safe and take care of you and each other…

Carol-signature

How To Use Building Blocks To Create A Publication

Posted on by Posted in Microsoft Office

You can speed up your document creation in Publisher using Building Blocks – these are content blocks that you can use over and over. See the different types of Blocks below:

  • Calendars – Stories, sidebars and headings
  • Page Parts – Stories, sidebars and headings
  • Borders and Accents – Reusable graphic elements
  • Advertisements – Coupons and other advertising content
  • Business Information – Contacts and other information about your company

You can also find four galleries of Building Blocks in the Building Blocks group on your Ribbon. The fifth gallery, Business Information, can be found in the Text group.

How To Convert Tables To Charts In Word

Posted on by Posted in Word 2016

Have you ever completed a table, had it exactly the way you wanted it, all formatting done – a real work of art – and you hand it in to your boss and he says, “well that’s great, but I would really rather see it in a chart?” Yes, that has actually happened to me. And worse yet, I didn’t know how to easily convert the table to a chart.  How embarrassing!

The good news is that I learned how to convert tables to charts and now I am going to share that information with you.

Follow the steps below to learn how:

  1. Select the table you would like converted to a chart.
  2. Be certain the Insert tab of your Ribbon is displayed.
  3. In the Text group, click the Object tool.
  4. In the resulting dialog box, select Microsoft Graph chart from the list of Object Types.
  5. Click OK to display a graph of your data.
  6. Format your graph to your liking.
  7. Click anywhere outside your inserted graph to continue working in your document.

You may notice that there is a Chart tool in the Illustrations group on the Insert tab of your Ribbon. You might be fooled into thinking that this would work for you just as well as the steps above. It will not.

If you have tried this, you know that the end result will be a generic chart created by Excel and placed directly in your document. Yes, you can also get the same end result if you choose Microsoft Excel Chart in step 4 above.  Word does not base your chart upon the table data you selected it in step 1 above. Instead, it inserts your chart into the first cell of the table, deleting anything that was in that cell.

For that reason, I feel it is better to avoid using the Chart tool and insert a Microsoft Graph Chart object.

How To Rotate Pages in PDF Documents

Posted on by Posted in Adobe Acrobat

I have had more than one frustrated person inquire how to rotate pages in PDF documents. It turns out that it is really very simple.

Follow to the steps below to learn how:

  1. Open your PDF in Acrobat DC.
  2. Select Tools | Organize Pages or Organize Pages from the pane on the right.

organize-pages-secondary-toolbar

  1. In the secondary toolbar, specify the page range where you would like to apply the rotation.
  2. You can select from Even Pages, Odd Pages, Landscape Pages, Portrait Pages, or All Pages. Or you could simply enter the page number you would like to rotate.
  3. Once you have made your specification, for Direction, select either counterclockwise 90 Degrees or clockwise 90 Degrees.
  4. You can also apply the page rotation on a certain page by clicking the counterclockwise or clockwise rotation buttons displayed in the thumbnail view.
  5. If you would like to temporarily change the view of your page, select
    View | Rotate View | clockwise or Counterclockwise.

Your original page view will be restored when next you open the PDF.

Subscribers: How To Un-pivot Your Date in Excel

Posted on by Posted in Subscribers Excel 2016, Subscribers Office 2016

I do not claim to be an expert in Excel, but I do like to learn about it and use it when warranted. As such, it behooves me to try and keep abreast of what is going on in the world of Excel. In that vein, I came across information describing how to "un-pivot" data

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: How To Personalize Office 365

Posted on by Posted in Subscribers Office 2016

The features in this article are only available in Office 365 for business and NOT for Home or Personal subscriptions. There are many ways in which you can personalize Office 365 and the Office 365 app launcher, to make it fit your personal style and to make it easier to use.  I love easier to

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: How To Use Mentions in Office 365 Comments

Posted on by Posted in Subscribers Office 2016

Whether you are adding comments to your Word Document, Excel worksheet, or PowerPoint presentation, Office 365 now will allow you to mention another user/colleague. You use the @ sign to do so, such as you would with many apps. What are Mentions for and how do they differ from Comments? Well read along and learn.

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: How To Enable/Disable AutoComplete Feature

Posted on by Posted in Subscribers Outlook 2016

I have had many questions regarding the AutoComplete feature and so I thought it prudent to follow up with even more information in that regard.  So read on! To access your AutoComplete setting follow the steps below: On the File menu, click Options. Select the Mail tab. Scroll approximately halfway down until you see Send

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!