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.


¶ 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.


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: , , , ,


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: , ,


#041 Send Them a Postcard

Posted by TetonTrekker on December 30, 2017 in Internet, Morning Coffee |

Privacy is an Illusion

I don’t ever type anything on an email I would not write on the back of a postcard.”

Several years ago, before social media, I was having a conversation with a coworker about a troublesome inter-office email that got passed around, and that was her response. It describes it perfectly, especially when typing in social media (or blogs such as this), I have adopted that quote.

Electronic communications are a part of our life, but the proverbial gene is out of the bottle, we cannot go back. In many ways that it makes our life easier, BUT, anything and everything you put out there is out there for good. Even if you live an boring and uneventful life, those words can come back to haunt you.

Written words, especially when thumbing a short email on you device, can be misinterpreted despite how carefully you proof read, if you proofed it at all. You could (and should) redact everything you write before you punch ‘save’, or you could go completely off the grid, but many times things are out of your control.

Then there is the problem of the social trolls spewing falsehoods on the internet. But that is another story for a future blog post “Social Media: The Ugly”.

Why should I care? I live an boring and uneventful life.”

Because it is there forever, and your life may change.

Employers search the internet and social media to see what there is to know about you. When typing in this blog I stop to think what a potential employer might think about me.

You could unexpectedly be part of a viral news story, true or not, and have thousands of people looking for any dirt on you they can find. Don’t laugh, within the last few years exactly that has happened to several normal people in our small town. Sports, politics, teachers, service industry, even tour services that don’t spend time on the internet. No one is immune. It does not need to be true, it just needs to be shared, people tend to form an unbendable opinion based the first story the read.

There is at least one website out there that has a snap-shot history of website pages across the net. Years ago, one of my website clients had club members phone numbers listed publicly so other members could have easy access. The problem being the entire planet could see the phone numbers. Even though I changed it to a password protected page, there are snapshots of the public version going back to 1999!

But, I posted a privacy notice on my social media account.”

Even if that meant anything, which it does not, your posts can be copied or a screen shot can be taken. If you delete your post from the internet it still exists on the servers and in the minds of the people who read it. Even private messages can possibly be subpoenaed.

Example: A friend saw a death threat on a public Facebook Page (there is no need to log in to see a public FB page and its posts). It was directed at a person we both knew, we were able to screenshot the threat, the profile of the person who made it, and several pictures of what the offender looked like. The pics had empty booze bottles in the background and the threats were deleted within a week. I suspect the offender was drunk and had regret when she sobered up, but you just don’t know. Those threats are in proper hands, deleting it didn’t change a thing.

For a brain numbing read see Stored Communications Act

Things You Can Do

  • Google, Yahoo Search, and Bing yourself, and do it often.
  • Don’t post while drunk. Just no.
  • Don’t let friends drunk post either.
  • Don’t post pictures with illegal activity in them. #DUH
  • Assume everything you type will be read out loud in court some day.
  • Don’t be an asshole.
  • If you type while angry, save a draft only and give yourself  24 hours to cool off. Ya, if you know me, I know you are laughing. This is something that I have learned by fire. I hope others avoid the fire by reading my blog.

Give Them Something to Read

I know a guy, who had no web presence, become part of a miss-reported news story about him and it went viral. Since he had nothing out there about himself, the only thing we can find on the internet about him is scathing.

After watching what a viral news story can do to a nice person, I have formed a personal opinion that giving people something good to read is a good alternative to hiding from the world. Since I have a large web presence I keep my websites up-to-date and public.

I believe that if there are good things on websites already in place, scathing pages would bury themselves quickly. However, I could be wrong. Make up your own mind.

Go ahead… put it on a postcard.


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