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.

May 2024

May 21 - May 22 Executive PA – 2-day workshop

Executive PA – 2-day workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 21 @ 9:30 am - 4:30 pm Power BI Introduction

Power BI Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 22 @ 9:30 am - 4:30 pm Identify and Manage Stress

Identify and Manage Stress

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 23 @ 9:30 am - 4:30 pm Telephone Techniques

Telephone Techniques

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 28 - May 30 Train the Trainer – 3- day workshop

Train the Trainer – 3- day workshop

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

May 28 Adobe Illustrator

Adobe Illustrator

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom +2 more

May 28 @ 9:30 am - 5:00 pm Excel Introduction

Excel Introduction

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

May 28 - May 30 Train the Trainer – 3- day workshop

Train the Trainer – 3- day workshop

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

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

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

June 2024

June 3 @ 9:30 am - 4:30 pm Leadership Skills

Leadership Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

June 4 - June 5 Supervisory Skills – 2- day workshop

Supervisory Skills – 2- day workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

June 4 @ 9:30 am - 4:30 pm Excel Advanced

Excel Advanced

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Testimonials

I loved that the trainer had done the role and understands the job and what is needed. Excellent!

Nicola – Office Administrator – Meertings and Minutes

General PD, Meetings and Minutes, Organisations Testimonials

I finished a Pitman Secretarial Diploma in 2008 and after one month working as a temp. I was lucky enough to be offered a permanent job as Clerical/Admin Assistant which is where I am still working now.
Learning to touch type at Pitman definitely helped to secure the job, and also having a certificate from all the units of the secretarial diploma which showed that I could use Microsoft Office programs competently.
I took the option to study from home as living in Perth , it meant I could fit in work around the kids school hours. Though I did enjoy going into Edinburgh occasionally to do Outlook, and Audio. The course was really straightforward, and the tests were an enjoyable challenge.
I love being able to touch type, and it will be useful for the rest of my life, in whatever job I do. I have even got my children started on the BBC’s cool typing lessons for kids, where singing animals encourage you, and I hope that they will be able to type by the time they are teenagers.
All the trainers at Pitman were really helpful, and always ready to explain things, when I phoned or emailed with questions.

GA – Secretarial Diploma

Private Individuals, Secretarial Diploma

Fantastic!

Nic – Senior Pilot/OSM – Report Writing

General PD, Organisations Testimonials, Report Writing

“I had been having trouble making the databases at work behave themselves but every problem that I had been having has been dealt with today.”

Access Level 2 A M——-Administration Co-ordinator

IT Tutor Led, Organisations Testimonials

“I had previously enrolled on a ECDL course through Aberdeen College which I failed to complete as the course was primarily home based with pre-historic methods for learning the given subjects and using there computers wasn’t really an option because of full time classes and a raffle ticket method for trying to book a computer.
I work offshore so my free time is varied and is never the same month to month. I needed to learn these as more and more of my job required knowledge in how to use for example word, excel and outlook. I contacted Pitman Training Aberdeen and went into see Faye about the Microsoft Fast Track Diploma which covers all the key Microsoft packages used in any office. The flexibility in the Pitman Training method of training is what really attracted me to their course, I could go to there training centre at any time I wanted. The learning process is very well developed, and by means of listening, reading and most importantly doing flowing exercises I found I learned the given subjects very fast with ease.
I recently decided to set up my own Ltd Company to enable me to provide Maintenance services primarily to the Oil and Gas Industry for Gas Turbines, diesel engines, pumps and compressors. In doing this I decided to enrol on the Sage Line 50 course as this would help me with my book-keeping and the Dreamweaver course so that I could set up and maintain my own website for the company.
I would recommend anyone wanting to learn or improve their skills to train with Pitman Training Aberdeen. Both Iain and Faye have been really helpful and would not hesitate to enrol on another course with them if I need to.”

CB – Fast Track Diploma

General Diploma, Microsoft Office, Private Individuals

Julie was excellent, she has given me the tools and skills to go forward as a trainer and do it confidently.

Natalie – Business Travel Consultant – Train The Trainer

General PD, Organisations Testimonials, Train the Trainer

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

The compliments I have received have certainly given my confidence a great boost. I am so enjoying the work, the environment and the people and it’s all due to the skills I have gained from the Diploma courses I have done through Pitman Training.

