Monthly Archives: August 2013

Small business chat – Sarah Goode

mugs Welcome to Saturday Small Business Chat! I don’t feature so many new people now, as we have updates from our on-going interviewees running solidly throughout the year, but I couldn’t resist featuring Sarah Goode, aka Pookledo, who makes lovely handmade jewellery using semi precious gems and recycled vintage materials. I’ve known Sarah for years via our mutual hobby of BookCrossing, and in all that time, she’s always been making things, whether that’s clothes or jewellery. She’s doing the day job / self-employment dual career thing at the moment but recently reached a very exciting stage with her business when her offer was accepted on a shop in Loughborough. Sarah’s unusual out of all of my interviewees in having got a day job specifically to help and support her self-employment – an interesting thing to consider for many, I’m sure. Let’s see what’s happened so far …

What’s your business called? When did you set it up?

My business is called Pookledo. This incarnation was set up in 2009, but I’d previously been self-employed a few years earlier.

What made you decide to set up your own business?

I love making things and there is only so much I can make and give away to friends or swap!

What made you decide to go into this particular business area?

I’ve always liked jewellery and accessories as they are very universal items. I’ve always been plus sized and  with jewellery it doesn’t really matter what dress size you are or age you are, you can always browse jewellery without getting down about your size or shape.

Had you run your own business before?

Yes. I paid my way through college and university by making hand-made cards and selling them at craft fairs. After I finished my degree, I designed and made plus sized gothic clothes which was very rewarding for a while.

How did you do it? Did you launch full-time, start off with a part-time or full-time job to keep you going … ?

I’m still working my full-time job as well as my self-employed work, but it’s getting to the point where there don’t seem to be enough hours in the day after I’ve finished my full time job to do everything I need to do for my self-employed business.

What do you wish someone had told you before you started?

Keep going. You might think it’s too difficult, and some say it is very hard, but the emotional rewards that come from working for yourself are great.

What would you go back and tell your newly entrepreneurial self?

To just get on with it. I need to keep telling myself that now too. Have confidence in what you make and keep pushing.

What do you wish you’d done differently?

Not much really apart from maybe pushing myself a little harder a long time ago but I guess that confidence has come with age

What are you glad you did?

Found a full-time job in a bead warehouse! I’ve learnt so much about beading and the jewellery industry working there that it has helped me so much in my self-employment.

What’s your top business tip?

If something isn’t working for you, do some research and change things for the better.

How has it gone since you started? Have you grown, diversified or stayed the same?

For a long time I was unprofitable but over time I researched different ways to improve what I was doing and gradually I’ve been more successful

Where do you see yourself and your business in a year’s time?

We’ve put in an offer for a small shop so, all being well, in a year’s time I’ll be working full time for myself.

Doing something she loves and does well – check. Experience behind her – check. Committed to researching what can be improved – check. Tenacious – check. Finding it hard to squeeze in a day job and business stuff – check. I think it’s time for that leap of faith – and I really look forward to interviewing Sarah in a year’s time to find out how it’s all going! And here’s her 2014 interview!

Visit for all the news and products, visit the Etsy shop, drop by and visit her Facebook page, read Sarah’s blog – and email her if you’d like to get in touch.

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my new books.


Posted by on August 31, 2013 in Business, Small Business Chat


Tags: ,

How do I print out table headings at the top of every page in Excel?

I recently wrote about retaining your headers across multiple pages in a Word document. This post will tell you how to make your header rows (or columns) in Excel 2007 and Excel 2010 print on multiple pages when you print them out.

What is the header row in Excel?

The header row is the row in a spreadsheet that contains the headings for all of the columns in your spreadsheet. It’s usually Row 1, or maybe a few rows at the top of the spreadsheet.

(If your columns have headings in Column A instead or as well as your rows, you can use all of the stages in this post but choosing the columns option where appropriate, or both.)

1 spreadsheet

Why would I want my header rows to print out on multiple pages?

If you’ve got a complicated spreadsheet that you want to print out in a report, as a handout, or as a pdf, it’s useful to have the header row show on every page. When you’re using Excel itself, you can freeze the rows and/or columns so you can see them as you scroll down. But this doesn’t carry over to the printout.

How do I check if my header row will be printed on every page?

To check what the printout will look like, you need to change from the standard Normal view of your document (see the first image in this post) to the Page Layout view.

To do this, choose the View tab, then the Workbook Views section and press the Page Layout button. Your view will change to what the document will look like on the page (this is also where you add headers and footers to an Excel document – more on that another time)

1 view menu

If we scroll down to the second page of our document in this view, we can see that the second page just starts with the next line of the spreadsheet – not very useful if you want to be able to see the headings at the top of each page:

2 no headers

How do I make the heading row print at the top of every page?

Staying in the Print Layout view, choose the Page Layout tab and look at the Page Setup section. In the bottom right corner, you’ll find a little arrow. Click on the arrow to access the Page Setup menu:

3 page layout menu

The Page Setup menu will default to showing you the Page tab. Click on the Sheet tab at the extreme right:

4 page setup menu

At last we’re in the Sheet menu. This is where you can choose the print area, titles, gridlines, quality, etc., but what we’re interested in is Rows to repeat at top (and/or Columns to repeat at left, if you have either or both of these):

5 page setup menu sheet

Now, how do you tell Excel which row you want to print at the top of every page? I got a bit flummoxed by this at first, I have to admit. Here’s how you do it:

Make sure your cursor is in the appropriate input box – in this case I have left-clicked with the mouse in Rows to repeat at top.

Then click with the mouse on the far left of the row you want to select. Can you see the dotted line round it on the image below? That means that it’s been selected. If you just click on one row, $1-$1 will appear in the text entry box. If you highlight more than one row, it will read $1-$2, etc.

6 page setup menu sheet choose

If you want to make sure that a heading column appears on every page of your printout, make sure the cursor is in the Columns to repeat at left box and click above the column you want to choose. You can choose a row(s) and a column(s) if you want to!

Once you’ve clicked on OK, you can scroll down in Page Layout view to see the top of the second page. There are the headings, ready to print on every page! You can change back to Normal view: the instructions that you’ve given Excel here will stay the same.

