RSS

Author Archives: Liz Dexter

About Liz Dexter

Book blog is at http://www.librofulltime.wordpress.com Writer, proofreader, editor, transcriber. Also runner, gym-goer, volunteer and BookCrosser! My married name is Liz Dexter but my maiden name and the name on the books I write is Liz Broomfield.

Displaying your data in Excel – pivot tables

We can use pivot tables to display the number of times a value appears in a column or row in an Excel spreadsheet.

Why would I use a pivot table to display data?

I keep a record of my reading, including author, publisher, date, fiction or non-fiction, source, if there are any special features like mental health, immigrant experiences etc. I used to tot up some of this information manually using my book blog but this year it’s been in Excel so I can copy other book bloggers and share more detailed information.

I wanted to be able to display numbers of times I read books by x publisher etc. so taught myself this pivot tables / pivot charts procedure.

Setting up a pivot table to display my data counts

Say I want to count the number of times I’ve read books published in particular years in my spreadsheet of books read. I want a graph with the years along the bottom and number of books from each year up the side.

First I select the source data to use, by highlighting the Date column.

Then I go to the Insert tab and select PivotTable then PivotChart:

This brings up a dialogue box. I check the range is in there and then tick the Existing Worksheet option, because I want to display this on my worksheet.

I select the first cell of the destination range to tell it where to paste (I’ve not filled that in yet here), and click OK .

The PivotChart Fields pane appears on the right-hand side of the worksheet. Date (or whatever field you selected) should be showing at the top. Click the tick box next to Date and drag Date down to the Axis section and then the Values section.

The empty Values section populates with Count of Date: this is correct. Once I’ve dragged them down …

As if by magic, a chart appears with my data!

I can move this around and resize it using the arrows that come up as you hover over the box containing the chart.


In this article I’ve shown you how to use pivot tables and pivot charts to make your data display in an easily readable form in Excel.

This works for Excel 2010 and above for PC.

Find other Excel tips in the Excel category!

If you found this article useful, please let me know in a comment!

 
Leave a comment

Posted by on September 25, 2019 in Excel

 

Tags: , , , ,

Small business chat update – Sophie Playle

Small business chat update – Sophie Playle

Hello and welcome to a lovely editing-inspired update with  Sophie Playle, editor and trainer of editors from Liminal Pages,  We first met Sophie in December 2013, and got updates in January 2015, March 2016, March 2017, and April 2018, where this was her plan: she wanted to be “Where I am now, but better”. Good plan! Let’s see how she’s getting on now …

Hello again, Sophie! So, are you where you thought you’d be when you looked forward a year ago?

As always, I think I can do more in the time I have than is realistic, so I’m a bit behind on where I’d hope to be – but I’m working on it, and trying not to beat myself up about it!

What has changed and what has stayed the same?

Most things have stayed the same. I’m still offering editorial services to authors and publishers of fiction, and I’m still offering online training to editors. The main difference is that this year, I’ve set the dates for when my courses will run in advance (rather than launch them as and when). This seems to be working well – it helps me and my potential students plan our schedules better.

Oh, the other thing that is about to change (at the time of writing) is my website. It’s been nearly two years in the making, but I designed a new website for myself from scratch (learning new software and design skills) and had it coded by a professional web developer (*cough* my spouse *cough*). I’m currently in the process of transferring all the content, but it should be going live soon.

Since my business has reached a point of stability, I felt it was time for a custom-built website. I’ve been using WordPress themes since the start, and those have served me well, but now I want to take my business to the next level. The new site will be much faster and look super-slick.

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

Teaching others teaches me so much. It forces me to find holes in my knowledge and solidify what I know. I’ve learned even more about story structure and types of narration recently, which in turn has improved my services.

At the start of the year, I detoxed from social media and learned that it didn’t have much impact on my business and that I felt more creative and less anxious. I wish I’d done it sooner.

Social media is full of other people’s successes and ideas, and I feel this can make you feel less enthusiastic about your own business, and crowd out your own thoughts and ideas. On top of that, it’s a time-suck – time that would be better spent elsewhere.

I’m not saying removing yourself from social media is right for every business (and I certainly haven’t totally removed myself from it), but I do think we all need to take a good hard look at how we’re using it and the true effect it’s having.

Any more hints and tips for people?

Get out of the house every day, preferably somewhere green. You’ll feel better for it.

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

