SBT BookAward2012 182x177 white Nominate Your Favorite Book: 4th Annual Small Business Book AwardsIt’s time for the 4th Annual Small Business Book Awards! If you’re new to the Book Awards, they’re put on by Small Business Trends, and highlight the top books published the year prior.

This year, we want to have even more great books nominated than last year, and we need your help. Right now nominations for business books are being accepted. The deadline for nominations is January 31, and then voting lasts through February 16.

How can you help?
We would love your support of the awards, and there are several ways you can assist.

1. Nominate your favorite books.
Likely, you read a few amazing books last year. Don’t those authors deserve to be recognized? You can nominate as many books as you like here.

2. Spread the word.
You’ve all been so supportive of past endeavors, like the Small Business Influencer project and Visual Marketing, so I hope you can continue to help us socially.

  • Blog: We’d love a blog post! Here you can find the rules for the awards. If you need more info, please ask.
  • Twitter: I’ll send pre-written tweets each week that you can easily share with your network.
  • Facebook & G+: I’ll do the same for these channels to make your work easier!
  • Emails: If you’d like to share the awards with your email subscribers, let me know how we can support this.


We’ve got some great events and book giveaways coming up, so I’ll keep you posted. Thanks in advance for helping us make this year’s Book Awards a smashing success!

Tweets to Share:
The #BizBookAwards are here! Nominate your favorite business books by Jan 31. http://ow.ly/8vmFg
Click here to tweet

What biz books rocked your world in 2011? Nominate them now #BizBookAwards. http://ow.ly/8vmFg Now through Jan 31. No limit on nominations.
Click here to tweet

Facebook/G+ Updates:
I nominated my favorite business books for #BizBookAwards. Did you? Nominate your favorite business books by Jan 31. http://bookawards.smallbiztrends.com/

Let your favorite business book author know how much you loved his/her book by nominating it for #BizBookAwards. Nominations accepted through Jan 31. http://bookawards.smallbiztrends.com/

{ 1 comment }

Mail Envelope w600 h900 300x214 How To: Create Mailing Labels Using Excel and WordI haven’t done an Excel tutorial in a really long time. I used to create one from every “how do you do this in Excel” request that I got on Twitter, via email or Facebook. A Twitter friend asked yesterday and this is actually really helpful for those who are sending out holiday cards or possibly some other type of mass mailing.

Here are the written steps and the video at the very end is for the visual people. These steps on how to merge and create mailing labels in Word with an Excel list were created using Microsoft Word 2007 so the actual navigation may be slightly different depending on your current version.

Part One: Create Your List of Addresses in Microsoft Excel

  • Be sure to use column headings in the Excel document as those column headings are what you will need as the merge fields for the actual labels within Word.
  • Add all of your names and addresses to the sheet
  • Save and close
Part Two: Creating the Mailing Labels in Word
  • Open a new document in Word and go to the Mailings section.
  • Click “Start Mail Merge” (in older versions of Word I believe this is called Mail Merge Wizard).
  • From the Mail Merge options you want to select “Labels”.
  • A pop-up window is displayed allowing you to select the type of label you are creating (the most popular mailing labels are Avery 5160). Click “OK” once you’ve selected the appropriate label type.
  • A new document should be shown on your screen with the label “guidelines” shown on the document ~ this represents each label and gives you a visualization on how the finished product will look once the remaining steps are completed.
  • On your menu bar at the top select “Select Recipients” and then chose “Use Existing List”.
  • Navigate and select the Excel file you saved from Part One above.
  • The pop up screen that displays next – just select “OK”
  • Your document should now show “Next Record” in all labels (except for the first one)
  • With your cursor in the first label we now want to set up the merge fields
  • On your menu bar select “Insert Merge Field” ~ the fields shown on this drop down should be the exact column headings you defined in your Excel sheet.  Each merge field needs to be inserted onto the label in the exact layout you want the final, merged labels to print. (Use Enter and Space as necessary)
  • You can edit font type and size using normal Word formatting options ~ just be sure your font/text does not go outside of the guidelines shown on the screen
  • Once Label One is laid out exactly how you like go back to the top menu and select “Update Labels” ~ this will take the merge fields, formatting, etc. that you defined on label one and automagically update the rest of the page of labels.
  • Now you are ready to pull the data in from your Excel sheet into the actual label template you have just finished creating.
  • Back at the top menu select “Finish & Merge” and then “Edit Individual Documents” ~ from here you can go ahead and select “All” (Tip: If you only want to print a certain range from your Excel sheet you can select the “From to To” option shown. If you use this range remember to subtract one from both the From and To number. For example: If you want to only print the names and addresses on Lines 30-60 on your Excel sheet; you will enter 29-59 as your From and To numbers)
  • Select OK and your completed, merge address labels should now be shown on the screen.
  • Tip: If the finished sheet of mailing labels shows data that is now running outside of the label guidelines (maybe you chose a font type or size that is too large for the finished product) you can re-format to a smaller font size / font type by clicking “CTRL+A” to highlight your entire document so you can easily re-format as needed.
  • Tip: If you have multiple pages of labels it may be best to print just the first page to assure that the printed results are perfect.
