Merge Excel and Word To Send Newsletters

Merge Excel and Word To Send Newsletters One of my favorite premium features in JibberJobber is the Get Contacts List page, which allows you to export your contacts from JibberJobber into various formats, including a .csv file (which opens in Excel).   This is what I use when I send my newsletter to bloggers, or to family/friends, etc. This allows you to slice and dice your data.   You can see a two minute video here. I asked my Twitter network how to merge a csv file and a Word document and my California buddy Walt Feigenson was kind enough to create a whole blog post out of it.   You can read his post, How to use Microsoft Excel and Word to send multiple emails, at the link. Why is this important?   Because it helps you send newsletter-like emails to your contacts.   This is HUGE and something I think every job seeker should do.   How? Read this post on newsletters for job seekers. Whats more, every PROFESSIONAL should do this, imho.   In The Google Story it talks about how the Google founders sent their friends and family newsletters announcing what they were doing, their projects, etc.   This was a personal newsletter. Whether you have the next google or not, you should reach out to your contacts with a newsletter. (thanks Walt, for the awesome post) Merge Excel and Word To Send Newsletters One of my favorite premium features in JibberJobber is the Get Contacts List page, which allows you to export your contacts from JibberJobber into various formats, including a .csv file (which opens in Excel).   This is what I use when I send my newsletter to bloggers, or to family/friends, etc. This allows you to slice and dice your data.   You can see a two minute video here. I asked my Twitter network how to merge a csv file and a Word document and my California buddy Walt Feigenson was kind enough to create a whole blog post out of it.   You can read his post, How to use Microsoft Excel and Word to send multiple emails, at the link. Why is this important?   Because it helps you send newsletter-like emails to your contacts.   This is HUGE and something I think every job seeker should do.   How? Read this post on newsletters for job seekers. Whats more, every PROFESSIONAL should do this, imho.   In The Google Story it talks about how the Google founders sent their friends and family newsletters announcing what they were doing, their projects, etc.   This was a personal newsletter. Whether you have the next google or not, you should reach out to your contacts with a newsletter. (thanks Walt, for the awesome post) Merge Excel and Word To Send Newsletters One of my favorite premium features in JibberJobber is the Get Contacts List page, which allows you to export your contacts from JibberJobber into various formats, including a .csv file (which opens in Excel).   This is what I use when I send my newsletter to bloggers, or to family/friends, etc. This allows you to slice and dice your data.   You can see a two minute video here. I asked my Twitter network how to merge a csv file and a Word document and my California buddy Walt Feigenson was kind enough to create a whole blog post out of it.   You can read his post, How to use Microsoft Excel and Word to send multiple emails, at the link. Why is this important?   Because it helps you send newsletter-like emails to your contacts.   This is HUGE and something I think every job seeker should do.   How? Read this post on newsletters for job seekers. Whats more, every PROFESSIONAL should do this, imho.   In The Google Story it talks about how the Google founders sent their friends and family newsletters announcing what they were doing, their projects, etc.   This was a personal newsletter. Whether you have the next google or not, you should reach out to your contacts with a newsletter. (thanks Walt, for the awesome post)

Inbox DETOX Clean for 2 Months!