H L

Private Individuals

Marion was really good and helped me to understand what I was doing and extremely fun.

Fiona – Trainee Administrator – Assertiveness

Assertiveness, General PD, Organisations Testimonials

What I liked about training at Pitman Training, was the flexible nature of the courses which enabled me to progress at my own pace and fit my studies around other commitments.

K C – Administrator

Private Individuals

The trainer was very responsible and a very clear communicator. Paid attention to what people in the group said and made the day enjoyable and very worthwhile.

Kenneth – Faculty Head Sciences – Time Management

General PD, Organisations Testimonials, Time Management

Engaging, easy to listen to, knowledgeable, great presence. The course quality was good.

Dandra – HVS Consultant – Presentation Skils

General PD, Organisations Testimonials, Presentation Skills

No Improvement required. Speed, clarity and technique ideal. The trainer was excellent!

Wendy – Receptionist – Meetings and Minutes

General PD, Meetings and Minutes, Organisations Testimonials

“I have completed a number of with Pitman Training since 2007, including ECDL course and the MCSA.

I have always found the staff at the training centre to be very helpful, friendly and supportive, in particular John whose help, advice and technical expertise has been an invaluable resource to me throughout my MCSA.

Prior to doing the course I had very little computer experience and was working as a Stockroom Supervisor but in May this year after completing my second last exam I managed to secure my first full time position in IT as an IT Assistant with a well known Scottish charity.”

SH – IT Assistant

IT Technical, Private Individuals

They seemed to be so impressed that I had been at Pitman Training to do the training. I cannot believe how doing one course can transform your job area.

J M – Management Support Officer

Private Individuals

Excellent facilities. Excellent trinaing course!

Kirsty – Team Organiser – PowerPoint

IT Tutor Led, Organisations Testimonials, Powerpoint Seminars

“I just want to thank you and your staff for all the help you offered me while I was studying my Executive PA Diploma at Pitman in Glasgow.
Before doing my training with Pitman I had studied ACCA but did not have much work experience, by doing the course I gained valuable skills that are now helping me at my new job at one of the big accountancy firms.
What I liked best about the course was flexibility of the course, I was able to choose the time and hours I did the course. The staff were very helpful and I will not hesitate to recommend this course to any of my friends.
Thank you again for all your help.”

SK – Executive PA Diploma

Executive PA, Private Individuals

The course was catered specifically to spreadsheets I use in my daily business, so was invaluable, useful and relevant.

Jennifer – Examinations Administrator – Excel

Excel Seminars, IT Tutor Led, Organisations Testimonials

The skills that I learnt on the course come up time and time again on a daily basis and I am sure that the diploma on my CV has ensured interviews for a number of job applications.

L B – PR Assistant

Private Individuals

Julie was an extremely good deliverer of the course content, very knowledgeable. I noticed she never failed to answer any questions and had offered solutions to all issues put to her.

Paul – Scientist – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

Very good. I did a full semester in university on Project Management and this course taught me much more than I learned at university.

Rosemary – Wind Farm Developer – Project Management Principles

General PD, Organisations Testimonials, Project Management

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

‘’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

“I studied the Accounting Technician Diploma with Pitman Training in Edinburgh. I decided to do this course, as I was just about to be made redundant, and decided that I wanted to gain some new skills to help me when applying for a new job. I was also thinking about starting my own company, and thought that finance studies would never go wrong.
A couple of months after redundancy, I got a temporary post at SAMH, and then applied and got my current post as the HRD (Human Resources & Development) Administrator. Although I hadn’t completed the course when I got my job, the skills I had learnt so far has helped me out in my new job, as I have to monitor budgets and make monthly reports to my boss.
I enjoy learning at Pitman. You learn at your own speed, which makes it all much easier. This is the second course I’ve done at Pitman, and would recommend it to anyone.”

LM – Accounting Technician Diploma

Book-Keeping, Private Individuals

“Just a note to let you know I’ve now managed to secure a permanent post as a Finance Assistant/Purchase Ledger Clerk for an electronics firm just South of Edinburgh.
I would just like to say that I believe my Pitman Training certificates in Sage Line 50 and Purchase Ledger were instrumental in securing the above post.
I would like to take this opportunity to thank you and your colleagues for all your help in assisting me in my future career in finance.”

