Indulge yourself in the no-nonsense ramblings of Sharon Hayes-Tucci, Internet Entrepreneur.
Friday, May 29, 2009
Friday Twitter Funnies
Saturday, May 23, 2009
Twitter Tips
Friday, May 22, 2009
Excel problem
Column B contains a value relating to each data string
Column E contains if statement to compare one row against another like this:
=IF(A3614=A3613,"STOP","")
What I need to do is in column E have a formula that returns another
STOP *if* column E contains STOP and column B is not equal to D
My brain is so dead - this should be simple and I'm just not getting it.
I realize there is deduping in Excel 2007 but the client wants the
data in this specific format.
Answer: =IF(E8="STOP",IF(B8<>"D","STOP",""),"")
Thanks to @mrrichardson for helping me out!
Wednesday, May 20, 2009
How to Get What You Want as an Entrepreneur
Over the past 20 years, I have had the chance to have a glimpse at the inner workings of literally tens of thousands of businesses – ranging from one-person shows to many of the world’s largest companies. I’ve also built several successful businesses of my own – both online and offline. I don’t have all of the answers to what makes one business succeed while another fails. However, I do believe that the insight I have goes beyond what you could find in any single book, course or even a full business school program.
In June, I’ll be rolling out a coaching program geared to small business owners and start-ups. This will be the first time I’ve done something like this. I’m not doing it for the money. I can make money more easily doing other things. The last thing I want at this stage of my life is to have more work. I am just feeling frustrated with the preponderance of misinformation when it comes to doing business online. I know there are a lot of good, decent people out there that genuinely want to create a business of substance. I feel confident I can provide the keys to unlock the magic kingdom for these people. The focus will be on becoming a true entrepreneur as opposed to being merely a self-employed technician or professional.
Before the program is launched, I’ll be sharing some general thoughts via my blog and eventually through the program’s website. This will give people who may be interested in the program a better idea of what they can expect if they choose to participate. Unlike the actual program, the content won't be provided in any particular order; i.e. you can expect me to jump around a lot. :)
Friday, May 15, 2009
FollowFriday Rockstars May 15, 2009
Each week I try and share with everyone some people on Twitter I think are worth following & getting to know better. I am doing it this way because I think that a simple 140 character recommendation isn't enough. Like many others that use Twitter, I believe in quality over quantity. I hope that some quality contacts come from this. That you personally can find one or more people from this list that you can also become friends with, network with & maybe get to know a little bit better.
HalSparks - For my first time, I'm actually including a real life celebrity - and with good reason. I've known of Hal Sparks since his stint on E!'s Talk Soup. Since then, he's been a host for a number of different entertainment shows, played one of the main characters on "Queer as Folk," been in a rock band (and is a surprisingly great singer), done stand-up comedy and is now pretty active on Twitter. I've been following Hal for a while now. I think he's setting a great example of how a "personality" can use Twitter effectively and can communicate with their fan base. He actually does interact with people, DM's with those he follows back and "gets" it.
TPR2 - Terry is a genuine sweetie. Although a serious business man (more on that in a bit), like me, he believes that the best reward we can get is by bringing a bit of sunshine to other people's days. He's taken it a step further by starting MyHugClub. Terry's a feel good person that you can't help but like. He hails from New Zealand and has homes in 3 cities. Terry owns 2 Real Estate Agencies, 2 Mortgage Broking Firms, 2 insurance agencies and 2 Financial Planning Practices. He also builds homes for people as well. Lately he's been making the transition to web geek. Terry's a doting dad to two boys who he loves to bits: Alex who is 6 months old and Bailey (featured in his avatar) is 4 years old. If you want to network with a sharp man that is compassionate, look no further.
Of course, you're more than welcome to follow me too :) I tweet a lot. I try to interact with followers to the extent I can. I spin tunes at Blip.fm. I share links I think are interesting. I'm a news junkie, voracious consumer of information - much of it useless but that which amuses me in some way.
For information on what #followfriday is, you can read here.
For information on why I do this weekly list, you can read here
Thursday, May 07, 2009
How to Share Music With Blip.fm
- Use the same user name that you use on Twitter. This will help you to avoid confusing people like me :)
- When I joined, it made suggestions of recommended DJ's to listen to (Blip's equivalent of "following"). I ended up removing them within a few days since I found their tastes to be very different from my own. I prefer adding DJ's as I come across them.
- To link to your Twitter account, you can go to "services". Although all songs you blip will be broadcast on blip.fm, you do have the ability to turn broadcasting to your Twitter stream on and off.
- You can add a profile pic/avatar like you can on Twitter. The size requirements are a bit larger than what they are on Twitter. A friend added a border to my Twitter avatar so that I could use the same one on Blip.
- Go through all of the tabs under "settings" so that you can decide whether to receive email notices, add your location, add your URL, etc.
- If you opt to receive email notices (like I do), I suggest setting up an email filter in your email program so that the emails will go to a folder. I have my blip emails go to a Gmail account with the following filter: from:(noreply@blip.fm) Skip Inbox, Apply label "* Blip".
- Your blip home page is located at http://blip.fm/username - for example mine is http://blip.fm/sharonhayes
- You can see in your stream either all blips (all DJ's) or just your favorites.
- To add someone as a favorite DJ, just click on the "listen to" button where their avatar is.
- There is a bookmark & share icon in each blip box to use across many different social networks.
- You can delete your own blips & remove blips from your playlist by clicked on the X (delete blip). I suggest doing this when you are aware that a song is no longer available.
- Song availability & quality varies. Please make sure to test a bit of a song (using preview or play button) before blipping. You'll also find that many songs end prematurely. Some songs are also incorrectly labelled. There are a lot of covers that are labelled as if they are the original song.
- There's a neat software tool called Blipster that makes blipping loads easier. It allows you to queue up a number of blips at one time. You can see length of songs and the file type so you'll have less chance of errors.
- You can embed blips into web pages.
- Blips can also be broadcast to FriendFeed & other services. You can set this up by going to Settings -->> Services.
Friday, May 01, 2009
FollowFriday Rockstars May 1, 2009
Each week I try and share with everyone some people on Twitter I think are worth following & getting to know better. I am doing it this way because I think that a simple 140 character recommendation isn't enough. Like many others that use Twitter, I believe in quality over quantity. I hope that some quality contacts come from this. That you personally can find one or more people from this list that you can also become friends with, network with & maybe get to know a little bit better.
JoshuaDenney - Of everyone I'm including today, I'm struggling the most on what to say about Josh. If you already follow him and/or know him at all, you'd understand why I say this. Josh has a great sense of humor, enjoys a wide variety of music and has a brilliant mind. He makes music, has worked as a talent agent and now does kick ass web design and strategy. He's a fellow #nightowl and currently lives in Nova Scotia. To me, Josh is simply Superman. :) Follow him & you'll see why I recommend him.
BradGal - Ingrid is not only simply stunning but a wonderfully sweet woman. She tweets a lot (much retweets of interesting things she comes across) but also a good deal of conversation too. Professionally, Ingrid is an electrical engineer. She lives in WV. She loves cats & dogs, computers, entertainment, high tech, iPhone and poker. Ingrid's also a huge Brad Garrett fan :)
RoseHwang - Rose is like a rainbow in Twitterville to me. I love people who are genuinely about giving and making others smile. This is Rose to a tee. Rose is in Taiwan but wherever you are in the world, she will succeed at making you smile with something she says. She's just really good people and any words cannot do justice to the joy she brings to others. Rose works in International trading, Graphic Design, Fashion Design, Events and she is also working on Social Enterprise.
Reddsmitty - Kim is someone I'm just getting to know myself. Most of our exchanges have come about so far because of music. She's a very friendly woman with a mahvelous sense of humor.Kim is a sales & marketing diva with 10+ years experience helping businesses grow through better understanding of their customers, their brand, and their locations. Kim has experience helping businesses market more effectively across every channel (including social media!). Mom to three boys 4 and under this road warrior keeps a very busy schedule and still manages to blip, blog, and tweet. I'm not sure how she manages to do it all and keep those of us that follow her smiling :)
There are many other people I wanted to include on this list. But there's always next #FollowFriday for that :)
Of course, you're more than welcome to follow me too :) I tweet a lot. I try to interact with followers to the extent I can. I spin tunes at Blip.fm. I share links I think are interesting. I'm a news junkie, voracious consumer of information - much of it useless but that which amuses me in some way.
For information on what #followfriday is, you can read here.
For information on why I do this weekly list, you can read here