Indulge yourself in the no-nonsense ramblings of Sharon Hayes-Tucci, Internet Entrepreneur.
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
Friday, April 17, 2009
FollowFriday Rockstars
Last week, I introduced you to a dozen amazing women. This week I want to share with you an assortment of men from around the globe & with different interests and tweeting styles. Each of these men is truly unique. Hopefully after you read what I have to say about each of them, you'll find yourself wanting to follow some or all of them yourself.
Minervity - For the ladies reading this, the first thing you'll notice is Richard's avatar is simply hot. ;) For many of you, that many not be enough reason to follow him. Richard is simply one extremely cool guy & one of the nicest people you can come across on Twitter. He's one of a handful of people I check their tweets daily. Richard tweets on a variety of subjects. One of my favorite recent ones was a nice article on how to work through exhaustion - something many of us could use help with from time to time. Richard has a varied creative background. He started out a songwriter/producer when he was 12 & signed to Sony Music (he still writes & produces music for artists such as American Idol, Swedish, German Idol & Lutricia McNeal). To date, Richard has sold about 10 million albums. Over the past decade, Richard has been working as a graphic/logo/icon designer. He also programs & works with 3D, flash and database development.
IAmKhayyam - Khayyam is one interesting dude. The tweeting side of him is just one aspect of this really super guy I am proud to call my friend. This guy is truly a renaissance man. His wisdom spans across pretty much everything and he's quite phenomenal at all of them. There's something about him that just makes you want to connect with him. He has an amazing energy that you want to be a part of and witness. You know - the old soul in a young body feel? That's him. A connoisseur of all things fine, it trickles nicely over to his design work. He's a print and identity designer that will get you noticed. But to call him just a designer is limiting. The side projects that he's working on will be definitely something to watch out for. He's an idea man. A thinker. Someone who will challenge you in ways you never thought of.
BuySellDomains - John is an incredible sweetie. Someone I had come across before Twitter but has gradually becoming a friend. He really makes an effort to support his friends - which is an admirable quality in anyone. John does web site design and is gradually making his mark in the domain industry. He's interested in health issues & natural stuff. He also is an animal lover and proudly owned by one little kitty.
Arodomus - Arod may seem like a strange choice to include if you look at his stream. (If you are easily offended you may want to avoid his stream.) He's one of the early people I connected with on Twitter. He's a normal guy with a heart of gold that shares his day to day life in his tweets as opposed to someone that interacts. He's just someone I find myself wanting to cheer on as he gets himself back in shape & celebrates life every day. If you follow him, you can't help but start to find yourself cheering him on.
AndySowards - Andy is a doting dad to 3 beautiful kids, a loving husband to his wife, a great friend that you can rely on and a simply mahvelous tweeter. He’s a freelance web designer and the selfless provider of the Web Development Nerdy Daily Links; a huge collection of links, tips, resources, tutorials and inspiration that he collects and shares with web designers the world over, every day. Andy produces extremely high quality custom Web 2.0 sites, Web Applications, e-Commerce Solutions & Wordpress blogs. He's done work for my businesses & clients - top notch job. One client was so thrilled, he even wrote a birthday song when Andy finished up a job on his birthday :)
BrianCray - Brian is a super dooper all around nice guy. Someone I'm just starting to get to know. Brian is a web ninja with a mix of marketing and web development knowledge that will karate chop straight through 5 thick cardboard boxes. He uses his knowledge to help businesses with everything web 2.0. He is the guy behind Nearbytweets.com and pxtoem.com. Brian is working on a book that is due out later this year - something I can't wait to read & tweet about myself!
TonyBlakeLive - Tony's tweets can be a little out there at times. He has a wicked sense of humor. Tony was a friend well before Twitter. We reconnected after I found him on Twitter. What can I say about Tony? He is one of the original Internet gurus while avoiding the guru type mentality. He combines his expertise with mentalism with some kick-ass marketing expertise to be top notch. Beneath the tough outer shell, Tony is a real sweet, stand-up guy who is loyal to his friends and always willing to go the extra distance.
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
Thursday, April 16, 2009
10 Things I Love About Twitter
Friday, April 10, 2009
FollowFriday Rockstars
Why I'm Changing How I Do #FollowFriday
Tuesday, March 31, 2009
Useful Links to Twitter Statistics
Today we have a guest post by Kirsty Wilson of http://www.interimbusiness.com.au/
You can also follow me on Twitter here.
Twitter is all about building connections with like-minded people and the focus is more about the individual rather than the business. However, it seems to be a fairly organic process that just naturally directs visitors to your website that are curious about the business behind the avatar and the personality.
In my short time tweeting I have discovered and utilise a number of links to review various statistics about my tweeting time; the ‘Followers’ I have attracted and the individuals I am ‘Following’. Here are some of my favourites and the information they provide:
http://tweetstats.com/ Displays your tweeting in a number of graph forms – a tweeting timeline can be viewed (since you commenced); your tweet density (days/time); Aggregate daily and hourly tweets; the top 10 Tweeters you reply to and the various interfaces you may use to Tweet.
http://twittercounter.com/ Displays much the same data as Tweetstats but also makes available the number of new Followers added in a day and the average growth per day. It will also make a prediction of how many Followers you will have the following day.
http://twitter.grader.com/ Displays where you are ranked out of all Twitter users world wide. (When writing this the total was 1,823,407). A ‘Tweet Cloud’ is also present. A ‘Tweet Cloud’ for those that do not know, is a list of dominant feature words you have used in your posts. It will also present you with a grade out of 100 and lists a number of ‘Suggested Folks to Follow’.
http://twitterholic.com/ Displays your ranking by Followers and then your ranking for your location. You can see where other local Tweeters fall within the rank.
http://mytweetcloud.com/ Displays all dominant #hashtags used during your posts. By adding a hashtag to any word or phrase, will allow real time tracking. For example some that I use frequently include #followfriday #travel #business #virtualassistant and you can search for other Tweeters that are tweeting the same topics. It’s a great way to find new Followers and make connections. Note: this site appears to be currently down.
http://twitter-friends.com/ Displays your relevant network and some stats about your tweeting behaviour compared to other Twitter users. It provides a list of the top 10 people you reply to and the top 10 people that reply to you. It clearly defines who is part of the ‘gang’!
http://www.twitalyzer.com/ Displays your activity in percentages over 5 categories, being - influence, signal, generosity, velocity, clout (How this is measured and the definition of each can be seen in detail visiting the above mentioned site)
http://twitterratio.com/ Displays the Twitter Ratio and is the ratio of your followers to friends (or people who you follow). It is measured with the TFF Ratio (Twitter Follower-Friend Ratio). The higher the ratio, the more Twitter heat you pack.
http://happytweets.com/ Displays a happiness score and a short description as to your happiness or maybe, unhappiness! Generally, a Tweeter with a score of 700 plus are the happiest Tweeters and the least happy, will display a score of 100 or below. My score for some time has hovered around 560 ‘Ridiculously Happy’!
Lastly, I wanted to share the fact that I analyse my own Website statistics and during the 3 months I have been involved with Twitter, the traffic to my website has almost doubled. The pages that were once viewed the most (Home & About Us) has had a huge shift to the ‘Services’ page being viewed significantly more than it ever has during the past 3.5 years and there has been a large increase in the number of visitors ‘saving to favourites’. “Social Media is truly awesome!”
About Kirsty
Kirsty Wilson, established Interim Business Solutions in 2005 when a need was recognised that small businesses and professionals were wishing to access virtual, temporary or ongoing administration support that allowed them to develop a close working relationship with the one service provider, without having to go down the path of employing some one. With more than 18 years experience across all areas of Business Administration, Kirsty believes she is extremely well equipped to deliver high level support offering a range of services. You can follow/thank Kirsty for this great list on Twitter here.