Writing your memoirs is so personal and cathartic. You can resolve issues in your head that you didn’t realise were still causing you pain. Alternatively, you may find that you remember events long since forgotten.
Your memoirs represent you. They are a testament to the life you have led, the dreams you have accomplished or the goals you have set yourself that you will accomplish by the time you retire, or pass the baton on to the next generation.
There are some very loose rules that you should abide by, and these are:
Only discuss the events you want people to know about.
Be honest about the events that took place, it is perfectly acceptable to write from your point of view
Be mindful of the reader and what they will get out of reading your memoirs
Decide on the format of the memoirs. Will you create a book or an audio book?
Think of the length of your memoirs. You may not want to write War and Peace, but we all have a story to tell.
Will your memoirs be funny or serious?
Will you make a passive income from your memoirs? For example, giving talks at schools, clubs and on the TV/Radio. Will you sell your memoirs online?
Are your memoirs for family and friends only?
Do you want to include photographs, if so, make sure you have the authorisation to use the photographs, especially if other people are in the photograph?
Do you have the support of your family members? This can make writing your memoirs so much easier.
Before you write your Memoirs
Before you write your memoirs, create a plan of what you want to include. Are you a business owner and want to discuss how you created your business from nothing and sold it for thousands? Are you a homemaker and loved every aspect of making a home for your family? Did you travel around the world and met some interesting people that had a profound effect on your life?
We all thrive on stories. What is yours?
For our guide on how to start writing your memoris join our emailing list.
I use to dream of being a Writer! I would love to write but don’t have the time! I don’t know where to start, but I have a story!
Questions and statements I often hear from people who would like to become an author, a writer, or publish their memoirs or family memoirs. I can sympathise. When I started writing my books and publishing my author’s books, it was a piece of common ground.
I had a fantastic tip form a young writer who was starting a career as a journalist, short and to the point.
“Just do it, don’t sit there thinking you will write war and peace. Stop making excuses and sit in front of the computer and write.”
Thanks Jack, that is what I did and what I tell my authors to do. In fiction, the story might take a few twists and turns you hadn’t planned on! Characters may quit their jobs or act unexpectedly, so remember the first draft of your manuscript will never be the same as the book that gets published.
When writing your memoirs, things will always pop in your head. One story may remind you of another story. A comment from a friend or family member will often start the next chapter. Alternatively, a comment could help you remember a story long since forgotten that could be pivotal to the memoirs.
Stop procrastination, sit down with a fresh screen or piece of paper and put something down. Once you start you find that you won’t stop. Map out what you want to say. Remember the reader and the journey you want them to go on. When writing your memoirs think about how much information do you want to share?
I have to open this post by stating that I love my Mum very much, but occasionally she exasperates me. I have spent the last 40 minutes helping her with her emails. Three days ago, they stopped showing up on her phone, iPad and computer. We went through all the normal settings and they were all fine.
But I saved my password once, shouldn’t it be automatically?
I was about to tell her she needed to seek an expert, when she casually remarked that she would leave her provider as she wasn’t happy with the services. I asked why. She calmly stated that she changed her password three days ago and has had nothing but issues ever since.
“Where did you change the password,” I carefully inquired.
“On 1and1” she replied.
“Did you change the password on your computer, iPad and Phone?” I asked.
“No, I thought it was athematic,” she replied.
The only analogy I could come up with, was that changing the cotton on her sewing machine and expecting the bobbin to have changed colour as well. At which point she burst out laughing seeing the funny side! Mothers who would have them and technology.
Writing your memoirs is so personal and cathartic. You can resolve issues in your head that you didn’t realise were still causing you pain. Alternatively, you may find that you remember events long since forgotten.
Remote working, working from home, working virtually have all become aspirations that many individuals aspire to achieve. This way of working can be rewarding as long as you understand that there are some advantages, some disadvantages and at times annoyances that will just niggle at you. To ensure that your virtual work is successful, rewarding and most importantly productive, you need to make some adjustments to your mental outlook, your idea of what work is and the distinction between work and home.
I thought it would be useful to speak to a HR specialist about the Coronavirus in the Workplace. What the effects could be on the working day for a small business. I have spoken to a friend of mine, Jane Fryatt from Face2FaceHr, and she has put this article together....
working, working from home, working virtually have all become aspirations that
many individuals aspire to achieve. This
way of working can be rewarding as long as you understand that there are some advantages,
some disadvantages and at times annoyances that will just niggle at you.
that your virtual work is successful, rewarding and most importantly productive,
you need to make some adjustments to your mental outlook, your idea of what
work is and the distinction between work and home.
home starts with excellent communications.
Communication with yourself, your surroundings, your home and those with
whom you share your home. Yes, that even
means the dog or cat.
What do we
mean by communication? What is communication? In its broadest sense, communication is getting
someone to do or act in a way you want them to. This communication can be in writing,
verbally or visual.
However, communication when working from home is the one area of our lives that is so easy to get wrong, with some devastating results. Let’s take a closer look at the communication.
single communique, there are six individual modalities that we must go through
to ensure that, that communique is appropriate to the audience we are
think about a pink elephant.
For me to
communicate this image of a pink elephant; I had to use two of the modalities
in what we call ‘The Communication Wheel’.
Preparation – had to make the decision of what it was I wanted you to think. I selected the topic of a pink elephant.
Transmission – For me to ask you to think of a pink elephant, I had to get you thinking of a Pink Elephant. As we are not a race of telepaths, I had to decide what kind of method communique I was going to use, to get you to think of the Pink Elephant. In this instance, I used the written word to say ‘Let’s think about a pink elephant’. I then used imagery to show you a picture of a Pink Elephant.
So far, I
have used two of the modalities of communication, written and visual. If you were in front of me, I might have used
a verbal instruction to think of the Pink Elephant.
This is when communication gets interesting, especially when working at home, because I no longer have any control over what happens next with my message of ‘Let’s think of a Pink Elephant’, I have just given you. This moves us nicely onto the next four modalities of communication which belong to you the reader:
Reception – Did you read or see what I asked to you do? Was I writing and using words that you understood? Did you know the language I used? Could you see the picture I placed within this document?
Understanding – Did you understand that I asked you to think of a Pink Elephant? This naturally presupposes that you know what the colour pink is and what an Elephant is! Was my instruction explicit enough for you to understand my request? I wanted you to think of something; I also wanted you to assign a colour to that object. I will assume, in this example, that you know what the colour pink is and what an elephant looks like. Did you accept my request?
Acceptance – Did you say to yourself; someone is asking me to think of something, that something is pink and in the form of an elephant?
Action – Did the image of a pink elephant pop into your head? If you thought of a Pink Elephant than you took Action. If on the other hand, you didn’t think of the Pink Elephant, then my communique to you was ineffective, and I used the wrong words or image to get you to think of the Pink Elephant.
Then what did you do? Did you accept my request, my communique to
think of a Pink Elephant, did you take action?
communication. The art of getting
thoughts from your head to someone else, to do something. This thought process generally takes milliseconds,
if you know or think you know what you are being asked to do.
When you are
asking someone to do something for you, you have control over two aspects of
that wheel the PREPARATION and TRANSMISSION after that the control of a
communique is out of your hands. A
communique can fail at any one of the above six steps. If my request was to think of a ‘Red Leaping
Camolopen’. What would happen then? A
Camolopen is a word that you have never seen before, and as such, something
that would have no idea how to visualise. Therefore, my communique would have failed.
Being a virtual worker or working from home, communication is one of the most important tools you have. It is the one tool you MUST master. It doesn’t matter if you are working virtually as part of a team, if you are a one-man-band, or work as a distant contractor. Communication with your team, your customers, or contracting team, you need to ensure that your communications are direct, to the point, and there are no areas of misunderstanding.
There are natural barriers to all forms of communication that are not linked to working from home. For example, if the person you are talking to uses a lot of anacronyms, or ‘business/industry jargon’ and you have no idea what they are talking about or what they are asking you do.
Face to face communication also has
issues, especially when you take personalities, confidence and credibility into
Telephone calls can be misunderstood
if the person on the other end of the telephone is only half listening to what
you are saying.
Emails can be very sort and to the
point, but the reader could take offence if you haven’t put in the necessities
like Dear Julie and go directly to ‘Get this job done asap’. This email could be seen as yelling at the
reader and instructing them to do something right now and you as then sender
don’t care about them or their feelings.
Once you have mastered your Communications when working from home, you could then set up a road map or stand of how you communicate to your colleagues, clients and line manager. This list is just a suggestion but find the that best suits you and your working environment.
To conclude, when you are working remotely, or working from home, or virtually bear in mind that your communications to your team, clients’ needs to be clear, you need to pay attention to what words and images you are using and what it is you are trying to communicate to the person receiving your communique.
It is easy
to half-listen; briefly read a request and think you understand what is being
asked of you and then go off at a tangent and get it completely wrong.
is also vitally important to that inner voice you have. That little voice that controls your
thoughts, your actions, and how you feel about yourself. There is not much point in telling the world
you are ‘the best thing going’ if that little voice keeps repeating back to you
“Yeah right, whom are you trying to kid!”. Take time in answering, writing or devising your
communications. Sit back and ask
yourself what it is I am trying to get across to people? Does this letter, article, blog, email, tweet,
text, image say precisely what it is you are trying to say?
body language, your attire portray the image you want to express? Just think of walking into a bank, how
comfortable would you be dealing with your financial matters to someone dressed
in ripped jeans, dyed hair, nose ring, torn t-shirt and a cigarette hanging out
of his or her mouth?
just as important as getting the correct message across to an audience, even if
that audience is an audience of one (A conversation). If I asked you name how many types of listening
there are, how would you do?
Most people will
name two. However, there are three types of listening I want you to pay
Passive Listening – This is half listening to what is being said to you. I am
sure you have practised this before, think of a time when your partner
has asked you to do or say something, and you didn’t do it. Not because you
were mean, but because you just didn’t remember. Listen out for the words ‘You never listen to
me?’ Passive Listening has its place when you are at home, and the kids are in
the garden playing. You are listening
out for any issues that may occur. However,
in the workplace, this isn’t as effective, especially if you have been given a
detailed task to complete.
Reflective Listening – This is a brilliant tool for Virtual working. Reflective
Listening is listening to a list of tasks that you have been asked to
complete and then repeating it back to the person who has given you the task
but in your own words.
For Example: The contract for the window cleaner is on the cabinet, next to my telephone on the right of my desk. Can you please collect it and post it back to the company and get the windows cleaned as soon as possible?
You want me to post the contract back to the window cleaners and get the windows done asap.
Here you are accepting what has been
said and using your own words to repeat back what has been reported to avoid
Active Listening – This is when you are paying complete and utter attention to what is being said. Nothing else matters the world could be falling around you, and you don’t take any notice.
When working virtually, you should engage your active listening
skills. Nothing else should be happening;
you are not putting the kettle on, emptying the dishwasher or eating your
lunch. You are listening to your work
colleague, client or employer.
As an aside, Active listening for 1 hour takes as much energy as a
3-hour A level maths exam. Next time you
attend a meeting with a minute take, bare that in mind!
Consistency has to be the by-word for Virtual
Workers. This is about maintaining your personal
standards of performance or behaviour when working away from the office and the
watchful eye of your line manager or client.
Consistency is bringing in a standard of performance
to your workload and ensuring that you keep to that standard all week/month or
through the entire project. We all know
someone who turns up at work on:
Monday – Determined to fly through their workload
Tuesday – Just as determined but slightly slower than yesterday
Wednesday – Longer coffee breaks creep in, but the workload
Thursday – Workload is done, but no passion/enthusiasm,
speed is slower
Friday – No work completed as the output for the week is
Your aim for being consistent should be that when you
start work on a Monday at 9 am full of enthusiasm and that enthusiasm is still
there at 5 pm on a Friday. A virtual
worker is judged on outcomes, not the number of hours sat in front of a
computer. The boss is not discreetly
watching you. They are making judgements
from your finished pieces of work.
Consistency comes from continuous improvement – looking
for ways in which tasks can be achieved more effectively and efficiently. Challenging the processes and norms the way
the team or organisation operates. This
way improvement across all areas helps strengthen the team working and output,
which in turn protects future development and employment.
Of all the resources we have at our disposal, time is the one which is
often the one that we say we do not have enough of. “I just run out of
time”, “it will take too long to achieve that task” and “there
are not enough hours in the day to do everything I have to do”. The perceived lack of time is not the sole
view of senior managers as it is for junior staff.
One constant in our working day is time. It never changes, although it
appears to slow down or speed up depending on our enjoyment of a task or not.
Another common reaction to the lack of time is it is others who are responsible
for us not having enough or adversely affecting how we manage our own time.
Everyone has responsibility for managing not only their time but the
time others require to get a task done. Setting deadlines that place others in
an impossible position is not good time management – its abdication or simply
put ‘passing the buck’.
Everyone has a responsibility to maintain standards and meet targets or
personal work objectives. Excellent organisational skills, problem-solving and
decision-making skills are fundamentally essential to time management. It is in
these areas the problems often lay, but we often simply blame poor time
management on an individual’s inability to get the job done quickly enough.
Speed is not always an option, but working efficiently as well as
effectively is what it is really about.
If you find you run out of time, you may need to look at the tasks you
Is the current task important in the grand scale of
the jobs at hand?
Can the task be delegated to someone else?
Is the task important right now?
Has your boss, line manager, client forgotten the
other task you have been requested to do for them?
Are you planning your time effectively? Are you
working SMART or just working?
Setting priorities is about deciding what must be done, not what should
be done as well as what will have the most significant impact – whether this is
positive or negative. Knowing how long your primary tasks take and how it may
affect others in the chain is essential.
Knowing which task is essential, not just for you bur for your boss,
your client or your business is vital.
There is no point planning a Christmas Dinner for the team in March when
the VAT is due in three days!
Everyone is in a chain of supply of some kind. Whether this is information or physical
activities – and each person in that chain plays a part in the achievement of
outputs. If someone at the start of the process takes too long, the loss of
time is multiplied by the time it gets to the last person.
This is essential but often overlooked because we believe if we dive
straight into a task, we will finish it quicker. In fact, poor planning usually
results in tasks being done again or corrected because they are completed
incorrectly. This is where we lose much of our time by rushing and not
preparing properly. We must challenge the process and be sure it will deliver
what is required. Just working more quickly is not the answer.
Some tasks cannot be planned if they are emergent in their nature. An
example of this could be reception or telephone answering. They do not know what the task is until the
phone rings. What they can do is have good working practices and processes in
place to deal with most types of calls. We all have some ‘downtime’ in which we
can identify what can be done in readiness for the next peak in a workflow.
If you can plan 60% of your day and leave the remain 40% of your time
for unexpected calls or clients, you are doing well.
Not everyone has a tidy approach to working. Often people with messy
desks, for instance, know exactly what they are doing, while those who have
neat and tidy desks are regarded as more organised. However, your working environment should be
conducive to your working methodology, if you are able to work with a messy
desk, that is fine, but if you can’t and get to distracted, organise your office,
yourself and then get on with the day’s work.
Being organised is about how an individual meets deadlines and targets
and how they make decisions about what is important or urgent. One useful thing
is to break down large tasks into ‘chunks’ each with a realistic target.
Sometimes when we do this, we will identify specific areas of a process
that will provide the biggest challenge.
We all work with others, or at least our work is affected by or affects
others. To be a good time, managers is about working with other people and
building relationships that complement each other’s needs. Before we request Action
from another person by a specific deadline, we must ask ourselves whether it is
reasonable, and we have presented our output correctly. It is not their
responsibility to correct our mistakes.
Delegation is not the sole domain of managers passing tasks downwards,
although the most common form of delegation. We can all delegate, whether
sideways to a colleague or upwards to a boss if we need help in getting a lot
of priority work completed on time. When under pressure the question, we must
ask ourselves is ‘who can help?’
Good time managers use others when the occasion arises. It may only be
to check out some information, make a phone call, deliver some work, share a
task or provide advice and guidance. It does not necessarily mean we pass a
complete task to another person, though this is an option. We must remember
that if the task is ours, we can only pass on the authority to do it but retain
the responsibility. Otherwise, this would be abdication.
Interruptions are inevitable but can be managed with assertive
behaviour, even from our close colleagues and friends. Excellent interpersonal
skills will help and most often, people will understand if approached firmly
We must learn to say ‘no’ and/or not take on the responsibility of
someone else’s decision making. The boss that places too many tasks on an
individual must be the one to decide what must be done and in what order. Every
job has a penalty if not completed. You may only have authority for certain
levels of work.
It is interesting to note that there are different types of work that
are done on anyone day. When working
from home, know what kind of work you are doing could help you to prioritise, plan,
become pro-active, organised and help you delegate to others and manage interruptions.
Core Work – Core work involves not only individual but also a shared
responsibility for meeting a business objective and carrying it out to an
agreed standard. These tasks are important to fulfilling an individual’s
primary work objectives.
Reactive Work – Reactive work is those that although related to an individual’s role
often occur with little, or no notice and generated from outside the person’s
immediate control. They are tasks that others request or instigate and have
timescales based on their needs. These tasks also include those of standing in
for colleagues or dealing with enquiries and problems.
Improvement Work – Improvement work is that which helps to improve the process of work
or develops staff. Such tasks can involve the reviewing of work processes, on
the job training, coaching, and making specific changes to the way things are
done. These tasks can fall outside of the job holder’s primary duties.
Incidental Work – Incidental work is where the job holder’s involvement is regarded as
necessary but in fact, serves no real benefit to them helping others solve
their problems, attending meetings for no apparent reason and spending time
discussing issues that do not concern them. Work can be sub-divided into types
Urgent and Important and both need to be fully considered when organising and
Urgent Work – This is work which must be completed by a specific time frame,
whether a time of day or date. It can also be tasks that need to be auctioned
at a required speed depending on its place in a chain of events or process of
Important Work – This is based on the seriousness of the consequences or implications for
others if it is not done. Maybe a task that enables someone else to achieve
theirs or one that has a financial implication.
Most people like to do a ‘To Do List’ to either guide them through a
busy period or simply to martial their thoughts and get some sense of order before
tackling the day’s business.
Unfortunately, this may only be a linear list in a random order, and
often we select those tasks we want to do first before those we should do next.
A Priority Grid could help to segregate tasks into groups and give a more holistic view of what needs to be done and in what order. This could be advantageous when working from home.
work is just as important as how you work.
If you have an extra room in the house that can easily be turned into an
office that is fantastic. Not many
people have extra space, so find a location that is suitable for the family. Where you won’t be disturbed and an area in
the house that you can close the door and say that ‘Works is done for the day’.
nothing worse than setting up an office on the dining room table and having to
remove the office every time you want to eat as a family. Keep your work area as work and your home
area as home, if at all possible.
office needs just as much space as you have in a regular office so be kind to
yourself, you will, on average spend 8 hours at ‘work’ it needs to be conducive
to produce your best work.
Be kind to
yourself when setting up the office, try not to hide in the corner or take conference
calls sitting on the stairs as there is nowhere else to sit. Don’t have your
computer camera facing your bed. It’s great that you are working, but we don’t need
to see your bedroom or your unmade bed.
People will be looking past you, and at the environment, you are living
and working in!
advantages to working Virtually. There
is the flexibility of deciding when you want to work and who with. It can be considered convenient, especially
if you have a disability or other personal commitments. You are in control of your day, your space. You won’t waste time sitting in a car, on a
bus or tube and can be extremely productive and focused, especially if you are
able to set your schedule.
But there are more disadvantages as well when you are working from home, and these should never be forgotten or deemed to be inconsequential. The problems can sometimes be more of a mental block but just as, if not more important when working on your own.
You are always at work and could find that you never leave your house, that can result in you become lonely and becoming disconnected from work.
You no longer have a place of rest, your home is now the workplace which can be very stressful
Distractions are increased with daily living and family just popping by
There is the Isolation, lack of social connection, a self-imposed ‘solitary confinement.’
No praise for the work you have done. Even when you have done an excellent job, you are now judged by the results you turn in and not the effort you are putting in.
You need to become Self-disciplined and a master of every office facility from the IT department to the cleaner
You can get bored with the task you are doing and do something more interesting, like the ironing.
Lack of collaboration and when you are stuck, you are stuck, there is no one there to help, and you can suffer burnout or
Proper tools for the job
Left out of discussions and feeling ignored
Lack of collaboration when working from home can result in a lack of solution thinking
Inconsistent, chaotic work pattern – starting work at 3 pm and finishing at midnight
Recommendations when Working from Home
Don’t work in your bedroom when you work from home if at all possible. The bedroom is for sleep and resting your brain. It should not be your office.
Create A schedule and stick to it. If you work 9-5 make sure you work 9-5. Then turn off the computer or telephone
Ensure your communication strategy is effective
Every now and then join a co-working space, so that you have the interaction with others and can meet people
Get out of the house, take an hour’s exercise. Do something so that you are not staring at those four walls – always
Schedule group chats with staff or co-workers or even clients
Take breaks from the computer, just as you would at work, step away from the computer and rest your eyes, have a glass of water to refresh your brain. Take a lunch break
Do some exercise, 10-star jumps, push-ups. Anything to get the blood pumping and your mind off your workload
Currently network online, when possible network in person, meet other businesses. Networking isn’t just about promoting your business; it’s about you are meeting other business people.
Working as a virtual worker, working from home as a PA Trainer and Publisher is one of the best jobs I have ever had. I like to control my hours, my schedule, and with whom I work.
It has given me the confidence to push my business
forward, to ensure that I am self-sufficient and that I am the master of my own
destiny. I have created systems that I use
and stick by that have worked for me and continue to work for me.
You can do it, just have faith that you know what you are doing, that you will find your way when you have made the decision to start working from home and that at the end of the day, work is work. Home is home and life does not mean that work is all-encompassing. Be kind to yourself when you work virtually and at home. You are doing your best, and if you can say honestly that you have worked to the best of your ability, that you couldn’t have done anything differently that you have been a successful virtual worker you have cracked this myth that working from home is hard or difficult. Julie Farmer
I thought it would be useful to speak to a HR specialist about the Coronavirus in the Workplace. What the effects could be on the working day for a small business. I have spoken to a friend of mine, Jane Fryatt from Face2FaceHr, and she has put this article together.
“We have been asked by a number of clients about coronavirus (COVID-19), mainly queries around pay. There is some excellent guidance available from Acas here covering steps employers can take. It is worth having a read of that. In the meantime, here are some common queries we’ve been asked and my response”.
When someone is self-isolating, do I need to pay them?
If someone is actually ill, your normal sick pay arrangements will apply. If they have been given written notice by a medical professional to isolate themselves, statutory sick pay will apply (and while it’s not a requirement, it would seem sensible to pay any enhanced sick pay you normally offer in these circumstances as well). The Government has announced that statutory sick pay will apply from day one rather than day four, and that emergency legislation will be passed to enact this very shortly. If someone has just decided to self-isolate, they are not entitled to be paid at all. However, if they are not ill but have been asked by you not to come into work, they should be paid in full as usual.
What happens if employees have to be off because schools shut?
In these circumstances the emergency dependants’ leave provision would apply, i.e. the employee would be entitled to a day or two unpaid leave to resolve the emergency, following which alternative arrangements should be made. Any longer absences should be dealt with using unpaid leave or annual leave.
Should I be developing contingency plans?
Yes it would be a good idea to do this if you haven’t already. Consider how you could make best use of remote working to keep your business going in the event of employees needing to stay at home. Think about cascading communication of any measures you may need to take, as the situation is changing quickly, and consider how flexible your business can be in terms of keeping going on a skeleton staff if necessary.
Will I have to pay staff if I have to shut the business for a period due to the Coronvirus?
It’s not recommended that you shut your business completely if someone develops symptoms. In the unlikely event you need to do this, you will need to pay staff unless there is provision in your contract or other agreement for you to do otherwise. If you’d like any specific advice about the workplace implications of coronavirus, please do get in touch with Jane Fryatt.
If you would like an introduction to Jane via myPA Virtual Services contact me.
As a Virtual PA, I get asked for advice on how to use or do a simple function within a Microsoft package, today I have been asked how do I copy a formula in excel. For those of us who use the software all the time, it is almost second nature and can be difficult to explain. Nevertheless, some people don’t use Microsoft packages daily and need a little more help. Most Virtual PAs ask you to send the document to them so they can do the work for you.
Therefor, today I will be explaining how to copy a formula in excel from one cell to another. Any experienced Virtual PA will be able to do this for you in about 15 seconds. This would include opening the document, making the change, and then saving and returning the document to you. This does not, however, teach you how to do the task yourself and can cause hours of distress and frustration.
For this reason,
myPA Virtual Services have decided that we are going to run a series of blog
posts that will teach you how to do these tasks. We hope
that you will find the instructions easy to understand and increase your
knowledge of Microsoft.
HOW DO YOU DO
How do I copy a formula in Excel from one cell to another?
Open the Excel Document and locate the cell with the formula.
A cell is an individual area on an excel sheet, a square, highlighted in the table below. From this image below we have highlighted cell A1. In an Excel document, you will have a Workbook, a Sheet, Columns, and Rows. A cell is contained in a workbook, which is on a sheet that is located in one column and one row.
the cell you want to copy – A1 for example.
your keyboard select CTRL button and C at the same time, see the image below.
Alternatively, right click on your mouse and a new screen will appear. From here select copy. You have now copied the cell sum/information
the cursor to the cell you wish to put
your keyboard select CTRL button and V.
Alternatively, right click on your mouse and select Paste
You have now copied the sum/formula you wanted.
Workbook The whole excel document
A Sheet Within the document you can have some sheets. Look at the bottom left of your workbook; you will see the word Sheet1. This is your first sheet. To add a new Sheet select the + button to the right.
A column A
column is the vertical lines in the workbook and are annotated with Letters.
A Row A row is the horizontal lines in
the workbook and are annotated with numbers.
I am not one for setting New Year’s Resolution. I have only ever set one before today. That was last year. To be honest, I find them a bit tedious, and most of them are very mundane and a bit boring. Not only that, my friends that have set New Year’s Resolutions have on the second or third broken them or have just forgotten that they had a resolution in the first place. Evidence has just published states that most New Year’s Resolution are broken by day 15Nevertheless, people are still trying to make changes for themselves. Instead of concentrating on making more significant changes for a year, they are now looking at making changes for a single month only. Dry January or Veganuary are prime examples.
Last Years New Year’s Resolution
Last year, I made a very lose New Year’s Resolution to improve my communications skills with my family, friends and clients. As I run a Micro business, excellent communication is one of the critical skills clients expect from me. I feel that I achieved this goal and am satisfied that the year was more rewarding because of it. However, I cannot quantify that with anything. I kept no note of what I did, how I improved my communication and what those around me felt. For the most part, I just ‘have a feeling it went well’.
Being Proactive about numbers
I have decided that I need to be more proactive in my
undertaking. This year it’s all about
business life and personal life are almost the same things. Therefore the numbers
I need to know are for both areas of my life. Identifying
these numbers will become paramount for this year. For example, the amounts in my bank account, the financial life cycle
of my client’s, know that magic number on the bottom of my balance sheet and
Profit and Loss. Knowing the numbers on the scales. I am really excited about this New Year’s Resolution.
To me, it is all about information. The more information I have, the more I can help myself, my business and my
clients, in that order.
My New Year’s Resolution is depressing! NOT.
To my utter surprise, most of the people I have spoken to
think that this is a very depressing New Year’s
Resolution and I should change it to something more exciting. A few suggestions have been:
Getting more clients
Giving up coffee or chocolate
To lose weight
Increase my profit
Double my savings
Planning holidays to a far-flung destination
These are all excellent suggestions, but surely that is what I have just said my New Year’s Resolution is all about. For instance, knowking your numbers is about understanding all of those things. Knowing how much money your business has, is just as important as the number of client’s you have and want to increase by. I could, for example, get 40 new clients, but if they all bring a profit of £100 each per year and take all of my time to look after, that won’t do much on the bottom line. An increase of £4000 at the end of the year. Wouldn’t it be better to understand the life cycle of the client before embarking on a working partnership? To lose weight is just the same. How many pounds do I want to lose?
My New Year’s Resolution is all about those numbers. However, most people seem to be afraid of them. Of knowing what they are, what they mean, and they need to be. For example setting a budget for my business on marketing, on expenses. Setting a budget for my household shop, all numbers.
I am genuinely excited about my New Year’s Resolution because I understand it. Likewise, I can see that if I accept that this year is all about numbers, then at the end of the year I would have had the most profitable, beneficial and rewarding year.
I will be honest with you, last year I was frivolous where numbers were concerned. If I wanted something, I went out and bought it. Additionally, if I wanted to take time off work, I did. My thought process was more about what do I need to get done to survive and not what can I do to be spectacular. My communications with my clients improved, for example, I stayed longer with clients, just for a chat, gave my time away for free or didn’t charge clients for the work I had done.
What was the result? To begin with, I got by and I am not ashamed to admit it. For instance, the company survived, could it have done better. Yes absolutely. In addition, did I lose weight? Yes, I joined Slimming World and lost some weight. However, could I have done better, absolutely.
This year I don’t want to get by. To begin with, I want this year to be fantastic, I want to experience everything and do more and go to more places. As a result, I have to start to know my numbers. Knowing what it is I want to achieve and therefore, I need to know how to get there.
Just putting it out there – Here are my numbers
This year I want to lose 30 pounds in weight
This year I want to increase my net profit by
This year I want to double my savings
This year I want to pay off all debt
All of the above is about numbers and how I see them. Therefore, I don’t or can’t see that this is depressing, daunting or a waste of time. Surely if I know what my current numbers are then, I can set goals to achieve those numbers. They may look like big numbers to you, but to me, broken down each month they are tiny. As a result, I am not setting myself up to fail. However, I am setting myself up to succeed. To make sure that this year will be twice or three times better than last year. Consequently, this year it’s all about my the numbers.
When we think of a Travel Consultant we think of big shiny offices or shops on the high street. The traditional Travel Consultant is changing and there are more opportunities to work from home. It truly is the age of the computer and internet.
What can a travel consultant do?
In essence, they make clients life easy by organising all their travel arrangements. This can be either for business or personal and both. Booking holidays, booking flights and hotels all takes time. A travel consultant takes this hassle away from the client. It will also mean that you will have to do some research into making the correct judgement and getting the right hotel booking and a good price.
It will also mean that you will have to do some research into making the correct judgement and getting the right hotel booking and a good price. Therefore understanding your client’s budget and personal requirements will be of vital importance. You could possibly have your client’s credit card details, so confidentiality and trustworthiness are essential. Discretion will also need to be undertaken.
It would be an advantage to have a list of local hotels and conference centres available in your area or create an approved suppliers list for your client’s.
There are some insurances that you will need to undertake with this type of job and training. However, there are franchises that you can purchase that will guide you through the process. This is an excellent way to get the backing of a larger organisation while still working for yourself at home.
Suggested Skill Requirements
A good understanding of clients’ needs. Knowing your client’s likes and dislikes would be an advantage, but through careful questions and open and honest discussions, you will be able to find out their exact requirements. You will need to be thorough and precise in what they want and what you can deliver.
Thinking on the spot
Organised. You need to know what is going on in your market. Knowing what offers are on in particular hotels and holiday resorts. Having a preferred list of hotels and taxi that you rely on will also be an advantage. Keeping records and a plan will be a must.
Flexibility. You will have to understand and know that business clients will change their minds and plans at the drop of a hat. You need to stay flexible at all times and work towards their time frames requirements.
Excellent IT skills. Keeping records and understanding how IT systems work will be a must. There are some websites for Travel Agents that may be useful for you to use.
Ability to work under pressure. Travel can be very stressful for some people, and they will rely on you to walk them through the process. If you are booking holidays, then remember that this is their only time off work and they have a dream that they are expecting you to provide.
Ability to work to tight deadlines. Knowing all deadlines will be of vital importance, and you will need to work to those deadlines and ensure that all subcontractors understand the time limits.
Research, digest, analyse and present material clearly. You will need to know your market inside out, make suggestions and help your clients make the right decisions for them. There will be some clients who know exactly what they want, but others will be relying on you to contribute to making those choices.
Excellent interpersonal skills. Understanding customer services is vital and speaking to them in a language that they understand and feel comfortable with is be an advantage.
In addition to the above you will also need to:
Honesty and reliability
Attention to detail
Discretion, understanding and confidentiality
Use of Word to create forms etc.
Further Reading if you want to work from home
In conclusion, you may like to find out what jobs you could do working from home from our book entitled ‘Jobs to do Working from Home‘ by Julie C Farmer.
Have you created basic websites for yourself that you are so proud of? If so, you could offer this service to other people who are looking for a basic website. This includes purchasing a domain name, web space, and the collecting information to include on the website.
You will also need to know if your client is prepared to pay for the website content and/or professional design. It will also be useful to know if your client is going to add content to their website themselves or ask you to update the website.
Creating simple or complex websites are perfect for home workers.
Suggested Skill Requirements
Computer literate. You will need to know how to use a computer and some online packages, for example, WordPress, 1and1, Go Daddy or any other website provider or host.
Basic knowledge of website setup and design processes will be vital.
Know which websites are free to set up and which are not and deciding which website will suit your client. It could be that you buy in a template and help to populate the website. This would be very useful if they have an e-commerce site and uploading products can be very time-consuming and costly.
Listening skills to understand your client’s requirements and how much the website means to the business. If the website is going to be selling their products, then it needs to represent their branding, their ethics and ease of use.
Project Management. Creating a website can be a lengthy process so knowing the time scales. Understand and explain the iterations and content timelines to your client.
Analytical and logical thinking. There are times when your knowledge on the design and function of a website will be greater than your clients, so you will need to suggest options, plugins or design features. You will also need to understand that a website is a logical piece of equipment that follows a strict set of rules. Taking your client through this process will be important and getting them to understand the limitations of a website will be useful.
The ability to envision business situations. You will need to look at a business as it is today and see where the business will be in 3, 4, or 5 years. Then ensure the website is able to grow with the business. Remember most websites have a 3-year life span. After three years, the website may need to be redesigned, rebuilt or modernised. Keeping your client happy will be vital to this process.
Intellectual Creativity. Creating a website means that you are using your creative skills. The ownership and updating of the website will be something that will need to be discussed quite quickly with your client. Remember if you make it difficult for your client to work on their website or with you, they will walk.
Further Reading if you want to work from home
In conclusion, you may like to find out what jobs you could do working from home from our book entitled ‘Jobs to do Working from Home‘ by Julie C Farmer.