7 done

We’ve learned how to make sure that your heading row (or column) prints on every page of your printout when you’re printing out your Excel 2007 or Excel 2010 document.

If you’ve enjoyed this post, please do share it using the buttons below!

Related posts:

Freezing rows and columns in Excel

How do I keep my table headings over multiple pages in a Word document?


This is part of my series on how to avoid time-consuming “short cuts” and use Microsoft Office in the right way to maximise your time and improve the look of your documents.

Please note, these hints work with versions of Microsoft Excel currently in use – Excel 2007 and Excel 2010 for PC. Mac compatible versions of Excel should have similar options. Always save a copy of your document before manipulating it. I bear no responsibility for any pickles you might get yourself into!

Find all the short cuts here


Posted by on August 29, 2013 in Errors, New skills, Short cuts, Word, Writing


Tags: , , , , , , , ,

Scheduling blog posts, scheduling writing, and keeping going

Things to doAs part of my series on blogging, in this article I’m going to talk about how frequently to blog, keeping going, and how to get down to writing those posts. This is primarily aimed at people who are blogging for their business, but this advice applies to anyone who wants to build the audience for their blog and needs help getting down to writing posts and sticking to blogging.

So that’s everyone, right?

How often should I blog?

How often should you publish a blog post? Well, that’s up to you to a certain extent. But if you’re looking to appear high up in the search engine results and keep your readers happy, you should keep it regular.

Most advice that I’ve read suggests posting at least twice a week. This will keep your readers engaged, keep your content updated enough for the search engines to promote it up their lists, and get enough keywords and content out there to keep your statistics nice and busy.

Varying your blog posts

Even a book review blog could do with a bit of livening up every now and again. A good example is my friend Ali – she mainly posts long-format book reviews, but she also takes up general topics or talks about book-buying trips – which varies things for her readers and gives them something new every now and again.

I choose to vary things and give myself a structure by running series in different topics every week. I tend to publish a short Troublesome Pairs post about a pair of easily confused words or at present an article on blogging on a Monday, a Word tip or business post on a Wednesday, and I always run a Saturday Business Chat or Chat Update each Saturday. I don’t stick to this slavishly – this post is coming out on a Tuesday to avoid the bank holiday, but it helps me to structure things and means that there’s something for everyone every week (I hope).

You don’t have to just publish text pieces, either. I’m sticking to text for the moment, but you can include video and audio pieces as well.

This article by Joanna Penn of The Creative Penn has really good advice about when she schedules her text, audio and video content. Her blog is really popular, with loads of comments and great search engine optimisation, and if you’re planning on using different media, this would be a good plan to follow.

Including guest posts on your blog

I’ve talked about this a bit already in my article on Reciprocity in Social Media, but hosting guest posts (and having them on other people’s blogs, too) is a great way to spark up interest in your readers and get reciprocal links and readers. I’m going to write more about the etiquette of guest blogging soon. But again, it varies things a bit. I wouldn’t personally have a guest post more than once every couple of weeks.

How do I remember my ideas for blog posts?

If you’re anything like me, you’ll have ideas and inspirations for blog posts at the oddest moments. If I’m anywhere near my desk and PC, I pop into my WordPress platform and create a Draft blog post, sometimes with just a title, sometimes with a few jotted notes. If I’m learning something new (like turning footnotes into endnotes, just today), I’ll take screenshots as I go along, and save them ready to insert into a post on the subject. If I spot a picture I want to take or have a document with a feature I want to use, I take a photo and email it to myself or save the document in the relative folder.

If I’m out and about, I use the note app on my phone to make a quite note of what I want to write about, or, if I’m feeling brave, I go into the WordPress app and create a draft from there!

How do I organise my images for my blog posts?

Because many of my blog posts are very screen shot based, and I always include some kind of image in my posts (looks good when sharing, attracts readers, etc.), I have a folder in my Windows Explorer called Blog posts. This has sub-folders for all of the blog posts I write, or plan on writing, so I can pop screen prints and pics into the appropriate folder and know they’ll be there for later. I have a set of generic pictures in the Blog posts folder, too, that I can use as images at the top of posts. I prefer to use my own images to avoid copyright issues.

How do I get down to writing my blog?

Here’s my secret: blogging SESSIONS.

You do not have to write your blog posts on the day you publish them! You can write them in advance, save them up, and publish in advance!

I’ve always got some draft posts on the go – either because I’ve had ideas (see above) and not yet written them up, or I’m part way through a series and I’ve planned the whole thing out. So when I can see at least a 90 minute slot in my schedule, I’ll schedule in time to write blog posts.

I’ll then bash through as many as I can, using my draft posts for inspiration and possibly already having pictures ready to go, either saved or inserted into the posts. Then I just need to write the text. In a good session I can get at least a week’s worth of posts ready in one go.

I’m used to having to write because that’s some of what I do in my job. If you have to wait for inspiration to strike before you write posts … just make sure that inspiration has plenty of room to keep going! Anyway, it’s surprising what you can produce when you sit down and tell yourself that you have 90 minutes to generate a load of blog posts!

Scheduling publication of blog posts

schedulingI would imagine that all blogging platforms have a scheduling feature. Here in WordPress, I can edit the Publish Immediately field to the right of my writing pane, and choose a date and time to publish the post (I also automatically post a link to Twitter, Facebook and LinkedIn. This means I can schedule a post to publish when I’m going to be away from my desk and the post will still be publicised).

If you don’t know how to schedule blog posts on the platform you’re using, Google your platform name plus something like “schedule blog posts” and you should be able to find instructions.

So, when I do a big writing session, I write the posts I want to write, then schedule them all in for the appropriate days. I can view just the posts I’ve scheduled to make sure there aren’t any clashes, then I can get on with work or even go on holiday, knowing that my blog will be publishing when I’m away.

How do I make myself keep on blogging?

