June 2017 – Carol's Corner Office

Carol’s Ramblings…

Posted on June 13, 2017 by Carol Bratt

Posted in Carol's Ramblings

Ah Spring is on the wane and Summer is just about to make an appearance…I’m loving life! The temps in my neck of the woods feel as if Summer is already here, but that’s ok. I love being outdoors and this is the perfect time of year for me! I like to try to keep in shape and stay healthy and a good part of that is exercise. I would absolutely much rather do my exercising outdoors rather than indoors, regardless of whether it is hot or cold so yes, I love this time of year. I just try to get out there early before it gets too warm.

Very turbulent times we live in right now, so I am asking everyone I know to try and be just a tad bit kinder to your fellow man/woman. Lead be experience and try to be the change you want to see. That means remember kindness and love. You can’t go wrong with either.

I have been very busy entertaining my grandchildren and working with my son who is a lawyer and still keeping up with my other job and this newsletter. Luckily, I don’t mind being busy!

I hope you find this month’s articles interesting and helpful. As always, if there is something special you would like to see covered just drop me a line and I will do my best to accommodate you!

Until next time, please take care of YOU…

Fill Effects in Excel – What you Need to Know

Posted on June 13, 2017 by Carol Bratt

Posted in Microsoft Excel

Excel does not purport to be a specialized graphics program. It is a Worksheet program. Having said that, you can insert drawing objects that could be helpful to the viewer regarding the information you are trying to convey to them in your worksheet. You can even get fancy and fill them with a color.

Follow the steps below to learn how:

Select the drawing object you would like to modify.
Be certain the Format tab of your Ribbon is displayed.
In the Shape Styles group, click the Shape Fill tool to display fill options.

You can select any of the following:

GRADIENT – Is used to modify the density of the color used in various parts of the drawing object. You can experiment with these to get the desired effect.
TEXTURE – Displays many different surface textures you can use to fill your drawing object. There are some great textures provided with Excel.
PICTURE – Allows you to select a picture that is used to fill your drawing object. Depending upon the picture you select, this can create some neat special effects.

Subscribers: How to Automatically Use “Smart Quotes” in your Word Documents

Posted on June 13, 2017 by Carol Bratt

Posted in Subscribers Word 2016

"Smart quotes" is what typographers call opening quotes and closing quotes. If you look at the quote marks in any printed book, you will notice that the quote marks at the beginning of a quote look different from those at the end, and according to Word, are smart quotes. If you look at the quotes

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!

Additional Ribbon Buttons in Outlook 2016

Posted on June 13, 2017 by Carol Bratt

Posted in Office 2016

You can now archive items in Outlook with a single click using the Archive button!

Also, browsing or adding new groups is just as simple. All you have to do is that those two group buttons to your Ribbon if you do not see them.

To do this quickly,follow the steps below:

Simply right-click your Ribbon and select Customize the Ribbon.
Then search for the commands on the left-hand side and add them to the right-hand side.

It is very simple to use the Archive button:

Simply select a message and click the Archive button to move it to the Archive folder.
For those of you who prefer to use your keyboard, you can simply use your Backspace key to move your designated message to the Archive folder.

The first time you use your Archive folder, you will be asked to allow Outlook to create an archive folder named Archive or you can select an existing folder. If you uses Exchange online or Outlook.com and previously used Archive in Outlook on the Web or on another device, Outlook will use that previous folder.

You can select a new folder any time you like by clicking Files | Tools |Set Archive Folder.

Subscribers: How to Find Where Your Templates are Stored in Word

Posted on June 12, 2017 by Carol Bratt

Posted in Subscribers Word 2016

Microsoft does not make very easy to modify templates simply because it is not very intuitive where to find them in the first place! The first thing you do when modifying templates is load one, and that means you must know where they are stored. Unfortunately, the average user no idea where they are stored.

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

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 Delete an AutoText Building Block

Posted on June 12, 2017 by Carol Bratt

Posted in Subscribers Word 2016

AutoText has always been a very useful feature in Word. There are many reasons why you would want to remove an AutoText entry created previously because you had a need for it, but now longer do. Suppose you may had created several AutoText entries for a certain project you were involved with. Once your project

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

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 the Function Keys on your Keyboard

Posted on June 6, 2017 by Carol Bratt

Posted in Subscribers Microsoft Windows

I think we all know that function keys exist on our keyboard but it is very surprising to me that most of us have no idea what they do or how useful they can be to save time and keystrokes when computing. So I deem it high time that you be made aware of just

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

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 Calculate Expressions in your Word Documents

Posted on June 5, 2017 by Carol Bratt

Posted in Word 2013

Obviously, a Word document is not a spreadsheet, but you can treat it like one (kinda) by adding a toolbar button that will allow you to quickly calculate values in your document based on numbers in a selection. For example, you could highlight text such as 12*14+2 and quickly calculate that the answer is 170.

Follow the steps below to learn how to add this button to your QAT (Quick Access Toolbar):

Display the Word Options dialog box by displaying the File tab of your Ribbon and then click Options.
At the left-hand side of the dialog box select Quick Access Toolbar.

Using the Choose Commands From drop-down list, select Commands Not In the Ribbon.
Locate and select the Calculate command in the list of commands.
Click Add . The command will move to the right side of the dialog box.
Click OK.

To use the tool, all you have to do is highlight the expression you would like to calculate, and then click on the tool. Word will show the calculated value in your status bar, and place the value in your Clipboard. You can now paste the value any place you like.

M	T	W	T	F	S	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30