Inbox DETOX Clean for 2 Months! Drugs?   No!   Booze?   No!   Im talking about SPAM!   January 1, 2013  I unsubscribed from every single daily email subscription and it has changed my life! What is life like without the daily emails, you wonder?   Here are the benefits after 2 months, SPAM-free: CLEAN!   After meditation and  a workout, I look at my email each morning and instead of 25+ emails, there are only 5-8 critical emails.   Its overwhelming to see  a big number of emails to attack first thing on a Monday.   Now I have a manageable number of emails to knock out, instead of deleting all the crap! LESS DISTRACTIONS!   Less www.Gilt.com  pop-up emails, more productivity.   Our brains switch gears too much when  daily subscription emails pop up  work to shopping, back to work, to restaraunt browing, making  it tough to focus on work after checking out the latest shoe sale on www.outnet.com.   No more! MORE $$$!    Its INSANE to realize how much we dont actually need.   These websites lure you in because they are time-sensitive and if you dont buy ASAP, its like you are missing out.   Wrong!   You have enough.   No emails = no extra spending on stuff you dont need. NO BOXES = no husband yelling at you, Another box from net-a-porter.com?   Seriously??   Sucka!   Thats right.   No more boxes unless its a super important purchase. I feel like I lost 5 lbs in my inbox.   Im clean and it feels so good!   I HIGHLY recommend an inbox detox ASAP. TELL ME:   Have you unsubscribed and noticed a big difference?   Are you distracted by emails popping up throughout the day unrelated to work?   Ready to Inbox Detox??   Tell me what you think!

Eleven things for students to do in London without going broke

Eleven things for students to do in London without going broke This post is a guest post by Sara McCallum.  She is the winner of no prizes or awards ever but has never really put the effort in, you know? So that’s fair enough.  Sara is currently writing a novel which is fairly standard behaviour for late twenties. Find her on Twitter (@sar_balls) or read her website (worth it!) Sara is also a friend. 1) First thing to do in London get a Cineworld cinema pass The first thing that I did when I moved to London was to get a Cineworld cinema pass. Ok, I also found employment and housing but definitely the next thing after that was the pass. If you like seeing the latest releases, then you will soon be shocked and appalled to find that London cinema tickets average between £11 and £15 a pop. The Cineworld pass gives you unlimited film watching privileges for just under £19 a month. It’s a 12-month contract but I’ve had it for almost two years now anyway. They also give you discounts on food and special film screenings. The best cinema in my opinion is the Haymarket Cineworld. It’s an old theatre which has retained much of it’s charm, and the main screen is massive enough that you are not crammed in trying to work out the subtext of the film whilst simultaneously arm wrestling the stranger next to you. The Shaftesbury Avenue/Trocadero cinema is also great in a kind of 90s way. It also screens more mainstream films, whereas Haymarket caters more to the indie contingent. The Chelsea and Wood Green Cineworlds are great if you live locally to them also. 2)  Hampstead Heath I don’t even feel like this one needs any explanation, but I spent the entirety of my summer in Hampstead Heath last year and it’s fair to say it stole my heart. It is one of the most beautiful places in the world (actual fact) and it is absolutely free. Go. Walk. Swim in the ponds. Have a subconscious lingering surprise that you are in fact in Central London as the mass of green surrounds you. Also if you want an alternative New Years Eve, climb up there just before midnight and as the mud seeps in to your ill-chosen shoes watch the fireworks jumping out of London Bridge and in to the New Year. 3) NUS Extra card If you haven’t already, definitely get one of these. It gives you discounts off places to eat, but for a change it’s actually the places you want to go to. Like Giraffe. And Pizza Express. 4) The Friendly Society in Soho This is a great little gay bar (I bet you’re singing gay bar in your head now, right?) buried underneath Ann Summers in Soho. I can only assume the reason that it is less well known is that it is so tucked away. It’s one of my favourite bars in London, and whilst drinks average about £7 for a spirit and mixer, the atmosphere more than makes up for the wallet damage. The design is incredibly eclectic don’t be too unnerved by the Barbie dolls that hang from the ceiling. The blue lighting makes you feel like you’re somehow in the Wes Anderson film The Life Aquatic. The music is pitch perfect, and the booths are great to pile in to on a Saturday night. Also, it’s great for an early week drink when it’s less busy. 5). New Bloomsbury Set If you fancy something a bit less expensive and altogether more quiet, check out the New Bloomsbury Set in … Bloomsbury. It’s a small basement bar that does great deals on drinks (especially for somewhere so central) and has lovely little covens, which you can hide in after a long day studying (or whatever it is students do these days). It also has big Sherlock Holmes-esque chairs where you can sit, miming a pipe perhaps, and talking in riddles (if you so desire). 6) If you fancy venturing to Quite North London The O’Neill’s pub in Muswell Hill is definitely worth a visit. A beautiful church that has been converted in to a drinking establishment, the architecture takes your breath away as soon as you walk through the door. Ignore your preconceptions about O’Neill’s and enjoy the cheapest drinks in London whilst sitting on a pew. Take the 134 bus from Tottenham Court Road or the 43 from London Bridge, and sit on the top deck so you can see the Shard as you pass under Archway Bridge. 7) Whilst karaoke is usually the type of activity that brings me out in hives, I recently discovered Lucky Voice in Angel. You get a great private booth in which to sing, rap (I genuinely thought I was Eminem for a moment whilst reciting ‘Lose Yourself’), and drink 2-4-1 cocktails. If you book early it costs as little as £4 an hour, which given the comedic memories created is great value for money. 8)  Southbank was my second favourite place of last summer and in particular the Southbank Centre. There’s so much space there to sit and study (read: Facebook/Twitter/Instagram) and with free wifi and general cultural greatness in your surroundings, there’s really no reason not to exploit this undervalued resource. 9) I’m still not entirely convinced about the under-25’s drinking coffee, but if you are so inclined, then grab a (free) Waitrose card, which entitles you to free coffee every day. The espresso will particularly help when you’re trying to convince yourself that your essay is ‘totally do-able’ in less than 2 hours. 10)  Byron Recently had some bad press when the Chancellor of the Exchequer tweeted a picture of himself eating one of their burgers. However don’t let that put you off; politicians do have to grab a bite to eat as they destroy society. Byron, and I can say this with some level of confidence given the level of research I have conducted, offers the best burgers in London. Top tip: order them cooked medium (this is the standard way they cook the burgers), order them well done or rare and you just won’t get the proper Byron experience. Also check out their coke floats for some classic 90s nostalgia, and their wine list which is categorised as ‘good’, ‘better’, ‘great’, and ‘best’. They have several restaurants across London, each with their own design. If you fancy ‘dilapidated hipster style’ check out the Islington branch, and if you want ‘shiny and new with high ceilings’, head to Shaftesbury Avenue. 11) UCL Main Library If you are a student at UCL you will have already discovered (hopefully) the amazing UCL main library in the Wilkins Building. If you are a student at another university, you can see details of how to join the library here: http://www.ucl.ac.uk/library/joining.shtml. The library itself is just stunning, and you feel like you are in a film (in fact, the library does feature in several films!). Get there early on the weekend to get the best spots (I recommend the law room). Comment or share below if you have any other to add to the list. 2