If you get stuck and don’t post for a while, or don’t feel like posting, don’t panic! Here are some things you can consider doing:

  • Have a think about why you’re blogging and whether you do actually want to continue (try reading my article on 10 reasons not to blog or the one on 10 reasons to write a blog!)
  • Have a little brainstorm and think of some ideas for blog posts – just jot them down and write them up later
  • Get into a writing routine that suits you – whether that’s posting once a day or having a weekly blogging afternoon
  • Sign up for one of the various schemes that suggests something to post, or ask your friends or readers to make suggestions about what to write about
  • Consider creating some themes – it’s easier to come up with an idea for a Word tips post than an idea for “a post”
  • Don’t beat yourself up. Look at other people’s posts for inspiration. Ask for some guest bloggers. Review something you use in your work life. Write about something personal


This article has talked about how often to blog, how to organise your blogging, how to schedule posts and what to do if you get stuck. I’d love to hear your thoughts on these topics – do post a comment, and if you’ve enjoyed this post, please share it using the buttons below.

Related posts:

10 reasons to start a blog – why you should do it now!

10 reasons NOT to write a blog – and why you should stop and think, at least!

Reciprocity and Social Media – how to negotiate social media kindly and politely

Top 10 blogging sins – avoid these if you can!


Posted by on August 27, 2013 in Blogging, Business, PowerPoint, Social media, Writing


Tags: , , , , ,

Small business chat – Rozelle Faulkner

mugs Today we welcome a brand new interviewee to the Saturday Small Business Chat fold. Now that the series has been going for over two years, most of the posts will be updates. But I can always squeeze in a few new ones, and I’m delighted to welcome friend-of-a-friend Rozelle Faulkner from candle-making company, The Indigo Chick today. Rozelle is another interviewee who started her business for family reasons – we do seem to fall into three camps, don’t we: made redundant, fancied a change and doing it for the family, and she’s done her research and started to build a lovely – if very new – business!

What’s your business called? When did you set it up?

My business is called The Indigo Chick. I started up in May 2013 but didn’t start selling until I launched my website on 1st July.

What made you decide to set up your own business?

My daughter starts school in September and the plan was that I would be at home, but busy bringing up a new baby. Sadly, my son was stillborn, and I didn’t want to try to get a part-time job in case I got pregnant again. Self-employment seemed like the perfect solution.

What made you decide to go into this particular business area?

I originally wanted to make Teacup candles as gifts and thought it seemed easy. Once I started researching candle making (or ‘Chandlery’), I soon realised it was a very complex business and fraught with frustrations, yet highly rewarding. The quest to make ‘the perfect candle’ became my mission and it was only once I discovered that I was pretty good at it that I considered it as a business.

Had you run your own business before?

I had been a demonstrator for the craft company, Stampin’ Up! a few years before. This required me to be self-employed but I mainly did it to fund my crafting obsession, so it didn’t really work as a business.

How did you do it? Did you launch full-time, start off with a part-time or full-time job to keep you going … ?

As I was already a stay-at-home Mum, I didn’t need to worry about giving up the day job. However, I consider myself ‘part time’ at the moment as the majority of my time is spent looking after my daughter. She often tells me off for doing too much ‘computing’ or trying to pack orders. I sometimes get her to help if she’s in the mood, which can be fun. She’s become quite adept at sticking safety labels to the base of the candles 🙂

What do you wish someone had told you before you started?

“If you buy a new batch of wax, make a test candle first to ensure that it requires the same wick as the last batch”. I had no idea that the same brand of wax, bought from the same supplier, could vary in how it burned. I found that out after making over £100 worth of stock, which I then couldn’t sell. It’s one of the ‘joys’ of working with a natural material.

What would you go back and tell your newly entrepreneurial self?

Don’t stress about problems, as they are inevitable in business. Focus on overcoming them and turning them to your advantage.

What do you wish you’d done differently?

Spent less money on numerous fragrances in the beginning. I would have been better off trying a few and finding out how different types of scent react in Soy wax before buying more.

What are you glad you did?

Taught myself Inkscape (free online graphics software) so that I could design my own logo and packaging. It was hard work and frustrating, but it saved me a fortune and I can’t put a price on how good I feel when someone compliments my design, knowing it was all my own work.

What’s your top business tip?

Listen to your customers and potential customers!  Alan Sugar tells The Apprentice candidates to “Smell what sells”, and this is very apt for my line of work!  If I’m asked for a product or scent that I wasn’t planning on producing, I make sure that I include it in my plans for the future of the business, even if it’s one I can’t stand 😀

How has it gone since you started? Have you grown, diversified or stayed the same?

It’s still early days for me and yet my business plan has changed already. I’ve added wax melts to my range and I’m currently working on introducing scented tealights too. The most difficult part is sourcing affordable recycled packaging. I refuse to go with the plastic boxes everyone else uses, as it just doesn’t fit with my ethos or my brand.

Where do you see yourself and your business in a year’s time?

I hope to have broken even financially. I would love to have a healthy database of clients who are repeat customers and are happy to recommend me and my products to their friends.

I’m impressed with the care and research Rozelle has put into her new company, especially while going through family heartbreak. She’s a real inspiration, and I’m sure that her policies of doing her research, learning how to do things, experimenting and learning, listening to her customers and sticking to her brand and ethics – things that many of us only learn to do as we go along, not right at the beginning – will stand her in good stead for her first year of trading. I think it’s lovely for her daughter to see her entrepreneurial spirit and even help out a little, too! I look forward to hearing what happens next …

You can find Rozelle’s lovely candles at, and email her or call her on 07578 486 669. She’s also on Twitter and Facebook. Please note, Rozelle is taking a rest from the business at the moment for personal reasons. We wish her all the best for the future, whatever she decides to do.

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my new book, Going It Alone At 40: How I Survived my First Year of Full-Time Self-Employment.

Leave a comment

Posted by on August 24, 2013 in Business, Small Business Chat


Tags: ,

How do I keep my table headings over multiple pages in a Word document?

If you have got a table that extends over several pages in a Word document, it’s useful to be able to repeat the header row at the top of each page automatically, so that it stays there no matter what you change in the table itself. This article shows you how to do that in Word 2007 and Word 2010 (we use the same procedure for both)