BS – Sage Accounts and Payroll

Book-Keeping, Private Individuals, Sage

“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

Very good pace, pitch and tone. Excellent subject knowledge which was explained clearly. Well structured, informative course pitched at the right pace in a relaxed environment.

Nick – Change Manager – Train The Trainer

General PD, Organisations Testimonials, Train the Trainer

“I relocated to Scotland after teaching English abroad for 15 years. Unable to find similar work here, I spent an anxious 12 months as an office temp, eventually gaining a permanent position as an admin assistant at a law firm in Glasgow. I carried out the usual range of tasks – photocopying, filing, distributing faxes. Although happy to have a job and appreciating its positive qualities, I felt held back – both in my own workplace and on the job market as a whole – by my lack of IT and keyboard skills.
One happy day I made an appointment to see Linda Morrison at the Glasgow Pitman Training Centre. Linda understood my frustration and recommended the Diploma in Business Skills, a qualification that combined basic keyboard training with Microsoft Office courses, plus Effective Business Communication and an elective (from a wide range of options, I chose ‘Get Into HR’).
There were eight modules in all and the sessions had to be fitted in around a full-time job and busy family life. Ultimately I took 18 months to complete it all but felt very proud when I took home my Diploma. I’m still working for the same firm but now run the library and deputise for the Archivist in his absence. My daily work is far more interesting and varied than it once was, and that fact – combined with the high unemployment brought about by the recession – means that I’m not interested in changing jobs in the foreseeable future. Nonetheless, it’s crucial to be flexible in these hard times and to be able to offer additional skills if need be. I don’t regret the time and energy I put into my courses – they’ve given me tremendous self-confidence and a great sense of relief that I’m no longer left behind or marginalised by my lack of knowledge.
I’ve already recommended the Glasgow Pitman Training Centre to a number of friends and am happy to do so again. I’d also like to put on record my thanks to all the staff for their cheerful help and unfailing moral support throughout my training.”

MF – Diploma

General Diploma, Private Individuals

Excellent trainer. Knowledgeable with a very pleasant and helpful manner.

Julie – Manager – Outlook

IT Tutor Led, Organisations Testimonials, Outlook Seminar

I have a better understanding of how to manage conflict in the work place, and how to be more confident.

Ann – Staff nurse – Conflict Managment

Conflict Management, General PD, Organisations Testimonials

‘’Just to thank you again for the excellent course. It was at just the right level and I really appreciated being able to attend without having done the previous one.Too many courses insist on a progression through levels with certificates rather than accepting experience. Callum presented the course at a very good pace giving plenty of time for questions.Definitely the best computing related course I have attended!’’

Excel level 2 C M——-National Trainer

IT Tutor Led, Organisations Testimonials

Very useful, customised experience, highly recommended.

Sam – Programme Officer – Project Management Principles

General PD, Organisations Testimonials, Project Management

“Great Knowledge on subject. Friendly and relaxed throughout. Excellent!”

Word Introduction Andy McDougall—–National MuseumsScotland

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

“Excellent! Extremely helpful and reassuring, thank you so much for this course!I now feel much more confident and know how to improve my minutes taking techniques.”

Adeline Amar—–Scottish National Gallery of Modern art

Minutes and Note Taking, Organisations 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

“When I met you back in February 2014 my mental state was at a low ebb. After our chat you gave me hope within myself!
When I realised what I was about to undertake, trepidation set in. Well, five months later I achieved my goal attaining a Diploma in Administration Assistant. This is such an huge achievement for me, being the first actual qualification I’ve attained. So a huge pat on the back for me!!!!
What can I say about Pitman Training, Edinburgh, simply first class! Your supervisors are a great bunch, nothing was too much trouble. Even when it came to asking what potentially could be a ‘stupid’ question, they always treated you with respect. I certainly asked a few ‘stupid’ questions! Their patience and understanding was first class, knowing that some of us weren’t on the same level with computer programmes as they were.
The courses are well set out with books and audio to help you along. The audio and on screen items are clear and concise, keeping it both plain and simple.
After five months my confidence is returning and that can only be a good thing for my future.
I’ve managed to secure a job with Edinburgh City Council and If there ever becomes a need to learn further subjects, you’ll be the first people I’ll contact.
Many thanks for all the help I’ve had over the past five months, so much appreciated.”