When To Channel Your Inner Entrepreneur

When To Channel Your Inner Entrepreneur You’re sitting in your chair at work, the same place you’ve worked for years and random thoughts suddenly race across your brain. Things like, “Could I do more? Could I make more? Do I need a boss or could I be that boss?” And those thoughts energize you rather than scare you. If it’s a one-time occurrence and you’re too young to be having a mid-life crisis, you may just be having a bad day. Or week. But what if similar thoughts repeatedly enter your consciousness? And they’re all pointing you in one direction? It may mean you’re thinking about breaking out on your own, starting a business and making money your way. If so, it’s time to release your inner entrepreneur and embrace the inevitable. While there often isn’t a specific date on the calendar for making the big leap, there are clues to look out for that can propel you into that next phase of your career. 10,000 hours and you’re an expert That’s five years, give or take, of honing your craft full time. From where you sit that may feel like an eternity, or it already has breezed by. It varies by industry, I’m guessing, but there will come a moment when instead of asking questions about your job, you are the one giving the answers. The job, while still enjoyable, isn’t feeding the side of you that longs for a challenge or to have your contributions be better utilized. What you considered awesome when you were just beginning your career, just doesn’t fulfill you now. When it feels like the trials of yesterday are now the navigable twists and turns of today (NBD), the idea of creating your own business from scratch begins to sound less daunting. You’ve become an expert in your field, now it’s time to share that knowledge with the world. Doing the Math Maybe it begins with a client asking for your work specifically, or another business asking for your work when you have the time. It could even be that now you are finishing your to-do list in half the time, but still expected to work 8 hours (who cooked this up as the length of an American workday, anyway?), and the inefficiency is killing you. Regardless, you’re starting to realize your value. After running the numbers between startup costs, new work hours required and the time you would have to invest, you realize that you can make more money in less time and all of a sudden dollar signs begin to dance between your eyes. Not to mention, your time could become yours again, and who doesn’t love a little flexibility? The Big Bang Science teaches us that life was created in one explosive moment, and in certain instances, so can our futures. Often all it takes is a single trigger for us to question everything and say, “What am I waiting for?” This could be that “aha” moment you’ve been waiting for. A little push can lead to great things and could be the start of the road to your new business. Listening to our gut is something we were taught growing up. Listening now is probably a good idea. Taking the Leap The pros and the cons have been weighed, math figured out and the urge is strong, but something is still holding you back. This could mean that maybe you aren’t ready to start your entrepreneur’s journey, but the hardest part of any change is embracing it. Starting a business is never easy, but even if there’s a tinge of possible regret, the answer is a simple one. As wildly successful serial entrepreneur Farrah Gray says, “Build your own dreams or someone else will hire you to build theirs.” Hint: If this quote resonates with you, it’s just another clue that the time is now. This guest post was authored by Michelle Olson, Fingerpaint Marketing. As a child, Michelle wasn’t afraid to get her hands dirty. She never asked for dolls, dresses or frilly things. She wanted cars, trucks and bikes and she still loves anything on wheels. She’s a mover and a shaker who fast became one of the Southwest’s most successful public relations professionals, building a public relations firms recognized throughout Arizona for client work and workplace morale. Although her career began in Minneapolis, Michelle has lived in Arizona for 23 years and has built strong relationships with business leaders, government staff and officials, and print and broadcast media throughout the state. She is a past president of the Phoenix Chapter of the Public Relations Society of America (PRSA), holds the Accredited in Public Relations (APR) designation and is a past chair of Counselors Academy, a 400-member special section within PRSA for public relations firm owners and leaders. Michelle is an active member of the National Association of Real Estate Editors (NAREE), the Urban Land Institute (ULI), and the Scottsdale Convention and Visitors Bureau. In 2003, Michelle was recognized by the Phoenix Chapter of PRSA with the prestigious Percy Award for her achievements in the public relations industry. Michelle says she’d ride her bike around the world if she could. There’s a part of us that thinks she just might find a way. . Image credit.