Why would I want to repeat my header row on multiple pages?

If you’re presenting a table which contains fairly self-explanatory information, for example, name, surname, book title, year, then you probably don’t need to repeat the heading row, even if the table runs across more than one page. But if you think that the person who will consult the table will need to keep reminding themselves about what the different columns contain, it’s useful to add the header row at the top of each page.

Doing this automatically rather than manually inserting a new row into each page of the table ensures that however much the table changes, the header row will stay at the top of each page.

How do I repeat the header row in Word?

We’re going to use the example of a list of books I have read. Here’s the table:

1 table

Now, this is a long list, and it goes over more than one page. OK, it’s fairly self-explanatory, but I might forget what the Acquired and Read headers are.

At the moment, when the table goes onto the next page of the document, the table just carries on, with no  header rows on the second and third pages:

2 table

Please NOTE that we’re in Print Layout view on the View menu at the moment: when we repeat the headers, the repeat is only visible in Print Layout or Print Preview, both of which show you what your document will look like when it’s printed. Word defaults to Print Layout view, but check, just in case:

3 view

Select the header row of your table so that you can tell Word that this is the header row by left-clicking with your cursor to the left-hand side of that row:

4 select

Now, because you’ve got a table in your document, Word will have added the Table menu tabs to your ribbon. There are two: Layout and Design. Choose the Layout tab. Find the Repeat Header Rows button:

5 repeat header rows

Click on the Repeat Header Rows button. Like magic, if you scroll down the page, you will now see that your header row is repeated!

6 repeat header rows done

Note: if you don’t have a row selected, the Repeat Header Row button will be greyed out and you can’t press it.

Here’s the magical thing: you can of course do this manually by inserting a row at the top of each page of your table. But then, if you move the text of the table around or resize it, you risk your manual header row not being the top row of your page.

Using the automatic function means that, whatever you do to your table, the top row of a new page will always be the header row (UNLESS you force a manual page break).

Here, I’ve changed the text size to make it larger. You can see that the first entry on the second page is no longer Coleridge, but the header row is still in place:

7 repeat header rows done

How do I repeat multiple header rows in Word?

You can display multiple header rows in Word in the same way. Make sure that you highlight BOTH rows that you want to repeat, and press the Repeat Header Rows button as before:

8 repeat multiple header rows

And there you go: the first two lines of the table repeat on each page:

9 repeat multiple header rows done

How to repeat header rows in Word 2003

In Word 2003, you will need to use menus rather than the ribbon.

Highlight the header row of your table.

Select the Table menu and click Heading Rows Repeat.


Today we’ve learned how to make the header rows repeat in a Word document. This is part of a series on Tables which I’ll be writing and publishing over the next few weeks.

Related posts:

Tables 1 – how to create a table

Please note, these hints work with versions of Microsoft Word currently in use – Word 2003, Word 2007 and Word 2010, all for PC. Mac compatible versions of Word should have similar options. Always save a copy of your document before manipulating it. I bear no responsibility for any pickles you might get yourself into!

Find all the short cuts here


Posted by on August 21, 2013 in Errors, New skills, Short cuts, Word, Writing


Tags: , , , , , , , ,

Top 10 blogging sins

pens and ink bottleI’ve been talking about why and why not to blog recently. Once you’ve committed to your blog, it can be a bit of a minefield. Here are the top ten blogging sins that I see over and over again, or hear other people complaining about. No one can be expected to know everything straight away, and we’ve probably all made at least one of these mistakes, so hopefully I’ll help you to avoid the big, bad ones with this list.

1. Not having an RSS feed

File:Feed-icon.svg RSS is a way to allow blog reader software to collect your content whenever it’s  updated and send it on to any of their readers who subscribe to your blog This Wikipedia article explains it all and examples of RSS readers include Feedly.

If you look at the top of this blog page, you will see that I have an RSS feed logo in the top right-hand corner, and a link in the right-hand menu bar, and I also offer a link to subscribe by email. All blogging software will have something in their settings that allows you to add this. If you don’t add this link, it makes it that bit harder for people who want to subscribe to your blog to do so (they can usually put the URL in their reader software, but are they going to do that extra process? Not always). Not having a button to use to do it quickly and easily can give the impression that you’re not interested in people reading your blog. That’s probably not true. But I’ve seen people get really cross about this and say that they’re not going to look at a person’s blog any more if they don’t have this. I know … but if one person’s saying it, how many are thinking it?

If you get stuck trying to add this button to your blog, the easiest way to find out how, is to Google your blogging software’s name and “RSS feed button”. You should find a YouTube video or set of instructions telling you how to do it.

2. Not updating your blog

If you set up a blog and you then don’t update it, it won’t help you to get more readers or to promote whatever it is you’re promoting. Google and the other search engines thrive on updated, fresh content. If you don’t update your blog regularly, it will fall further and further down the search rankings and no one will be able to find it. If you want to write a blog, commit to updating it regularly.

I’ll be publishing a post about scheduling and keeping active with your blog posts soon, so watch this space!

3. Stealing content from other people

It’s fine to “reblog” other people’s blog posts onto your own blog (where a snippet of the post appears on your page, with a link to the real thing). It’s fine to link to other people’s blog posts and tell other people about them. It’s even fine to be inspired by another person’s blog or content – one of my friends has started a questionnaire series a little like my Small Business Chat one but with an emphasis on marketing techniques: similar idea, different content, that’s fine.

It’s not fine to lift content wholesale from another person’s blog or website. If you quote large amounts of text written by someone else, it’s just the same as if you were using that in an article or essay – you need to reference where it came from and acknowledge the author. It’s fine to talk about newspaper articles or reports in your blog and react to them, not fine to quote them verbatim, or quote people they have quoted, and not give the original source.

Never be tempted to take someone else’s content for your blog post. At best, you won’t get picked up by the search engines anyway (see below). At worst, you’ll find yourself slapped with a lawsuit for plagiarism! And it’s just not right.

4. Reusing content in exactly the same form

Say you’ve had a guest post on someone else’s blog and you’re really pleased with how it’s turned out – so much so that you want to share it. So you post it in its entirety on your blog, too. Not a good idea.