My new website should be up and running, as should my latest course on copy-editing fiction, Tea and Commas. I’m hoping to incorporate more video into my business, too, and this is something I’ve already started experimenting with. I’ve just moved house, too, and so I’m looking forward to getting into some new routines. I find regular structure to my day makes me happier and more productive.

I always love reading Sophie’s interesting newsletters (especially as she works from all over the place, which makes me a bit jealous sometimes) and I always appreciate her honesty. Having a website refresh is a great idea and I’m glad that’s all going well. And she’s completely right about getting outside every day, into natural surroundings if you can. I’m fortunate to have my running hobby to help me do that.

Website: www.liminalpages.com

Twitter: www.twitter.com/sophieplayle

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 books, all available now, in print and e-book formats, from a variety of sources. 

 
2 Comments

Posted by on September 21, 2019 in Business, Small Business Chat

 

Tags:

Small business chat update – Sara from Sara’s Parlour

Small business chat update – Sara from Sara’s Parlour

Welcome to the first update from Sara, a friend of a friend, who runs Sara’s Parlour Face Painting, which offers face painting and other art services in the West Midlands and beyond. I first interviewed Sara in June 2017 so we’re long overdue a catch-up (and that’s entirely my fault) and I’m glad to see things are going so well. Last time, this was where Sara wanted to be in a year’s time: “Full time, potentially with at least one paid worker in the office so I can work on being creative!”

Hello again, Sara! So, are you where you thought you’d be when you looked forward a year ago?

Yes things are on the up.

What has changed and what has stayed the same?

I’ve continued to grow my corporate client base. I still don’t have an assistant – but I’m hoping to this will change shortly. I am busier than ever!

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

Sometimes you need to make a change before you get snowed under. It’s always worth looking for what business help and advice there is out there.

Any more hints and tips for people?

If you want to run your own business it has to be a labour of love. Expect long hours – so make sure its something you really love to do!

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

Expanding what we offer with more party services and I hope to have expanded into mural making as I have an illustration degree

I very much agree with doing what you love – even though my job is a lot less creative, I still enjoy very much being in on the process of creation at the text level. Do have a look at Sara’s origin story in her first interview (ever start a business by accident? I sort of did that, too!) and click on a link below to see the marvellous work Sara does, and I’ll be looking forward to her follow-up interview next year!

Sara’s Parlour
Tel: 07964 081 325

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 books, all available now, in print and e-book formats, from a variety of sources. 

 
Leave a comment

Posted by on September 14, 2019 in Business, Small Business Chat

 

Tags: ,

Getting your business ready for no-deal Brexit if you don’t pay VAT – EORI number registration

HMRC state UK businesses need an EORI number to trade with Europe after a no-deal Brexit.

I received this email from HMRC yesterday and I suspect I only received it because I signed up for their update emails (none of the others of which have been useful so far). I am just putting it here for people to see – I’ve been through the process and got my number (but when they give it to you, copy and paste the page into your own records otherwise you have to go back in and search for it once you’ve been approved). You need a Government Gateway login to access it.

This is not legal or business advice, I am merely sharing what I’ve been sent in case it helps any other sole traders who are not VAT-registered.

Dear Liz,

The Government has said that the UK will be leaving the EU on 31 October whatever the circumstances.

Leaving the EU without a deal means there will be immediate changes to the way UK businesses trade with the EU that may impact your business.

  • UK businesses will have to apply customs, excise and VAT processes to goods sold into the EU (these are the same rules that already apply for goods and services traded outside of the EU).
  • Trading partners in the EU will have to apply customs, excise and VAT processes to trade they carry out with you, in the same way that they do for goods and services traded from outside of the EU.

HMRC is helping businesses get ready for Brexit by automatically issuing them with a UK EORI (Economic Operator Registration and Identification) number. We have written to more than 88,000 VAT registered companies to let them know the UK EORI number they’ve been assigned. Businesses will not be able to move goods in and out of the UK without one.

If your business is not VAT-registered, you will still need to apply now for a UK EORI. HMRC cannot give you this automatically.

You can check the next steps you need to take to ensure that your business is ready for Brexit using our trader checklist.

We will continue to provide you with the latest guidance and support to help you prepare your business for the UK leaving the EU.

You can sign up for HMRC emails here.

You can register for Government Gateway here.

Not legal advice. Not tax advice. Sharing what I’ve been sent.

 
Leave a comment