A Day in The Life of A SEO Specialist

A Day in The Life of A SEO Specialist SEO professionals are responsible for the mammoth task of ensuring a raging organic search visibility, amidst a fast changing environment. They must remain abreast of the latest developments in the field and continuously learn new things; meaning that there is virtually no margin for a drop in attention.On a daily basis, SEO professionals have to engage in a plethora of activities including, but not limited to, consultation, audits, competitor analysis, industry research, keyword research, inter-departmental coordination, report generation and networking.evalSo, how can you ensure the provision of value added services to your employer as well as your client’s websiteMake use of free tools, such as Xenu, that check all external website links and generate status reports in a matter of minutes. With time consuming link tests out of the way, you can put all your energy in fixing or removing damaged links.3. Continuous learningContinuous learning is an integral part of an SEO expert’s job, owing to a rapidly changing industry. With every passing minute, new techniques and tools surface. Therefore, SEO professionals can only add value, if they remain up-to-date with these developments. SEO experts have to examine various blogs and read up about algorithm changes as well as employ new SEO techniques on a daily basis.This can be difficult to manage in a hectic routine, so we recommend the use of tools like Pocket, which allow you to save articles, videos, etc. in one place that you can read when you’re free.4. Community interactions and networkingTo make their mark in the fiercely competitive internet marketing industry, both self-employed and agency-employed SEO professionals have to maintain a strong web-presence. This allows them to learn about recent developments in the industry, develop strong reputations, acquire new business and add credible backlinks.evalSEO specialists tend to post regularly on community platforms. So they need to frequently switch user accounts. Doing so multiple times a day can be tedious, so opt for Quick Login which will enable you to switch between up to 10 Google accounts with ease. It will also save you the trouble of recalling passwords.5. Keyword research and analysisKeyword research and analysis is one of the most significant responsibilities of an SEO professional, as it allows him to reach out to customers, increase search engine rankings and learn more about his target audience. It also enables a professional to anticipate shifts in demand, adapt to evolving market conditions and produce offerings that his customers desire.However, keyword research and analysis can be both boring and time consuming. To tackle this, we recommend the use of tools that will speed up the entire process by providing you with lists of high ranking keywords suggestions, tracking their performance, analyzing competitors etc.Some popular tools for keyword search and analysis include Advanced Web Ranking, Affilorama, Wordstream, Übersuggest, Ultimate Keyword Hunter and Wordze.Accurately gauging the efficiency of your efforts can allow you to focus on tactics that produce results and improve upon those that need modification. This can be done with the help of keyword research metrics such as average monthly search volume, search volume changes over time, suggested bid prices, etc.6. Content strategy and ideationAs part of a content strategy, the job of an SEO expert entails determining the purpose of the website’s content and how it will be compiled, managed and updated. They also have to identify relevant topics for their client’s content.Here are some tips on making your content generation and ideation efforts more productive:A) MetricsIn order to ensure that the content being created by you and your team is up to the mark, be sure to use the following metrics:Sharing metrics which indicate the number of times your content has been shared on social media platforms.Consumption metrics which indicate s tatistics like page views, visits, downloads etc.Lead generation metrics which calculate the rate at which your visitors opt-in for subscription lists, requesting quotes or submit forms.Sales metrics which indicate the frequency of leads turning into sales.B)Ideation toolsevalUse content ideation tools such as Evernote, Jump Start and Scoop.it that will both support and catalyze your ideation process.C) Minimalist word processor appsBoth ideation and content generation demand tremendous focus which can be difficult to maintain with new notifications popping up every minute. In such an instance, using minimalist word processors like WriteMonkey or Typed can be a huge blessing as they provide full-screen and distraction free writing platforms. These tools increase the quality of your work and reduce the overall time spent.D) Block unwanted websitesevalTechnical and creative aspects of SEO require undivided attention. However, SEO professionals often find themselves distracted by certa in websites which may be important otherwise but can also inhibit creativity. So, we recommend the use of browser extensions like Stayfocused that will allow you to blacklist websites that you know will reduce your productivity.7. Content PromotionSEO professionals often need to seek publicity for their client’s web-content, not to mention, to develop their own brand. To do so, they utilize paid, earned and owned coverage all aimed at receiving a healthy amount of traffic.You can boost your productivity by using social media management tools like Sensible that will allow you to quickly share your content with a wide array of social networks. BuzzBundle is also recommended as it is extremely effective in promoting content and establishing web-presence at the same time.8. Report generationSEO experts are required to make analytical reports using Microsoft Excel and PowerPoint. Therefore, you can increase your productivity by learning useful shortcuts for common functions that will a llow you to save a tremendous amount of time.In this article, we have shared what a typical day for a SEO Specialist might look like. As a bonus, we have also added productivity hacks for SEO Specialists to accomplish a whole lot more each day.

