In order to be consistent in how certain data is spelt/displayed in Excel e.g suppliers, persons names, products a list can be created in Data Validation – being consistent makes it easier to filter, sort and use the information in formulas. Here’s a step by step guide to creating a list …
Update – VACANCY FILLED but thanks for looking.
Are you looking for a new bookkeeping job? Part time?
We are recruiting:
Experienced Bookkeeper, SAGE / Excel competent (plus QuickBooks experience or happy to learn)
12 hours p/week £21k pro rata
To work at our office on Parkgate Industrial Estate, Knutsford
Please email your details / CV to
Thank you to R.Anderson, Knutsford for the following emailed testimonial:
“I recently undertook a series of ‘Upskill’ training sessions at Knutsford Admin in Microsoft 2010 Outlook, Word, Excel and Powerpoint. This was conducted on a one to one basis, tailored to meet my individual requirements and carried out in a professional and relaxing atmosphere. I highly recommend Knutsford Admin to meet all your training requirements, no matter how simple or complex.”
Do you wish you knew a bit more about Microsoft Office Word and Excel? Perhaps you don’t feel confident and would benefit from some extra help showing you what can be done and where to look to find out how to do tasks.
If you’re new to Excel and Word 2010 you might not be familiar with ‘The Ribbon’ and its functionality.
Essentially everything with The Ribbon is easy especially when you know where to look!
We know people have enjoyed learning at our office. Training is on a one to one basis or as part of a small group, max of three. It is possible in this setting to tailor the learning to what you as an individual need to learn.
Do get in touch if you have something you would like to learn more about in Word or Excel.
Meanwhile click to see our simple guide to adding regularly used text into your Word document Microsoft Word Quick Parts
If you are looking for training on Excel in Knutsford, Cheshire, then we’ll be happy to share our knowledge with you and have produced a ‘menu’ of some of our favorite uses for Excel.
Please click on the link below to see examples of what you can learn.
We look forward to hearing from you.
Below is a list of the available times in Knutsford, Cheshire, for training slots to be booked within.
It is sometimes possible to offer a degree of flexibility so please ask if the time you wish for training is not displayed.
Any times between the hours below
MONDAY 09.00 – 20.30
TUESDAY 09.00 – 17.30
WEDNESDAY 18.30 – 20.30
THURSDAY 12.00 – 20.30
FRIDAY 09.00 – 17.30
SATURDAY 09.00 – 17.00
For a printable list of days of week and times please open this PDF.
Knutsford Admin Training Dates Availability Winter . Spring 2014
Knutsford Admin, a provider of bookkeeping, credit chasing, Excel/Word/PowerPoint training, admin and secretarial services for local businesses is expanding. The business was established in 2011 and has been growing steadily for 3 years.
We are looking to recruit a qualified bookkeeper on a part time basis. Approximately 11 hours per week to suit personal circumstances.
This role is based at our office on Parkgate Industrial Estate, Knutsford, though occasional visits may be required to client’s premises.
Due to the varied nature of the business it is essential that the qualified bookkeeper is proficient in Microsoft Office, with excellent Excel skills and has a professional telephone manner. We use SAGE and QuickBooks, experience in one is essential, both is desirable. A love of I.T will definitely help in this role.
Please send your CV and covering note to Helen Rogers, [email protected]
Closing date for applications is Friday 6 December 2013
From time to time people ask what we do, “what is Knutsford Admin?”. Here are some examples of projects we’ve worked on:
A necessary evil that we approach in a persistent and persuasive manner.
Databases & Research
Databases often evolve over time and can become messy. We took a client’s database and sorted it into a more orderly fashion. The list from Excel has now been imported into MailChimp. From there it is managed in a consistent way and mail shots are send to filtered sectors of the list as appropriate according to the criteria chosen.
In order to complete the task it was necessary to spend some time researching if the data was up to date, this was carried out by web search, emailing and telephoning.
Type documents up to look professional and these are then bound with covers if required.
We love Excel! We’ve created and trained people on good spread sheet solutions that helps them keep their data in good and efficient order. Particularly like formats like the =INDIRECT one that pulls information together by criteria.
Advised on spread sheet completion for uploading to other software e.g SAGE and e-commerce sites.
Our Excel training courses help establish good practice when using Excel. We provided bespoke training to a client who wanted a quick and robust invoicing system creating.
Look after client’s email accounts, telephones, laptops when they go on holiday so that their customers receive personal responses rather than ‘we’re on holiday’!
Client needed to make a substantial claim for loss of earnings due to extensive telecoms problems. We liaised with the loss adjustor, organised his visit, provided all the paperwork necessary whilst the client was able to carry on working to re-establish his business. The claim was swiftly settled without complication or delay.
Take minutes and type them up concisely and produce them swiftly.
We inherited an untidy QuickBooks and have carried on the weekly inputting routines whilst slowly and carefully tidying up some of the old debtors and creditors. The aged debt, for example, is now much healthier looking with just a matter of pence in the over 60 days.
Co-ordinated job vacancy adverts, received applicant details (56), presented to client and helped made his list of potential candidates. Communicated back to applicants.
Organised the interview day so that the process went smoothly and kept to the time schedule. This was followed with second interviews and site visits.
Along side running the day to day SAGE activities we’ve helped a client manage their large number of customers within SAGE by establishing a customer category code system – this enables easy annual invoicing to customer types and enables reports to be filtered by customer type.
Make calls on behalf of clients when perhaps tact and diplomacy and a third party voice is beneficial.
Have liaised between web designer and client to advised client’s on what volume of text and images were needed and where. We’ve helped put these together in an organised, and easy to understand, fashion and sent to the web designer to implement.
… we also enjoy transcription, travel booking and any other tasks that we can devote time to while you can continue to work in your business.
What does your image say about you …
We’re running a Photo Session with Cheshire photographer www.paulworpole.com on Friday 11 October 2013.
See here for more details OCT2013 What Does Your Image Say …
Microsoft Excel Training dates for Autumn 2013
Monday 14th October 6.00pm to 8.30pm
Friday 25th October 9.15am to 3.00pm
Thursday 7th November 6.00pm to 8.30pm
Friday 22nd November 9.15am to 3.00pm
Please enquire for individual tuition at times to suit