Microsoft Excel 2019 Expert

Name: Microsoft Excel 2019 Expert
Author: admin

About the Course

The course consists of 13 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding.

The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.

Course Info

Duration 22 hours. This will vary based on prior knowledge and ability.

Training Type Course

Study Type In centre, Online

Awards & Qualifications

Awarded 22 CPD points upon successful completion

Is this course right for me?

In this course, you will learn advanced-level features of Microsoft Excel, such as macros, PivotTables, PivotCharts, and data analysis tools to help you make data-driven decisions.

Is this course for you?

This course is for those who are proficient with the basic and intermediate concepts and features of Excel and wish to build on their abilities with spreadsheets by leveraging Excel’s advanced features.

Awarded 22 CPD points upon successful completion

Duration 22 hours. This will vary based on prior knowledge and ability.

Course Content

Course Content

Module 1: Using Functions

Using Functions; AutoSum

Module 2: Date and Time Functions

Basic and Complex Date and Time Functions

Module 3: Text Functions

Using Text Functions

Module 4: Logical Functions

Filling Cells by Using Flash Fill; Using Logical Functions

Module 5: Lookup Functions

CHOOSE, HLOOKUP, and VLOOKUP Functions

Module 6: Financial Functions

Financial Functions and Terminology; Personal and Professional Financial Functions; Depreciation

Module 7: Statistical Functions

Statistical Functions for Description, Forecasting, and Inference

Module 8: Connecting to External Data

Connecting to Other Workbooks, Access Databases, and Web Data Sources; Using Get and Transform Functions

Module 9: Macros

Recording and Managing Macros; Copying Macros between Workbooks

Module 10: Tables

Working with Tables; Table References; Table Styles

Module 11: PivotTables

Working with PivotTables; Filters and Slicers; PivotCharts

Module 12: Data Analysis

What-If Analysis; Scenario Manager; Using Goal Seek and the Solver Program

Module 13: Graphics and Charts

Area, Surface, Radar, and Bubble Charts; Sparklines; Stock Charts; Dual Axis and Other Charts

Course Overview

Aims and Objectives

The aim of the course is to build on your knowledge and skills with the Excel 2019 application to gain advanced-level skills.

Career Path

Microsoft Excel is used across a wide range of job roles. Your new skills with the software will make your work more efficient and more valuable to employers.

Pre-Requisites

This course follows Excel 2019 – Part 2.

April 2024

April 29 - April 30 Microsoft Project Complete – 2-day course

Microsoft Project Complete – 2-day course

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

April 29 - April 30 Project Management Principles

Project Management Principles

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 2024

May 1 @ 9:30 am - 4:30 pm Better Business Writing

Better Business Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 2 @ 9:30 am - 4:30 pm Personal Development Workshops

Personal Development Workshops

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 2 @ 9:30 am - 4:30 pm Management Skills

Management Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 7 @ 9:30 am - 4:30 pm Excel Intermediate

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 7 @ 9:30 am - 4:30 pm Time Management

Time Management

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 7 Adobe Photoshop

Adobe Photoshop

May 8 @ 9:30 am - 4:30 pm Influencing Skills

Influencing Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 8 @ 9:30 am - 4:30 pm Report Writing

Report Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 9 @ 9:30 am - 4:30 pm Excel Intermediate

Excel Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 9 @ 9:30 am - 4:30 pm Personal Development Workshops – Assertiveness

Personal Development Workshops – Assertiveness

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Testimonials

“I started doing a Secretarial Diploma at Pitman because I had been working in retail since graduating from university in 2008. I had pretty good admin skills but no qualifications and felt like I was stuck in a rut. Pitman was a perfect fit for me because I was working shifts at my job at Glasgow Science Centre and could come in whenever I was free.
At first I thought I was just going to be getting a qualification for skills I already had but I actually learned a lot more than I expected. Modules like Effective Business Communication were helpful and I did electives in Access and Introduction to Medical Secretary which was extremely helpful in getting my new job.
In May 2013, before I had even completed my diploma, I started my job as an Audio Typist for the NHS. I had been searching the NHS pages before I started my diploma and it took the help of Pitman to actually help me find a job. My typing and audio typing skills along with the medical terminology learned in Pitman have been essential in my progress within my job with my manager telling me she feels I have a career in the NHS ahead of me.
I just discovered today that I received a distinction for my diploma and am now thinking of where to move up within my new sector. Without Pitman, I don’t think I would have been able to get out of retail so I’m very happy to have chosen to take this course!”