Posted by on August 23, 2019 in Brexit, Business

 

Tags:

Small business chat update – Kathy Ennis

Small business chat update – Kathy Ennis

Catching up with one of last year’s interviews, today we’re chatting to Kathy Ennis, from LittlePiggy. She focuses on helping small and micro-businesses develop, including social media, marketing, branding and business planning. Kathy joined us in May 2012 and we updated her story in July 2013, August 2014 and February 2016April 2017 and April 2018. At that point, this was Kathy’s plan for the year: “Well, I hope to be living beside the sea by that time. As far as the business is concerned, I just want things to tick along the way they are at the moment as it’s all so lovely at the moment..” Let’s see what happened next …

Hello again, Kathy! So, are you where you thought you’d be when you looked forward a year ago? Are you in fact by the sea?

Well, I am by the sea. I moved to Old Hunstanton in Norfolk last November. It’s a lovely place and I feel so privileged to be able to call it home.

I hoped to minimise the disruption to my business but there have been a few hiccups. Whenever I have moved before it has always been within a defined geographical area, which meant I carried my network with me – you know what they say “your network is your net worth”. This move was a complete upping of sticks, so I am having to start a lot of things from scratch; that can’t but have an impact on business.

I am lucky to still be working with a few of my clients in London, and I do work online with others – but my big push for the coming year is to build a client base in and around my new home.

What has changed and what has stayed the same?

As I said previously, the house move has had a big impact and caused quite a few changes. I have also been working on honing my offer and my customer profile which means I am working with clients in a slightly different way. I must say, the use of platforms like Zoom has started to really transform the way I work.

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

Rather than learned, I am learning to take time out to really appreciate my surroundings.

I live a 3 minute walk from one of the most beautiful beaches / coastlines in England; I also have marvellous country walks on my doorstep. There’s more to life than work and, sometimes, you can over-do/over-think stuff; taking time out is essential.

Any more hints and tips for people?

I am able to structure my workload and appreciate my surroundings because I know exactly what I am offering and who I am offering it to. I have a plan for my business that allows me to get things done and not worry about what’s next – because I know what’s next.

So, my biggest tip is to get a plan – not a business plan, but a plan for your business. I use a method I developed where it can all be done on one sheet of paper. If anyone wants to know more they can book a Discovery Call with me on https://calendly.com/littlepiggyuk/discoverycall

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

More established in my local area, working with clients face to face but with more emphasis online. Working fewer hours and days per week- all the things I have remodelled my business to allow me to do.

I’m fortunate in that none of my work is location-based, so I could work anywhere in the world as long as I have broadband and a decent keyboard. And the nature of my work means most of my clients now are regulars or by recommendation, so I don’t need that local network so much, although I certainly engaged with it at the beginning to build my confidence and experience, and also help others. But it must be so hard to build that up again! I have also adjusted my working hours – I very rarely work weekends now, and that allows me more down time, or time for my hobbies of running and athletics officiating. I wish Kathy all the best in building her networks locally, and am happy she can get out into marvellous natural environments so quickly and easily now (jealous? me?).

Website: https://littlepiggy.ltd/

Facebook: https://www.facebook.com/LittlePiggyUK/

Twitter: https://twitter.com/kathyennis

LinkedIn: https://www.linkedin.com/in/kathyennis

Email: kathy@littlepiggy.ltd

You can find the website for Kathy’s book here, and order it from Amazon.

Phone: 07815951585

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 (I have a full roster of interviewees now so am only taking on a very few new ones). If you’re considering setting up a new business or have recently done so, why not take a look at my books, all available now, in print and e-book formats, from a variety of sources. 

 
Leave a comment

Posted by on August 3, 2019 in Business, Small Business Chat

 

Tags: ,

Small business chat update – Mel Bridger (was Carpenter)

Small business chat update – Mel Bridger (was Carpenter)

I’ve let these interviews slide for a couple of weeks, sorry – real life intervened in the shape of an ultramarathon and a family celebration. But now let’s say another hello to Mel Bridger (was Carpenter), a busy exercise and fitness guru who is always updating and pivoting and refining her business models. You can find her at The Mummy Trainer and she also runs a printing company with her husband. We first met Mel in February 2013 and updated in February 2014, March 2015, May 2016 and July 2017. At that point, here was where she wanted to be in a year – and knowing Mel, so much will have changed in two years! “Still studying, still working and still striving to be the best that I can be!”