IS – Administration Assistant Diploma

General Diploma

“I first enrolled for a computer course in January 2013, I only had very limited knowledge and knew I had to get more advanced skills. I started with word then decided I was enjoying my course and chatted with Linda the Manager regarding what options I should take and that would be best for me in the working environment, so we decided on Office Diploma.
I had just been made redundant from the Airline Industry, which had been my life for the last twelve years, so I knew I wanted to change my career. I had realised that IT skills are so important as I had now started looking for work and realised very quickly that the job market was very competitive.
I have not mentioned this till now but I am visually impaired and have been since birth so having a disability makes it even more difficult for employers to consider employing a disabled person, when so many abled bodied people are available so the training I received was incredible, the one to one help that the Glasgow ladies gave me was amazing I am surprised I never turned them to drink, but nothing fazed them they provided me with Zoom text and large print books and test papers. I was not very successful at school and the thought of taking exams really scared me but they sat me down and told me I could do it just take my time and they were right I managed to complete my Diploma.
I am now working for a charity called Momentum on the east side of Glasgow on a six months contract which was arrange through another charity to give me some office experience.
I enjoyed every day in the Glasgow office such a lovely atmosphere and such kindness that I was shown was just incredible and gave me a new found confidence.
Thank you team Glasgow, you’re the best.”

DB – Word and Microsoft Office Plus Diploma

General Diploma, Microsoft Office, Private Individuals

I wanted to let you know that I really enjoyed the 2 day course. Our Trainer was really in tune with us as a group and understood exactly where we were all coming from with regards to the daily obstacles we face in our various roles as office and personal assistant.
The course content was fabulous; I especially enjoyed the section on Communication & Assertiveness. I felt I took most away from these parts and have definitely been able to implement in my daily work commitments. I feel more confident and more in control of my work time. The handouts we were given have also proved useful and I have referred back to them time and time again. The Trainer also gave us recommendations of helpful books, 2 of which I have purchased since the coaching and have dipped in and out of.
I would definitely recommend the workshop to anyone in a support role, be it as a PA or Office Manager, who is looking for a little extra support or guidance. There is a lot to learn, both for people new to this type of role or experienced individuals.”

Louise —PA to the Chief Executive Change Recruitment Group

Executive PA, Organisations Testimonials

I am able to write faster and take minutes of meetings.

Lucy – PA/Business Support Officer – Speedwriting

General PD, Organisations Testimonials, Speedwriting

“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

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

“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

“I studied the Executive PA Diploma with Pitman. I started studying it in January 2013, it was a great way to start the new year.
Before training I was working in a pub. Having graduated from Glasgow University with an English degree, I found it very difficult to get a job and to know what jobs to apply for. I began working in a hotel for three years before I realised no matter how good I was at my job or how many shifts I had done, there was no room for growth.
Training really helped me, it helped me get some focus and direction and it was a great way to learn new skills. It allowed me to get up to speed with all the Microsoft packages and to get back into the way of using computing skills. It also allowed me to broaden my job search as I now had skills I didn’t have before and skills that companies were looking for.
I now work at St Margaret of Scotland Hospice, which I am really enjoying, where I have been employed as a Receptionist and Medical Secretary.
I really enjoyed my Pitman course, all the staff were very friendly and always willing to help out with any problems. I definitely feel if I hadn’t done the Pitman course I would have struggled for even longer to find a job.”

LN – Executive PA Diploma

Executive PA, General Diploma, Private Individuals

“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

Excellent. Would recommend to colleagues.

Scott – Project Manager – Access

Access Seminars, IT Tutor Led, Organisations Testimonials

Everything needed was provided. Work booklets, pad, pen and pencil were all good quality.

Louise – PA – Speedwriting

General PD, Organisations Testimonials, Speedwriting

“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

High praise. Marion drew from her own experiences which I appreciated. She was able to help us with our individual issues. She listed to us and adapted her training to suit our needs.

Alanna – Office Manager/PA – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

I completely understood the topics covered and everything was explained very well. Thank you!

Abbi – Receptionist Seminar

General PD, Organisations Testimonials, Receptionist Seminar

Upcoming Events

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.

There are no events on this day.

May 7

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 13

May 13 @ 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.

May 21

All day

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

May 28

All 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