EJ – Secretarial Diploma

General Diploma, Private Individuals, Secretarial Diploma

“I left school in 2010 with 3 A-Levels and the opportunity to study at a top university. After a year working in retail alongside unfortunate periods of ill-health stemming from a medical condition that I was born with, I decided that university just wouldn’t suit me. The decision to ‘skip’ the university step lead me to Pitman Training.
I studied for the Executive PA Diploma, starting in September 2011 and completing by April 2012. My electives were Marketing, PR and Advertising. I studied Teeline shorthand and attended the Executive PA seminar.
Following completion of the Executive PA Diploma, I was immediately signed to Office Angels’ temp books and quickly became their most requested temps. I worked for a variety of organisations including law firms, wealth management firms, business centres, health centres and accountancy bodies. I even did a bit of events work for music gigs which was great fun. My last assignment with Office Angels was an Administrator/PA position at the Institute of Chartered Accountants (ICAS). After three months I was offered a full-time, permanent position.
I was an Administrator/PA at ICAS for 15 months and I used all of my Pitman skills on a daily basis. I have now just started a new job as Secretary to the Edinburgh Residential sales team at Knight Frank, a global organisation which presents huge opportunities for my career going forwards. I see myself working for Knight Frank for many years to come.
Without my qualification and skills gained through the Executive PA Diploma I wouldn’t be in the position that I am today. The staff at York Place were incredibly kind and helpful and made the training environment a very happy one. The flexible approach to study proved invaluable especially during periods of ill health. I am pleased to say that I am happy, healthy and loving living in Edinburgh and working full-time – something we never thought would be possible a couple of years ago.
I would recommend the Executive PA Diploma to absolutely anybody. Not only do you learn many new computer skills – even as a fairly ‘tecchy’ person – but you actually learn a lot about yourself and where your strengths/weaknesses lie. I found the Executive PA Seminar particularly helpful as it gave me a real insight into the life of a high-level PA. My decision not to go to university was definitely not an easy one and it was daunting at first but I’m so pleased with where my career is at now. I’m very fortunate to have a full-time, permanent job in the current market when so many of my friends are struggling to find a job after 3 years at university.”

AL – Executive PA Diploma

Executive PA, General Diploma, Private Individuals, Secretarial Diploma

From going from redundancy to this is just a great feeling! I actually love my job!

I C – Legal Secretary

Private Individuals

Marion was an excellent trainer, very clear and concise and I look forward to attending Executive PA course in July in Edinburgh.

Ashley – Executive Assistant – Time Management

General PD, Organisations Testimonials, Time Management

I am convinced that my Pitman Training Diploma impressed them, and I certainly felt confident when I had to do a series of “skills tests” on Word and Excel. The skills I attained at Pitman Training have been invaluable, and I’ve become known as the person to see if anyone has any Microsoft Office problems!

B S – Project Officer

Private Individuals

‘Couldn’t improve, one of the best courses I have ever attended.”

Susan K—–Director—-The PA Exchange

Organisations Testimonials, Presentation Skills

“This was one of the most useful training sessions I have ever been to.The tutor gave a lot of practical advice and I thought asking people to commit to action plans to take advice back to the workplace was great.The trainer really listened to people and made sure everyone’s objectives were dealt with fully.”

Zoe Westwood—–Project Officer—-Changeworks

Organisations Testimonials, Time Management

“The course exceeded my expectations and I would recommend it to all my colleagues and will let our training department know that it was excellent”

Bob—–Co-ordinator—–Voluntary Sector

Organisations Testimonials, Time Management