All of the search engines, like Google, like to offer their users varied content. So if the same content appears in two places, both places won’t come up in search results. Effectively, one of them will be invisible to search engines, therefore invisible to people searching for keywords that might lead them to that content.

To look at it from a different viewpoint, if you’ve published information in a guest post, the owner of the blog you’re guesting on will want to be posting up original content, not things that can be found elsewhere. Some people actually specify that the content must be original in their guidelines for guest posters. See more about this in a week or so when I blog about guest posts.

How do you deal with this? Publish a snippet of the post on your blog, with a link to that post. Put some of your own text around it, then the search engines will find your post and your guest post, both of you will get found and viewed, and no one’s copied anything. There are clever ways to deal with all of this in the coding behind your blog, but I’m guessing that most of us aren’t the kind to deal with that level of complication – I’m certainly not!

5. Being rude or negative

I feel like a  bit of a hypocrite writing this, because obviously this post is a little bit negative. But I’m also genuinely trying to help people to avoid making common mistakes! In the same way, I tried to make sure that my 10 reasons not to write a blog article talked about reasons for reviewing your blogging and content and making a positive decision. Whining and moaning and relentless negativity won’t make your readers like you any more than they would like you in real life.

Being rude can get you views in the short term. But it’s like those restaurants that people go to only because the waiters are desperately unfriendly. Fine for a laugh: but will they go back regularly for birthdays and anniversaries? Probably not. Even ranty blogs about politics or issues have to be constructive as well as rude!

If you want to have a rant or talk about a mistake you’ve made, try to vary and space out these posts, and make them as constructive as you can. We can all get a good blog post out of a bad experience, but make sure that you and your readers come away having learned something. I’m going to post soon about managing your social media brand, and this comes very strongly into that, too.

6. Posting inappropriate content

I don’t just mean lurid or dirty pictures here. If you want to share information about your management courses, then blogging about your exercise classes won’t get you the audience you want to buy your courses, unless you’re doing some very clever keyword placement and making the articles valuable to both groups of readers.

I have to admit to having a laugh at funny spelling mistakes as much as the next person. However, I’m careful not to mock or talk about or post pictures on this blog, because a lot of the people I work with as an editor are unsure about their English and using it as a second, third, fourth language … and would be mortified if they thought people were laughing at them (I don’t laugh at their English: I know I couldn’t do half as well as my overseas clients if I was writing in my second language. Bong joor toot le world).

7. Not giving your guest posters what they need

If someone takes the time to write a guest blog post for you to to give you more, fresh content, bring their fans over to your website, give you a marketing opportunity, etc., etc., then you need to do certain things to make the experience a good one on all sides. Chief among these, and something I see people having issues with all the time, is making sure that you provide live links back to their website and whatever it is they’re promoting, be it another website, their book on Amazon, or whatever. A live link is one that your readers can click on and be taken to their page, like this one which takes you to a post I wrote telling you how to add links to your blog posts!

Formatting guest posts that have come through in an email or an attachment can be tricky, full stop. I recommend pasting the text into a Notepad file on your computer, then pasting it from there into your blog post. Lots more on this in an upcoming article. But please make your guest blogger’s links live so that your readers can visit them online!

8. Not letting people respond to your posts

I like responding to blog posts. We all like responding to blog posts. We like to feel it’s a two-way conversation when we read something online, don’t we. But I still come across blogs every day that either don’t allow any comments at all, or make the commenting process so complex that people give up.

I have to say that the blogging software can be a culprit here. I can never seem to reply to Blogger posts, and WordPress itself can give the impression that you have to sign up to a WordPress account in order to comment on one of its blogs (you really don’t, you just need to add your name and email address).

Enable comments, even if you moderate and check all of them for spam (most blogging platforms allow you to set the level of moderation, for example, I hand-moderate the first post by anyone, and am alerted to all new comments, so I can check they’re not spammy or inappropriate). And listen to your readers – if you’re getting complaints about how hard it is to reply to a post, have a look at your settings and see if you can make it easier. One of my blogging friends has a note whenever you go to comment with an email address to use if the process won’t work – very helpful!

9. Not responding to comments

Allied to the above, if people take the time to reply to your blog, it’s only polite to take a moment to respond to them. Some people who get a lot of comments will do a general reply mentioning all of the previous commenters with a sentence addressed to them, and that’s of course fine. But I get a bit frustrated if I comment thoughtfully on a blog post and the author never responds. You don’t have to do it immediately, but I try to do it within 24 hours, a couple of days at most.

Conversations on your blog can be one of the most interesting things about blogging – so get out there and engage with your readers!

10. Only advertising, never helping

Yes, I and other people have told you again and again that having a blog will help your business. That’s true. But just blaring out adverts to your readers won’t make them keep coming back. Imagine two blogs, both about plumbing:

  • One lists the different areas of plumbing the plumber can do, and has carefully inserted keywords to attract the search engines
  • One talks about the jobs the plumber has done this week, including how she solved a particularly tricky question. She sometimes posts a question and answer about a common type of issue, like changing the washer on a tap

Which blog will you go to once, to find a plumber? Which one will you bookmark and read, share and tell other people about? Which one will actually bring the plumber more business in the long term?

I give away quite a lot of free advice on my blog, but just because I tell people how to set up a table of contents doesn’t mean that none of my clients ever ask me to do that now. On the contrary, seeing my expert advice, they trust that I can sort it out for them!


That’s my personal top 10 list of blogging sins. Would you add any to that? Are any of those NOT sins in your book? I’d love to know what you think, and whether you’re enjoying this new series of articles all about blogging!

Related posts:

Top 10 reasons to write a blog

Top 10 reasons not to write a blog

Scheduling blog posts and keeping going

You can find a growing set of articles on blogging and social media in the resource guide. Do click on the share buttons below or comment if you found this article interesting or useful!


Posted by on August 19, 2013 in Blogging, Business, New skills, Writing


Tags: , , , , , , ,

Small business chat update – Marvin Edinborough