Video Instructions on How to Merge Mailing Labels Using Microsoft Excel and Microsoft Word

Happy Holidays! Hopefully this how-to helps save some time on getting those Christmas cards out the door!

 

{ 23 comments }

When Chasing the Dollar Causes You to Spend More

by Michelle Mangen on December 2, 2011

in Random

**Note: This is a really long post and for anyone who has been around my blog for any period of time you’ll immediately realize this is the most personal post I’ve ever written. It’s not my standard blog fare…but like all of my posts, I hope you learn something.

Party Favors w600 h900 300x200 When Chasing the Dollar Causes You to Spend MoreA few hours ago I realized that yesterday was my three year business birthday. Yes, I know “technically” it is referred to as an anniversary but isn’t starting any new business really a “birth”? There are many analogies we could draw in comparison to a birth and a business but that’s not what this post is about rather I’d like to focus on what I’ve learned the past three years.

Part One: The Realization

December seems to be a time when many people reflect on the past year and make decisions and commitments to the year ahead. My time of reflection began in September after having friends that I haven’t seen in 4 years come to visit (one from London and the other from Milwaukee).  While they were here it became painfully obvious to me that I was putting so many hours into client work that I felt as though I couldn’t step away for a few hours to do girlfriend things (aka shopping, pedicures, etc.)

I promised myself that after they left I was going to assess what I was doing against what I thought I was doing. Sometimes our mind plays tricks on us. For example, there have been many days where I’m at my computer “working” for 12 hours but I only bill out for 7 ~ so where did the other 5 hours go?!

My prep work included updating my budget so I could determine the actual number of hours I needed to work. Next I ran and exported a Quickbooks report showing my billings for the past three months (I figured that was a good way to get a solid average of monthly billed hours). With that list in Excel I added a column and “classified” each of my clients as either a) regular, recurring work or b) project work (meaning I have no idea when they will need me and how long it will take)

As a general rule of thumb I know that for every hour I am at my desk I bill out 45 minutes or less. Spreadsheet in hand a bunch of sorting took place, numbers crunched and tallied, and the end result was….”Oh wow, I’m actually billing out way more hours than I thought!” Followed immediately by, “I’d have made partner in a law firm by now!”

Not-so-funny lawyer joke aside, I actually had a sinking feeling in my stomach and the questions began spinning in my mind. How did I take on this much? Do I really say yes to everything and everyone? How did I get here? No wonder it seems that I am always working, I really am!

The only question I had a solid, known answer for initially was I knew how I got here.

Part Two: How I Got Here and How To Change

I work all night, I work all day; to pay the bills I have to pay.

Ain’t it sad?

~Money, Money, Money from Mamma Mia!

“Here” for me is defined as the state of “I’ve taken on too much and can’t even take a few hours off to hang with my visiting girlfriends”. I wasn’t feeling overwhelmed but I was feeling as though I was never getting caught up and what I had taken on was considerably more than what I knew I actually needed to take care of myself and my son (referring to my trusty budget).

Careful analysis uncovered the following:

  • I had been turning away general website inquiries but saying yes to nearly every referral that came through from friends or existing clients
  • Because I had said yes to nearly every word of mouth referral I took on some clients that I should have referred to another Virtual Assistant
  • Each client, no matter the size, takes the same mental energy from me
  • Because each client takes the same amount of mental energy I’m not prepared to become a multi-Virtual Assistant firm
  • Conventional “wisdom” isn’t always necessarily what is right for me
  • Some tasks, that used to be fun, now seemed like drudgery
  • I needed help, on some scale, to get some of my own things addressed
  • Working 7 days a week was taking a toll on me (and we aren’t talking about 8 hour days)
  • I realized I actually need to scale back in order to grow