‘’Over the past two years we have used Pitman Training for a number of courses and the feedback has always been excellent.
I have personally been on two – Delegation Skills and Supervisory Skills, both proved to be well constructed, interactive and of great use not just in the workplace but as useful tools in general life.
One of our other teams have used their Project Management course to great effect. It was carried out by someone who has masses of experience in Project Management so gave a solid practical slant rather than a Trainer delivering a course.It would be fair to say that the two courses that I attended were the same.
On the whole I find them extremely professional, also great if you want a bespoke course.
I have over the years used a variety of companies and Pitman always seem to deliver exactly what you want.’’

Elma C——HR Administrator (Training)—–NHS Education for Scotland

Organisations Testimonials, Supervisory Skills

“When I first came to see you I found myself aged 50 with no skills to offer the modern workplace and I had no idea how I would earn a living and support myself financially. I decided to undertake the Legal Secretarial Diploma and, at first, it felt like I had such a huge mountain to climb. However, I kept reminding myself of that well worn quote that, even the longest journey begins with one small step. I was able to study as and when I could and fit it around all the personal changes that were going on in my life.
With the patience, help and support and encouragement of everyone at Pitman I gained my diploma. However, I wasn’t sure if being a legal secretary was what I wanted to do so I decided to temp for a while to gain experience and ‘test the waters’. Since then, I have been a Medical Secretary, Office Manager in a very busy recruitment consultancy and, more recently, Administrator in a small firm of quantity surveyors.
At the end of last year I decided to start looking for a permanent post and have just been offered a part-time position as Audio Typist/Medical Secretary. This will bring together my previous nursing experience and knowledge of medical terminology with all that I have learned at Pitman and consolidated while temping.
I have such fond memories of the training room and found all the staff to be friendly and helpful. I would recommend the courses to anyone and wish I had discovered Pitman years ago. Big thanks to you all.”

JG – Legal Secretarial Diploma

Private Individuals, Secretarial Diploma

” I would like to thank you for giving me this unique opportunity to change my life and get a good job as a bookkeeper.
To be honest, as a foreigner I was scared at hat the course would be too hard to study and understand but I decided to take this challenging opportunity and improve my skills.
The training materials were amazing. They were very well presented and easy to learn. However the greatest advantage was the Training Supervisors. At any point when you are stuck with the subject or do not understand the questions then all you have to do is ask and all the help you need is there for you.
After I completed just three of the modules I decided to look of a job as a part time bookkeeper and I was in seventh heaven when I was offered a job before I had even finished my course.
The knowledge I have received from Pitman has helped me to develop my skills and improve my financial situation.
I strongly believe that anyone with a bit of discipline, patience and effort can change their lives for the best with the help of Pitman Training.”

AKS – Accounting Technician Diploma

Book-Keeping, Private Individuals

’Not only was this an excellent learning experience, but also great fun. I picked up some great tips on how to command and hold the attention of a less than enthusiastic audience and I found the section on voice coaching extremely useful.
The course really helps develop confidence, particularly with regard to the advice on body language and stance and I would recommend that everyone who has to present to small or large audiences should attend.’’

Jacqui C—-HR Manager—-Citizens Advice

Organisations Testimonials, Presentation Skills

“I just wanted to send you a quick email to say thank you most sincerely for finding me a place on the course. I have to say to you that I found the course totally inspirational. I have been on many courses, some dreadful and some ok, but none came anywhere near to the quality delivered by Pitman Training. The Trainer was so energetic, enthusiastic, very knowledgeable, friendly and adaptable to our needs – no wonder you heard the hoots of laughter from the course room, everyone was just enjoying it so much. It was a great group as well, lots of characters and this helped as well.
Our Trainer kept us totally captivated for 3 days and that’s no easy task when delivering – she is a gem. If I could be a Trainer with even half her ability I would be delighted.”

Derek Walker ——Project Manager

Organisations Testimonials, Train the Trainer

“When I came to see Fran she recommended Microsoft Excel, HTML, Dreamweaver 8 and Book-Keeping Level 2 Module 1 courses as the most suitable for preparing me to set up my own online business.

The staff were all very helpful and polite and the environment was professional but friendly. I have since set up a website with a friend as an information site for parents and carers of children with autism.

The courses at Pitman increased my confidence with technology and made me believe that after 15 years as a music teacher, and 2 years as a full time carer for my children who have support needs, I can now change direction and transform my life.”

JM – Various Courses

