The Tribe of Adminsa home for wayward admins

You want to have a drawing, or you’ve created a word list for a party and want to mix them up and don’t want to have to go through the process of pulling them out of someone’s greasy fedora. Here’s how to do it in about 15 seconds:

in Column A, list your names.
in Column B, enter the following: =RAND()*300
What that will do is enter a random number between 1-300 into Column B. If you choose 1000, it will enter a number between 1-1000. Go wild.

Drag to copy the formula down the whole column. You’ll see something like this:

See the random number in column B? Now sort by Column B. Be sure to choose “no header.” The results are confusing to look at, because Column B has an imperative to randomize and will do so again immediately, but now look at Column A:

Voila! Random!
You can throw away Column B – you don’t need it anymore.

Sometimes someone else says it so well, there’s no point in repeating it. I stumbled across this tip in LauraJ’s Weblog the other day. It’s yet another tool to use in our unending quest to split up first and last names (or any text) in an Excel column. Here’s the link:  LauraJ’s Weblog

I’d quote her, but she uses pictures – bless her – and those wouldn’t carry over. Take a little side trip over to her site and then come on back for more about Excel. Thanks, LauraJ!

A lot of people are asking how do I decline a meeting without having the meeting notice disappear? I changed my mind later and the invitation was GONE! The answer is here:
Outlook FAQ Item 9…but I won’t make you click again!

If you have a newer version of Outlook, the invitation is in your Outlook trash folder and you can retrieve it. If you have an older version, however, it’s just gone. You’ll need to ask the host to send you a new copy of the invitation, or ask someone to forward* it to you. The way to avoid this in the future is to open the calendar, open or right click on the meeting, and decline from there. The invitation will remain in your inbox where you can accept it again, thereby putting it back into the calendar.

If you want to the invitation to remain on the calendar but not show as busy, you’ll need to “reply to” the originator saying that you won’t be able to attend, then change the “show time as” option to “free.” If you choose “decline” it will be removed from the calendar.

Tip: I like to make a personal folder for declined invitations so that I can quickly review what I’ve turned down if the conflict changes.

Aren’t admins busy enough?!?

The short answer is yes, you must.

Your boss may just be discovering social media – and you may be, too. You must get ahead of that curve! An old-school admin will soon find herself in a new-fangled unemployment line – online.

What happens when your manager wants you to maintain the website and tweet regularly? Are you ready? You may be in the position of advisor. If that happens, you need to figure out whether or not Twitter is an appropriate means for your business to promote itself. Tweeting about caulking every five minutes isn’t going to win your company love or dollars.

If you think Twitter is all there is to it, you need to put down the quill pen and start start surfing. You might check out JK Virtual Office Blog. She’s a VA who has specialized in social media and she has some useful insights to share. Another one is the My Twitter VA blog. She’s taken a certification in social media marketing. We might not all want to become marketers, but if you don’t know the basics and it doesn’t come easily to you, find a course, online or otherwise.

And what about that website? The theory is that “all” you have to do is post the updates. The words “all” and “website” should never be used in the same sentence. You’ll need to learn more about it, and what you need to learn depends on what kind of website your company has. Something that definitely falls in the “can’t hurt” category is learning a little HTML. I know….it sounds like “ewwwww…programming,” but it’s really more like pig Latin. Once you get the gist, you can navigate reasonably without being fluent. I found this free online tutorial at W3 Schools fun and illuminating.

Leave the “I don’t need to know that” mentality to those who can afford it – admins need to adaptive learners. That’s the long answer.

You’ve done everything right – you’ve chosen “Insert” from the menu bar or the picture icon from a tool bar or pane, you’ve chosen “picture from file,” and you’ve said OK. A nice box appears but no picture! You try different formats, you try this, you try that. You print the picture out of another program and it’s fine! What gives?? What gives is that Word thinks your picture is behind some text, even if you have none. What can I tell you? Word is occasionally delusional.

Get to “Format Picture” by your preferred method – I right click on the picture.

Now choose “Layout” from the list of choices. In the Mac 2008 version it looks like this – yours may differ, but the same choices will be there:

Now click on “In front of text,” which shows the dog in front of the lines:

Your picture appears like a rabbit in freshly planted lettuce patch.

Check the Outlook FAQ! You can find answers to:

