We can deliver training onsite at your workplace or via virtual classrooms if preferred.
For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.
CITB Members can receive a special discounted rate on our training courses – Click to find out more
For individuals who are already using Excel to an advanced level.
What you will learn:
What you will learn:
| Macros | Additional Items |
| Editing & Deleting Macros | IfAnd/ IfOr Formula |
| Recording Macros | IfNa Formula |
| Custom Ribbon | Convert to Table |
| Screenshots | |
| Review Data | Removing Duplicates |
| Tracking Changes | Filter Timeline |
| Auditing Tools | IfError |
| Watch Window | HLookups |
| Restricting Data Area | Sparklines |
| Pivot Tables | |
| Utilities | Flash Fill |
| Goal Seek | |
| Data Consolidation | |
| Power View Reports | |
| Create Senarios | |
| What – If Analysis | |
| Drawing Diagrams | |
| Recommended Pivot Tables | |
This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.
None
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...
“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
“I started off with Pitman doing Microsoft Office 2007 specialist before progressing into Microsoft Office 2010 and attaining Microsoft Office Master status by sitting Microsoft exams at Expert Level in Word and Excel and standard level Outlook and PowerPoint.
To add to my knowledge I have just completed Pitman’s ‘Train the Trainer’ 3 day course and applied to become a Microsoft Certified Trainer (MCT). With this training I have plans to increase the knowledge of Office within East Coast Mainline staff.
The skills and knowledge I gained, studying at Pitman Training, have made my job easier by using the advanced features in Microsoft Office to ‘correctly’ format and automate reports and simplify data collation. The ‘Train the Trainer’ course has provided me with increased confidence in dealing with people and situations and will allow me to improve working practice in the office by imparting my ‘Pitman gained’ Microsoft Office Knowledge to others. By raising the overall Office knowledge this should allow the depot to operate better with less time spent ‘trying’ to figure out bullet points and how to create graphs and more time spent doing the actual work.
You have an amazing team of staff at York Place, they are all a credit to you.
The flexibility of learning at Pitman Training is excellent given that you are able to study at Pitman Offices or distance learning at work or home to suit your personal circumstances.
I would thoroughly recommend Pitman Training whether you are looking to improve your situation by training to get a better job or improve your job security at your current location by improving your skills.”
KS – Microsoft Office
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
E W – PA
B D – Project Administrator
“Having chosen not to go to University, and after a years work in the retail business, I was still unsure as to which career path I ultimately wanted to follow. I enrolled on the Executive PA Diploma course with Pitman Training School in Edinburgh in September 2008, knowing that it was highly respected amongst employers.
The course for me was an undoubted success. I completed the main Microsoft modules reasonably quickly – they proved to be very easy to follow and actually quite a lot of fun! I very much enjoyed having the flexibility to choose which elective courses to do, and I was pleased to be given the choice of seminars as well as computer programmes. I have completed two seminars; both were great fun, and whereas I had found Pitman to be a quiet and studious place, suddenly we got to interact with other students and I met some great people.
I now have the role of Personal Assistant to an Art Broker in Edinburgh, which I found through word of mouth. All that I learnt during my time in Pitman has certainly now been put to use – especially the PA Seminar, which focuses not only on the general office keeping but also on the more personal and, often hugely overlooked aspects. Approximately two months elapsed between my finishing the main bulk of the course and securing my current job.
I also hold the position of Secretary on the board of the Edinburgh Charity Fashion Show. This is a non-profit and student run body that annually holds a highly respected Fashion Show in aid of three charities. My job involves organising meetings, taking minutes and being the administrative organiser. Without the Pitman background I would not have the skills that I now use daily.
I am moving to London in March, and thanks to my time at Pitman I am approaching agencies with confidence in myself and my abilities.”
HJ – Executive PA Diploma
Duration: 1 Day We can deliver onsite at your workplace of via virtual classrooms if preferred. For individuals who are already using Excel to an advanced level. This course will...