General Courses, Private Individuals

“I studied the Legal Secretarial Diploma with Pitman because I wanted to have some formal IT qualifications and was interested in finding work in the legal or property sector. Before taking the course I was doing housekeeping and cleaning work and I had decided I wanted to look for something with a more administrative focus.
I had used computers a lot before doing the diploma but I now feel like I have a much better and more organised understanding of programmes like Microsoft Word and Excel and I am confident enough to experiment with them.
I thought I could already type very well but I am so much faster now that I’ve done the Typaz and speed development courses.
I have just been offered a job as a Plans Officer with Registers of Scotland through the Pertemps agency. I wouldn’t have been able to apply for this job without my Pitman diploma.
I would definitely recommend Pitman to others, especially other graduates, because it gives you more confidence and more options. I liked being able to work at my own pace and the supervisors in the training room were really helpful with all my modules.”

HB – Legal Secretarial

General Diploma, Legal Secretarial, Private Individuals, Secretarial Diploma

Julie related ‘real life’ situations which I could relate to.

Paul – Problem Manager – Communication Skills

Communication Skills, General PD, Organisations Testimonials

Julie tailored the course excellently to the different interests/problems of the participants. She sought out appropriate material related to our fields of work. I felt the small course size was excellent.

Rachel – Manager – Influencing Skills

General PD, Influencing Skills, Organisations Testimonials

Well delivered, friendly and approachable.

Claire – Property Services Assistant – Report Writing

General PD, Organisations Testimonials, Report Writing

“The Executive PA course is by far the best course I have attended. Our Trainer was a fantastic tutor and really knew her subject, she was able to communicate parts of the course content with her own real life experiences. I have attended many courses in the past, some of which were quite boring but I must say the tutor had my full attention over the course of the two days.
The size of class was also perfect, which allowed everyone to have their say and share similar experiences. Overall all, it was a very enjoyable course and I would be keen to attend other relevant courses”

Michelle Anderson—–PA—–Airtricity

Executive PA, Organisations Testimonials

Very engaging, simplified a lot of complex issues to meet the needs of the audience. Genuinely found both days very fascinating – very rare that I can listen to someone speak for 2 days and not get bored, but Julie achieved this! Can’t wait to try out my new tools and techniques!

Sarah-Louise – Business Development Executive – Influencing Skills

General PD, Influencing Skills, Organisations Testimonials

I am now confident in managing manipulative behaviour and also how to manage staff that just do their own thing.

Lorna – Senior Staff Nurse – Conflict Management

Conflict Management, General PD, Organisations Testimonials

“I had worked in Lettings Management for over six years and decided to have a complete career change. Pitman Training offered a legal secretarial course which I was able to complete in two and a half months full time and in less than two weeks of completion of the course, I found work.
I registered with a few recruitment agencies but also sent my CV to law firms directly. I am now working as a PA for the main partner of a law firm and training as a paralegal.
Thanks to Pitman and the team at the Edinburgh office, who have been very helpful, I am thankful and happy embarking on my new career.”

RA – Legal Secretarial Diploma

Legal Secretarial, Private Individuals

“I successfully completed Executive PA Diploma at Pitman in 2013. With the help of Pitman training I also gained Microsoft 2010 Master Qualification which enabled me to become a confident and proficient administrator in record times.
But most importantly, Pitman training changed my life, forever and beyond I could have ever imagined. I did not have a job and had a very low self-confidence. It took me a while to have a courage and sign up for the advanced course that I had chosen, but I never looked back since that moment and everything in my life went on from strength to strength.
The staff became my second family and I would like to thank you for making me a better person. Every day you were transforming a young girl into a confident successful woman. We, as students are so lucky to have you.
After completing Pitman I was working for a Law Company, Edinburgh College and sat further exams that enabled me to progress further in my career.
I have recently been accepted for the position of Sales Consultant with Travelex. It took me just 7 days to get approved for the job since I saw the vacancy at the Job Fair and had a phone call to congratulate me for getting the job!!
I owe a lot in my life to Pitman Training. It truly changes lives, it gives confidence in your professional abilities, provides you with necessary qualifications to get that Dream Job!!”

DT – Executive PA Diploma

