The Tribe of Adminsa home for wayward admins

I recently solved a problem that had been plaguing me for months. I inherited an email schedule that had been created for a client, laid out like this:

Week 1              Week 2                Week 3

Tier1 Name 1    Tier1 Name 2   Tier1 Name 3

Tier2 Name 1   Tier2 Name 2   Tier2 Name 3

Tier3 Name 1  Tier 3 Name 2   Tier 3 Name 3

Looks like one of those puzzles in the Sunday Times, doesn’t it? Here’s the thing: Tier 1 folks got contacted every 2 months. Tier 2 every 4 and Tier 3 every 6. So here’s this beautiful schedule, which, when it comes to the end of the names, repeats. Well, it didn’t take me too long, as measured by average ape mentation rates, to figure out that when we repeated the first tier 1 contact it wasn’t going to be time yet to contact the Tiers 2 and 3 people listed for the same week. What’s really embarrassing is how long it took me to solve it. When I’m embarrassed, I try to advertise how stupid I am so everyone else can be embarrassed for me. I think it’s a well thought out psychological strategy. But seriously, this problem had clearly also happened to the person who preceded me, and something similar may have happened to you.

I searched the web for templates or solutions. I consulted Excel experts and tried out their arcane and extremely labor intensive formulas. I squinted and scribbled and searched for different software. I cursed.

Sometimes you just need to look at data in a different direction. If you can’t make a spreadsheet work horizontally, try it vertically. Everything may look different to you. If you want to see my—really very simple—solution to this particular little hell, the details are on this page. If you’re struggling with one of your own, try turning your monitor sideways.

Related Posts:

• Excel Window is Too Big
• Randomizing a List of Words or Names
• LauraJ’s Weblog : Excel tip: Split first name and last name into separate cells
• New Excel Wiki and Counting Check Marks
• Counting Multiple Variables in Excel
• How to Count the Number of Days between Two Dates
• Picture Doesn’t Show in Word
• Can I Create a PDF without Adobe Acrobat?
• Lots of New Stuff
• Wanted: Guest Gurus

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.

Copyright secured by Digiprove © 2012

Related Posts:

• Can I Create a PDF without Adobe Acrobat?
• Lots of New Stuff
• Hiding Data in a Word Table
• Changing the Page Number Style in Word
• Aligning Bullet Indents in Word and PowerPoint
• Who Loves Office 2007?
• Editing PDF Files That Won’t Be Edited
• How to Tab within a Cell in Word Tables
• Sometimes You Can Over Think It
• Changing the Format of a Picture

Large companies tend to be charry of handing out Acrobat Pro to just anyone, and you’re not one of the chosen. Or you work from home and can’t afford a copy…can you create a PDF? Yes! See item 6 in the Acrobat FAQ.

For more information about PDFs, check out the Adobe Acrobat 9 PDF Bible at Amazon.

Related Posts:

• Lots of New Stuff
• How to Print Webpages Properly
• Picture Doesn’t Show in Word
• Editing PDF Files That Won’t Be Edited
• Hiding Data in a Word Table
• Changing the Page Number Style in Word
• Who Loves Office 2007?
• How to Tab within a Cell in Word Tables
• Sometimes You Can Over Think It
• Changing the Format of a Picture

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

Related Posts:

• Can I Create a PDF without Adobe Acrobat?
• How to Print Webpages Properly
• Picture Doesn’t Show in Word
• Hiding Data in a Word Table
• Changing the Page Number Style in Word
• Who Loves Office 2007?
• Editing PDF Files That Won’t Be Edited
• How to Tab within a Cell in Word Tables
• Sometimes You Can Over Think It
• Excel Window is Too Big

I don’t use the full range of Excel, and the people who create it don’t think like I do. Those two factors make the directions difficult for me to follow. Halfway through I’m thinking “What are they going on about??” It just isn’t how I would do it. If you have the same problem and have figured out a few tricks, send them in. Here’s one of my own:

Sometimes I need to count more that one variable in a line, but I can never remember the formula. I finally saved a small spreadsheet with the formula in and called it, “How to Count Multiple Variables in Excel.” Imaginative, aren’t I? If you can’t remember it either, use this formula:

=IF(AND(D3=”d”,E3 =”yes”), 1, “0″)

That means if cell D3 consists of the letter “d” and the cell E3 has the word “yes,” count it. If not, enter “0.” The last set of quotations is for the value “if false.” If you leave out the zero and just use:

=IF(AND(D3=”d”,E3 =”yes”), 1, “”)

Excel will leave the cell blank if both variables are not true.

Of course you would use your own cell numbers and entries.

Click into a blank cell at the end of the column you’ve been entering this formula into and choose “Autosum.” You can find this by clicking on ∑ in your toolbar, by choosing “function” from the insert menu (or pane in 2008), or right clicking then choosing “insert function.” If you use one of the latter methods, you’ll then need to choose “sum.” If you click on ∑ and haven’t pulled down to another choice recently, it will default to “sum.” One click totals! Any way you do it, you’ll have the total number of rows that meet your criterion of having both the specified variables. Clever bugger, isn’t it?

Have an Excel question? Send it in here. More about Excel:

Excel Wiki

Reversing Last Name First Lists into a Single Excel Column

Counting Check Marks

Everything Pasted into One Cell!

How to View Excel on Multiple Monitors

Related Posts:

• Sometimes You Can Over Think It
• How to Count the Number of Days between Two Dates
• Excel Window is Too Big
• Randomizing a List of Words or Names
• LauraJ’s Weblog : Excel tip: Split first name and last name into separate cells
• New Excel Wiki and Counting Check Marks
• Wikiing Up to Word
• Picture Doesn’t Show in Word
• Can I Create a PDF without Adobe Acrobat?
• Lots of New Stuff

This site is heavily skewed to Microsoft Office, but there are a lot of other heavily-used software suites out there–Lotus Notes, “notably”–so if you have answered a lot of questions about some other piece of software, send in the questions and answers. People need you!

Related Posts:

• Must I Tweet?
• Why Administrative Professionals Day?
• What makes an AA an EA?
• Sometimes You Can Over Think It
• Picture Doesn’t Show in Word
• Can I Create a PDF without Adobe Acrobat?
• Lots of New Stuff
• How to Tab within a Cell in Word Tables
• Hiding Data in a Word Table
• A Better Way to Organize Your Outlook Email