mugsToday we’re catching up with my old personal trainer, Marvin Edinborough. I first interviewed him in July 2012 and his plans then were all around his clients and his personal training services: “Continuing to grow, continuing to help clients achieve their goals no matter how big or small they may be”. He moved from my gym to another one and I stopped having personal training sessions for unconnected reasons, but neither he nor I could have predicted what happened next!

Are you where you thought you’d be when you looked forward a year ago?

Not in the slightest. I’m at Solihull College lecturing in Sports & Fitness now. I had no idea I’d be teaching a year ago today, it wasn’t until August that I decided I wanted to take the PTLLS (Preparing to teach in the Lifelong Learning Sector) course. In relation to my business, the answer would be the same: because I am now working at a college, my hours at the gym have been reduced by quite a bit, and a year ago, I couldn’t see this happening. The business is still there, I could go into the gym this week, walk the floor and gain clients, or re-book in old clients now that I’m officially broken up for the summer.

What has changed and what has stayed the same?

Moving to EasyGym there is a lot more competition (6 trainers, compared to LA’s 3) but because of their lower prices and larger number of members, this hasn’t affected my business at all, plus I also took 80-90% of my client base with me from LA. My passion, drive, enthusiasm and motivation have stayed the same, if not increased, due to the surroundings, the space, the equipment, etc.

What have you learned? What do you wish you’d known a year ago?

I have learnt that if you have a great business product that people want, have built yourself a very good base of clients, there is no reason to why your business cannot relocate and still succeed. In my example, for 80-90% of my clients to follow me to a completely new gym they’ve never stepped foot in before rather than stick with their current gym and take on the services of a new trainer must say something about the product I have to offer.

I have also learnt that having your own business and “being your own boss” if you like gives you the opportunity to explore different paths in life, for example, the time and financial support to go onto a teaching course and now into a teaching job.

Any more hints and tips for people?

Believe in yourself and your product, build a rapport with users of your business, never cut ties and always be prepared to offer rewards to those loyal to your business. One of my ex-clients introduced me to (my now new boss) at the college, and that’s where it all started with me going into teaching.

And … where do you see yourself and your business in a(nother) year’s time?

Hopefully still expanding, still running, still profitable. The fitness industry is neverending, you can’t sleep on it, you always have to be learning, willing to learn more, do more, be better, and this is what I intend to do to improve my business.

A very driven chap with the right motivation and attitude to succeed, I am sure Marvin will do well in his new teaching job, which does, after all, require many of the same skills as personal training: emotional intelligence, ability to alter teaching styles to reflect people’s learning styles, and the ability to motivate people, among others. I know other personal trainers who have gone into the education sector, interestingly enough – have any of you travelled in the other direction? Good luck to Marvin for the exciting year ahead! Catch up with Marvin in 2014 here!

You can contact Marvin via Twitter or email, and he has a profile on the EasyGym website if you’re interested in his personal training services.

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my new book, Going It Alone At 40: How I Survived my First Year of Full-Time Self-Employment.


Tags: , ,

Portrait and landscape orientation in Word and Excel

In this article, we’re talking about the Portrait and Landscape orientations in Word and Excel, what they are, why you might want to use each one, and how to swap between them.

What are Portrait and Landscape?

Portrait and Landscape are the terms used for the orientation of the page in applications that deal with pages, such as Word and Excel. Orientation means the relative position of the page when you’re looking at it:

1 pages

Portrait means that the page has the shorter sides at top and bottom. Think of a portrait in a gallery or museum. They are usually this way round. Landscape means that the page has the shorter sides on the left and right. Again, think of an art gallery. Which way round are views painted of the landscape? Exactly.

Why would I want to use the landscape orientation?

Word and Excel documents default to being in the portrait orientation. That’s the format of most books, reports, folders, etc. But landscape can be very useful if …

In Word

  • Your layout is such that it comes out wider than it’s high – maybe a poster or a sign to put up in your office or building
  • You have a wide table to insert into the document with lots of columns and it gets too squashed up and hard to read if you try to fit it onto a standard portrait A4 page
  • You have a diagram to insert into the document that’s wider than it’s high
  • You have a picture to insert into the document that’s wider than it’s high

In the last three incidences, you might only want one page of the document to appear in landscape. That’s easily done, and you can find out how to have portrait and landscape in one document here.

In Excel:

  • Your spreadsheet is too wide to fit comfortably onto a portrait A4 page

How do you change between Portrait and Landscape in Word 2007 and Word 2010?

You swap between Portrait and Landscape using the Orientation menu in Word. This can be found in the Page Layout tab, in the Page Setup section:

2 menu

Press the Orientation button (or the little arrow at the bottom) to access the menu:

3 menu

Choose your orientation, and the whole document will change to that orientation, unless you’re only changing one section (see below)

How do you change one page in Word to be in Landscape?

To change one page in Word to be in Landscape, you need to set Section Breaks first, so that Word knows which pages you want to change. See this post on Section Breaks for instructions on how to do this and change just one page or section.

How do you change between Portrait and Landscape in Excel 2007 and Excel 2010?

Changing the orientation in Excel works in exactly the same way as doing it in Word. Find the Orientation menu by going into the Page Layout tab and Page Setup section:

4 excel

Then press the Orientation button to make your selection.

How do you change between Portrait and Landscape when you’re printing?

Sometimes you don’t realise that you need to print your document in Landscape rather than Portrait (it’s usually this way around, I find) until you have printed out one copy and find that your lovely picture or table falls off the edge of the page.

You can change the orientation of the printing while printing – however, the orientation of your original document will NOT change if you use this method, and if you want it to change to Landscape permanently, you will need to go back and follow the instructions I give above.

If you want to change the orientation of your printing (in Word or Excel or when you’re printing off a web page or a map or anything!) …

First, select the Print option. When the Print dialogue box comes up, click the Properties button:

5 printer

You will usually then be given a screen something like this which will have a Features tab:

6 printer

Find choice buttons for Portrait / Landscape, select the one you want, and OK, and then your printout will be in that orientation.


In this article we have learned what the portrait and landscape orientations are, why they are useful, how to change them in Word and Excel and how to change orientation when you are printing.