The decisions I had been making were made from a place of fear. I was fearful that if I said no I’d hurt people’s feelings. Fearful knowing that things can change quickly for most of my clients which could result in a decrease in income. Fearful that somehow I’d end up on the street with my son.

I was chasing the dollar….living to work. And that is NOT why I started my business.

I knew this. It. Had. To. Stop.

And I made a commitment, to myself, on the spot. It had to change despite the fact that I thrive on keeping busy and helping others and I truly love what I do.

I revisited the Quickbooks report / spreadsheet I had conjured up and tried to figure out which clients I could refer to someone else. It was hard, really hard…because I love all of my clients (except one). The one I didn’t “love” was a no-brainer. The others were harder but from that list I chose two of my smallest, regular-recurring clients and explained the situation to them. I gave them both names to other Virtual Assistants I knew were taking on new clients and offered the services they needed.

Despite the three clients I had identified I knew there was more work to be done and more hours I had to cut to regain some sense of balance in my life.

Part Three: A Painful (and Costly) Lesson Learned

Six days later (October 11, 2011) I was moving a card table and threw out my back. The pain literally brought me to my knees. During breaks in my crying I started making phone calls to various medical professionals. I knew it was severe and wasn’t going to be healed by merely “sleeping it off”.

I’ve since learned that the chronic hip pain I’ve had for three+ years has caused me to favor my right leg. That led to my hips being out of balance. Couple that with poor posture and my lower back was working overtime trying to compensate and make things right. The muscles weakened. I moved a table. The back decided it had “had enough”.  And I’m in tears, doing lamaze style breathing through the pain, against a wall frame because I’m afraid if I sit on the couch or lay on the bed I won’t be able to get up again.

Over the following seven weeks I had a total of five appointments per week with various medical professionals. Because I rarely, if ever, get sick I chose a high deductible health insurance plan.

How much did my lack of properly taking myself cost me? 

The Time Factor:

  • Weekly time spent at appointments and drive time: 7.5 hours per week x 7 weeks: Total of 52.5 hours
  • Other misc. doctor appointments: medical doctor for a referral, x-rays, etc: 6 hours
  • Total Lost Work Time: 58.5 hours
The Out of Pocket Factor:
  • Out of pocket paid to date: $2,859

**Note: I don’t even have all of the final doctor bills yet to fully calculate the actual out-of-pocket expenses as certainly my health insurance will determine I have more to pay!

Combine the lost work hours with my out-of-pocket and it’s a pretty staggering number.

Part Four: Moving Forward

Gifts w600 h900 300x225 When Chasing the Dollar Causes You to Spend MoreI am one of those “everything happens for a reason” types and I’ve spent a lot of time the past few weeks figuring out how I’m moving forward into 2012. I have lots of ideas, some which have been in the works for months now, some which will be discarded.

Year One was hard, really hard. Year Two was much better. Year Three has been fantastic. Year Four and onward will be better because I’m going to make better choices. The opportunities are there and referrals will keep coming.

Work-Life balance is probably elusive for most people, maybe even more so when you are self-employed. It’s not a destination. It’s a journey. And no journey is worth losing yourself to the point that you are entirely out of the game.

After all…what good would I be for any clients if I had to spend my days heavily medicated in bed?

What have I really learned the past three years? I’ve been given a gift. A gift of a second chance.

{ 16 comments }

Powerful Tips to make your Business Process More Profitable

by Michelle MangenSeptember 19, 2011 Guest Writers
This is a guest post from University Alliance on behalf of Villanova University’s online programs. Many business owners and entrepreneurs experiencing the excitement of company growth may also experience the frustrations that come along with growth, such as increased administrative tasks.  While it is important that these tasks be done properly, doing them yourself or [...]

Read the full article →

12 Essential Small Business Tools

by Michelle MangenJune 27, 2011 Productivity Tools
Ana Lucia Novak (@CyberDivaVA) had me as a guest this past Thursday on her OnlineSocialSmarts weekly show. The topic of the show was Small Business Time Management Tools. Not only do I love technology but I also love to figure out how to use that technology to make my life easier and / or more efficient, [...]

Read the full article →