Executive PA, General Courses, General Diploma, Private Individuals

I believe that the only reason I was granted an interview let alone being offered this position, is because I had enrolled for your course at Pitman Training, Edinburgh.

F C – Medical Secretary

Private Individuals

“Working as a secretary with Axis Media I felt that I needed to brush up my skills on some of the Office programmes that I was using as part of my job as well as gaining a recognised qualification. The Fast Track Diploma did this for me, and clarified some of the “mysteries” surrounding programmes such as Access which I had used slightly but never fully explored.
The course books and audio CD were clear and easy to follow, and the training staff were all very friendly and helpful, to the point of offering advice even after the course had finished.
Their unfailing cheeriness and sense of humour (together with the excellent facilities and pleasant working surroundings) added to the good atmosphere at the Pitman’s centre which is why I’ve now come back to do another course!”

PF – Fast Track Diploma

General Diploma, Microsoft Office, Private Individuals

“As I was due to retire from teaching within a few months, I was looking to update my computer skills in order to facilitate a move to part time work in administration/ reception. After a chat with Linda, I decided upon the Fast Track Microsoft Office Diploma. This enabled me to remember work I had previously done in class using Word and PowerPoint and to also extend my use of the programs. The three others modules covered were Outlook, Excel and Access. I have to say Access was the most challenging for me, even though I could see the logic in it!!
I thoroughly enjoyed working through the modules as you are able to work at your own pace and go over areas again and again until you feel comfortable with your understanding. Another very positive aspect to going in to the Centre to work is the invaluable help given by the staff who are friendly and on hand to iron out any little problems; they calm you down when frustration levels begin to rise at your inability to see where you have gone wrong and expertly set you back on the right pathway!
I am delighted to say that I completed the course with Distinction.
At the moment I am not working but am now veering towards working within the NHS. In order to further my chances with this I am currently studying Medical Terminology. Again a bit of a refresher for me as I have previously studied Anatomy and Physiology, but am enjoying it none the less as it makes me use my brain cells. Not a bad thing!
Although not working I have been looking at the Show Website for NHS workers and will also be looking to find temporary work through an agency, if the first option does not work out, in order to gain experience back in an office environment.
I am glad I made the decision to call Pitman and chat to Linda about options. I can be a bit of a learning junkie and once I have the bit between my teeth I may well find another area to study and keep me at Pitman that bit longer.
Very satisfied client”

JN – Fast Track Diploma

General Diploma, Microsoft Office, Private Individuals

Marion was excellent. Kept us all motivated. Structured the session well. Looking forward to attending another one of Marions training workshop.

Natalie – Executive Assistant – Report Writing

General PD, Organisations Testimonials, Report Writing

Excellent. Very approachable and knowledgeable. Made the subject interesting.

Angela – Assistant Facilities Manager – Excel

Excel Seminars, IT Tutor Led, Organisations Testimonials

‘’I would like to say how much I enjoyed the above course yesterday. I have to say this ranked as one of the very best courses I have attended and I now have a more positive attitude towards meetings/minute taking. Please pass my thanks to the trainer.’’

L D

Minutes and Note Taking, Organisations Testimonials

Enjoyed the Supervisory Skills course, picked up useful tips and methods on how to handle difficult situations.

Deborah – Finance Team Leader – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

Everything I have learnt can be used throughout the future not just in my employment. The Information came across well and I will definitely use it throughout my daily routines at work. I was Very impressed by the service today – friendly, welcoming and nothing was too much trouble.

Yvonne – Family Support Worker – Receptionist Seminar

General PD, Organisations Testimonials, Receptionist Seminar

I was recently promoted to secretary to the Clinical Director at the Princess Royal Maternity in Glasgow. The job is varied, interesting and very well paid. I still have fond memories of my days at Pitman Training.

E L – Medical Secretary to the Clinical Director

Private Individuals