If you have enjoyed this post, please share the link using the buttons below or sharing the Facebook, Twitter or LinkedIn alert that you followed to get here!

Other useful posts: Section breaks in Word

Please note, these hints work with versions of Microsoft Word currently in use – Word 2007 and Word 2010, for PC. Mac compatible versions of Word should have similar options. Always save a copy of your document before manipulating it. I bear no responsibility for any pickles you might get yourself into!

Find all the short cuts here


Posted by on August 14, 2013 in Errors, New skills, Short cuts, Word, Writing


Tags: , , , , , , , ,

10 reasons not to write a blog

pens and ink bottleWe’ve already looked at reasons to write a blog. But what are the reasons for not writing a blog, or for taking an informed decision to stop writing one, even if you started?

Note that this, like the last post, is mainly targeted at business bloggers. However, if you have a blog that you want to gain an audience and maybe earn some money from in whatever way, these points will interest you, too.

So, what are the reasons NOT to write a blog, or to give up?

1. You are only doing it because someone told you that you should

I go on about blogging to people ALL THE TIME. I even did it when I was buying vegan food from a stall in Greenwich at the weekend. But don’t just do it because someone tells you to. OK, it’s worth looking at the reasons why having a blog is good (see my previous post) and making an informed decision, but if someone just tells you, “start writing a blog” and you do, it’s not so likely that the habit will stick and it will be useful and fun.

2. You actually dislike doing it

So, you’ve started blogging and you’ve got into a routine, and then you realise that you’re just dreading writing that next post. I’m going to talk in another post about slumps and maintaining momentum (if I forget to link to it here, look in the index). But what I’m talking about here is hating it all the time, disliking putting fingers to keyboard and putting the thing together, resenting the time it takes up. If you don’t enjoy doing it

  • get someone else in your organisation to do it
  • pay someone else to do it
  • stop doing it entirely

3. You haven’t got time to post regularly

Although if you have a personal blog and you’re not worried about statistics and search engines, you can get away with blogging very irregularly, if you are doing it so as to appear in search results and get more exposure for your business, you really do need to post regularly. I find that, for me, three posts a week are the sweet spot. When I publish three posts a week, I get the most visits to the blog. It’s worth noting that not all of those are long posts (my Troublesome Pairs certainly are not), but it’s regularly updated content, full of relevant keywords and useful to different groups of readers.

Once a week is, I think, the minimum you can get away with and still gain value from the process. If you don’t have the time to do this, again, consider outsourcing, or consider not doing it at all.

4. You’re not organised to post regularly

Following on from the time issue, you do need to be organised enough to generate new content fairly regularly. Again, I’m going to talk about this in detail in another article, but you do need to be able to plan what you’re going to talk about, gather photographs and illustrations for the posts, and organise yourself to sit down and write them, and then publicise the posts and deal with any comments that might ensue. If you fly by the seat of your pants and do everything as and when, and find organisation in general to be a tricky thing, blogging for business might not be for you.

5. You’re only in it to make money

You do read loads of posts about making money from your blog. And you can make money from your blog, for example by …

  • Allowing adverts to appear on your blog (but be very careful with this and make sure you only allow adverts relevant to your readers or this will be a big turn-off. The best way to do this is through carefully selected product placement that matches with your content and readership)
  • Hosting affiliate links on your blog so that readers can click a button or picture on your blog to be taken through to buy a product, while you get a percentage of all sales (this is notoriously difficult to make money from)
  • Selling your blog to a publisher to make into a book (but not many people make money writing and selling books, and there’s more to a blog-to-book than just bunging all your blog posts in one place – I have direct experience of this)

It’s not common to make money directly from your blog. It’s hard to say how many page views you need per month to do well out of advertising, but recommendations start at 10,000 unique visitors per month. Not many publishers convert blogs into books outside the big ones we’ve all heard about. What my blog does is let people know about me who then become customers … but that’s using your blog to build your business, not to make money per se. If you’ve read an article or been to a seminar about easy ways to make money online, be VERY careful what you sign up for and get into.

6. You are not interested in engaging with your readers

People who read blogs like to comment on them. People who comment on blogs like to see the blogger reply to these comments. I know that personally I’ve stopped reading and commenting on blogs when I’m never responded to, especially if I can see that the blogger never responds to any comments. This is actually one of my Top 10 Blogging Sins, too.

If you’re not actually interested in having a conversation, in engaging with your readers, in replying to their comments, and you just find it a chore; if you just want to broadcast and don’t want to engage in two-way conversation, I don’t personally think that blogging is for you. You will lose readers as fast as you gain them, and it will never be personally or professionally fulfilling for you.

7. You are not interested in engaging with other bloggers

This is similar to point 6, but we’re talking here about other people in the same line of business as you (whether that business be small business support, engineering or book reviewing). If you see other people blogging on a similar topic to you as rivals, and you want to keep apart from the, set yourself apart and distance yourself, then you may not find blogging to be useful. You probably can’t “beat” the most successful blogger in your industry, and if you don’t want to engage with them, share guest blog spots, link to their material and comment on each other’s blogs, then it might be wise to disengage with the process.

8. You haven’t got anything interesting to say

If you’re boring yourself with your blog content, you will probably be boring your readers. If you’re constantly scratching around for topics to write about, or covering the same ground time and again, consider scrapping that series, if you have various topics you cover on your blog, or the whole thing. I used to post up an update about what I’d been doing in the previous month at the beginning of each month. Although some readers said they enjoyed it, it was becoming very repetitive and boring to write. So I stopped doing it and added something else in that slot on the blog.

Note: what you think isn’t interesting might be to other people – it’s always worth doing some market research. When I meet people like locksmiths, carpenters and electricians, I always tell them they should write a blog about their daily lives and the jobs they do (keeping their clients’ confidentiality, of course) as many of us would find that sort of thing really interesting. I’m talking about when you’re struggling for ideas and you’re maybe not getting any positive feedback or a growing readership, and your blog becomes bogged down and repetitive. Have a rethink or ditch the blog!

9. Your blog isn’t relevant to your target market

