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

Carol's Corner Office

Monthly Archives: September 2021

Carol’s Ramblings

Posted on by Posted in Carol's Ramblings

Unofficial Fall is upon us. Leaves are falling, I am requiring a sweater when I go out to get the paper in the morning and I really, really, have the urge to bake! All sure signs of Fall, regardless of what the calendar has to say.

It looks like the pandemic is ramping up again.  I pray daily for all the little children in school who cannot yet be vaccinated. Two weeks in and my grandchildren have a teacher and a child with Covid and the other two grandchildren who are taking a bus home for the first time, got on the wrong bus the first day and the following week the bus was involved in a traffic accident. Oh, if I could just keep them in a bubble, safe from harm!  Hopefully there will soon be a safe vaccine for the little children as well. My oldest grandson wanted to be a person to test it on. His mom told him there was a possibility that he could die testing it.  He said “Well mom if I die doing something to save other people, I’m ok with that.” He is ten, God bless his little heart.  I have never been more proud of him. If only adults could be as selfless as he…  Nuff said.

Please take care of each other and anyone else you can help.

Until next time…

 

Carol-signature

Subscribers: How To Create A Report Using the Wizard in Access

Posted on by Posted in Subscribers Office 365

In today's post you will learn how to create a report using the Report Wizard.  I like the sound of that; don't you? I mean who wouldn't like to have a wizard around to do things you don't necessarily know how to do or are afraid to try? And the good news is that you

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!

Time Saving Outlook Shortcuts

Posted on by Posted in Outlook 2016

Everyone knows that I love saving time and keystrokes. Why wouldn’t you like to do that as well? So below you will find some time saving Outlook shortcuts.

Want to insert a hyperlink on a selection of your text? Simply click CTRL + K

Need to align text?

CTRL + L will align left

CTRL + E will align center

CTRL +  R will align right

Want to run Spellcheck before you hit send? Just tap F7

Forgot to fill in your subject? Alt + J will take you back to the subject field

You are welcome. Glad I could help!

How To Use Word Document as Outline for PowerPoint

Posted on by Posted in Word 365

I love it when Microsoft Office applications work together to make my life that much easier.  You may already be using this method, but if you are not, then you should definitely try it so you can make your life easier as well.

Follow the steps below to learn how:

  1. Open your Word document.
  2. Click Home.
  3. Use Styles to format the content in your Word document.
  4. You can highlight your content that you would like to use as a slide title and in Styles, select Heading 1.
  5. You can highlight the content you would to use as slide text and in Styles, select Heading 2.
  6. In your Word document, click File | Save.
  7. Then click File | Close.
  8. You cannot insert your Word document into PowerPoint unless it has been closed.
  9. Now, open PowerPoint.
  10. Click Home | New Slide.
  11. Select Slides from Outline.
  12. Navigate to and select your Word document in the Insert Outline dialog and click Insert.
  13. A new slide will be created for each Heading 1 in your document.

If you did not use Heading styles, PowerPoint will create a slide for each paragraph in your document.

Pretty cool huh?

How To Create Labels With Access Wizard

Posted on by Posted in Office 2016

You can use the Label Wizard to create labels for a wide variety of standard label sizes, and it is really quick and easy.  You all know I love to save time and keystrokes!

Follow the steps below to learn how:

  1. In the Navigation pane, open your table that will be the source for your labels by double-clicking it.
  2. On the Create tab, in the Reports group, click Labels.
  3. Follow the directions of the Label Wizard.
  4. On the last page, click Finish.

Access will display your labels in Print Preview so you will see them as  when they are printed. You can use the slider control on your Access status bar to zoom in on details.

Please note that Print Preview is the only view you can use to see multiple columns. In any other view you will see only one single column.

Again, easy peasy!

Subscribers: How to Create A Report in Access

Posted on by Posted in Subscribers Office 365

There can be many reasons why you may want a report when using Access.  In this post I am going to tell you how to create the easiest report you can.  It may not be fancy or finished looking, but it also will not prompt you for information. Why then am I telling you about

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 Add A Chart to A Word 365 Document

Posted on by Posted in Subscribers Word 365

Ever have a need to create a chart in Word? I know when I was in the working world, there were many, many times I was requested to do so. The first time I panicked but once I learned how it was a piece of case. Having said that, you can make a chart in

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 Create A 3D Map in Excel 365 & 2016

Posted on by Posted in Subscribers Word 2016

3D? Really? You can do that in Excel??? Why yes, you certainly can. It is a three dimensional map that allows you to view your information in newer, more modern ways. So why would you want to use this? Well there are more than one answer to this question.  See some of them below: Map

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 Evenly Place Your Table Rows

Posted on by Posted in Subscribers Office 365

OK, you know what data you want to use in your table, and you think you have all your formatting in place. So now you start to input your data and you find that event though the height of your table seems correct and pleasing to the eye, your rows look funny.  Hmm, how 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!