“The skills I have learned by doing the course have helped with my confidence and ability to carry out tasks quicker and easier. I was frustrated with my lack of knowledge of the various Microsoft packages and was convinced that there ‘must be an easier way’ of doing things. Not only did I brush up on my Word skills, my office skills got a complete overhaul and without a doubt, they helped me get the job I’m in now.
I proved to myself that I’m never too old to learn and that there’s always a need to update skills throughout your working career regardless of how long you’ve been in a role.
I was working in a recruitment agency on a part time basis and had finished the Pitman course when I saw the job on S1 jobs web site. I sent in my cv and went for an interview. Following the interview I sent a thank you letter which was one of the skills learnt in ‘Go Get That Job’. I was successful in getting the role and I subsequently found out that they were so impressed that I’d sent a thank you letter that they offered me the job over someone else who was equally qualified. Such a simple thing to do but very effective.
I would thoroughly recommend anyone to do a course at Pitman, whether it is a comprehensive course such as the Executive PA course or a single subject course. Not only has the organisation been going a long time and has built up an enviable reputation, but I also found the flexible method of learning suited my situation as I was working part time and was able to wrap the course hours around my job. The supervisory staff were very helpful and approachable and did their best to help you out.”

SH – Executive PA Diploma

Executive PA, General Diploma, Private Individuals

“I was previously working as an Office Manager for a small online retailer – which I enjoyed – but I was ready for a new challenge and wanted to expand my CV.
I couldn’t fault the training at Pitman. Each course was easily manageable as it was split into lessons. To add to that, the supervisors were always on hand to help out with any questions, however big or small.
I applied for one job I particularly liked the sound of, and after two interviews, a psychometric test and three skills tests (which I was able to complete with confidence due to my training at Pitman) I found out I was successful!
I am now Office Manager and PA to a senior member of staff at one of Scotland’s leading estate agents. I absolutely love my new role and I am learning more and more every day.
I could have easily stayed in my old job but wanted a new challenge, on a different path, and Pitman training was the stepping stone I needed.
I would fully recommend the Executive PA course to anyone looking to develop their skills and CV. It gave me confidence to apply for the job I have now, helped me in the interview process and above all, now helps me on a daily basis in my new role.
The team at Pitman made me feel welcome and comfortable, and my time spent at York Place was most enjoyable.
Many thanks!”

KC – Executive PA Diploma

Executive PA, General Diploma, Private Individuals

‘’Both Carol & Liz attended the Professional Receptionist Training course on Friday 31st January in Edinburgh held by Pitman Training. Both enjoyed the course and thought it was beneficial and relevant to their place of employment.
Since the course they both feel more confident and understand a lot more about what is required of a Receptionist.’’

Professional Receptionist

Organisations Testimonials, Professional Receptionist

Knowledgeable, Approachable and effective communicator.

Margaret – Care home manager – Assertiveness

Assertiveness, General PD, Organisations Testimonials

Marion had great knowledge. I benefited from the examples provided. Great that Marion encouraged discussion, as the hints and tips will help me in my work environment.

Natalie – Executive Assistant – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

I found learning at Pitman Training was enjoyable, which makes all the difference. It was probably one of the best decisions I have made in the last decade.

S E

IT Tutor Led, Private Individuals

“When I started my Executive PA Diploma last September I was quite unsure what direction my career was going in, I guess you may hear this fairly often, however as the course progressed and my confidence increased I felt ready to look for a PA Executive job. In January I was very successful to be offered the role PA to the Senior Dental Advisor at Practitioner Services (part of the NHS) which I believe my Pitman training played a pivotal part and gave the company confidence to employee me.
I have now completed my three month contract at Practitioner Services, so again I had to think about the direction my career would go. So, I am delighted to let you know that I have been offered a permanent job as a Training Co-ordinator, taking over all the logistics and administration associated with the training events and seminars that the Company delivers and I will be working directly with the Managing Director.
Therefore, I would like to take this opportunity to thank you and your training administration team without whom none of this would have happened.”

LF – Executive PA Diploma

Executive PA, Private Individuals

Marion created a fun training environment and always encourages questions and opinions.

Jennifer – Insolvency Administrator – Report Writing

General PD, Organisations Testimonials, Report Writing