Switching Career Paths - How To Make An Informed Decision

Switching Career Paths - How To Make An Informed Decision Switching career path is nothing if not exciting. This can also come with a great degree of worry too. For people who are used to switching from job to job this can be an easy decision, but making the leap when you’re already decades into a certain field can feel quite overwhelming. Bringing up your anchor after such a long time can feel destabilizing to anyone, but thankfully in today’s modern markets, working hard can lend you every chance of success. However, switching career paths without a plan in advance can be an exercise in silliness. While you may wish to tear down everything your previous career had in mind, you may be best suited to the following options, potentially scoring a higher pay grade, or most importantly something you are happier doing: Consider Retaining Your Skills It might be that your skills could also be well utilized in another field, perhaps part of a field you weren’t expecting. For example, if you have excellent project management skills, who’s to say you wouldn’t make an excellent assistant producer for a movie studio near you? If you have excellent set dressing skills for movies, who’s to say you couldn’t be well-utilized designing showrooms for high-end furnishing stores? Switching up your career is never a negatively informed choice, so long as you understand that your skills can and will often transition to aid you in a new field. This can help you get the head start you’re looking for, prevent the initial awkwardness of slow training, and help you begin to build specialist competencies in your new environment. Utilizing your set skills can also help you develop into specialisms that you may not have expected. For example, you may use your experience as a chef in order to become a health and safety kitchen inspector in the conglomerate you work for, identifying hygiene issues in kitchens around the world. You may decide to use your highly polished skills in a technological field, undergo technical recruiting training, and begin to fill the most essential vacancies in fortune 500 tech firms around the world. Your skills are never fixed, they are malleable, and with a little creative thinking you may find this out yourself. Learn How To Network Learning how to network is an essential part of switching careers. Without forging connections, none of us will make it to the higher echelons of our career. However, when moving to a new industry, we often lose the previous connections we have made. Or do we? Using to utilize connections we have already built to potentially give us an in into other fields is a smart move, as is attending working event, ensuring you put your name out there via volunteer projects at your new employer, or potentially bringing the trade secrets from one industry into another, helping you raise your profile in that business. When you learn how to network, you learn how to continually refine yourself and your personal brand. With these tips and the willingness to absorb the new career path you choose, you are sure to enjoy a lucrative second path.