• How do I send something from my computer “from” my manager?
• Why does the email say it’s from me even though I was in his inbox when I started a new email?
•  How do I keep my manager’s mailbox from being deluged with responses to big meetings?
• Why does my executive’s inbox keeps getting overloaded even though s/he is using personal folders?
• Sometimes I open a distribution list or copy a long list of names into the “To” box. When I hit “Send,” Outlook checks the addresses against my company directory and gives me the opportunity to choose a name if it can’t identify it. If the name isn’t there, I have to close out of the window, take the name out of the “To” box and start all over! Is there a way to avoid this?
• Why is an appointment suddenly appearing as nonsense text (”Greek” or gibberish)?
• When I try to accept a meeting, it says ”The function cannot before performed because the message has been changed.”
• When I try to save changes to a meeting I created in my manager’s calendar, it says something along the lines of “The item cannot before saved because the item has been changed. Would you like to save to the default folder?”
• How do I decline a meeting without having the meeting notice disappear? I changed my mind later and the invitation was GONE!

Find those answers or submit your own questions here.

Need a copy of Microsoft Office? Click below for the best prices and help support our site!

Mac Version:

Other Versions:
Click here for any upgrade, professional version…any version of Office you want!

Someone asked, “How do I decline a meeting without having the meeting notice disappear? I changed my mind later and the invitation was GONE!’

If you have a newer version of Outlook, the invitation is in your trash and you can retrieve it. If you have an older version, however, it’s just gone. The way to avoid this is to open the calendar, open or right click on the meeting, and decline from there. The invitation will remain in your inbox where you can accept it again, thereby putting it back into the calendar.

If you want to the invitation to remain on the calendar but not show as busy, you’ll need to “reply to” the originator saying that you won’t be able to attend, then change the “show time as” option to “free.” If you choose “decline” it will be removed from the calendar.

Tip: I like to make a personal folder for declined invitations so that I can quickly review what I’ve turned down if the conflict changes.

Want to find this information later? Bookmark out the FAQ section of the Outlook Wiki

I’ve posted an Excel Wiki – I call them “faux-wikis” because you need to click contact or add a comment to edit or add to it, rather than editing directly as you would in a true wiki. It’s ready for your input!

So far, it’s connected to a page about reversing last name first lists and putting them into one column, and some posts about viewing Excel on dual monitors, solving the problem of all of your data pasting into a single cell, and counting multiple variables.

And here’s a silly little tip:

Check marks are useful little critters, and you can use them for counting, too. Many fonts use Alt (Option on Mac) V for a check, but many fonts – especially in Windows – don’t. That means you have to choose Insert>Symbol, find the check mark and insert it. Repeat every time you want it, or copy and paste. More trouble than it’s worth!

Easy fix: Insert a column for your check marks. If you have the font Marlett, change highlight the column and change it to that font. The letter “a” is a check in Marlett.

Now, to count:

Select a cell to enter your count in. Change it to a normal font or you’ll be very confused! Enter: 

=COUNTIF(C1:C3,”a”)

The C1 and C3 should be changed to the top cell of your check mark column and the bottom cell of that column.

Here’s how you get to that formula if you want to do it from scratch: Under the ∑ symbol on your tool bar, or Insert>Function, choose or search for COUNTIF. Once you’ve selected it, a box will open. Click in the first box then click into your column and drag from the top to the bottom, or select it in your favorite manner. Now click in the second box and type “a.” Hit enter.

That’s it!

The solutions to those annoying “function cannot be performed” messages have been posted in items 7 and 8 of the Outlook FAQ.

The site has updated with lots of new information. An Adobe Acrobat Faux Wiki has been added with a couple of supporting pages to address some of those nagging PDF issues and open the floor to questions and tips.

There’s a new page on how to get rid of that annoying markup that remains when you print Word documents after tracking changes here.

Ever paste a table into Excel, only to have it all show up in one cell? Here’s a solution that’s just been moved into the Word Faux Wiki.

There’s a page on The Wonder of Snag-it, a big problem solver for admins.

Finally, there’s a new post right below this one on how to count multiple variables in Excel that will eventually become part of an Excel section.

You might notice a few more little ads at the bottom of the pages. I remain committed to keeping it to a minimum, but I could use a little help supporting site, so if you want any of the software or books you see here, click through!

If you want to be notified of the updates on this site, click on RSS or on “RSS” down at the very bottom of the page. Once you’re there, choose “subscribe in mail” near the bottom of the right hand sidebar.

Cheers!

Technorati Profile