“In the last year I successfully completed and passed Sage Accounting and Sage Payroll Computer Courses with Pitman Training. Before my training I was looking for a job, but realised that I needed more qualifications in order to get my ideal job.
I am now applying for jobs and feel more equipped and confident. I am searching the job sites and sending my CV. I know it’s only a matter of time until I have the job I desire.
My learning time at Pitman Training was a very happy time for me. I felt warmly welcomed each day and this enabled me to learn quickly. The staff were extremely professional, friendly and helpful and the atmosphere was very relaxed. I so enjoyed my Courses and it really was learning made easy.
I wish to Thank each member of Pitman Training Staff. I have never enjoyed a learning experience as much as I enjoyed my time with you.
Many Thanks!”

GC – Sage

Book-Keeping, Private Individuals, Sage

The trainer was very good, explained everything clearly and answered questions well. The content of the course was at a good level for introduction.

Alison – Project Manager – Access

Access Seminars, IT Tutor Led, Organisations Testimonials

First time being in Marion’s course and was an excellent experience, I need more!

Linda – Centre Manager – Conflict Management

Conflict Management, General PD, Organisations Testimonials

Julie was obviously very confident and capable with content on course. Wonderful style and completely approachable. Overall the course is very hard to fault. Julie was lovely throughout and left me with a really thorough understanding which will be very valuable. Thank you.

Tracey – Student – Train The Trainer

General PD, Organisations Testimonials, Train the Trainer

‘I found this course hugely beneficial. I have just taken on a training aspect to my current role and the skills gained on this course have given me the confidence to approach the training sessions in a much more positive way.
This course gave me both the knowledge of how to put a training session together, and insight into the different approaches and skills used to deliver the training. I particularly found the practical aspect of the course useful. Throughout the three days, we not only learnt ‘how’ to do various tasks, but actually did, and evaluated them’.

MC—-Project Officer

Organisations Testimonials, Train the Trainer

The learning process used by you is so relaxing and such an enjoyable was to learn. I have studied a lot in my time, but this is the first time it has really been fun.

J L

Private Individuals

I was wary of attending the course as this was new to me but I fitted in very well and had a great two days. Thank you.

Louise – Office Manager – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

The small group to tutor ratio was very helpful. It was at a great location, lunch was a treat, the training was well-paced and clear. The trainer was very patient, not patronising (a relief) and very helpful.

Paula – Assistant Visitor Experience Manager – Word

IT Tutor Led, Organisations Testimonials, Word Seminars

I was offered three jobs within a matter of weeks!

H S – Personal Assistant

Private Individuals

“After a change in my personal circumstances in 2012, I decided I wanted a complete change in career and decided to study as a Medical Secretary, opting to take the full diploma at Pitman Training. I previously worked in the Newspaper & Magazine industry, and had done so for 10 years so this was quite a drastic change for me! My most recent role was as an Account Manager for a 3rd Party Retail Consultancy Company. Having not been to university, almost all of my experience had been picked up at work and therefore to move in to a new specialised career was going to be very difficult without some form of qualification.
After doing a lot of research I decided that Pitman had exactly the course I wanted and an excellent reputation so I knew I would be in good hands. From the very first time I went in to sign up to the course, right through to the completion, the team were so helpful and friendly, ready to help with any problems and provide support.
I had already completed 60% of the course when I discovered I was being made redundant from my current role. Whilst obviously a big shock, I had been planning to leave in any case. Whilst working out my notice at my job, I was applying elsewhere and was offered some contract work at Spire Murrayfield hospital within their Medical Secretary team. This will provide me with invaluable experience and an opportunity to put all my study to use in a new and exciting career.
I know for a fact none of this would have been possible without the qualification and support from the Pitman team at Edinburgh.”

VH – Medical Secretary Diploma

General Diploma, Medical, Private Individuals

Upcoming Events

There are no events on this day.

April 2

April 2 @ 9:30 am - 4:30 pm

There are no events on this day.

There are no events on this day.

There are no events on this day.

April 8

All day

There are no events on this day.

There are no events on this day.

April 15

All day

There are no events on this day.

There are no events on this day.

April 22

April 22 @ 9:30 am - 4:30 pm

There are no events on this day.

There are no events on this day.

April 29

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

Choose your centre

Your details

Course details

Course subjects

Courses by title

Diploma subjects

Diplomas by title

Microsoft Excel 2019 Expert