Hello, again, Mel! So, are you where you thought you’d be when you looked forward two years ago?

Well, I now have a very successful Multi Format Fitness Organisation called Beatz Fitness (originally a clothing line, we loved the name so much, we used it for everything!) that I run with my husband. We have 140 active instructors in the UK and Ireland and thousands of people take part in Beatz classes every week!

I also ran the first Social Media Marketing and Networking Event for Fitness Instructors (FINE – Fitness Instructors Networking Event) on 1 June 2019 and I will be running Quarterly Masterminds in addition to that (the first is on 28 September 2019).

What has changed and what has stayed the same?

My ethos is still the same, my drive has increased I feel! I’m moving more into theory-based tutoring, coaching and public speaking and focusing less on the actual delivery of physical classes.

I also get booked for workshops at events outside of the Fitness Industry (I specialise in Video for Social Media) and I’m working on my first book (which has changed titles and topics so many times)!

Wow – exciting times! What have you learned? What do you wish you’d known two years ago?

That I’m capable of so much more than I give myself credit for – I wish I’d had the confidence to push forward with a few products sooner but then I also believe that there is a time and a place for everything.

Any more hints and tips for people?

Never ever stop learning – Whether that be a course, attending an event, networking, reading a new type of book or podcast, education is important for you to survive as a solopreneur/entrepreneur

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

Who knows? Maybe I’ll finally have that studio I’ve been talking about for years! I’d like to move more into training brands and business coaching within the Fitness Industry, I’ve been doing this a long time now, it’s time to pass more of this knowledge on!

Wow, Mel is certainly a force to be reckoned with, so who knows indeed! I’ve loved seeing her growth and if it’s possible to have more drive and confidence,she’s done that! Good luck for the next stage!

Beatz: www.beatz.fit

www.themummytrainer.co.uk

Info@themummytrainer.co.uk

www.themummytrainer.co.uk

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 (I have a full roster of interviewees now so am only taking on a very few new ones). If you’re considering setting up a new business or have recently done so, why not take a look at my books, all available now, in print and e-book formats, from a variety of sources. 

 
Leave a comment

Posted by on July 27, 2019 in Business, Small Business Chat

 

Tags: ,

Can I print a Word document to PDF and retain the tracked changes?

If you want to print or save a Word document to change it into a PDF, and you have Tracked Changes showing in the Word document, will those tracked changes still show up in the PDF?

I needed to check this myself this morning, so now I’ve confirmed what happens, I thought I’d write a quick article about it, on the grounds that if I’ve had to check, someone else will need to, too (bloggers: this is a good way to inspire blog posts if you’re lacking ideas!).

So here is the definitive answer to the question Can I save a Word document as a PDF and keep the tracked changes showing.

Why save a Word document with tracked changes into a PDF?

This came about because I was discussing plagiarism with a colleague and explaining what I do if I need to confirm from a client’s supervisor that it’s OK to make as many changes as I’m making to their text. I mentioned that sometimes I will send over a copy of the work so far, and sometimes I’ll go as far as to turn the Word document into a PDF so it can’t be altered between me and the supervisor. But will the tracked changes still show up?

Proof that tracked changes still show on the PDF

So here’s my Word document, complete with tracked changes (make sure these are showing):

A word document with tracked changes

Just a reminder that in the newer versions of Word you can save to a PDF automatically without having to go through third-party software. Choose File – Save As then drop the file type down to choose PDF:

Save Word as PDF

Then when you open it in your PDF reader (I use PDF-XChange Viewer), there are all the tracked changes!

Tracked changes showing in PDF

So, if you want to preserve your tracked changes so they can’t be, um, well, changed, printing to PDF will give you an image of them you can share.

I hope you’ve found this useful – do click the Like or Share buttons or comment if I’ve helped you out!

Please note: these tips work for Microsoft Word version 2007 and upwards. They are not guaranteed or tested for Word for Mac.

Other track changes articles on this website

Track changes 1 – why use it, where can you find it, what can you do with it?

Track changes 2 – customising Track Changes

Track changes 3 – working with a document with tracked changes

How do I accept one reviewer’s changes?

Why are my tracked changes changing colour?

How do I get rid of tool tips on tracked changes?

 
Leave a comment

Posted by on July 24, 2019 in Copyediting, proofreading, Skillset, Word

 

Tags: , , , , , , ,