0

STOP YELLING!

Posted by TetonTrekker on March 14, 2018 in Customer Service, Fly By Posting, Internet, Tips for the common user, Toxic Thana, Word |

Unlocking the Cap Key

I remember the 90’s, I was using a Zenith Computer with DOS programs and the Caps Lock key always on. Like my old 8-track tapes, those days have past. One of my first world pet peeves is people who type in all CAPITOL LETTERS, it is hard to read and hurts my eyes. And since the introduction of email and social media it is associated with yelling, it’s rude. I once cleaned up after Toxic Thana, she typed everything in capitol letters, and she had a reputation for yelling at people. I found that funny, and in this case it was a benefit, I new if something was in capitol letters I needed to review it. But please, unless you are yelling, unlock your Caps Key.



Tags: , , ,

0

Tip of the Two Weeks

Posted by TetonTrekker on January 13, 2018 in Fly By Posting |

Never make yourself so indispensable you can not take a vacation.

You should be a valuable asset to your employer but if no one else can do your job duties while you are away, you may never get a vacation. Keep an up-to-date list of duties and instructions for your relief. If you have no relief, delegate, bring gifts.



0

¶ is Your Friend

Posted by TetonTrekker on January 11, 2018 in Tips for the common user, Word |

Showing the Formatting Marks to Fix Layout in Word Docs

Have you ever been editing a MS Word Document and the layout keeps hopping around? Do you have one of those documents that print extra blank pages? Chances are good it’s a formatting problem.

Showing all the formatting marks makes it easy to identify problems and delete extra formatting. I first learned this trick on Word Perfect. Give it a try.

On the Home tab, in the Paragraph group, click the formatting icon to toggle Show/Hide. The background of the formatting  button is shaded when it’s turned on.

Now your document will show paragraph marks ¶, tab marks , spaces (gray dots), and other hidden formatting. Carefully review and delete unwanted formatting. If your document is printing blank pages scroll to the bottom of the page and delete all the hidden formatting marks up to the last line of your document.

If you have never used this tool I recommend saving a copy of your document prior to deleting extra formatting.

Was this helpful? Post a memo.



0

Those Pesky New Digits of the New Year

Posted by TetonTrekker on January 6, 2018 in Excel, Tips for the common user |

Using conditional formatting to alert yourself of wrong year.

Now that it is January 2018, sometimes we forget to date things with the correct year, but it usually only happens a couple times before the new digits are embraced.

Example 1

The brain freeze I have every year happens when I’m entering data in Excel. Much of the data I enter has a date that is from the  previous month. Since Excel assumes the year is the current year, unless something else is typed, I usually just type the month and day and let the computer do the rest. In January, data entry can problematic for me because it may not be immediately noticeable if I forgot to type the correct year in a December cell.

To make my life easier I use conditional formatting to highlight cells that have future dates. A red highlight alerts me that I have entered a bad year. Give it a try.

Example 2

Follow these steps to set up Conditional Formatting:

  1. Highlight the Excel column(s) you will be typing the dates in. (example 1)
  2. Click the Conditional Formatting button in the toolbar. (example 2)
  3. Pick Highlight Cell Rules.
  4. Pick Greater Than.

Now you should have a dialog box, in the formula box type  =TODAY() as in the example 3. You can modify it with math if needed, in example 4 I added 30 days so a date in the next 30 days will not highlight with a color box.

Example 3

Example 4

Next set the highlight and font color to your choice and press OK, and you are done.




Example 5

Now when you type a year greater than today,  the cell lights up with a light red background and red text.

Conditional formatting is handy for a variety of reasons that I will be covering in future posts. Feel free to post a memo to this entry and please subscribe to my blog to be notified for new posts.

I used an older version of Excel to screenshot these examples, what you see on your computer may vary a little. You can click each example for a larger view.

Tags: , , , ,

0

Happy New Year Fellow Office Gurus!

Posted by TetonTrekker on January 2, 2018 in Fly By Posting |

Happy Year End Fellow Office Gurus!

{Don’t worry, I won’t hurt you
I only want you to have some fun}

I was dreamin’ when I wrote this, forgive me if it goes astray
But when I woke up this mornin’, could’ve sworn it was 1099 day
The sky was all purple, there were bookkeepers runnin’ everywhere
Tryin’ to run from the migraines, you know I didn’t even care

Say say one thousand zero zero party over, oops, out of time
So tonight I’m gonna party like it’s ten ninety-nine




Tags: , ,

Copyright © 2013-2018 Julie: Girl Friday All rights reserved.
This site is using the Desk Mess Mirrored Child Child-Theme, v2.5.1511966596, on top of
the Parent-Theme Desk Mess Mirrored, v2.5, from BuyNowShop.com