How to Write a Respiratory Therapist Resume Cover Letter

How to Write a Respiratory Therapist Resume Cover LetterRespiratory therapist resume cover letters are a must if you want to land that dream job. This profession does not have the best reputation among the medical staff, however it is one of the most in-demand professions today. The reason why there is such a high demand for this field is because of the huge number of people who suffer from respiratory diseases and those who work with them each day.Most of the respiratory therapists today have a background in clinical practice, having gone through courses and training in order to be hired by the clinics. Not all of them are going to earn a living from their work, however. Many of them have become skilled workers in other fields. The most important thing about your Respiratory Therapy Resume cover letter is that it will give your potential employer enough information to decide whether or not you are the right candidate for the job.Doctors of all kinds and all types of schools are eage r to hire respiratory therapists. A common question is, 'How many respiratory therapists do you need?' The answer is not only the answer to this question, but the answer to many more as well.Different jobs require different skills. Since most job descriptions require a certification, it would be wise to focus on this area as well. After all, a job description that requires a certification could be cut short if you have acquired a degree.The next important thing to focus on is your work experience. You need to prove to your potential employer that you have an outstanding track record in working with patients. You should be able to provide evidence of your work ethic as well as your dedication to patients.Most Respiratory Therapists do not become self-employed until they retire. You can use the Respiratory Therapy Resume cover letter to mention what you have accomplished in the past. It is an opportunity to give your prospective employer a glimpse into your character.When it comes to your academic qualifications, Respiratory Therapists usually take a particular course. This may include the BSN program, but it may also be something as simple as chemistry or biology. Just make sure you are writing this type of letter for a major employer.The main goal when it comes to writing a Respiratory Therapy Resume cover letter is to convince a potential employer that you are an ideal candidate for their health care facilities. You need to convince them that you are a stable person, someone who is dedicated to the job. Do not forget to include the specializations that you have, and you should have a good chance of getting that job offer.