If you’re blogging for business, your blog posts need to be relevant to your target market(s). For example, I blog about …

  • Word tips and hints – because most of my clients and target market use Word
  • Language tips and hints – because my business lies in improving written language
  • Business tips and hints – because I’ve written a book about business and I am passionate about engaging with other businesses
  • Blogging tips and hints – because I get asked about this a lot and because of the business reason above and because I noticed that I get searches coming through to my blog on that topic already, so people want to know about it

If you sell garages but blog about hairstyles, the people who read your blog are not likely to have a huge overlap with the people who are going to buy your services. If you have a book review blog and want to engage with mystery authors but only review romance, that’s not going to engage your audience. There needs to be a big overlap between what you talk about on your blog and the people you want to attract to read it. Even “the general public” has niches – people who like to read about fashion, or the work of an ambulance driver, or about low cholesterol eating.

10. Nobody is reading your blog, even after 6, 12, 18 months

It takes time to build a blog and its audience. Both of mine have grown over the months, pretty gradually. My book review blog wasn’t growing its audience much for a while, and I did wonder whether to cancel it. I actually published a post asking if people found it interesting to see whether anyone was reading it! What I found out was that many people were reading it on blog aggregators, which don’t show up on my statistics. So it was worth doing, but I also took steps to add value, beefing up my reviews, adding some more web pages to the blog, and importing a whole wodge of old reviews from another blogging service I used to use. My traffic improved and the blog was saved. But if you do that, and you change things and no one’s looking, maybe it’s time to consider other ways to market and raise awareness.


These are not necessarily ten reasons to stop blogging altogether. They certainly are reasons to stop, look at what you’re doing, reconsider things and maybe tweak your posts, style, content or other aspects.

Have you stopped writing a blog? Why?

Relevant posts:

10 Reasons to Write a Blog

Reciprocity and social media

Top 10 blogging sins

Scheduling blog posts and keeping going

Coming soon …

WordPress blogging 101



Posted by on August 12, 2013 in Blogging, Business, Writing


Tags: , , , , , ,

Small business chat update – Carl Nixon

carlnixonToday we’re saying hello again to Carl Nixon, my very first interviewee when I started this series back in summer 2011! In our last update, Carl had plans for some new services: ’”I’m moving the business from providing bespoke services to providing off the shelf solutions such as accounts packages. This will mean a totally different business model, but we have already struck partnership deals to bring in outside expertise”. What happened next?

Are you where you thought you’d be when you looked forward a year ago?

In a word, no. I was hoping to have a range of off the shelf products ready to sell by now, however the bespoke side of the business has been so busy, there have not been enough hours in the day to develop the “off the shelf” products. The project is far from shelved and work continues on the products.

What has changed and what has stayed the same?

I’m no longer a part of the face-to-face networking scene and I have withdrawn from a couple of business forums I was a member of. Networking stopped working for me a fair time ago and I realised I was in it more for the social and support side rather than the getting and sharing of business. I’m not anti-networking and I still recommend that start-ups should at least try it, it’s just no longer a good fit for my business. All of my effort is now focused in and around LinkedIn, which is producing some great results for us.

Our core services have remained constant, which appears to be great news to our clients as we are getting a higher percentage of referrals. Although the bespoke side of the business is up this year, I do it see it as bit of a risk, as it is something that can dry up quickly, so that is something I need to sort out ASAP.

What have you learned? What do you wish you’d known a year ago?

So much this year, but here are the main three.

Check out the experience of the people giving you advice – several times this year I have been given advice on how to run and market my business from people who have full-time jobs and part-time businesses. Although the advice is given with the best intention, it is obvious that they have not walked the walk.

Hang out with the big boys – One of the problems I found with the networking scene was that I found myself hanging out with people with small businesses and even part-time businesses. There is nothing wrong with that, as there is some great support to be had in that environment. On LinkedIn I specifically picked groups frequented by larger companies and I joined the local Chamber of Commerce. These venues are stuffed full of people who have loads of experience and have really walked the walk before. Surrounding yourself with people like this really changes the way you think and can be very uplifting and encouraging.

Oranges are not the only fruit – We’ve all been told at some point that we must be mad not to do X, Y & Z in our businesses: well, after quitting networking, I got this by the bucketful. People who I had never met were messaging me to tell me how mad I was. I can understand that if a particular marketing channel works for someone they will want to shout about it, however there are plenty of people who will claim their preferred method is the ONLY method. The truth is that it is not, it is just one of many marketing channels available out there. I tend to shut these people out now; however I still try to understand why something works well or doesn’t work for other people. Knowledge is always good.

Any more hints and tips for people?

Keep learning – if you’re not learning anything new, you are standing still. If you are standing still, you will be overtaken.

And … where do you see yourself and your business in a(nother) year’s time.

I think it is going to be a year of change for us for a couple of reasons.

First of all we have the business need to move away from our reliance on our bespoke work. Secondly we have the move away from desktop PCs and laptops towards tablets – this means less and less reliance on Excel and a divergence into things like Google Docs. While we have no problems programming Google Docs, it is not a platform on which we can copy protect our work.

At the moment, my partner and I are looking at a number of revenue streams not directly related to spreadsheets, so this year is very much an open book.

This was very interesting for me to read, because without really realising it, I, too, have moved away from specific business networking and especially forums. I’m just too busy with work and blogging and networking with peers and colleagues to interface with the forums much any more. Like Carl’s, my business is now fairly mature (we set up at about the same time), and I’m relying on referrals and repeat custom rather than scrabbling around establishing myself and finding out how to do things. I never stop learning, of course, but the sources of your knowledge and learning do change as business progresses. I’ll look forward to hearing about Carl’s next year with great interest!

Carl’s website is here and his Contact Us page offers many ways to get in touch. You can call him on 029 2125 1450.

Carl’s business is still going strong, I’m happy to say, although he’s no longer part of the interview series. Best wishes for the future, Carl!

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my new book, Going It Alone At 40: How I Survived my First Year of Full-Time Self-Employment.


Posted by on August 10, 2013 in Business, New skills, Small Business Chat


Tags: , ,