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

Carol's Corner Office

Category Archives: Microsoft Office

More Windows 10 Shortcuts

Posted on by Posted in Microsoft Office

These shortcuts will narrow down your local Cortana searches:

Apps – Search with Apps

Documents – Search within Documents

Videos – Search within Videos

Music – Search within Music

Settings – Search within Settings

Photos: Search within Photos

Mail – Search within your Outlook email inbox

People – Search within People

Don’t worry. If you do not see what you were looking for here, there will be more to come!

Commonly Used Microsoft Access Shortcuts

Posted on by Posted in Microsoft Access

Who doesn’t like a good shortcut? You know, saving time and keystrokes? Nobody, that’s who!

Follow the steps below:

Alt + H Opens the Home tab

Alt +Q + enter search word opens the Tell Me box on your Ribbon

Shift + F10 will display the shortcut menu for the selected item

F6 moves the focus to a different pane of your window

Ctrl + O or Ctrl + F12 opens an existing database

F11 shows or hides the navigation pane

F4 Shows or hides a property sheet

F12 Switches between Edit mode (with insertion point displayed) and Navigation mode in the Datasheet or Design view

F5 switches from Design view to Form view

CTRL + P opens the print dialog box for data sheets, forms and reports

CTRL + Z zooms in or out on a part of your page

F1 opens the Help window

Alt + F4 exits Access

These are by no means all of the shortcuts but definitely enough to make you happy!

 

 

More Outlook Shortcuts

Posted on by Posted in Microsoft Office

As I always say, you can never have too many shortcuts.  I just love saving time and keystrokes!

These are handy shortcuts one can use in Outlook Calendar.

Follow the steps below to learn how:

CTRL + N – Creates an appointment in Calendar view and CTRL  + Shift + A when in any Outlook view

CTRL + Shift + Q  Creates  a meeting request

CTRL + G  Takes you to a date

Alt + Equal or CTRL +  Alt + 4 – Switches to Month view

Alt + Minus Sign or CTRL + Alt + 3 Switches to Full Week view

CTRL + Alt + 2 Switches to Work Week view

CTRL + Comma  or  CTRL + Shift + Comma takes yo to a previous appointment

CTRL + Period or CTRL + Shift + Period Takes you to next appointment

CTRL + G sets up recurrence for an open appointment or meeting

Alt + (number of days you would like to see)  will show number of days in your Calendar

You’re welcome!

 

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!

Create A Note Book in OneNote

Posted on by Posted in Microsoft Office

Microsoft OneNote will allow you to create multiple notebooks for different subjects or projects.  And I find this very, very helpful.  It keeps me organized way better than I do on my own. All you have to do is create a note book for your specific needs.

Follow the steps below to learn how:

  1. Open OneNote.
  2. Click Show Notebooks.
  3. Click +Notebook, which you will find at the bottom of the list that appears.
  4. Key in a name for your notebook in the Notebook Name area.
  5. Click Create Notebook.

Easy peasy!

How To Sort Contacts By Color in Outlook

Posted on by Posted in Microsoft Outlook

One of my subscribers inquired if he could sort his contacts by color.  He felt it would be a lot easier for him to keep his contacts straight in this manner.  As I have always said, we all learn differently. Some of us read, some need pictures and illustrations. Well I guess that also applies to sorting as well. It helps that this is very easy to do.

Follow the steps below to learn how:

  1. Click People |  Home.
  2. In the Current View group, click List.
  3. Now scroll all the way to the right-hand side of your list of contacts and you will see the Categories column.
  4. Click the Categories column header to sort the list by color.

Told you it was easy!

How To Analyze Data In Excel 365

Posted on by Posted in Office 365

I confess that I do not use Excel all that often, but I do use it often enough to recognize how extremely helpful it can be for someone like me who was never a stellar scholar when it comes to numbers or math. So if you are like me, this will come in handy for you hopefully. I would not have a clue how to analyze data, much less in Microsoft Excel. But this has made it a whole lot easier for me.

Follow the steps below to learn how:

  1. Select a cell your a data range |  select Analyze Data on the Home tab of your Ribbon. Analyze Data in Excel will analyze your data, and return  visuals for you in a task pane.
  2. If you are  interested in specific information, you can enter a question in the query box at the top of the pane, and press Enter. It will then  provide answers for you with visuals (i.e., tables, charts or PivotTables) that you can then insert into your Excel workbook.
  3. Select the text box at the top of the Analyze Data pane, and  a list of suggestions based on your data will appear for your perusal.

Analyze Data is available in several languages to Microsoft 365 subscribers.

Go ahead and give it a try!